The following is a list of issues addressed and enhancements implemented in this release of Space Manager.
| Feature | Enhancement / Resolved Issue | Defect ID |
|---|---|---|
| Double Database Instance Issue | An issue with double database entry appearing at the left side of the Windows Explorer has been resolved. | SPC-1022 |
| Feature | Enhancement / Resolved Issue | Defect ID |
|---|---|---|
| Renci Upgrade | The Renci SSH.NET library is upgraded from version 2012.3.9 to 2020.0.1 in Space Manager to help resolve connectivity issues with the oracle servers running on the latest AIX operating systems. | SPC-906 |
| Partitioning Wizard | An issue with the "Move to Tablespace" functionality in Space Manager is resolved. | SPC-908 |
| Feature | Enhancement / Resolved Issue | Defect ID |
|---|---|---|
| Reorg Manager | Reorg Manager now includes the parameters ACCESS_METHOD and COMPRESSION for DataPump and allows the user to modify these settings. | SPC-499 |
| Feature | Enhancement / Resolved Issue | Defect ID |
|---|---|---|
| Advanced Search | Enhancement: The Advanced Search window now includes an "Add to Results" button in addition to the menu item. | SPC-410 |
| General | This release includes support for maximum object name length of 128 bytes in Oracle 12c Release 2. | SPC-308 |
| General | This release includes support for Windows 10. | SPC-379 |
| Reorg Manager | (Oracle 12c) You can now specify the DataPump method for objects individually. | SPC-323 |
| Reorg Manager | (Oracle 12c) Corrected an issue that in some cases prevented a successful cleanup if a script was cancelled or failed during the datapump procedure. | SPC-393 |
| Reorg Manager | Corrected an issue that caused a "Value was either too large or too small for an Int32" error when running a reorganization on objects that include large integer values. | SPC-381 |
| Reorg Manager | Corrected an issue that prevented the Index partition attributes from being scripted correctly when creating a partition-level reorg script for a partitioned table with a local index. | SPC-431 |
| Feature | Enhancement / Resolved Issue | Defect ID |
|---|---|---|
| LiveReorg | Corrected an issue that caused an ORA-04067 error during a LiveReorg of a table containing a LOB data type column when other processes attempted to access the table. | SPC-392 |
| LiveReorg | Corrected an issue that caused an ORA-04067 error during LiveReorg Cleanup of a table containing a LOB data type column when other processes attempted to access the table. This issue is related to SPC-392. | SPC-398 |
| LiveReorg | The DataPump data movement method (available for Oracle 12c) can now use the overflow directory/directories specified in the OVERFLOW_DIR_nn parameter/parameters. | SPC-363 |
| LiveReorg | When connected to Oracle 12c, the Reorg Manager now allows you to specify the following options for the DataPump data movement method: a maximum file size and the number of parallel processes to use. See New Feature in this release for more information. | SPC-321 |
| Object Properties | (Oracle 12c) Corrected an issue that caused an "Unable to cast object of type" error when attempting to view Object Properties of a table. This issue occurred when connected to an Oracle 12c database. | SPC-388 |
| Feature | Enhancement / Resolved Issue | Defect ID |
|---|---|---|
| Reorg Manager | Improved performance when the analysis option "Restore original statistics in data dictionary for the CBO" is selected on the Scripting Options page of the Reorg Manager. | SPC-241 |
| Scripts/Job Monitor | When deleting a script group, if the Detail pane is open, the list of scripts no longer persists in the Details pane after the group is deleted. | SPC-122 |
| SQL Editor | Corrected an issue that caused an "access violation" error when attempting to edit a very large script or enter characters very quickly. | SPC-243 |
| SQL Editor | Corrected an issue that caused Space Manager to become unresponsive when attempting to run a SELECT statement containing duplicate column names. | SPC-244 |
The following is a list of issues known to exist at the time of this release.
| Feature | Known Issue and Workaround (if applicable) | Defect ID |
|---|---|---|
| General |
Some wizard screens do not display correctly on Windows 7 if your text size setting is greater than 100%. Workaround: Set text size to 100%.
|
N/A |
| General | When running the Space Manager client (64-bit) in a 64-bit environment, some users might encounter the following error when attempting to submit a standard or live reorg script: “Error creating script group: Could not load file or assembly ManagedQP5.dll or one of its dependencies. is not a valid Win32 application.” | SPC-409 |
| Domain Indexes |
Reorganizing tables with Domain indexes. Space Manager provides limited support for Domain indexes when performing reorganizations and warns that you might encounter a problem because of the Domain index. Space Manager scripts the reorganization of the domain index correctly. However, the underlying implementation of the index type may be very complex, and some unforeseen dependencies may cause runtime errors. Important: It is recommended that you test the reorganization of a table with a Domain index on a non-production version of the table to make sure Space Manager reorganizes both the table and index correctly before you reorganize your production table. |
N/A |
| Installation |
Error when installing QSA on Windows for Oracle Database 12cR2. Some users might encounter an "Error running setup" error after attempting to install the QSA Server Agent on Windows for Oracle Database 12c R2. Workaround: If you encounter this issue, contact Quest Support for assistance. |
SPC-491 |
| Live Reorg |
Error when running Live Reorg on Oracle Database 12cR2 in Windows. Some users might encounter the following error when attempting to run a Live Reorg script on Oracle 12c R2 in a Windows environment: "350: Aborted QSA - 20391 ORA - 01403 during internal SQL." Workaround: If you encounter this issue, contact Quest Support for assistance. |
SPC-493 |
| Object Properties | Attempting to open the Object Properties dialog for a recently-created partitioned table using a Direct connection type resulted in an error. |
SPC-482 |
| Partitioning Wizard | After creating a table partitioned by range with a global index, using the Partitioning Wizard to change the partitioning method from range to hash unexpectedly changed to the index's locality to local. |
SPC-483 |
Before installing Space Manager and Capacity Manager, ensure that your system meets the following minimum hardware and software requirements.
The Space Manager client must be installed on the same computer, and their requirements are the same unless otherwise specified. The computer must meet the following requirements:
| Item | Requirement |
|---|---|
| Oracle® Client |
Oracle Net version 11g, 12c , and 19c Note: The bitness (architecture) of the Oracle client must match the bitness of the Space Manager application. |
| Operating System |
Note: The Space Manager client is tested on Windows Server 2022 with the QSA Agent and Oracle 19c hosted on AIX 7.2, and AIX 7.3. |
| Processor | 1 GHz Processor (recommended minimum) |
| Memory | 2 GB of RAM |
| Display Settings | A resolution of 1024 x 768; true color or high color; small fonts |
| Disk Space |
Space Manager: Approximately 800 MB |
| .NET Framework |
Microsoft® .NET Framework 4 (including update 4.0.3) Note: The .NET Framework 4 Full Profile is required. The Client Profile is not sufficient. |
Each database being managed with Space Manager must meet the following requirements:
| Item | Requirement |
|---|---|
| Oracle Database |
Notes:
|
| Database Server Operating System |
Space Manager supports the following operating systems:
|
| Disk Space |
Disk-space requirements are:
|
| Oracle Packages |
Space Manager: DBMS_SQL, DBMS_PIPE, DBMS_LOCK, DBMS_SPACE_ADMIN QSA: DBMS_SQL, DBMS_PIPE, DBMS_OUTPUT, DBMS_APPLICATION_INFO Find Long LONGs feature: UTL_RAW Email notifications: UTL_SMTP |
| Oracle's Partitioning Option |
Required for the Online Switch (a feature available for live reorganizations) and the Partitioning Wizard; Partitioning Option must be installed and licensed. |
| XDB Schema |
Required for XMLType datatypes. |
Before installing the server components (and QSA), specify a password version for the database by performing the following procedure.
First, to verify that this procedure is necessary for the target database, run the following query:
select username, password_versions
from dba_users
where username = 'SPACER'
Note: Username is the installation DBA.
Enter the following:
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8
BEQUEATH_DETACH=YES
Add the below command in the listener.ora file.
USE_SID_AS_SERVICE_<oracle-sid>=on
Stop and restart the listener. Use the following commands:
lsnrctl stop
lsnrctl start
The listener may take a few minutes to fully restart.
Alter the password for the installation DBA to a temporary password and then back again to reset it, for example:
alter user spacer identified by X;
alter user spacer identified by spacer;
Reset the sys password using alter, for example:
alter user sys identified by syspassword;
Now run the query again to verify the change.
select username, password_versions
from dba_users
where username = 'SPACER'
Note: Username is the installation DBA.
You can also verify the change for the sys user.
select username, password_versions
from dba_users
where username = 'SYS'
For additional information, see the Oracle documentation: https://docs.oracle.com/database/121/NETRF/sqlnet.htm#NETRF2010.
Note: Capacity Manager is not available in a 64-bit version at this time and is not included in the 64-bit installer.
The database used for the Capacity Manager repository must meet the following requirements:
| Item | Requirement |
|---|---|
| Oracle Database |
Supported for the repository: Oracle 12c |
| Disk Space |
8 MB recommended per monitored database assigned to a repository (accommodates one year of growth in repository objects) |
| Job Scheduler |
One of the following schedules is needed for snapshot jobs
|
| Oracle Initialization Parameters |
Oracle initialization parameters should be set as follows:
|
| Character Set |
Must be a superset of the character sets for all monitored databases. A UTF8 character set is recommended. |
| Activity Level |
Light activity level. |
To activate a trial license
In the License Key dialog, enter your Authorization Key.
Enter the Site Message included with your Authorization Key.
To activate a purchased commercial license
In the License Key dialog, enter your Authorization Key.
Enter the Site Message included with your Authorization Key.
Note: License validation will happen in Space Manager, QSA independently will not authorize the license key.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
