Home » RDBMS Server » Server Administration » package STANDARD not accessible
package STANDARD not accessible [message #62079] Wed, 23 June 2004 21:10 Go to next message
Gaurav
Messages: 20
Registered: February 2002
Junior Member
ORA-00604: error occurred at recursive SQL level 1
ORA-06553: PLS-213: package STANDARD not accessible
I am getting these two errors together whenever i try to run the "$ORACLE_HOME/SQLPLUS/ADMIN/PLUSTRCE" script.
The instance of database i am working on was automatically created by Oracle as default databse while installing Oracle9i.Do i need to run Catalog.sql & Catproc.sql. 

Report message to a moderator

Re: package STANDARD not accessible [message #62082 is a reply to message #62079] Thu, 24 June 2004 01:05 Go to previous messageGo to next message
Alex
Messages: 190
Registered: August 1999
Senior Member
I ve got last week the same error-messages and running these scripts solved the problem!

Report message to a moderator

Re: package STANDARD not accessible [message #62116 is a reply to message #62079] Fri, 25 June 2004 16:07 Go to previous messageGo to next message
Thomas Anderson
Messages: 9
Registered: January 2003
Junior Member
Your DBMS_STANDARD package either wasn't created or got invalidated for some reason. Run the catalog.sql & catproc.sql as SYSDBA and the problem will be solved.

Spool the scripts output, so you can check for any errors later.

Hope that helps,

clio_usa - 8/8i/9i OCP DBA

Oracle DBA Resources | Oracle DBA Forums & Usenet Newsgroups

Report message to a moderator

Re: package STANDARD not accessible [message #63212 is a reply to message #62079] Sat, 18 September 2004 15:11 Go to previous message
yull
Messages: 1
Registered: September 2004
Junior Member
hum guys

what to do if the same error occurs when trying to execute the catalog.sql and catproc.sql?:-)))

thanks

Report message to a moderator

Previous Topic: 100%cpu usage
Next Topic: Statistics : Urgenrt
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Feb 03 05:22:31 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.