|
Cause: The post installation scripts were not
run properly,so drop_segments column is missing
from sys.mon_mods$ . One or more of these post
installation scripts would add the new column to
the database and if the script is not run
properly, it will cause an ORA-904 in the
application later on.
Fix: Connect to the SQL session as SYS and issue
the following:
SQL> desc sys.mon_mods$
If the drop_segments is missing then we are
getting ORA-904.If this is the case,we can do
one of these:
1.Shutdown the database- startup migrate and
then run catpatch.sql and catalog.sql(the
scripts that are needed to be run as a post-installarion
process).
2.Add the drop_segments column using:
SQL> alter table sys.mon_mods$ add (
drop_segments number default 0 );
Then run $ORACLE_HOME/rdbms/admin/catalog.sql
again.
|
