-
Title
Error: "An error has occured in table InitializeFast in connection PROD01.SoO with the following -
Description
When logging into database with Spotlight the following error comes up.
An error has occurred in table InitializeFast in connection <connection> with the following error:
ORA-06550:line 2, column 18:
PLS-00302: component 'INITIALIZE_FAST' must be declared
ORA-06550: line 2, column 4:
PL/SQL: Statement ignored in table InitializeFast -
Cause
Corrupted or incompatible version of Spotlight objects installed.
-
Resolution
If you are the only user, you can drop the objects and let Spotlight re-create them. To do this, you can either drop the user with the cascade option (if you are sure the user is not being used by anything other than Spotlight), or you can use the Database Objects wizard in Quest Central under Configure | Oracle | Database Objects...
If there are other users that are successfully connecting with an older version of Spotlight, it would be best to create a separate spotlight user on the database to be used by the new version and create the schema objects under this new user.