Downgrade Oracle Database 11.2.0.3 to 11.2.0.2
Downgrading 11.2.0.3 to 11.2.0.2 works. But like everything with oracle 11.2 you have to apply a patch.
Oracle Restart (GI) is used for this setup.
# current release
shutdown immediate
startup downgrade
spool downgrade
drop user sysman cascade;
@catdwgrd.sql
spool off
shutdown immediate
shutdown immediate
# change environment
srvctl downgrade database -d dsdb01 -o /opt/app/oracle/product/11.2.0/rdbms1 -t 11.2.0.2
oratab
sid dsdb01
srvctl modify database -d dsdb01 -p /opt/app/oracle/product/11.2.0/rdbms1/dbs/spfiledsdb01.ora
srvctl config database -d dsdb01
???
# get cat reload from patch 11811073
unzip p11811073_112020_Generic.zip
cd 11811073
/opt/app/oracle/product/11.2.0/rdbms1/OPatch/opatch apply
startup upgrade
spool reload.log
@$ORACLE_HOME/rdbms/admin/catrelod.sql
spool off
shutdown immediate
startup
@utlrp