After enabling trace for a session, immediately fails with ora-00900 saying error at line 2 in settrace:
The following session could not be traced:
SID = 117
Serial = 3740
Oracle error:
ORA-00900: invalid SQL statement
ORA-06512: at "NAME.QUEST_SOO_PKG", line 1704
ORA-06512: at line 2
in table SetTrace
NOTE: Patched pkg to be used in 9.5.1 version only !!!
Attached is a patch to fix this issue ...
To apply the patch, please follow the steps to update your environment:
1. Close your Spotlight 9.5.1;
2. Open the folder “Spotlight on Oracle/Plug-ins/SoO”, rename the existing file “quest_soo_pkg.plb” to “quest_soo_pkg.plb_bak” or other names to back it up;
3. Copy the attached file “quest_soo_pkg.plb” into folder “Spotlight on Oracle/Plug-ins/SoO”;
4. Start your Spotlight 9.5.1, and open user wizard dialog from menu “File->Oracle User Wizard…” to reconfigure the user you are using on the connection by following:
Ø Click “Next” button and go to “DBA connection credentials”, input the DBA account details and click “Next” button;
Ø Select “Set up an existing user” and click “Next” button;
Ø Select the user you are using on the connection and enter the password, click “Next” button;
Ø Click “Next” button by default or you can change the option, finally finished the reconfiguration of the user, launch the connection.
5. The users on all your other connections are needed to be reconfigured like above before you continue to use.
