Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

OS upgrade from 11.0 to 11.i . do we really need to upgrade/relink oracle ??

anand_19
Occasional Visitor

OS upgrade from 11.0 to 11.i . do we really need to upgrade/relink oracle ??

After upgrading OS from 11.0 to 11.i do we really need to relink oracle or oracle 8.1.7.4 will work ?
seeks margarita for good times
10 REPLIES
Ian Dennison_1
Honored Contributor

Re: OS upgrade from 11.0 to 11.i . do we really need to upgrade/relink oracle ??

1. I would install HP-UX 11i direct, rather than upgrade (there are many posts on this subject).

2. Definitely relink Oracle afterwards (Use the make commands specified by oracle).

Share and Enjoy! Ian
Building a dumber user
John Poff
Honored Contributor

Re: OS upgrade from 11.0 to 11.i . do we really need to upgrade/relink oracle ??

Hi,

We upgraded from 11.0 to 11i a few months ago here, and our Oracle DBAs had to relink our binaries. I'm not a DBA, but they said it was pretty smooth and painless.

JP
John Poff
Honored Contributor

Re: OS upgrade from 11.0 to 11.i . do we really need to upgrade/relink oracle ??

Ian is right. We did a cold install here also for the O/S, and not an upgrade.

JP
Steven E. Protter
Exalted Contributor

Re: OS upgrade from 11.0 to 11.i . do we really need to upgrade/relink oracle ??

1) You MUST relink oracle.

2) The upgrade path is harder and a bad idea.

You are better off with a cold install, then the latest Gold Quality Pack, then the required oracle patches, then java patches, then java, then oracle, then migrate your data.

You can't reliably pull off an upgrade on a single production server.

P
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Keith Clark
Valued Contributor

Re: OS upgrade from 11.0 to 11.i . do we really need to upgrade/relink oracle ??

The others are correct. You must relink Oracle. You should also relink Oracle anytime that you apply Networking or Kernel patches. We now relink Oracle after we apply our quarterly patch bundles due to past MC/SG - Oracle issues. It's quite simple with 8.x and up:

su -
relink all (8.x and up)
Ravi_8
Honored Contributor

Re: OS upgrade from 11.0 to 11.i . do we really need to upgrade/relink oracle ??

Hi,

after upgrade you need to relink the oracle.

I prefer to do cold install rather than upgrade to 11i. it creates problem later, even though it looks fine now
never give up
anand_19
Occasional Visitor

Re: OS upgrade from 11.0 to 11.i . do we really need to upgrade/relink oracle ??

Thanks a lot guys !!!!
I will relink oracle ..... I was hesitating as I am doing this on production box .
seeks margarita for good times
Steven E. Protter
Exalted Contributor

Re: OS upgrade from 11.0 to 11.i . do we really need to upgrade/relink oracle ??

DONT!
DONT!

Hesitate some more.

Based on a half decade of experience with Oracle and a decade of HP-UX experience let me tell you this:

You can not do this on a production box without substantial downtime. Even if everything goes perfectly, it will take a long time.

It will not go perfectly.

If you peridodically upgrade hardware, buy a new box, build it with the new OS and make the last step of your migration plan migrating the oracle data.

That's how we do it.

P
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Keith Clark
Valued Contributor

Re: OS upgrade from 11.0 to 11.i . do we really need to upgrade/relink oracle ??

Sorry Steven I don't agree. We have just completed O/S upgrades on half of our SAP environemnt, 12 oracle instances. We did cold HP-UX 11i installs using ignite and can complete the entire upgrade in a three hour window. The relink of oracle takes maybe 10 minutes tops.

We put in a lot of up front work, building our ignite image and testing the upgrade procedure in our technical sandbox. But now we have a repeatable procedure that has not failed us in the first six upgrades.

Good luck Anand, and be sure to test, document, test again till you are comfortable with your the procedure.
Ian Dennison_1
Honored Contributor

Re: OS upgrade from 11.0 to 11.i . do we really need to upgrade/relink oracle ??

WRT upgrade paths,...

No matter how much you test an upgrade or an install & cutover, it will never be guaranteed to work the same every time.

Yes, you should test diligently on trash and burn servers, then migrate the changes through from least impact / importance to highest impact / importance servers.

Yes, you should ensure that you have a reliable reversion path that you have experience in using, and reliable backups (lets be honest, when was the last time you tested your reversion method before implementing changes like this? Anyone?)

BUT! If it was that easy and reliable to do, this T-shirt would be true of a lot of SysAdmins,...

http://www.thinkgeek.com/tshirts/frustrations/374d/

Due diligence is the watchword here,...

- Look for notes on Oracle On The Net (OTN), from HP and from the Product Vendor (SAP, Sybase, Progress, Peoplesoft) regarding this type of upgrade / relink. It should be very rare to have a problem that is unique to only you.

- Test on the different types of configuration, patch levels and hardware as much as time and resources permit

- Know the criteria for success that you require, how to measure it and time limits for success / reversion.

- Write down the steps so you (and others) know what has to be done, and what has been done at any stage of the upgrade.

In short, take all resonable measures to ensure success.

And if it all turns to custard, the business is relying on your experience, judgement, wisdom and character to do the following,...

- Know the implications of the problem (or how to find them out)

- Understand when you need to ask for outside help, who to ask and what to tell them

- Be familiar enough with the products to revert the upgrade or changes made in a reasonable period of time (Reversion Timings was what I believe Steve P was highlighting in his comments)

And if the boss gets upset because something did go wrong, show him the project plan and all your reasonable steps, then tell him 'if it makes you feel any better, you can go and shout at the Server for 10 mins or so!'

Share and Enjoy! Ian
Building a dumber user