Unable to upgrade MaxDB

[brian_walker]

Running MaxDB 7.6.03.09 on Linux x86_64 and trying to upgrade to 7.6.06.06. Getting a failure during the install using SDBSETUP:

SYS: /sapdb/TST/db/bin/dbmsrvctl start

SYS: /sapdb/programs/bin/dbmcli -R /sapdb/TST/db inst_reg -k /sapdb/TST/db: ERR

SYS: /sapdb/programs/bin/dbmcli -R /sapdb/TST/db inst_reg -k /sapdb/TST/db: -24913,ERR_SERVICEDB: Cannot register service database instance for /sapdb/TST/db

STDERR: error occured while executing /sapdb/programs/bin/dbmcli -R /sapdb/TST/db inst_reg -k /sapdb/TST/db

STDERR: /sapdb/programs/bin/dbmcli -R /sapdb/TST/db inst_reg -k /sapdb/TST/db: ERR

/sapdb/programs/bin/dbmcli -R /sapdb/TST/db inst_reg -k /sapdb/TST/db: -24913,ERR_SERVICEDB: Cannot register service database instance for /sapdb/TST/db

STDERR: installation exited abnormally at Th, Sep 17, 2009 at 16:29:57

Now when trying to run /sapdb/programs/bin/dbmcli -d TST I get the error:

ERR -24700 DBMSrv ERR_DBMSRV_NOSTART: Could not start DBM server.

ERR -24832 DBMSrv ERR_SHMNOTAVAILABLE: Shared memory not available

ERR -24993 DBMSrv ERR_RTEEXT: Runtime environment error

ERR -24778 DBMSrv 1,could not create dir:dbm/ipc

ERR -24778 DBMSrv 13,No system errortext for ERRNO 13

I have been able to re-run SDBSETUP for 7.6.03.09 and now dbmcli works again.

How can this upgrade be performed without errors?

Brian

[lbreddemann · Accepted solution]

looks like something is wrong the the permissions of the files/folders in /sapdb/data/.

Post the output of "ls -Rla /sapdb/data".

[brian_walker · Accepted solution]

Apologies, this is kinda long...

/sapdb/data:

total 44

drwxrwxr-x 11 sdb sdba 4096 2009-09-16 12:05 .

drwxr-xr-x 5 root root 4096 2009-09-16 12:05 ..

drwxrwxr-x 3 sdb sdba 4096 2009-09-17 16:30 config

drwxrwx--- 2 sdb sdba 4096 2009-09-17 16:31 dbspeed

drwxrwx--- 2 sdb sdba 4096 2009-09-16 12:05 diag

drwxrwxr-x 2 sdb sdba 4096 2009-09-17 16:31 fifo

drwxrwxr-x 4 sdb sdba 4096 2009-09-17 16:31 ipc

drwxrwxr-x 3 sdb sdba 4096 2009-09-17 16:31 pid

drwxrwx--- 2 sdb sdba 4096 2009-09-17 16:32 pipe

drwxrwxr-x 2 sdb sdba 4096 2009-09-17 16:31 ppid

drwxrwx--- 5 sdb sdba 4096 2009-09-17 16:56 wrk

/sapdb/data/config:

total 280

drwxrwxr-x 3 sdb sdba 4096 2009-09-17 16:30 .

drwxrwxr-x 11 sdb sdba 4096 2009-09-16 12:05 ..

-rw-rr 1 sdb sdba 54 2009-09-17 16:30 Databases.ini

drwxr-xr-x 2 root sapinst 4096 2009-09-17 16:30 install

-rrr-- 1 sdb sdba 53 2009-09-17 16:30 Installations.ini

-rw-rw---- 1 sdb sdba 9654 2009-09-17 16:30 .M760309

-rw-rw---- 1 sdb sdba 95352 2009-09-17 16:30 .M760309.pah

-rw-rw---- 1 sdb sdba 1536 2009-09-17 16:30 .M760309.upc

-rrr-- 1 sdb sdba 48 2009-09-17 13:38 Runtimes.ini

-rw-rw---- 1 sdb sdba 10388 2009-09-17 17:17 TST

-rr--- 1 sdb sdba 10388 2009-09-16 12:23 TST.01

-rw-rw---- 1 sdb sdba 0 2009-09-16 12:07 TST.cfg

-rw-rw---- 1 sdb sdba 109052 2009-09-17 17:17 TST.pah

-rw-rw---- 1 sdb sdba 2048 2009-09-16 12:24 TST.upc

/sapdb/data/config/install:

total 2956

drwxr-xr-x 2 root sapinst 4096 2009-09-17 16:30 .

