topic Re: Oracle Patching problem in Operating System - HP-UX

Oracle Patching problem

Rob Kunicki — Tue, 21 Jun 2005 09:00:53 GMT

We are trying to patch 8.1.7 (I know old and not supported but we do not have choice). All goes fine but at the linking part we get an error:

ERROR IN INVOKING TARGET INSTALL OF MAKEFILE
/OPT/ORACLE/8.1.7/RDBMS/LIB/INS_RDBMS.MK

and as suggested in other threads we find following in make.log file:

- Linking Oracle
rm -f /opt/oracle/8.1.7/rdbms/lib/oracle
cc -Wl,+s -Wl,+n -o /opt/oracle/8.1.7/rdbms/lib/oracle -L/opt/oracle/8.1.7/rdbms/lib -L/opt/oracle/8.1.7/lib -o /opt/oracle/8.1.7/rdbms/lib/oracle -Wl,-PF,linkorderfile -Wl,+Ostaticprediction /opt/oracle/8.1.7/rdbms/lib/opimai.o /opt/oracle/8.1.7/rdbms/lib/ssoraed.o /opt/oracle/8.1.7/rdbms/lib/ttcsoi.o /opt/oracle/8.1.7/rdbms/lib/kpuasvr.o /opt/oracle/8.1.7/lib/nautab.o /opt/oracle/8.1.7/lib/naeet.o /opt/oracle/8.1.7/lib/naect.o /opt/oracle/8.1.7/lib/naedhs.o /opt/oracle/8.1.7/rdbms/lib/config.o -lserver8 -lskgxp8 -lclient8 -lvsn8 -lwtcserver8 -lcommon8 -lgeneric8 /opt/oracle/8.1.7/rdbms/lib/defopt.o -lknlopt -lslax8 -lpls8 -lplp8 -lserver8 -lclient8 -lvsn8 -lwtcserver8 -lcommon8 -lgeneric8 -lknlopt -lslax8 -lpls8 -lplp8 `cat /opt/oracle/8.1.7/rdbms/lib/nmliblist` -ldbicx8 -ldbicx8 -ljox8 -lserver8 -lwwg8 -lobk `sed -e 's/-ljava//g' /opt/oracle/8.1.7/lib/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 `sed -e 's/-ljava//g' /opt/oracle/8.1.7/lib/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtcserver8 -lcommon8 -lgeneric8 -lmm -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 `sed -e 's/-ljava//g' /opt/oracle/8.1.7/lib/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 `sed -e 's/-ljava//g' /opt/oracle/8.1.7/lib/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtcserver8 -lcommon8 -lgeneric8 -ltrace8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lclient8 -lvsn8 -lwtcserver8 -lcommon8 -lgeneric8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lserver8 `if ar tv /opt/oracle/8.1.7/rdbms/lib/libknlopt.a | grep "kxmnsd.o" > /dev/null 2>&1 ; then echo " " ; else echo "-lordsdo8"; fi` -lordts8 -lctxc8 -lctx8 -lzx8 -lgx8 -lctx8 -lzx8 -lgx8 -lordvirt8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 `cat /opt/oracle/8.1.7/lib/sysliblist` -lm
/usr/ccs/bin/ld: Unsatisfied symbols:
kkx_same_src (first referenced in /opt/oracle/8.1.7/lib/libserver8.a(kkp.o)) (code)

Stop.

Stop.
*** Error exit code 1
*** Error exit code 1

We verified all the environment and kernel settings as suggested in other threads but no luck for couple of days now.

Re: Oracle Patching problem

Steven E. Protter — Tue, 21 Jun 2005 09:16:28 GMT

One of the oracle files needed to complete the make/compile may be corrupt. You may need to get

/opt/oracle/8.1.7/lib/libserver8.a

and other relavent files from another system.

If unavailable, you may need to redo the initial oracle install.

This post assumes SHLIB_PATH and other relavent environment variables are correct.

Also note, you are using /usr/ccs/bin/ld

/usr/ccs/bin needs to be on the SHLIB_PATH and PATH and needs to be fully patched on the OS level.

Oracle has OS quarterly patch requirements that alos must be met to success with this process.

SEP

Re: Oracle Patching problem

