SOURCE OF INVALID STANDARD.SQL

[cib]

I am trying to find what occured to make STANDARD.SQL invalid in one of our databases. We were not running an install, an upgrade or applying a patch.

Somewhat before standard.sql became invalid I dropped some synonyms.

THANKS

[dknight]

How do you know that it is invalid? What are the symptoms?

[cib]

When logging into sql*plus I was getting error messages that package STANDARD was not available (ora-06553). I ran script to view all invalid_objects and then compiled standard. It corrected the problem, no longer were the errors coming up when I logged into sql*plus. Although now there are about 300 invalid 'sys' objects.

[dknight]

I had a related problem a few weeks ago during 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.

[cib]

I was able to recompile the package standard. I am just curious how the package could have become invalid. We were not installing, upgrading or adding a patch.

thanks

[davidpan]

I had experience the same question? but do not solve until now.
The oracle version is 8.1.5. OS solarix 5.7.
I have two database at the machine. a long time they can normal run. but one day, one database occur "ora-6553' at sqlplus, but other database can normal run, i could not find the find standard.sql directory ORACLE_HOME/rdbms/admin .
i ask the question what action can bring on the error,
how to solve the problem?

[dknight]

The STANDARD package is created with dbmsstdx.sql in $ORACLE_HOME/rdbms/admin.

The package and the .sql are different things.

[davidpan]

dknight , you say the PACKAGE STANDARD was created by dbmsstdx.sql, i could not find the syntax "create or replace package STANDARD " , only found the "create or replace package STANDARD" at standard.sql, i do not know your means. can you explain that?

[shawish_sababa]

Hi guy's

never ren into this (allways running into neww stuff on this forum), but, when i lokked at the metalink i found this doc id:
132217.999

there is a reference there to an official oracle note that i could not access. look into this, if you can not access metalink post your email.

[jm]

in metalink search, I typed 132217.999
no match!!!

where I can locate this doc? forums or tar?

thanks