Upgrading one instance from 11.1.0.7 to 11.2.0.3 on Windows

From: Schauss, Peter (ESS) <"Schauss,>
Date: Thu, 18 Apr 2013 20:39:40 +0000
Message-ID: <8AE45871F749FC4CBBE053CF2F8A493C0D14A8D6_at_XMBVAG74.northgrum.com>

We have a Win32 server running four instances of Oracle 11.1.0.7. I want to upgrade one of these, the test instance, to 11.2.0.3 while leaving the other three production instances at 11.1.0.7 for the time being. Here is what I plan to do:

• Install 11.2.0.3 in a separate oracle_home.
• Copy the test instance spfile and password file to the database folder in the new oracle_home.
• Use oradim -delete (from the 11.1.0 oracle_home) to delete the test instance service.
• Use oradim from the 11.2.0.3 oracle_home to create a new service for the test instance.
• Start the test instance and upgrade it.

Is there anything else that I have to do to insure that the test instance always comes up under the 11.2.0.3 oracle_home?

Will the production databases continue to start in the 11.1.0.7 oracle_home?

Thanks,
Peter Schauss

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Apr 18 2013 - 22:39:40 CEST