Eric Antunes — Tue, 21 Jun 2005 09:44:53 GMT

Hi Rob,

What is your maxdsiz value (maxdsiz_64bits if your binaries are in 64 bits...)? It must be greater than 300 Mb...

Best Regards,

Eric Antunes

Re: Oracle Patching problem

Eric Antunes — Tue, 21 Jun 2005 09:51:33 GMT

Hi again,

Post also the following:

#swapinfo -tam

You need to have enough contiguous swap space.

Finally, swchunk kernel parameter should be equal to 4096.

Best Regards,

Eric Antunes

Re: Oracle Patching problem

Eric Antunes — Tue, 21 Jun 2005 10:06:12 GMT

Hi again,

I verified that I don't have this libserver8.a library so it must be 64 bit lib!

If you are not running a 64 bits RDBMS, you must download the 32 bits patch!!

Best Regards,

Eric Antunes

Re: Oracle Patching problem

A. Clay Stephenson — Tue, 21 Jun 2005 10:18:28 GMT

kkx_same_src is defined in kkxwtp.o in the rdbms/lib directory. Add that .o to the link list.

Re: Oracle Patching problem

Rob Kunicki — Tue, 21 Jun 2005 10:22:35 GMT

Thank you for fast response.

my swapinfo:

# swapinfo -tam
Mb Mb Mb PCT START/ Mb
TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME
dev 4096 0 4096 0% 0 - 1 /dev/vg00/lvol2
reserve - 235 -235
memory 1533 1330 203 87%
total 5629 1565 4064 28% - 0 -
#

maxdsize 536870912
maxdsize 1073741824
swchunk is set to 2048 (I will change it and try again)

Thank You

Re: Oracle Patching problem

Yogeeraj_1 — Tue, 21 Jun 2005 10:37:35 GMT

hi Rob,

also have a look at metalink note: 255922.1
Subject: Patchset 8.1.7.4 Installation Fails with Undefined Symbol kkx_same_src,skgxntrace

hope this helps!
regards
yogeeraj

Re: Oracle Patching problem

Rob Kunicki — Mon, 27 Jun 2005 08:28:10 GMT

I did try everything that suggested with no luck.
And I do not have access to Metalink as of yet.

Re: Oracle Patching problem

Eric Antunes — Mon, 27 Jun 2005 10:19:34 GMT

Hi,

In my opinion you have the wrong bits version patch.

Please go to $ORACLE_HOME/bin and execute:

$file oracle

If you run on 32 bits, you'll get something like this:

oracle: PA-RISC1.1 shared executable dynamically linked -not stripped

If your are running with 64 bits, you will get the "64 bits" somewhere...

So, what do you get typing "file oracle"??

Best Regards,

Eric Antunes

Re: Oracle Patching problem

Rob Kunicki — Mon, 27 Jun 2005 10:30:01 GMT

that is what I get:

oracle: ELF-64 executable object file - PA - RISC 2.0 (LP64)

Re: Oracle Patching problem

Eric Antunes — Mon, 27 Jun 2005 11:21:41 GMT

Hi Rob,

Is the patch on CD? Can you list the CD contents here?

Are you installing the 8.1.7.4 patch? Can you list the content of the patch? Do you have the 32bits and 64bits directories?

What is the patch you are installing if it isn't the 8.1.7.4 patch?

Best Regards,

Eric Antunes

Re: Oracle Patching problem

Rob Kunicki — Mon, 27 Jun 2005 12:13:41 GMT

Patch is on cd from Oracle Support Services.
It says on it HP 11.0 64-bit 8.1.7.2.1 patch set 04/08/04

There is one file on CD: p1909158_8172_hp64.zip

inside of the zip file:
hpx64_81721_patchset.tar
and README.html

Re: Oracle Patching problem

Eric Antunes — Tue, 28 Jun 2005 03:27:19 GMT

Hi Rob,

You should try to install the following approach:

- Fresh install of 8.1.7.3 Enterprise Edition;

- Patch it to 8.7.1.4;

- Install RDBMS patches 2073948, 2225569, 2346568, 2386334 and 2401670;

- Check for more RDBMS patches...

That's how I've upgraded from 8.0.5 to 8.7.1.4...

Best Regards,

Eric Antunes