Category
Product Version
Topic
Subtopic
Does QSA/LiveReorg support failover? (4218484)
Per the user guide, the Quest Server Agent should be installed on only one instance in an active-active environment. ... The instance should be the one designated as the primary instance.
How soon can the users be let back onto the application? (4351527)
Some sites specify that Space Manager's LiveReorg switch can only be allowed during an outage of the application, under this scheme how soon can the outage be ended? ... Some sites will only approve a switch with the application down, but want to let the users back on the system as quickly as possible, some processing is performed post switch, so how soon is the system stable?
Received error: Aborted ORA-01418: specified index does not exist (4232619)
(os errno 13) ... Indexes were being reorganized separately at the same time the table was being reorganized ... One script was executed to recreate the tables. ... As part of recreating the table, the index was dropped.
Error accessing the OLE registry (4232015)
Error accessing the OLE registry occurs when attempting to install Space Manager. ... Based on the install log, there was an error copying qpspc.dll, which is the Space Manager plugin dll. Possibly because of write permission, or because it was previously installed and it was in use.
ORA-25191: cannot reference overflow table of an index-organized table. (4232239)
The above error is received when scheduling an analysis job in space manager. ... Due to an error in the Space Manager query, the IOT OVERFLOW objects are not excluded, however space manager will trap the error and continue with the next object
After upgrading from version 6.0.1 to 6.2, is regenerate reorg scripts required? (4280755)
Is it required to regenerate the reorg scripts after upgrading? ... When a new release of Space Manager is distributed, the suggested practice should be to re-create reorg scripts. ... Because the space and size checks occur at script generation time, it is always suggested that reorg scripts be generated as close to (shortly before) reorg time as appropriate.
Sequential Reads on SAP tables after reorganization (4232260)
A user would like to know how Space Manager updates Oracle statistics after a table reorg as they may experience regular sequential reads over tables and SAP jobs running for extraordinary amounts of time.
How to perform datafile maintenance in the middle of reorg? (4266834)
How to perform datafile maintenance in the middle of reorg? ... If you're using a standard reorg, there is Script Pause option available for datafile maintenance. ... While script is pause, you can:
"Access violation at address" error when launching Space Manager (4242027)
Access violation at address 0012FA42. ... Write of address 0012FA42. ... Data Execution Prevention (DEP) is enabled for the client computer. ... Consult your system administrator before altering these settings.
What is the relocate to tablespace option for? (4267009)
What is the relocate to tablespace option for? ... Relocate option normally is being used when: 1. ... User wants to move tables or indexes to a different tablespace. ... 2. On some occasion, we've seen users relocate objects to different tablespaces, and then run another reorg to relocate them back to original tablespaces, only when: a. Users do not have enough space in the original tablespace b. Users need to do maintenance on the datafiles.
Received error: invalid logon while trying to install QSA manually on Windows server (4250124)
Received error: invalid logon while trying to install QSA manually on Windows server ... Msxml4.dll is not installed ... Install msxml4.dll. ... Then try to reinstall QSA manually again on the server.
QSA fails (can't find pid) - QSA-20392 Internal error in script engine at qexecd (4232034)
QSA does not restart itself as usual when it encountered the below error, ... QSA fails (can't find pid) - QSA-20392 Internal error in script engine at qexecd ... The error can't find process id is OS related.
Receive error: ora-00604, ora-01116, ora-01110 and ora-27092 during space manager installation (4258246)
ORA-01116: error in opening database file 15 ... ORA-01110: data file 15: '/sv10/data/db/wfmprd/undotbs2.dbf' ORA-27092: size of file exceeds file size limit of the process ... 1. Change the Ulimit value to unlimited
Cannot choose "LiveReorg" for T-lock option for Oracl Standard Edition (4324853)
Can't shoose "LiveReorg" for T-lock option when <p>Customer is using Oracle Standard Edition, without Partitioning option with Space Manager LiveReorg 8.1 version, table cannot be reorganized with T-lock switch in Oracle Standard Edition.</p><p>SQL> select * from v$option;</p><p>PARAMETER VALUE<br>---------------------------------------------------------------- ----------------------------------------------------------------<br>Partitioning FALSE</p> Issue fixed by Space Manager 8.1.1.694. 451771
Error: ORA-04043: object QUEST_QSA_LWRP<Object_ID> does not exist (4327306)
A previously reorg job for this table left some temporary objects behind. ... This may occurs when the table has been reorganized once already and the previous reorg job was cancelled or aborted.
How to refresh statistics in space manager (4234772)
Database has changed from the last time an analysis was done, for example several objects no longer exist ... In order to refresh space manager statistics, you will need to go to File | Admin and select the Space Manager Stats Cleanup option cleans up the space manager repository by deleting stats for objects that have been dropped from the database.
Workaround to QSA 6.2 against Oracle 9.2.0.4 and earlier on AIX 5 (4326238)
Error: "QSA-20383: Could not create configuration file" when trying to install Quest Server Agent on Oracle pre 9205 running on AIX. ... Workaround to support QSA 6.2 against pre Oracle 9.2.0.5 on AIX 5 and above
Switch rac nodes between clusters - becomes unstable to connect (4236367)
You need to clean up the old QSA and reinstall. ... The shortest way to do that if there is no QSA version changed between the old and the new is to force a fresh install. ... Run the query below and reinstall QSA and let me know if errors persists: delete from quest_com_products where product_id=61; commit;
Reinstalling Space Manager after Oracle upgrade or cloned database (4290150)
When Space Manager objects become invalid or several database errors result when connecting, then an oracle upgrade or cloning the database may have invalidated the Space Manager installation and objects.
Online Reorg for Indexes - requests an automatic load for associated tables (4232274)
User like to request a function or option in space manager that will automatically load tables for indexes that have been selected in a livereorg. ... While selecting indexes that need reorg, the livereorg could not be completed because the indexes did not have their tables selected as well
Error calculating reorg need for tablespace <tablespace_name> (ora-06502: PL/SQL: numeric o (4249658)
This happens when a table has a lot of LOB columns and/or with long names. ... Try installing the attached packages and retry. ... 1. You need to Rename the current spc_pkg_reorg_need_body90.plb and spc_pkg_analysis_tasks90.sql in space manager Install folder
Received error: Access denied during Quest Server Agent installation (4242524)
Received error: Access denied during Quest Server Agent installation ... Incorrect permission on ScriptQSAInstall.log. ... 1. Delete ScriptQSAInstall.log file ... 2. Restart installation by running QSAInstall.exe
"License key expired" (4217777)
1. From the Space Manager client Tools tab, select Admin License Key ... 2. Copy the expired Authorization Key and site Message ... 3. Email the License Support at license@quest.com to create a service request to obtain a permanent key and a temporary key while waiting for the permanent key
Turn OFF autorefresh (4329509)
Is there a way to turn off auto refresh of the views in livereorg. ... My application is constantly freezing because autorefresh is 5 seconds. ... 2 Select the Automatically refresh scripts list checkbox.
Error: "Aborted FC-20633 Direct path export failed at row 1" during fastcopy (4332423)
When running fastcopy against a table containing LONG column, and CHAR (1 CHAR) column, in a database which uses multi-byte Character set such as AL32UTF8, an error: "Aborted FC-20633 Direct path export failed at row 1" is encountered.
New Product Association
- Self Service Tools
- Knowledge Base
- Notifications & Alerts
- Product Support
- Software Downloads
- Technical Documentation
- User Forums
- Video Tutorials
- RSS Feed
- Contact Us
- Technical Support
- View All