Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
Showing results for 
Search instead for 
Did you mean: 

Server OS upgrade having Oracle

Frequent Advisor

Server OS upgrade having Oracle

I have HP server 10.20 , running Oracle 8.
I am upgrading my server to 11.

Does it be any impact on Oracle database ?
Any prework I need to do before upgrade ?

Looking for your reply.

Graham Cameron_1
Honored Contributor

Re: Server OS upgrade having Oracle

Doesn't have to be any impact on your database if you don't want there to be, but you'll have to re-install the oracle distribution for 11i, oracle for hp-ux 10 may not work too well on 11.

There was a thread on this recently.
Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done.
Stuart Abramson_2
Honored Contributor

Re: Server OS upgrade having Oracle

Certain versions of Oracle are "certified" by Oracle to run on certain versions of HP-UX (and all vendor's OS versions).

You may find that your version of Oracle isn't certified on HP-UX 11.0.

The Oracle may still run, but you Oracle won't provide support for you. And, the old Oracle may not run at all on the new HP-UX.

Oracle puts out a support matrix. here is an old copy, attached.

In any case, you may want to test your Oracle on another server at 11.0, before you upgrade your production system.
Geoff Wild
Honored Contributor

Re: Server OS upgrade having Oracle

Actually - yes....

You will have to re-link the Oracle binaries....

Talk to your DBA - I'm not too sure how to do it.

I know our DBA's had to do it when we went from 11.0 to 11.i

Proverbs 3:5,6 Trust in the Lord with all your heart and lean not on your own understanding; in all your ways acknowledge him, and he will make all your paths straight.
Steven E. Protter
Exalted Contributor

Re: Server OS upgrade having Oracle

So long as you stay on the certification matrix, you should be okay.

Make sure you get all the patches you need into the 11 system prior to relinking.

Relink instructions:

The database and listener MUST be down.

By product:

$ cd $ORACLE_HOME/rdbms/lib
$ make -f install

% cd $ORACLE_HOME/sqlplus/lib
% make -f install

% cd $ORACLE_HOME/network/lib
% make -f install

Finally, unless you have a specific reason for installing patchset, the latest available is would be recommended install.

For everything
- shudown oracle
- shutdown listener
- shutdown every other oracle application, like dbsnmp

su - oracleuser
relink all

Steven E Protter
Owner of ISN Corporation