Backout 10.2.0.5 to 10.2.0.1 (Downgrade):

Backout 10.2.0.5 to 10.2.0.1 (Downgrade):

$ sqlplus /nolog

SQL> connect / as sysdba

SQL> SHUT IMMEDIATE

SQL> EXIT

Take backup of following files from 10.2.0.5 Oracle Home Directory:

$ cp $ORACLE_HOME/rdbms/admin/catrelod.sql  $ORACLE_HOME/rdbms/admin/catrelod.sql.10205

$cp /var/opt/oracle/tnsnames.ora   /var/opt/oracle/tnsnames.ora_10205

$ sqlplus /nolog

SQL> connect / as sysdba

SQL> startup downgrade

SQL> spool downgrade.log

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

SQL> spool off

SQL> shut immediate

SQL> exit

     èCopy 10.2.0.1 catrelod.sql to oracle home {10.2.0.1 binary backup catrelod file only copy }

$ cp $ORACLE_HOME/rdbms/admin/catrelod.sql   $ORACLE_HOME/rdbms/admin/catrelod.sql

$sqlplus /nolog

SQL> connect / as sysdba

SQL> spool catrelod.log

SQL> startup downgrade

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

SQL> spool off

SQL> shutdown immediate

SQL> connect / as sysdba

SQL> startup

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

SQL> spool off

SQL> shutdown immediate

SQL> select comp_name,version,status from SYS.DBA_REGISTRY;