BACKOUT FROM 10.2.0.1 to 9.2.0.7 (DOWNGRADE):

BACKOUT FROM 10.2.0.1  to 9.2.0.7 (DOWNGRADE):

$ .oraenv

     ORACLE_SID:prod

$sqlplus “/ as sysdba”

SQL> startup downgrade

SQL> SPOOL downgrade.log

SQL> @/opt/oracle/product/10.2.0/rdbms/admin/catdwgrd.sql àu already upgraded all components to be downgrade

SQL> SPOOL OFF

SQL> shutdown immediate

# vi /etc/oratab

 prod:/opt/oracle/product/9.2.0:N

 #prod:/opt/oracle/product/10.2.0:N

$ .oraenv

     ORACLE_SID:prod

$ echo $ORACLE_HOME

                /opt/oracle/product/9.2.0

$sqlplus /nolog

SQL> connect sys/sys_password as sysdba

SQL>startup migrate

SQL> SPOOL reload.log

SQL> @/opt/oracle/product/9.2.0/rdbms/admin/catreload.sql àwhat r the 9i DB Datadictionary table needed that can be create.

SQL>SPOOL OFF

SQL> shutdown immediate

SQL> startup

SQL> @/opt/oracle/product/9.2.0/rdbms/admin/UTLRP.SQL

SQL> select comp_name,status,version from dba_registry;