Should oracle be recompiled after applied patches ?

[yc_2]

Hi,

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

Thanks in advance,
YC

[Frederic Sevestre · Accepted solution]

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

[Michael Tully]

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~

[yc_2]

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]

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

[Olav Baadsvik]

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]

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]

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]

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