DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.