Rem rburns 10/18/04 - remove catpatch.sql
Rem rburns 09/02/04 - remove dbms_output compile
Rem rburns 06/17/04 - use registry log and utlusts
Rem mvemulap 05/26/04 - grid mcode compatibility
Rem jstamos 05/20/04 - utlip workaround
Rem rburns 05/17/04 - rburns_single_updown_scripts
Rem rburns 01/27/04 - Created
Rem
DOC
#######################################################################
#######################################################################
The first time this script is run, there should be no error messages
generated; all normal upgrade error messages are suppressed.
If this script is being re-run after correcting some problem, then
expect the following error which is not automatically suppressed:
ORA-00001: unique constraint (
possibly in conjunction with
ORA-06512: at "
These errors will automatically be suppressed by the Database Upgrade
Assistant (DBUA) when it re-runs an upgrade.
#######################################################################
#######################################################################
#
Rem Initial checks and RDBMS upgrade scripts
@@catupstr.sql
Rem catalog and catproc run with some multiprocess phases
@@catalog.sql --CATFILE -X
@@catproc.sql --CATFILE -X
--CATCTL -S
Rem Final RDBMS upgrade scripts
@@catupprc.sql
Rem Upgrade components with some multiprocess phases
@@cmpupgrd.sql --CATFILE -X
--CATCTL -S
Rem Final upgrade scripts
@@catupend.sql
Rem Set errorlogging off
SET ERRORLOGGING OFF;
REM END OF CATUPGRD.SQL
REM bug 12337546 - Exit current sqlplus session at end of catupgrd.sql.
REM This forces user to start a new sqlplus session in order
REM to connect to the upgraded db.
exit
Rem *********************************************************************
Rem END catupgrd.sql
Rem *********************************************************************
总结：经过以上操作，便可以打开数据库了。可能有朋友已经发现其实这个过程也同样适用于数据库升级的操作。