Re: Upgrading one instance from 11.1.0.7 to 11.2.0.3 on Windows
Date: Thu, 18 Apr 2013 20:26:11 -0400
Message-ID: <CAPptggU4SDMpG-0N795L1R84SKJcXeLB7c=ku-JOjzSb1NvuEQ_at_mail.gmail.com>
Peter,
You will need an 11.2.0.3 Oracle TNS Listener process running to support remote connections.
I doubt that the 11.1.0.7 listener will be able to hand off connections to an 11.2.0.3 database instance.
The Complete Checklist for Manual Upgrades to 11g R2 is your friend - Doc ID 837570.1
At the bare minimum, generate a cold backup set and run the script utlu112i.sql out of the 11.2.0.3 home prior to the startup upgrade ...
Btw, 11.2.0.3 p18 for ms win was released earlier this week. That might be worth including in your test plan. The oc4j patch from the middle of last year should also be applied to the new dbhome.
hth.
Paul
On Thu, Apr 18, 2013 at 4:39 PM, Schauss, Peter (ESS) <peter.schauss_at_ngc.com
> wrote:
> 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
>
>
>
-- http://www.completestreets.org/faq.html http://safety.fhwa.dot.gov/ped_bike/docs/pamanual.pdf -- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 19 2013 - 02:26:11 CEST