tracing session using dbms package
Hello: I am trying to trace a particular session and get this message
SQL> execute dbms_system.set_sql_trace_in_session (41, 721, TRUE);
BEGIN dbms_system.set_sql_trace_in_session (41, 721, TRUE); END;
ERROR at line 1:
ORA-06509: PL/SQL: ICD vector missing for this package
ORA-06512: at "COTPROD.DBMS_SYSTEM", line 54
ORA-06512: at "COTPROD.DBMS_SYSTEM", line 46
ORA-06512: at line 1
How do I resolve this issue? If I have to run catproc or catlog.sql on a production system, is it OK? and how would I do that without any problems. Should users be on or off and any risks?
Probably u should call to Oracle Customer support or
I did look into metalink..
It's resolved now..
The solution is to do the same logged in as SYS user, rather than as a SYSTEM or any user with DBA privilege.
Click Here to Expand Forum to Full Width