Re: Upgrading one instance from 11.1.0.7 to 11.2.0.3 on Windows
- From: Jack van Zanen <jack@xxxxxxxxxxxx>
- To: Paul Drake <bdbafh@xxxxxxxxx>
- Date: Fri, 19 Apr 2013 12:11:06 +1000
Follow the upgrade guide as suggested
Listener for 11.1.0.7 can hand off to 11.2.0.3 database, but may require
some listener.ora changes
Jack van Zanen
-------------------------
This e-mail and any attachments may contain confidential material for the
sole use of the intended recipient. If you are not the intended recipient,
please be aware that any disclosure, copying, distribution or use of this
e-mail or any attachment is prohibited. If you have received this e-mail in
error, please contact the sender and delete all copies.
Thank you for your cooperation
On Fri, Apr 19, 2013 at 10:26 AM, Paul Drake <bdbafh@xxxxxxxxx> wrote:
> 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@xxxxxxx
> > 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
> >
> > --
> > //www.freelists.org/webpage/oracle-l
> >
> >
> >
>
>
> --
> http://www.completestreets.org/faq.html
> http://safety.fhwa.dot.gov/ped_bike/docs/pamanual.pdf
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
