Category
Versión del producto
Tema
Subtema
Idioma
Es necesario instalar el Quest Server Agent (QSA)? (4327123)
El agente QSA necesita ser ejecutado en el servidor de la base de datos para admnistrar la reorganización y la calendarización de las tareas.</p><p>QSA también tiene su propia base de datos de objetos las cuales deben ser installados en el mismo esquema que el Space Manager.
Error durante instalacion "Failed to open archive file... Invalid Archive Signature." (4308013)
Archivo de instalación descargado está dañado. ... CAUSA 2: ... Usualmente ocurre cuando el usuario usando un dominio de Administrador instala Toad y no posee privilegios completos, o si la empresa posee reglas de seguridad específicas el dominio de la red.
Aborted QSA-20393 Must be run under the Quest Server Agent (4222425)
Cuando se intenta ejecutar un script de reorganización, se recibe el siguiente error: ... Esto ocurre cuando se intenta ejecutar el script desde el cliente o otro ambiente en vez de ejecutarse desde el Agente QSA..
El paquete QUEST_SPC_ANALYZE permanece descompilado (4301038)
Después de actualizar la base de datos de 11.2.0.3 a 11.2.0.4, el paquete QUEST_SPC_ANALYZE se ha descompilado y no se vuelve a compilar. ... El error se da en la línea 1068 del cuerpo del paquete, columna 12.
La instalación de los objetos de Space Manager falla con error ORA-01031 permisos insuficientes (4335579)
El usuario de Oracle perteneciente al Space Manager tiene el role DBA, y el parámetro de inicialización de Oracle O7_DICTIONARY_ACCESSIBILITY está establecido en verdadero "true". ... Aún así, Space Manager intenta instalar los objetos del lado del servidor en Oracle 12c, y falla con error: ORA-01031 permisos insuficientes al intentar crear la vista quest_spc_all_obj.
Reorg manager lento al abrirse (4324870)
Toma mas de 5 minutos el abrir la ventana del Reorg Manager <p><span style="font-size: 12px;"><span style="font-family: arial,helvetica,sans-serif;">Bug de Oracle <span style="color: rgb(68, 68, 68);line-height: 20px;">21308952: Consulta de DBA_FREE_SPACE es lenta en Oracle 11.2.0.4.</span></span></span></p><p><span style="font-size: 12px;"><span style="font-family: arial,helvetica,sans-serif;"><span style="color: rgb(68, 68, 68);line-height: 20px;">Cuando se abre la ventana del Reorg Manager, LiveReorg hace una consulta a DBA_FREE_SPACE para calcular el espacio libre para todos los tablespace.</span></span></span></p><p><span style="font-size: 12px;"><span style="font-family: arial,helvetica,sans-serif;"><span style="color: rgb(68, 68, 68);line-height: 20px;">Se puede observar "TABLE ACCESS FULL RECYCLEBIN$" en el plan de ejecución.</span></span></span></p> <p><span style="font-size: 12px;">1- Purgar la papelera de reciclaje</span></p><p><span style="font-size: 12px;">2- Recopilar las estadísticas de los objetos de diccionario <span style="line-height: 20px;">X$KTFBUE:</span></span></p><p><span style="font-size: 12px;"><span style="line-height: 20px;">sqlplus> exec DBMS_STATS.gather_table_stats('SYS','X$KTFBUE');</span></span></p><p>3- Utilice la versión 11.2.0.3 de dba_free_space (por favor referirse al documento de Oracle <span style="font-family: arial,helvetica,sans-serif;"><span style="font-size: 12px;"><span style="line-height: 20px;">1904677.1</span>)</span></span></p>
Validación en la versión de Space Manager with LiveReorg falla (4328449)
Cuando el cliente de SpaceManager with LiveReorg intenta conectarse a la base de datos, recibe el siguiente error: ... "The Space Manager with LiveReorg database objects are from a later version than currently running on your computer.
No se puede elegir en LiveReorg la opción T-lock en Oracle Standard Edition (4324853)
No se puede elegir en LiveReorg la opción T-lock en Oracle Standard Edition <div>Al utilizar Oracle Standard Edition, sin la opción de Particionamiento en la versión de Space Manager LiveReorg 8.1, la tabla no puede ser reorganizada con la opción T-lock switch.</div><div></div><div>SQL> select * from v$option;</div><div></div><div>PARAMETER VALUE</div><div>---------------------------------------------------------------- ----------------------------------------------------------------</div><div>Partitioning FALSE</div><div></div><div></div> <div>Solución</div><div></div><div>Problema resuelto en la versión de Space Manager 8.1.1.694.</div><div></div><div></div><div>ID del Defecto: 451771</div> 451771
Document for manual clean up on temporary objects created in the process of live-reorg (4345094)
When a Reorg is canceled or fails during the switch step, the cleanup utility will ask to perform a manual cleanup before clearing the failed Reorg from the job list. ... Connect with SPACE MANAGER USER while dropping the quest temporary tables.
How to Auto Approve All Scripts (4352733)
When generating a reorg script in Space Manager the Switch option defaults to 'Upon User Approval'. ... It is possible to select the Switch option. ... This changes the behaviour of a Live Reorg when the tables are ready to be switched.
Access Violation during Simulation of Reorg (4352759)
Whilst generating a reorg script a simulation is run to check space and other possible issues. ... Given this scenario the simulation aborts and reports an Access Violation. ... This can be caused by a missing QSA parameter.
Unable to find the QSA manual installation download for Linux 2.6 (4351767)
The SupportLink site does not seem to offer a manual installation download for Red Hat Enterprise Linux AS release 4 (Linux 2.6). ... There have been no changes required to QSA for this platform since version 2.1 of the O/S, therefore the Linux 2.1 QSA installer is applicable to Linux 2.6.
How to run the package quest_spc_find_long for all tables in a tablespace. (4351696)
The package quest_spc_find_long will calculate the size of longs held in a table and allow Space Manager to choose the optimal reorg method for the table. ... The following code will run quest_spc_find_long for all tables in a tablespace...
Error during snapshot job: "ORA-00600: internal error code, arguments:[kksumc-xpin-required]" (4292271)
When Capacity Manager runs the scheduled snapshot job on the monitoring database it produces an ORA-0600 error. ... The job doesn't complete successfully ... This is due to an Oracle bug which is fixed in a later patch of Oracle.
Received error: QSA-20391 ORA-01631:max # extents () (4325910)
QSA-20391 ORA-01631:max # extents () From the script log, there is no additional information on which specific table had reached the max number of extents. ... 1. The tablespace used for QSA installation has reached the max extent limit set to it.
Actual used information is different between Oracle data dictionary and Quest Repository (4258382)
Users select copy the objects statistics from Oracle Data Dictionary into Space manager Repository, and see the mismatch information field on Actual used when he/she select look up object statistics in Oracle Data dictionary and look up the object statistics in Quest Repository.
Missing information on Index management statistics Report (4227411)
Missing information on Index management statistics Report even analyze was done daily. ... User can capture the statistics into space manager repository by following:
An entry for a repository has been found in Quest tables located on database <alias> But no (4313391)
An entry for a repository has been found in Quest tables located on database <alias> But, no repository was found. ... The application cannot connect to <alias> ... The database once had a repository installed (under a separate username than other quest products) and the repository objects have since been dropped.
How to download Space Manager with LiveReorg 6.x from Supportlink? (4266039)
In order to obtain a copy of the installation file contact Support team using below link by submitting a Service Request:
Error: "QSA-20311 Table conflict with script already executing;" (4326619)
Error when starting a job on the QSA, after a previous script execution: ... For example, a reorg job runs successful once, but then when rerunning the job, this error occurs. ... The QSA (qexecd) is waiting on a PID.
Error when installing Quest Server Agent (QSA): "QSA-20373: Required Quest Script not found"</ (4260254)
The Quest script package is not installed on the database server or incompatible version was installed. ... Install or upgrade Space Manager database object prior to installing or upgrading QSA. ... To install or upgrade database object:
What are the privileges to install and run space manager client? (4259712)
What are the privileges to install and run space manager client? ... To install Space manager client: You need to login as administrator (a member of the Local Admin Group) or Standard Windows user (member of Local Power Users Group).
Aborted ORA-01653: unable to extend table . by in tablespace (4232085)
(os errno 2) ... The reorg tablespace has insufficient tablespace. ... For example, suppose you have allocated 74G and you need one more gig. Oracle will create another extent, and it may be so large that the 90G tablespace runs out of space, even though you only needed one extra gig.
Unable to locate QSA manual installation files for Solaris 10 and Oracle 9. (4351819)
The file descriptions for QSA standalone installation seem to exclude the combination of Solaris 10 for Oracle 9. ... This is a documentation error and a request to update the download site has been created.
Analysis Job Stuck - status indicates 'running' but unable to reschedule (4235082)
User ran an analysis job and it completed with errors, however the job can't be rescheduled because the status indicates that it is still running ... RESOLUTION1:
Asociación de nuevos productos
- Herramientas de autoservicio
- Base de conocimientos
- Notificaciones y alertas
- Soporte de productos
- Descargas de software
- Documentación técnica
- Foros de usuarios
- Tutoriales en video
- Aviso de actualizaciones de páginas web (RSS)
- Comuníquese con nosotros
- Soporte Técnico
- Ver todos