** Myself
## Upgrade and recompiled object
set ORACLE_SID=ORCL
sqlplus "/as sysdba"
startup upgrade;
spool uppatch.log
@$ORACLE_HOME/rdbms/admin/catupgrd.sql;
shutdown immediate;
startup;
@$ORACLE_HOME/rdbms/admin/utlrp.sql;
spool off
##The database will now be started in STARTUP UPGRADE mode. This will disable
system triggers and replication dependency tracking, and will suppress unwanted
error messages such as ORA-904: table or view does not exist and ORA-01092: ORACLE instance terminated. Disconnection forced. This
will make it easier to screen the spool file for errors during the upgrade.
0 comments:
Post a Comment