-
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.
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|