package standard not accessible

[wischme]

Hi,
I have 3 instance of 8i on SOLARIS on the same machine,
when I connect to database via Sqlplus with the 1st SID there's no problem with.
But when i try to connect with one of the two others I got this error :
Error accessing package DBMS_APPLICATION_INFO
ERROR:
ORA-06553: PLS-213: package STANDARD not accessible
Connected to:
Oracle8i Release 8.1.5.0.0 - Production
With the Java option
PL/SQL Release 8.1.5.0.0 - Production
SQL>
And just after I can do every query I need on the target instance (one of them is RMAN's one).
Is there something to do that I could have miss when I create the two others instances ?
Thanks.

[marist89]

I think this package gets created with either catalog.sql or catproc.sql.

[dknight]

I had a related problem a few days ago. It may be related to the installation.

Try this:

1. run catalog.sql in $ORACLE_HOME/rdbms/admin
2. run dbmsstdx.sql in $ORACLE_HOME/rdbms/admin
3. run catproc.sql in $ORACLE_HOME/rdbms/admin

I found that running only catalog and catproc did not successfully create and compile the DBMS_STANDARD package.

You can view DBA_OBJECTS with owner='SYS' and object_type = 'PACKAGE' to see if the packages are valid.

Good luck

[wischme]

thanks, I have forgoten to run dbmsstdx.sql.
Now it's realy better.
Thanks again.

[dknight]

Oracle documentation will not tell you to run the dbmsstdx.sql script, only catalog.sql and catproc.sql.

They should update the documentation in my opinion.