LoveUnix » ORACLE等数据库 » oracle 如何低patch 大哥们帮帮我呀!
让LU留住您的每

一天 让LU博客留住您的每一天
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.

2008-3-30 06:54 vongates
请问楼主是如何区分行和不行的。
对着readme做就没有问题的。
别外楼主的是RAC的环境吗

页: [1]


Powered by Discuz! Archiver 5.5.0  © 2001-2006 Comsenz Inc.