drwxrwxr-x 3 sdb sdba 4096 2009-09-17 16:30 ..

-rw-rr 1 root sapinst 236098 2009-09-17 16:30 INSTREG

-rw-rr 1 root root 176684 2009-09-17 16:22 INSTREG.20090917162233

-rw-rr 1 root root 236126 2009-09-17 16:24 INSTREG.20090917162409

-rw-rr 1 root root 236701 2009-09-17 16:30 INSTREG.20090917163028

-rw-rr 1 root sapinst 2105344 2009-09-17 16:30 INSTREGLOG

/sapdb/data/dbspeed:

total 12

drwxrwx--- 2 sdb sdba 4096 2009-09-17 16:31 .

drwxrwxr-x 11 sdb sdba 4096 2009-09-16 12:05 ..

-rw-r----- 1 sdb sdba 5 2009-09-17 16:31 TST

/sapdb/data/diag:

total 8

drwxrwx--- 2 sdb sdba 4096 2009-09-16 12:05 .

drwxrwxr-x 11 sdb sdba 4096 2009-09-16 12:05 ..

/sapdb/data/fifo:

total 8

drwxrwxr-x 2 sdb sdba 4096 2009-09-17 16:31 .

drwxrwxr-x 11 sdb sdba 4096 2009-09-16 12:05 ..

prwww- 1 sdb sdba 0 2009-09-17 22:01 TST

prw-rw---- 1 root root 0 2009-09-17 16:07 xserver_ike_logger

prw-rw---- 1 root root 0 2009-09-17 14:12 xserver_ike_update

/sapdb/data/ipc:

total 16

drwxrwxr-x 4 sdb sdba 4096 2009-09-17 16:31 .

drwxrwxr-x 11 sdb sdba 4096 2009-09-16 12:05 ..

drwxrwxrwx 2 sdb sdba 4096 2009-09-17 16:32 db:TST

drwxrwxrwx 2 sdb sdba 4096 2009-09-17 22:20 us:TST

/sapdb/data/ipc/db:TST:

total 12

drwxrwxrwx 2 sdb sdba 4096 2009-09-17 16:32 .

drwxrwxr-x 4 sdb sdba 4096 2009-09-17 16:31 ..

prw-rw-rw- 1 sdb sdba 0 2009-09-17 16:31 FIFO-CONSOLE

-r----

---

1 sdb sdba 0 2009-09-17 16:31 -m3080225

-r----

---

1 sdb sdba 0 2009-09-17 16:31 -m3112999

-r----

---

1 sdb sdba 0 2009-09-17 16:31 -m3145768

-r----

---

1 sdb sdba 0 2009-09-17 16:31 -m3178537

-r----

---

1 sdb sdba 0 2009-09-17 16:31 -m3211306

-r----

---

1 sdb sdba 0 2009-09-17 16:31 -s1310720

-r----

---

1 sdb sdba 0 2009-09-17 16:31 -s1343489

-r----

---

1 sdb sdba 0 2009-09-17 16:31 -s1376258

-r----

---

1 sdb sdba 0 2009-09-17 16:31 -s1409027

-r----

---

1 sdb sdba 0 2009-09-17 16:31 -s1441796

-r----

---

1 sdb sdba 0 2009-09-17 16:31 -s1474565

-r----

---

1 sdb sdba 0 2009-09-17 16:31 -s1507334

-r----

---

1 sdb sdba 0 2009-09-17 16:31 -s1540103

-r----

---

1 sdb sdba 0 2009-09-17 16:31 -s1572872

-r----

---

1 sdb sdba 0 2009-09-17 16:31 -s1605641

-r----

---

1 sdb sdba 0 2009-09-17 16:31 -s1638410

-r----

---

1 sdb sdba 0 2009-09-17 16:31 -s1671179

-r----

---

1 sdb sdba 0 2009-09-17 16:31 -s1703948

-r----

---

1 sdb sdba 0 2009-09-17 16:31 -s1736717

-r----

---

1 sdb sdba 0 2009-09-17 16:31 -s1769486

-r----

---

1 sdb sdba 0 2009-09-17 16:32 -s1835024

-r----

---

1 sdb sdba 0 2009-09-17 16:32 -s1867793

-r----

---

1 sdb sdba 0 2009-09-17 16:32 -s1900562

-r----

---

1 sdb sdba 0 2009-09-17 16:32 -s1933331

-r----

---

1 sdb sdba 0 2009-09-17 16:32 -s1966100

-r----

---

1 sdb sdba 0 2009-09-17 16:32 -s1998869

-r----

---

1 sdb sdba 0 2009-09-17 16:32 -s2031638

-r----

---

1 sdb sdba 0 2009-09-17 16:32 -s2064407

