Ask The Real Tom

April 27, 2012

Downgrade Oracle Database to

Filed under: oracle — admin @ 8:02 am

Downgrading to 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;
spool off
shutdown immediate

shutdown immediate
# change environment
srvctl downgrade database -d dsdb01 -o /opt/app/oracle/product/11.2.0/rdbms1 -t
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
cd 11811073
/opt/app/oracle/product/11.2.0/rdbms1/OPatch/opatch apply

startup upgrade
spool reload.log
spool off
shutdown immediate

No Comments »

No comments yet.

RSS feed for comments on this post. TrackBack URL

Leave a comment

Powered by WordPress