Following Oracle's desupport notice, I need to upgrade my 10.2.0.5 ASM instance running on windows 64bit to 11g R2.
Can anyone provide me with a link or metalink page that provides step by step instructions for doing this?
I tried following the upgrade guide, for the grid infrastructure and it just hung at the point of 'Starting Grid Configuration'. At this point I had to do a full system restore back to 10g r2.
There are no functional reasons for upgrading the the DB from 10.2.0.5 as it is running well and has experienced no downtime since August and at the moment, the risk of upgrading without clear documentation seems too risky.
Every patchset comes with a file called 'readme'. It contains installation instructions.
Did you read it?
Also, all documentation is on http://docs.oracle.com, including installation documentation.
Senior Oracle DBA
I have looked through the documentation and readme and can only find the following:
If you have an Oracle Automatic Storage Management installation from a previous release installed on your server, or in an existing Oracle Grid Infrastructure installation, you can use Oracle Automatic Storage Management Configuration Assistant to upgrade the existing Oracle Automatic Storage Management instance to 11g Release 2 (11.2), and subsequently configure disk groups, Oracle Automatic Storage Management volumes and Oracle Automatic Storage Management file systems.
You must first shut down all databases and applications using an existing Oracle Automatic Storage Management instance before upgrading it.
So at the moment, the only instructions I can use are:
1. Unload the zip file
2. Run OUI
3. Stop the DB instances using the current ASM and run the upgrade (leaving the ASM instance running)
Last time I ran this, the upgrade hung.
I did close the ASM instance once the ASM instance had been indentfied, is this the mistake I madet?
I find the above instructions very ambiguous and would expect some clear instructions from Oracle for such a major DB maintenance job.
Hi - thanks for the advice.
I have had a look at the recommended metalink notes and all of them are for linux/ unix systems,
I need the equivalent for windows.
Looking at the notes, I seem to have got most of the way and then hit the hang phase.
I'm going to try again tomorrow, keeping the ASM instance up, and close the DB instance.
If this fails, then it's back to 10.2.0.5 until next Christmas.
You can refer
ASM 11.2 Configuration KIT (ASM 11gR2 Installation & Configuration, Deinstallation, Upgrade, ASM Job Role Separation (Standalone Only). (Doc ID 1092213.1)