Results 1 to 9 of 9
  1. #1
    Join Date
    Mar 2003
    Location
    SJ, Costa Rica
    Posts
    48

    Unanswered: error accessing package "DBMS_APPLICATION_INFO"

    Hi everybody!
    Everytime I log in oracle with the system user, I get the
    following message:

    Error accessing package DBMS_APPLICATION_INFO
    ERROR:
    ORA-06509: PL/SQL: ICD vector missing for this package
    ORA-06512: at "SYSTEM.DBMS_APPLICATION_INFO", line 37
    ORA-06512: at line 1

    I've read something about that the package must be owned by the sys user, I ran several scripts but haven't resolved this yet.
    Any pointers about this?
    thanks in advance.
    regards,

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    looks like you ran CATALOG.SQL and/or CATPROC.SQL as a user other
    than SYS, see Note:1015902.4 on ways how to cure this,
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Mar 2003
    Location
    SJ, Costa Rica
    Posts
    48
    where can I find this note?
    thanks!
    regards,

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    http://metalink.oracle.com
    but access to it requires a support contract/CSI number.

    As SYS do the following:

    1. Rerun CATPROC.SQL.
    2. Rerun DBMSUTIL.SQL.
    3. ALTER PACKAGE DBMS_APPLICATION_INFO COMPILE.

    If problem still persists, do

    4. Relinked procedural option (mk -f ins_rdbms.mk procopt) and install (mk -f ins_rdbms.mk install).
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Mar 2003
    Location
    SJ, Costa Rica
    Posts
    48
    thanks anacedent,
    I tried the steps you posted,
    I have problems with the 4th step, I can't find the "mk" command...
    any other pointer?
    thanks in advance..
    regards,

  6. #6
    Join Date
    Mar 2003
    Location
    SJ, Costa Rica
    Posts
    48
    ok, this supossed to be pretty basic, sorry...
    I use Redhat Linux and I should use 'make' instead of mk..
    thanks...

  7. #7
    Join Date
    Mar 2003
    Location
    SJ, Costa Rica
    Posts
    48
    well, despite I already figure out how to run all the steps, I still receive the same error...
    Still accepting suggestions
    regards,

  8. #8
    Join Date
    Jan 2004
    Posts
    370
    Did you shutdown all instances when you relinked?
    If not the new executable would not have been copied to $ORACLE_HOME/bin

  9. #9
    Join Date
    Mar 2003
    Location
    SJ, Costa Rica
    Posts
    48
    this post is very old.
    Months after this post I realize how to resolve this problem.
    just do as user system:
    Code:
      drop package dbms_application_info
    that will do the trick!
    regards,
    -eduardo s.m.

Posting Permissions

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