tracing session using dbms package Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: tracing session using dbms package

  1. #1
    Join Date
    Oct 2000

    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?

    Thanks, ST2000

  2. #2
    Join Date
    Sep 2001
    NJ, USA
    Probably u should call to Oracle Customer support or
    use Metalink

  3. #3
    Join Date
    Oct 2000
    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.

    Thanks, ST2000

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width