2008-3-27 17:18
slippY123
oracle 如何低patch 大哥们帮帮我呀!
我使用 dbua 降报读.
用readme 的方法不行.
sqlplus /nolog
SQL> CONNECT SYS/SYS_password AS SYSDBA
Set the CLUSTER_DATABASE initialization parameter to FALSE:
SQL> ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=spfile;
Exit SQL*Plus and shut down the database:
SQL> EXIT
$ srvctl stop database -d db_name
$ sqlplus /nolog
SQL> CONNECT SYS/SYS_password AS SYSDBA
SQL> SHUTDOWN (Required only for Single Instance)
SQL> STARTUP MIGRATE
SQL> SPOOL catbkout.out
SQL> @?/rdbms/admin/catbkout.sql
SQL> SPOOL OFF
SQL> SHUTDOWN IMMEDIATE
Restore the Oracle9i installation and Inventory (see /etc/oraInst.loc) that you backed up before applying the patch set.
After restoring the original Oracle home, perform the following steps:
$ sqlplus /nolog
SQL> CONNECT SYS/SYS_password AS SYSDBA
SQL> STARTUP MIGRATE
SQL> SPOOL catpatch.out
SQL> @?/rdbms/admin/catpatch.sql
SQL> SPOOL OFF
If Oracle Spatial is installed with the database, perform the following steps:
SQL> alter session set current_schema = mdsys;
SQL> @?/md/admin/prvtmd.plb
SQL> @?/md/admin/prvtmd2.plb
SQL> @?/md/admin/sdopidx.sql
SQL> @?/md/admin/prvtpidx.plb
SQL> @?/md/admin/prvtsidx.plb
SQL> @?/md/admin/sdogeom.sql
SQL> @?/md/admin/prvt3glh.plb
SQL> @?/md/admin/prvtgeom.plb
SQL> @?/md/admin/prvt3gl.plb
SQL> alter session set current_schema = sys;
Shut down the database:
SQL> SHUTDOWN IMMEDIATE
Start the database and recompile the remaining invalid objects:
SQL> STARTUP
SQL> @?/rdbms/admin/utlrp.sql
Review catbkout.out and catpatch.out for errors.