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

Should oracle be recompiled after applied patches ?

SOLVED
Go to solution
yc_2
Regular Advisor

Should oracle be recompiled after applied patches ?

Hi,

Is it a norm to recompile Oracle after applied OS patches ?

Thanks in advance,
YC
8 REPLIES
Frederic Sevestre
Honored Contributor
Solution

Re: Should oracle be recompiled after applied patches ?

Hi,

I never had to recompiled Oracle after applied patches (OS).
The only case I had to, was when I upgraded my OS from 10.20 to 11.00

Fr??d??ric

Crime doesn't pay...does that mean that my job is a crime ?
Michael Tully
Honored Contributor

Re: Should oracle be recompiled after applied patches ?

Hi,

There is no need to re-compile anything after loading OS patches. The OS patches are primarily for the Operating System and nothing else. If there are any oracle related patches they will be to do with libraries. The only time you would need to re-compile or re-install would be if your planning on upgrading your operating system. 32 bits applications will continue to run on 64 bit operating systems as well.

Cheers
~Michael~
Anyone for a Mutiny ?
yc_2
Regular Advisor

Re: Should oracle be recompiled after applied patches ?

Hi,

What about after installing ANSI C and C++ compiler ?

This is because Oracle was not able to startup after I applied patches and installed ANSI C and C++.


Rgds,
YC
Frederic Sevestre
Honored Contributor

Re: Should oracle be recompiled after applied patches ?

Hi,

Installing a new compilerer on a server has no effect on compilied programs. You should not have to recompile Oracle after installing those patches and products.

Fr??d??ric
Crime doesn't pay...does that mean that my job is a crime ?
Olav Baadsvik
Esteemed Contributor

Re: Should oracle be recompiled after applied patches ?

Hi,

Once again, it would be helpful if info about HP-UX version etc was
was provided when a questin is posted.

At hp-ux 10.20 there was in issue with oralce and a patch
for DCE 1.5.
Depending on what version of Oracle is installed, a relink of
oracle is needed
If this is your case you should contact Oracle for exact
info about the action needed.

regards
Olav
yc_2
Regular Advisor

Re: Should oracle be recompiled after applied patches ?

Hi,

The system info is as follows:
1) 2 nodes cluster of N-class running MCSG with active-active configuration.
2) HP-UX 11.00
3) Node A running Oracle 8i
4) Node B running Informix IDS2000

Failed over was tested successfully for both applications all the while.

Then OTG (Oracle Transparent Gateway) software, its requested patches and ANSI C and C++ were installed in Node B. No failed over was tested after the installation.

Weeks later, found Oracle unable to failed over and Oracle had recommended to relink/recompile.

Before relink/recompile Oracle (this coming week end), ANSI C and C++ were removed as OTG was not installed successfully due to 32/64 bit issue.

Is there any thing wrong in the process of installation and removal ?
Simeon Fox
Advisor

Re: Should oracle be recompiled after applied patches ?

Oracle generally recommend relinking executables after patching, though oracle installer should normally do this for you, if necesssary. After applying patch 8.1.7.3 I had to relink the intelligent agent.
H.Merijn Brand (procura
Honored Contributor

Re: Should oracle be recompiled after applied patches ?

Relinking Oracle might also improve performance after updates to 'ld' :) [ seldom happens ]

Recompiling HLI programs (your own C code) *will* benefit after installing HP C-ANSI-C, because that compiler has Optimizer support, which is missing in the braindead crippled default bundled compiler
Enjoy, Have FUN! H.Merijn