In Session Browser I clicked on green button to start a trace session.
Selected the Support tab and clicked OK, resulting in the following error:
"PLS-00201: identifier 'SYS.DBMS_SUPPORT' must be declared"
1. SYS.DBMS_SUPPORT package is not installed or is invalid, or
2. User does not have execute privileges on the package
SOLUTION 1:
Install the package (script located in ORACLE_HOME/rdbms/admin/dbmssupp.sql) or recompile the package if invalid
SOLUTION 2:
Have DBA grant execute permission i.e.
GRANT EXECUTE on SYS.DBMS_SUPPORT to username;
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center