Database Resources
- RDBMS Server
- Database Administration
- Performance Tuning
- Backup and Recovery
- Oracle Utilities
- SQL and PLSQL
- Network Administration
- Client Applications
- Miscellaneous Stuff

Oracle's technology Sites

http://technet.oracle.com

http://metalink.oracle.com

http://asktom.oracle.com/

http://www.oramag.com

Category     : Database Resources -> Database Administration

DB Version  : Oracle 8i / Oracle 9i

OS Details    : Sun Solaris9

Patch de-install in oracle usually involves restore of the database from the backup taken prior to the patch installation. However, starting 9.2.0.7 oracle has given us the capability to de-install the patch without any restores. Here are the steps as documented by oracle, that need to be followed in order to de-install the patch:

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

$ sqlplus /nolog
SQL> connect / AS SYSDBA
SQL> SHUTDOWN
SQL> STARTUP MIGRATE
SQL> SPOOL catbkout.out
SQL> @?/rdbms/admin/catbkout.sql
SQL> SHUTDOWN IMMEDIATE

Restore the Oracle9i installation and Central 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 / AS SYSDBA
SQL> STARTUP MIGRATE
SQL> SPOOL catpatch.out
SQL> @?/rdbms/admin/catpatch.sql

If Oracle Spatial is installed with the database, perform the following steps:

SQL> alter session set current_schema = mdsys;
SQL> @?/md/admin/prvtsidx.plb
SQL> @?/md/admin/prvt3glh.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