Getting error when enabling session trace

sseshadr

Member
Hello,
I am getting error 'PLS-00201:identifier SYS.DBMS_SYSTEM must be declared' when trying to enable SQL trace for a session. This happens only with Oracle 9.2 database and works fine with Oracle 8.1.7. Tried with both 8.1.7 and 9.2 client using PL/SQL Developer 5.1.6.747. I did executed DBMSUTIL.SQL and PRVTUTIL.PLB as SYS user. Able to enable sql trace on server and it works fine but not able to enable SQL trace using PL/SQL Developer.

Thanks in advance!
 
I think you need to grant the execute privilege on sys.dbms_system to the user (or to an applicable role).
 
Back
Top