-r----

---

1 sdb sdba 0 2009-09-17 16:32 -s2097176

-r----

---

1 sdb sdba 0 2009-09-17 16:32 -s2129945

-r----

---

1 sdb sdba 0 2009-09-17 16:32 -s2162714

-r----

---

1 sdb sdba 0 2009-09-17 16:32 -s2195483

-rw-r----- 1 sdb sdba 4 2009-09-17 16:31 TST

/sapdb/data/ipc/us:TST:

total 8

drwxrwxrwx 2 sdb sdba 4096 2009-09-17 22:20 .

drwxrwxr-x 4 sdb sdba 4096 2009-09-17 16:31 ..

-r----

---

1 tstadm sapsys 0 2009-09-17 16:34 -s4227158

-r----

---

1 tstadm sapsys 0 2009-09-17 16:34 -s4259927

-r----

---

1 tstadm sapsys 0 2009-09-17 16:34 -s4292696

-r----

---

1 tstadm sapsys 0 2009-09-17 16:34 -s4325465

-r----

---

1 tstadm sapsys 0 2009-09-17 16:34 -s4358234

-r----

---

1 tstadm sapsys 0 2009-09-17 16:34 -s4391003

-r----

---

1 tstadm sapsys 0 2009-09-17 16:34 -s4423772

-r----

---

1 tstadm sapsys 0 2009-09-17 16:34 -s4456541

/sapdb/data/pid:

total 16

drwxrwxr-x 3 sdb sdba 4096 2009-09-17 16:31 .

drwxrwxr-x 11 sdb sdba 4096 2009-09-16 12:05 ..

drwxrwx--- 2 sdb sdba 4096 2009-09-16 12:05 serverpids

-rw-rr 1 sdb sdba 5 2009-09-17 16:31 TST

/sapdb/data/pid/serverpids:

total 8

drwxrwx--- 2 sdb sdba 4096 2009-09-16 12:05 .

drwxrwxr-x 3 sdb sdba 4096 2009-09-17 16:31 ..

/sapdb/data/pipe:

total 8

drwxrwx--- 2 sdb sdba 4096 2009-09-17 16:32 .

drwxrwxr-x 11 sdb sdba 4096 2009-09-16 12:05 ..

/sapdb/data/ppid:

total 12

drwxrwxr-x 2 sdb sdba 4096 2009-09-17 16:31 .

drwxrwxr-x 11 sdb sdba 4096 2009-09-16 12:05 ..

-rw-rr 1 sdb sdba 5 2009-09-17 16:31 TST

/sapdb/data/wrk:

total 320

drwxrwx--- 5 sdb sdba 4096 2009-09-17 16:56 .

drwxrwxr-x 11 sdb sdba 4096 2009-09-16 12:05 ..

-rw-rw---- 1 sdb sdba 0 2009-09-17 16:05 dbmsrv_ike.err

-rw-rw---- 1 sdb sdba 10946 2009-09-17 16:30 dbmsrv_ike.prt

drwxrwx--- 3 sdb sdba 4096 2009-09-17 16:30 .M760309

-rw-rw---- 1 sdb sdba 2592 2009-09-17 16:30 .M760309.dbm.shi

-rw-rw---- 1 sdb sdba 338 2009-09-17 16:30 .M760309.dbm.shm

-rw-rr 1 root root 79247 2009-09-17 16:23 MaxDBSoftware_install-17.09.2009-

16.23.log

-rw-rr 1 root root 44422 2009-09-17 16:30 MaxDBSoftware_install-17.09.2009-

16.30.log

-rw-rr 1 root root 50521 2009-09-17 16:31 MaxDBSoftware_install-17.09.2009-

16.31.log

-rw-rw---- 1 root root 4 2009-09-17 16:07 niserver_ike.pid

-rw-rw---- 1 root root 245 2009-09-17 16:07 niserver_ike.prot_7269

-rw-rw---- 1 root root 498 2009-09-17 16:07 niserver_ike.trace_7269

-rw-rr 1 root root 190 2009-09-17 16:07 nisslserver_ike.trace_7270

drwxrwx--- 2 sdb sdba 4096 2009-09-17 16:29 root

drwxrwx--- 2 sdb sdba 4096 2009-09-17 16:31 TST

-rw-rw---- 1 sdb sdba 2592 2009-09-17 17:17 TST.dbm.shi

-rw-rw---- 1 sdb sdba 376 2009-09-17 17:17 TST.dbm.shm

-rw-rr 1 root root 494 2009-09-17 16:07 xserver_ike.nitrace

-rw-r----- 1 root root 65536 2009-09-17 16:07 xserver_ike.prt

