vincent's Blog

這是別人整理好的＠＠
Oracle Database Install Patch Set Software

1.rman full backup database

2.Shut Down Oracle Databases
SQL>shutdown immediate;

3. Stop All Processes

$lsnrctl stop

4. Back Up the /oracle mount point

v890-1 & v890-2
$tar -cvf oracle_9206.tar /oracle

5. Install patch set 9.2.0.8
$ patchset_directory/Disk1
$ ./runInstaller

6. Upgrade the Database
Use SQL*Plus to log in to the database as the SYS user with SYSDBA privileges:
$ sqlplus "/ as sysdba"
SQL> STARTUP MIGRATE;
SQL> SPOOL patch.log
SQL> @?/rdbms/admin/catpatch.sql
SQL> SPOOL OFF

7. Review the patch.log file for errors and inspect the list of components that is displayed at the end of catpatch.sql script.

This list provides the version and status of each SERVER component in the database.
If necessary, rerun the catpatch.sql script after correcting any problems.

8. Restart the database:

SQL> SHUTDOWN
SQL> STARTUP


9. Run the utlrp.sql script to recompile all invalid PL/SQL packages now instead of when the packages are accessed for the first time. This step is optional but recommended.

SQL> @?/rdbms/admin/utlrp.sql

確認資料褲版本
select instance_name,status,version,host_name from v$instance;

10. Start Stop All Processes

$lsnrctl start

select instance_name,status,version,host_name from v$instance;

11.AP test

?
Oracle Database Removing the Patch Set Software

Starting in 9.2.0.7.0, there is a new script called catbkout.sql. This script enables the user to restore the Oracle9i installation of the database back to the original 9.2 patch release (as long as it is 9.2.0.4 or greater) that the user backed up before applying the patch set. Perform the following steps for backing out from the 9.2.0.8 patch release:

1. Before restoring the Oracle home to the original release, perform the following steps:

1. Use SQL*Plus to log in to the database as the SYS user with SYSDBA privileges:

$ sqlplus "/ as sysdba"

2. Exit SQL*Plus and shut down the database:

SQL> SHUTDOWN
SQL> STARTUP MIGRATE
SQL> SPOOL catbkout.out
SQL> @?/rdbms/admin/catbkout.sql
SQL> SPOOL OFF
SQL> SHUTDOWN IMMEDIATE


2. Restore the Oracle9i installation and Inventory (see /var/opt/oracle/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

3. Shut down the database:

SQL> SHUTDOWN IMMEDIATE


4. Start the database and recompile the remaining invalid objects:
SQL> STARTUP
SQL> @?/rdbms/admin/utlrp.sql


5. Review catbkout.out and catpatch.out for errors.

6. Restart the database:

SQL> SHUTDOWN
SQL> STARTUP