-
Title
"ORA-06512: at SPOT.QUEST_SOO_ARCHIVELOG, line 1757 in table ArchiveBuildList" -
Description
This is new Spotlight on Oracle 6.0 installation. Runs for a couple of minutes before Oracle error messages popped up on the main screen of Spotlight.
Product:
Spotlight on Oracle 6.0.0.1325
--------------------------------------------------------------------------------
Message:
An error occurred while refreshing the table ArchiveBuildList in connection FProd.
* Click OK to continue,
* Click Ignore to ignore any further errors related to this table, or
* Click Disconnect to close this connection.
--------------------------------------------------------------------------------
Details:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at SPOT.QUEST_SOO_ARCHIVELOG, line 1757
in table ArchiveBuildList
-------------------------------------------------------------------------------- -
Resolution
WORKAROUND:
The supportbundle shows that third archive destination is called (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=<hostname>)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME= <service name>)(INSTANCE_NAME=<instance name>)(SERVER=dedicated))) which exceeds the limitations of Spotlight. The workaround in the meantime is to shorten the name of the archive destination, by adding an alias to the tnsnames.ora file on the server, then pointing the destination to that alias, instead of the full connect string.
RESOLUTION:
Waiting for fix in a future release of Spotlight on Oracle. -
Defect ID
CR6831