Skip to Content
0
Former Member
Jul 17, 2008 at 09:40 AM

10.2.0.4 + Patches - Relink error (and finally SIGSEGV)

149 Views

HP-UX 11.23 IA64

I upgrade to 10.2.0.4 manually (using catupgrd.sql). The "naked" 10.2.0.4 worked fined.

Then I downloaded the 30 single patches and used MOpatch 1.9 to apply them. The final relink failed with

 - Linking Oracle
        rm -f /oracle/FOO/102_64/rdbms/lib/oracle
         cc +DD64  -Wl,+s -Wl,+n +DD64 -o /oracle/FOO/102_64/rdbms/lib/oracle -L/oracle/FOO/102_64/rdbms/
lib/ -L/oracle/FOO/102_64/lib/   /oracle/FOO/102_64/rdbms/lib/ssoident.o `if /usr/bin/getconf KERNEL_BITS
 | grep "64" > /dev/null ; 
                then echo "-Wl,+pi,64M -Wl,+pd,L -Wl,+padtext,16M -Wl,+paddata,1M" ; 
                   else echo "" ; fi` -Wl,-E -Wl,-PF,linkorderfile +FPd /oracle/FOO/102_64/rdbms/lib/opimai.
o /oracle/FOO/102_64/rdbms/lib/ssoraed.o /oracle/FOO/102_64/rdbms/lib/ttcsoi.o  /oracle/FOO/102_64/rdbms/
lib/defopt.o  -Wl,+forceload -lperfsrv10 -Wl,+noforceload /oracle/FOO/102_64/lib/nautab.o /oracle/FOO/102
_64/lib/naeet.o /oracle/FOO/102_64/lib/naect.o /oracle/FOO/102_64/lib/naedhs.o /oracle/FOO/102_64/rdbms/l
ib/config.o  -lserver10 -lodm10  -lnnet10 -lskgxp10 -lsnls10 -lnls10  -lcore10 -lsnls10  -lnls10 -lcore10
 -lsnls10 -lnls10 -lxml10  -lcore10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 -lhasgen10 -lcore10 -lskgx
n2 -locr10 -locrb10 -locrutl10   -lhasgen10 -lcore10 -lskgxn2   -lclient10  -lvsn10  -lcommon10 -lgeneric
10  -lknlopt `if /usr/ccs/bin/ar tv /oracle/FOO/102_64/rdbms/lib/libknlopt.a | grep xsyeolap.o > /dev/nul
l 2>&1 ; then echo "-loraolap10" ; fi`  -lslax10 -lpls10  -lplp10 -lserver10 -lclient10  -lvsn10  -lcommo
n10 -lgeneric10 `if [ -f /oracle/FOO/102_64/lib/libavserver10.a ] ; then echo "-lavserver10" ; else echo
"-lavstub10"; fi` `if [ -f /oracle/FOO/102_64/lib/libavclient10.a ] ; then echo "-lavclient10" ; fi`  -lk
nlopt -lslax10 -lpls10  -lplp10 -ljox10 -lserver10  /oracle/FOO/102_64/has/lib/libclsra10.a -ldbcfg10 -lo
cijdbcst10 -lwwg  `cat /oracle/FOO/102_64/lib/ldflags`    -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -l
nnz10 -lnl10 -lnro10 `cat /oracle/FOO/102_64/lib/ldflags`    -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10
 -lnnz10 -lnl10 -lmm -lsnls10 -lnls10  -lcore10 -lsnls10  -lnls10 -lcore10 -lsnls10 -lnls10 -lxml10  -lco
re10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 `cat /oracle/FOO/102_64/lib/ldflags`    -lnsslb10 -lncryp
t10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lnro10 `cat /oracle/FOO/102_64/lib/ldflags`    -lnsslb10 -lnc
rypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10   -lsnls10 -lnls10  -lcore10 -lsnls10  -lnls10 -lcore10 -ls
nls10 -lnls10 -lxml10  -lcore10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 `if /usr/ccs/bin/ar tv /oracle
/FOO/102_64/rdbms/lib/libknlopt.a | grep "kxmnsd.o" > /dev/null 2>&1 ; then echo " " ; else echo "-lordsd
o10"; fi` -lctxc10 -lctx10 -lzx10 -lgx10 -lctx10 -lzx10 -lgx10 -lordimt10  -lsnls10 -lnls10  -lcore10 -ls
nls10  -lnls10 -lcore10 -lsnls10 -lnls10 -lxml10  -lcore10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 -ls
nls10 -lunls10  -lsnls10 -lnls10  -lcore10 -lsnls10  -lnls10 -lcore10 -lsnls10 -lnls10 -lxml10  -lcore10
-lunls10 -lsnls10 -lnls10 -lcore10 -lnls10      `cat /oracle/FOO/102_64/lib/sysliblist`  -lm    `cat /ora
cle/FOO/102_64/lib/sysliblist`  -lm  -lpthread  -lpthread
ld: Unsatisfied symbol "kkpapIsPartColId" in file /oracle/FOO/102_64/lib//libserver10.a[kko.o]
ld: Unsatisfied symbol "kkpapHasCorrKey" in file /oracle/FOO/102_64/lib//libserver10.a[kko.o]
ld: Unsatisfied protected symbol "kkpapIsAnyPartColId" in file "/oracle/FOO/102_64/lib//libserver10.a[kkq
jpd.o]"
3 errors.
*** Error exit code 1

I tried the manual relink using "sh link.sh" - which worked (?) - I got an $ORACLE_HOME/bin/oracle binary.

When I tried to start the database I got an

SQL> startup
ORACLE instance started.

Total System Global Area 1.6274E+10 bytes
Fixed Size                  2084616 bytes
Variable Size            7616856312 bytes
Database Buffers         8640266240 bytes
Redo Buffers               14692352 bytes
Database mounted.
ORA-03113: end-of-file on communication channel

with alertlog telling me

Errors in file /oracle/FOO/saptrace/usertrace/foo_ora_10873.trc:
ORA-07445: exception encountered: core dump [_strlen()+33] [SIGSEGV] [Address not mapped to object] [0x20
00000000000] [] []

and

ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [_strlen()+33] [SIGSEGV] [Address not mapped to object] [0x20
00000000000] [] []
Current SQL statement for this session:
SELECT INSTANCE_NUMBER FROM SYS.V$INSTANCE
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
c000000402bdda10       587  package body SYS.DBMS_UTILITY
c000000402c13ca8      2442  package body SYS.DBMS_PRVTAQIP
c000000402c188d8         1  anonymous block

in the corresponding usertrace.

I´m actually restoring the old "naked" version. The problem seems to be caused by the merge patch 7228971 (OPTIMIZER MERGE LABEL REQUEST ON TOP OF 10.2.0.4 FOR SAP (#3)) because this seems to be the only one changing/updating kko.o. Are the any known issues in this area?

I will try to apply all the patches again without that one and see if it helps. This is a testsystem and not critical.

Markus