MaxDB INSTANCE UPDATE failed ..

[Former Member]

While upgarding MAXDB to 7.6.00.36, I'm getting the follwoing error ..

(root@wpxxxs01 ) # ./SDBUPD -d LCS -u control,XXXX

MaxDB INSTANCE UPDATE

*********************

starting installation We, Dec 27, 2006 at 12:41:34

operating system: AIX PowerPC 5.3.0.0

callers working directory: /usr/sap/trans/patches/MAXDB_PATCH_36/maxdb-server-aix5-64bit-ppc-7_6_00_36

installer directory: /usr/sap/trans/patches/MAXDB_PATCH_36/maxdb-server-aix5-64bit-ppc-7_6_00_36

archive directory: /usr/sap/trans/patches/MAXDB_PATCH_36/maxdb-server-aix5-64bit-ppc-7_6_00_36

beginning to check sap db instances

resume broken instance check

finding instance type...

finding starting release...

finding apo starting release...

finding migration strategy...

MaxDB instance "LCS" not ready to update

finding migration strategy...

cannot find migration strategy cause of unknown apo target release

MaxDB instance update exited abnormally at We, Dec 27, 2006 at 12:42:17

in the /sapdb/data/wrk directory, in the log.. I see following :

STDOUT: finding starting release...

kernel executable is /sapdb/LCS/db/pgm/kernel

kernel version by GetBuildString 7.6.0 Build 029-123-130-265

starting release is 7.6.0 Build 029-123-130-265

STDOUT: finding apo starting release...

<b>sapapo lib is /sapdb/LCS/db/sap/libSAPAPO.so

no read permission for /sapdb/LCS/db/sap/libSAPAPO.so</b>

apo starting release is unknown

STDOUT: finding migration strategy...

cannot find migration strategy cause of unknown apo starting release

MSG: writing 13 packages

MSG: net install registry size = 102603 bytes

MSG: wrote install registry (126255 bytes)

STDERR: MaxDB instance "LCS" not ready to update

STDERR: finding migration strategy...

cannot find migration strategy cause of unknown apo starting release

I don't find the files in BOLD ..

[roland_mallmann]

Hi,

your current liveCache 7.6.00 Build 29 installation does not seem to be correct, three packages were invalid, according to the 'sdbregview -l' output.

I'm wondering if your livecache LCS has worked normally at all so far, or is it a brand new installation?

Currently, I'd suggest to reinstall (using SDBUPD and should that fail, SDBINST) the liveCache using the exact same (as current) liveCache 7.6.00 Build 29 software. Please make sure you really use the exact same package (probably either LC760029A5006_0-10003393.SAR (SAP LC/LCAPPS 5.0 SP06) or LC760029A5007_0-10003393.SAR (SAP LC/LCAPPS 5.0 SP07)).

Please issue both previously mentioned commands ('sdbreview -l' and 'ls -la /sapdb/LCS/db/sap') after reinstalling the liveCache package and show me the output.

Regards,

Roland

[Former Member]

The reinstall is failing with the error below :

2006-12-28 13:26:42 117 20039 Admin Kernel state: 'REDO LOG' finished

<b>2006-12-28 13:26:42 117 54000 OBJECT /sapdb/LCS/db/lib/lib64/liboms

2006-12-28 13:26:42 117 ERR 11865 DCOM dlapi(dlopen) Error:Could not load module /sapdb/LCS/db/lib/lib64/liboms.so.

System error - error data is: 0 /sapdb/LCS/db/lib/lib64/liboms.so

2006-12-28 13:26:43 117 ERR 11865 DCOM dlapi(dlopen) Error:Could not load program /sapdb/LCS/db/lib/lib64/liboms.so:

2006-12-28 13:26:43 117 ERR 11865 DCOM dlapi(dlopen) Error:Could not load module /usr/lib/nls/loc/En_US.

2006-12-28 13:26:43 117 ERR 11865 DCOM dlapi(dlopen) Error:System error: No such file or directory

2006-12-28 13:26:43 117 ERR 11258 DCOM-DMP LVC_LoadLibrary - File: /sapdb/LCS/db/lib/lib64/liboms err: Could not load module /sapdb/LCS/db/li

2006-12-28 13:26:43 117 ERR 3 Admin Database state: OFFLINE

2006-12-28 13:26:43 117 ERR 6 KernelCo + Internal errorcode, Errorcode 1200 "key_not_found"</b>

2006-12-28 13:26:43 117 11560 COMMUNIC Releasing T94

2006-12-28 13:26:43 117 12696 DBSTATE Change DbState to 'SHUTDOWN'(25)

The LIBPATH is set to LIBPATH=/sapmnt/RAS/exe:/sapdb/programs/lib/lib64

[Former Member]

I've fixed this ..

Permission's problem in /sapdb/LCS/db/lib/lib64 directory ..

(root@wpsras01 ) # /sapdb/programs/bin/sdbregview -l

Server Utilities /sapdb/programs 7.6.01.05 64 bit valid

DB Analyzer /sapdb/programs 7.6.01.05 64 bit valid

PCR 7300 /sapdb/programs 7.3.00.55 valid

