DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA-06553: PLS-213 package STANDARD not accessible

  1. #1
    Join Date
    Jun 2005
    Posts
    1

    Exclamation ORA-06553: PLS-213 package STANDARD not accessible

    Hi All,

    I'm having this message when I try to logging into the DataBase (Oracle 7.3.4, HP-UX)

    Here I post the traces:

    ====================
    sqlplus system/manager

    SQL*Plus: Release 3.3.4.0.0 - Production on Thu Jun 16 10:47:15 2005

    Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.

    ERROR:
    ORA-06553: PLS-213: package STANDARD not accessible


    Error accessing package DBMS_APPLICATION_INFO
    ERROR:
    ORA-06553: PLS-213: package STANDARD not accessible


    Connected to:
    Oracle7 Server Release 7.3.4.2.0 with the 64-bit option - Production
    PL/SQL Release 2.3.4.2.0 - Production

    SQL> exit
    Disconnected from Oracle7 Server Release 7.3.4.2.0 with the 64-bit option - Production
    PL/SQL Release 2.3.4.2.0 - Production
    smp1 pfuser> exp system/manager

    Export: Release 7.3.4.2.0 - Production on Thu Jun 16 10:47:29 2005

    Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.


    Connected to: Oracle7 Server Release 7.3.4.2.0 with the 64-bit option - Production
    PL/SQL Release 2.3.4.2.0 - Production
    Enter array fetch buffer size: 4096 >

    Export file: expdat.dmp > /in/platform/pfuser/UAE6_20050616.dmp

    (1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > 1

    Export grants (yes/no): yes >

    Export table data (yes/no): yes >

    Compress extents (yes/no): yes > no

    Export done in US7ASCII character set

    About to export the entire database ...
    . exporting tablespace definitions
    . exporting profiles
    . exporting user definitions
    . exporting roles
    . exporting resource costs
    . exporting rollback segment definitions
    . exporting database links
    . exporting sequence numbers
    . exporting snapshots
    . exporting snapshot logs
    . exporting job queues
    EXP-00008: ORACLE error 6553 encountered
    ORA-06553: PLS-213: package STANDARD not accessible
    EXP-00000: Export terminated unsuccessfully
    smp1 pfuser>
    =================

    What I want to know is if I run theses scripts (standard.sql, catexp.sql and catproc.sql) what will happened with my services (Prepaid, Universal, etc...). Will they crash?... I guess yes....

    Pls help me....

    Thks in advcd
    Sebas
    Last edited by sebashache; 06-16-2005 at 03:18 PM.

  2. #2
    Join Date
    Jan 2001
    Posts
    3,134
    Sounds like that package is missing or corrupt, not a good thing when there are problems with the SYS schema.
    Can you pull the DDL to re-create it from another box?

    Is that package compiled?
    I remember when this place was cool.

  3. #3
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    Just run that standard.sql and see whther the problem is solved or not.This will have no effect on your applications
    There are three kinds of lies: Lies, damned lies, and benchmarks...

    Unix is user friendly. It's just very particular about who it's friends are.

    Oracle DBA

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