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