10.2.0.4 + Patches - Relink error (and finally SIGSEGV)

[Former Member]

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

[JPReyes · Accepted solution]

I had a similar problem before and it was releated to an opatch that I shouldn't have implemented... if you think that the Merge patch is giving you problems you could remove it reimplement the patches that goes after that one (as far as i remember they need to go in certain order)

Hope that helps

Juan

[markus_doehr2 · Accepted solution]

Hola Juan,

I will try that - thanx for suggestion. The optimizer merge fix is listed separately in Note 1137346 - I will omit it (and maybe try to apply it after all the others).

Markus

[JPReyes · Accepted solution]

Great... let us know how it goes.

Regards

Juan

[markus_doehr2 · Accepted solution]

So that´s what I found out:

Note 1137346 was updated today - I use version 31 as reference.

I installed/uninstalled quite a number of times different patches. The following turned out:

No  1 (5251842) is getting installed and linked but fails on startup with the SIGSEGV
No 15 (6506617) is failing during link time with the mentioned error
No 27 (6679303) is mentioned *twice* in the note (as no. 27 and no 17)
No 30 (6396242) fails with "invalid compressed data size"

The DB is running fine now with 10.2.0.4 + the patches but the ones I needed to omit.

BTW: I did the upgrade today also on a Windows x64 box and it worked flawlessly.

Markus

[Former Member]

Hi troy,

Me to come cross the same error,have you got the solution for the error you have got,kindly let me know..

Thanks & Regards

naveen

[vince_laurent]

This is documented in Note 603465.1 OPatch Fails With "Jar not applied ... to

$ORACLE_HOME/jdbc/lib/classes12.zip... 'invalid entry compressed size (expected

x but got y bytes)'"

HTH,

Vince

[former_member527726]

No such note as 603465.1

What is the solution?

[markus_doehr2]

> No such note as 603465.1

This is a note number from Oracle Metalink (metalink.oracle.com), not a SAP note.

> What is the solution?

Installing the latest OPatch and MOpatch.

Markus

[Former Member]

Hi Hellemons,

I have OPatch 10.2.0.4.3 downloaded for Service Market Place (as you have mentioned) and MOpatch Version 1.9. Still i am facing this issue.

Please let me know, how to proceed for here, if someone on the above mentioned patch levels has faced this issue. Thanks.

Regards,

Arun Jain

[Former Member]

Hi Arun,

I am receiving exactly this error with MOPatch 1.9 and Opatch 10.2.0.4.3. Did you get it resolved?

Any hints that can help me out?

My MOPatch log:

The following warnings have occurred during OPatch execution:

1) OUI-67124:Jar not applied /net/cunip03/software/sap/netweaver7/dvd/ora10.2/ora10.2.0.4/zip/mopatch-8QaWHG/7252962/files//jdbc/lib/classes12.zip/oracle/jdbc/driver/OraclePreparedStatement.class to /oracle/DBI/102_64/jdbc/lib/classes12.zip... 'invalid entry compressed size (expected 31214 but got 30948 bytes)'

Jar not applied /net/cunip03/software/sap/netweaver7/dvd/ora10.2/ora10.2.0.4/zip/mopatch-8QaWHG/7252962/files//jdbc/lib/classes12.zip/oracle/jdbc/driver/OraclePreparedStatement$PushedBatch.class to /oracle/DBI/102_64/jdbc/lib/classes12.zip... 'invalid entry compressed size (expected 31214 but got 30948 bytes)'

Jar not applied /net/cunip03/software/sap/netweaver7/dvd/ora10.2/ora10.2.0.4/zip/mopatch-8QaWHG/7252962/files//jdbc/lib/classes12.zip/oracle/sql/NUMBER.class to /oracle/DBI/102_64/jdbc/lib/classes12.zip... 'invalid entry compressed size (expected 31214 but got 30948 bytes)'

Please assist,

Troy

[Former Member]

How to get the new opatch: https://service.sap.com/sap/support/notes/839182

Also take a look there: https://service.sap.com/sap/support/notes/1137346

[Former Member]

Try using the most recent opatch - I forgot to mention that I replaced both: MOpatch and opatch.

[Former Member]

Tomasz,

which version of Opatch are you running? We have the exact same problem with patch 6396242 on HP-UX 11.11.

We are running MOpatch 1.9 and OPatch 10.2.0.4.3

All bugfixes went in fine.

[Former Member]

SAP has released a new version of OPatch, which can be downloaded from marketplace. After installing this new version the problem has been resolved.

[Former Member]

Latest version of OPatch that i am able to find on service market place is 10.2.0.4.3. I am still getting this probme with this version of OPatch. Please let me know, if a newer version is available.

Error i am getting is:

INFO:The following warnings have occurred during OPatch execution:

INFO:1) OUI-67124:Jar not applied /oracle/stage/102_64/10204/patch_10204/mopatch-25584-10900/6396242/files//jdbc/lib/classes12.zip/oracle/jdbc/driver/OraclePreparedStatem

ent.class to /oracle/SLM/102_64/jdbc/lib/classes12.zip... 'invalid entry compressed size (expected 31214 but got 30948 bytes)'

Jar not applied /oracle/stage/102_64/10204/patch_10204/mopatch-25584-10900/6396242/files//jdbc/lib/classes12.zip/oracle/jdbc/driver/OraclePreparedStatement$PushedBatch.cl

ass to /oracle/SLM/102_64/jdbc/lib/classes12.zip... 'invalid entry compressed size (expected 31214 but got 30948 bytes)

[Former Member]

Have you downloaded and extracted this file from marketplace:

OPatch 10.2.0.4 v3.zip E SAP 07.08.2008 1040

Problem was resolved after extracting it and restarting MOpatch. Pleas make sure you have MOpatch 1.9 as well.

[Former Member]

I got the same problem: patch 6396242 failed with "invalid compressed data size". It turned out that the reason was... old MOpatch.By mistake I copied new version (1.9) to improper directory, thus used old version - and it didn't work.

[markus_doehr2]

I was calling mopatch.sh with full path - and the same problem also occurs when I use opatch to apply manually...

Markus

[Former Member]

We had exactly the same problem with OPatch 6506617, we got ORA-04745. But it look like there was a problem with this patch on the market place. It has a new date now (07/25/2008). So we downloaded it again and with the new one the error seems to be solved.