/sapdb/data/wrk/.M760309:

total 16

drwxrwx--- 3 sdb sdba 4096 2009-09-17 16:30 .

drwxrwx--- 5 sdb sdba 4096 2009-09-17 16:56 ..

drwxrwx--- 2 sdb sdba 4096 2009-09-17 13:38 dbahist

-rw-rw---- 1 sdb sdba 1536 2009-09-17 16:30 dbm.upc

/sapdb/data/wrk/.M760309/dbahist:

total 8

drwxrwx--- 2 sdb sdba 4096 2009-09-17 13:38 .

drwxrwx--- 3 sdb sdba 4096 2009-09-17 16:30 ..

/sapdb/data/wrk/root:

total 12

drwxrwx--- 2 sdb sdba 4096 2009-09-17 16:29 .

drwxrwx--- 5 sdb sdba 4096 2009-09-17 16:56 ..

-rw-rw---- 1 sdb sdba 501 2009-09-17 16:29 appldiag

/sapdb/data/wrk/TST:

total 10392

drwxrwx--- 2 sdb sdba 4096 2009-09-17 16:31 .

drwxrwx--- 5 sdb sdba 4096 2009-09-17 16:56 ..

-rw-rw---- 1 sdb sdba 0 2009-09-17 16:25 dbm.cfg

-rw-rw---- 1 sdb sdba 1417 2009-09-17 17:17 dbm.prt

-rw-rw---- 1 sdb sdba 819234 2009-09-17 16:32 dbm.utl

-rw-rw---- 1 sdb sdba 847061 2009-09-17 22:33 knldiag

-rw-rw---- 1 sdb sdba 592 2009-09-17 16:31 knldiag.err

-rw-rw---- 1 sdb sdba 847061 2009-09-17 16:29 knldiag.old

-rw-rw---- 1 sdb sdba 359184 2009-09-17 22:33 KnlMsg

-rw-rw---- 1 sdb sdba 8192 2009-09-17 16:31 KnlMsgArchive

-rw-rw---- 1 sdb sdba 280754 2009-09-17 16:29 KnlMsg.old

-rw-rw---- 1 sdb sdba 7421952 2009-09-17 16:31 knltrace

[lbreddemann · Accepted solution]

hmm... ok.

my fault this time.

looking at the source code i found that the the error message means:

could not create the ipc files in '/var/lib/sdb/'

Due to certains issues, the default location for the dbmserver ipc files had been moved to this folder.

See sap note #1041650 and make sure that sdb:sdba is the owner:group setting for this folder.

regards,

Lars

[brian_walker · Accepted solution]

Thanks very much, that fixed the problem and I was able to update MaxDB.

You might consider adding the error "ERR -24778 DBMSrv 1,could not create dir:dbm/ipc" to the SAP note or creating another SAP note. Likewise, it might make sense to have SDBSETUP fix the permissions during the update.

Brian

[lbreddemann · Accepted solution]

> You might consider adding the error "ERR -24778 DBMSrv 1,could not create dir:dbm/ipc" to the SAP note or creating another SAP note. Likewise, it might make sense to have SDBSETUP fix the permissions during the update.

I agree - this information should be available also for the non-developer.

I already asked the developer to simply improve the error message so that it's easier to fix the issue when it occurs.

regards,

Lars

[peter_baumgartner]

Thank you for this solution!

Tried to Install NW 7.01 ehp1 on SUSE Linux 10 (SELS) & MaxDB 7.7.

There was already appl server on the same OS

At the point "install database server .. " i got an error: "The database installer reported an error. DIAGNOSIS: Some database applications might still be running. Check sdbinst.log.

There i found:

error occured while executing /sapdb/programs/bin/dbmcli -R /sapdb/BWP/db inst_reg

/sapdb/programs/bin/dbmcli -R /sapdb/BWP/db inst_reg: ERR

/sapdb/programs/bin/dbmcli -R /sapdb/BWP/db inst_reg: -24832,ERR_SHMNOTAVAILABLE: Shared memory not available

/sapdb/programs/bin/dbmcli -R /sapdb/BWP/db inst_reg: -24993,ERR_RTEEXT: Runtime environment error

/sapdb/programs/bin/dbmcli -R /sapdb/BWP/db inst_reg: 1,could not create dir:dbm/ipc

/sapdb/programs/bin/dbmcli -R /sapdb/BWP/db inst_reg: 13,Permission denied

The error occured at the last line: permission denied for creating files in IPC

Solution (look at the bottom of note 1041650) :

cd /var/lib/sdb

xxxxxx:/var/lib/sdb # chown sdb:sdba * -R

Retry@sapinst and everything worked flawless