Oracle upgrade to 8.0.5 - Relink Error

[Upendra Kulkarni]

We are in the process of upgrading Oracle from 8.0.4 to 8.0.5 on HP UX 10.2.
During the upgrade process, when Oracle enterprise RDBMS is being upgraded, we are getting the following error:
"Relinking Error. The executables for Oracle8 Enterprise (RDBMS) were not made successfully."
The trouble shooting hint is to check if C compiler is installed and is of correct version. I have no idea how to check that.
Has anybody encountered similar errors and know of any patches etc?
Any feedback would be greatly appreciated.
TIA,
Upendra.

[Stefan Farrelly · Accepted solution]

To check your version of HP C compiler do;

type cc

This should result in /usr/bin/cc

Then do the command;

what /usr/bin/cc

This should give something like;

/usr/bin/cc:
HP92453-01 A.10.32.00 HP C (Bundled) Compiler
/usr/lib/libc: $Revision: 76.3 $

This gives the version of your HP C compiler. Bundled means its the default compiler which comes with HP-UX - not the full Ansi C version. But you dont necessarily need the full Ansi C version to relink oracle anyway. As for patches, are your running up-to-date General release patch bundles ? latest is March 2001. For oracle you only really need the latest linker (ld) patch. Check the ITRC patch section for latest version.

[Stefan Farrelly]

Further to my last reply, the latest linker (ld) patch for 10.20 is; PHSS_21110

[Upendra Kulkarni]

Stefan,

Thanks for your detailed reply.
I could check the version and it matches with what you had said in your reply.
I don't think we have been keeping upto date with the patches and I will try and get the latest patch installed asap and hopefully that would resolve the problem. Thanks for sending the exact patch number.
Best regards.

[Bart Paulusse]

Hi,

we've encountered a similar problem during an Oracle upgrade. In our case the problem was that Oracle had hardcoded the need for the Ansi C compiler in the upgrade script.
It's worth a check.

HP was so kind to lend us a the full version for the upgrade.

regards,
Bart

[Eugene Vinokur]

I would try to relink ORACLE executabales.
1. Shutdown all databases:
2. Relink RDBMS:
cd $ORACLE_HOME/rbms/lib
make -f ins_rdbms.mk install
3. Relink SQL*PLUS
cd $ORACLE_HOME/sqlplus/lib
make -f ins_sqlplus.mk install
4. Relink network:
cd $ORACLE_HOME/network/lib:
make -f ins_network.mk install
5. Relink SVRMGR:
cd $ORACLE_HOME/svrmgr/lib:
make -f ins_svrmgr.mk install

[joe clark]

What is maxdsiz set to, you will want to look at this, initially it is probably too small,
800-1200 meg should do the trick. This seems to primarly be a problem at relink time.