PATCH UPGRADE & DOWNGRADE

ORACLE PATCH UPGRADE…?

1.Method
Fresh Oralce Software Installed (not create any database) then after apply patch .

2.Method

Shutdown all Oracle Windows services

Install 10.2.04 patchset (run setup)

RUN > setup > change home path (ORACLE_HOME _2 to ORACLE_HOME_1)

Startup all Oracle Windows services

NOTE:- When the the database not created then normaly upgrade patch ,But when the database exist then be carefully updated patch see following steps:-

from CMD prompt: sqlplus /nolog

from SQL prompt: connect sys/sys@db as sysdba

after connect:

idel instance show

shutdown immediate

after shutdown:

startup upgrade

after startup:

@ D:\oracle\product\10.2.0\db_1\rdbms\admin\catupgrd.sql

after script finishes (it could take a while)

(Ques)..DOWNGRADE PATCH..........?

For more Info read doc:- Doc ID 1151427.1

https://blogs.oracle.com/db/entry/master_note_for_oracle_database_downgrade_doc_id_11514271

12.1 Removing the Patch Set Software for Single Instance Installation
Perform the following steps for removing the patch set from the 10.2.0.4 patch release:
Use SQL*Plus to log in to the database as the SYS user with SYSDBA privileges:

$ sqlplus /NOLOG
SQL> CONNECT SYS AS SYSDBA

# Enter password:SYS_password
SQL> SHUTDOWN IMMEDIATE
SQL> EXIT

# Take a backup of the following file in 10.2.0.4 Oracle home directory:
D:\oracle\product\10.2.0\db_1\rdbms\admin\catrelod.sql
D:\oracle\product\10.2.0\db_1\rdbms\admin\tnsnames.ora

# Enter the following SQL*Plus commands:
$ cd $ORACLE_HOME/bin
$ ./sqlplus /NOLOG

SQL> CONNECT SYS AS SYSDBA
Enter password:SYS_password

SQL> STARTUP DOWNGRADE

SQL> SPOOL C:\downgrade\downgrade.out

SQL> @ D:\oracle\product\10.2.0\db_1\rdbms\admin\catdwgrd.sql

SQL> SPOOL OFF

SQL> SHUTDOWN IMMEDIATE

SQL> EXIT

Review the downgrade.out file for errors.
After restoring the original Oracle home, copy the saved version of catrelod.sql script into the restored Oracle home rdbms/admin directory.
Also copy the saved version of 10.2.0.4/network/admin/tnsnames.ora directory into the restored
Oracle home /network/admin/tnsnames.ora directory, and
then perform the following steps:

$ sqlplus /NOLOG
SQL> CONNECT SYS AS SYSDBA
Enter password:SYS_password

SQL> STARTUP DOWNGRADE

SQL> SPOOL C:\downgrade\catrelod.out

SQL> @ D:\oracle\product\10.2.0\db_1\rdbms\admin\catrelod.sql

SQL> SPOOL OFF

SQL> SHUTDOWN IMMEDIATE

Review the catrelod.out file for errors.
Start the database and recompile the remaining invalid objects:

SQL> STARTUP

SQL> @ D:\oracle\product\10.2.0\db_1\rdbms\admin\utlrp.sql

Cross-check the status of installed components with the following script:
SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;