PCR 7301 /sapdb/programs 7.3.01.18 valid

PCR 7500 /sapdb/programs 7.5.00.39 64 bit valid

SAP Utilities /sapdb/programs 7.6.01.05 64 bit valid

APO LC APPS /sapdb/LCS/db/sap 5.00.008 64 bit valid

Redist Python /sapdb/programs 7.6.01.05 32 bit valid

Base /sapdb/programs 7.6.01.05 64 bit valid

JDBC /sapdb/programs 7.6.00.30 valid

Messages /sapdb/programs MSG 0.4211 valid

ODBC /sapdb/programs 7.6.01.05 64 bit valid

Database Kernel /sapdb/LCS/db 7.6.01.05 64 bit valid

Loader /sapdb/programs 7.6.01.05 64 bit valid

SQLDBC /sapdb/programs 7.6.01.05 64 bit valid

SQLDBC 76 /sapdb/programs 7.6.01.05 64 bit valid

Fastload API /sapdb/programs 7.6.01.05 64 bit valid

PCR 7403 /sapdb/programs 7.4.03.44 64 bit valid

[roland_mallmann]

Hi,

I see you already performed an upgrade to the newest available build (7.6.01 Build 05).

<b>Does your liveCache LCS run okay now?</b>

The permission problem in /sapdb/LCS/db/lib/lib64 can really only be caused by a manual intervention, because the SDBUPD or SDBINST programs set the permissions correctly.

---

I'm still wondering if your liveCache LCS worked at all before you got the first problem after your first upgrade attempt.

Kind regards,

Roland

[Former Member]

Yes, I've initialized livecache with LC10 and also T_CODE /sapapo/OM13 works fine ..

I'm still getting an error that RFC to client 001 doesn't exist .. I read a note that there is a way to deactivtae clinet 001..

Before this live cache didn't work propoerly at all.. All I could do was start & stop.. ? /SAPAPO/OM13 didn't work earlier ..

The install is performed by root and the files in the lib directory are set to r_xr_x___ with owner sdb and group sdba. Root wasn't able to access the files as root is not in the group "sdba". When I changed them to r_xr_xr_x.. it all worked fine ..

Thank you for all the help ..

[roland_mallmann]

Hi,

just for your information: please make sure you always use transaction LC10 to start/stop your liveCache instance.

Regards,

Roland

[roland_mallmann]

Hi,

I received your email.

---

Can you please show me:

a.) the output of the following command:

<b>/sapdb/programs/bin/sdbregview -l</b>

b.) the output of:

<b>ls -l /sapdb/LCS/db/sap</b>

Regards,

Roland

[Former Member]

Here it is ..

(root@wpsras01 ) # /sapdb/programs/bin/sdbregview -l

SAP Utilities /sapdb/programs 7.6.00.29 64 bit valid

Server Utilities /sapdb/programs 7.6.00.29 64 bit valid

DB Analyzer /sapdb/programs invalid

APO COM /sapdb/LCS/db/sap invalid

Redist Python /sapdb/programs 7.6.00.29 32 bit valid

Base /sapdb/programs 7.6.00.29 64 bit valid

JDBC /sapdb/programs 7.6.00.24 valid

Messages /sapdb/programs MSG 0.3347 valid

ODBC /sapdb/programs 7.6.00.29 64 bit valid

Database Kernel /sapdb/LCS/db 7.6.00.29 64 bit invalid

Loader /sapdb/programs 7.6.00.29 64 bit valid

SQLDBC /sapdb/programs 7.6.00.29 64 bit valid

SQLDBC 7600 /sapdb/programs 7.6.00.29 64 bit valid

(root@wpsras01 ) # ls -l /sapdb/LCS/db/sap

total 904

-rwxrwxrwx 1 sdb sdba 138 Jul 7 11:35 dbpinstall.lst

-rwxrwxrwx 1 sdb sdba 1442 Jul 7 12:46 grantxdb.dbm

-rwxrwxrwx 1 sdb sdba 21568 Jul 7 11:35 lcinit

-rwxrwxrwx 1 sdb sdba 320044 Jul 7 13:50 lvcbench.so

-rwxrwxrwx 1 sdb sdba 83 Jul 7 11:35 saprfc.ini

-rwxrwxrwx 1 sdb sdba 10 Jul 7 11:35 sphsapdb.lst

-rwxrwxrwx 1 sdb sdba 94265 Jul 7 13:02 sphsapdb.so

[roland_mallmann]

Hi,

hm, this does look weird.

First of all, should your LCS instance be a liveCache instance or an OLPT instance? Currently, I'd say it (= the instance type) is set to 'liveCache', but you chose to upgrade using an OLTP package, instead of using a liveCache upgrade package.

Please let me know if LCS is supposed to be a liveCache or OLTP instance. In both cases, changes are necessary.

Regards,

Roland

[Former Member]

This is a LIVECACHE instance ..

Thank you

[roland_mallmann]

Hi again,

can you please send me the complete upgrade protocol file (from your /sapdb/data/wrk directory) per email?

You can find my emailaddress on my SDN business card.

Regards,

Roland

[Former Member]

I've just sent them ..

Thank you very much for your help ..