Please Help: Error! Connection failed to MaxDB (Linux)

[Former Member]

Hello,

our current situation is, that we copied manually (after a system crash) all files under /sapdb from an old backup into the our (empty) Live system. Only the database files under sapdb/KRT/sapdata comes from the chrashed SAP system. These files are not lost.

If we start the Sap System following messages appears:

Checking ADA db Database

-

---

ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-

---

09:04:34 27.04.2010 LOG: Effective User Id is root

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

• This is Saposcol Version COLL 20.95 700 - v2.12, AMD/Intel x86_64 with Linux, 2008/01/02

• Usage: saposcol -l: Start OS Collector

• saposcol -k: Stop OS Collector

• saposcol -d: OS Collector Dialog Mode

• saposcol -s: OS Collector Status

• The OS Collector (PID 5469) is already running .....

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

saposcol already running

Running /usr/sap/EC6/SYS/exe/run/startdb

Trying to start database ...

Log file: /home/ec6adm/startdb.log

Database start failed

DB startup failed

Our system administrator is ill and i'm not a system administrator.

Could you help me ?

Thank's lot

Franz

[Former Member]

Thank you all!

Franz

[markus_doehr2]

> our current situation is, that we copied manually (after a system crash) all files under /sapdb from an old backup into the our (empty) Live system.

This is not enough.

You also need

/usr/spool/sql
/etc/opt/sdb or /var/opt/sdb

with the proper permissions.

Otherwise the registration of the database is missing (and hence you get 'invalid' with sdbregview).

Markus

[Former Member]

Hi Markus,

thank you for your help !!

These directories are not chrashed, there are the same directories without any modifications, because the crashed directory /sapdb was on a seperate iscsi device.

But i've started the program sdbregview with the option --set_corrupted_invalid and answered every question (to marked it as invalid) with yes ... maybe this was wrong ?!?

Problem is, that i'm not a system administrator expert ....

Could i solve this problem with the invalid packages without new installation ?

Best Regards

Franz

[markus_doehr2]

> Could i solve this problem with the invalid packages without new installation ?

I'd open an OSS call before more damage is done. It may be a quick fix to just reinstall the software using SDBINST but I'd let the support have a look on the system first. Without system access it's very difficult to suggest something.

Markus

[Former Member]

sorry, i thing you are maybe right:

kurt:/usr/spool/sql # ls -al

total 12

drwxrwxr-x 3 sdb sdba 4096 Jan 11 21:22 .

drwxrwxr-x 3 sdb sdba 4096 Jan 11 21:22 ..

lrwxrwxrwx 1 sdb sdba 19 Jan 11 21:22 dbspeed -> /sapdb/data/dbspeed

lrwxrwxrwx 1 sdb sdba 16 Jan 11 21:22 diag -> /sapdb/data/diag

lrwxrwxrwx 1 sdb sdba 16 Jan 11 21:22 fifo -> /sapdb/data/fifo

drwxrwxrwx 2 sdb sdba 4096 Jan 11 21:22 ini

lrwxrwxrwx 1 sdb sdba 15 Jan 11 21:22 ipc -> /sapdb/data/ipc

lrwxrwxrwx 1 sdb sdba 15 Jan 11 21:22 pid -> /sapdb/data/pid

lrwxrwxrwx 1 sdb sdba 16 Jan 11 21:22 pipe -> /sapdb/data/pipe

lrwxrwxrwx 1 sdb sdba 16 Jan 11 21:22 ppid -> /sapdb/data/ppid

kurt:/etc/opt # ls -al

total 24

drwxr-xr-x 4 root root 4096 Jan 11 21:22 .

drwxr-xr-x 76 root root 8192 Apr 26 13:31 ..

drwxr-xr-x 11 root root 4096 Jan 11 13:44 gnome

drwxr-xr-x 3 root root 4096 Jan 11 2008 kde3

-rw-rw-rw- 1 root sapinst 90 Jan 11 21:22 sdb

you see, that the directory /usr/spool/sql is refferd to the crashed directory /sapdb !

Are the permissions ok ?

Franz

[markus_doehr2]

> you see, that the directory /usr/spool/sql is refferd to the crashed directory /sapdb !

yes.

> Are the permissions ok ?

looks fine to me.

Check knldiag in /sapdb/data/wrk/<SID>, maybe that will give us a hint why the database is not coming up.

Markus

[Former Member]

here the directory

kurt:/data/sapdb/data/wrk/KRT # ls -al

total 12696

drwxrwx--- 5 sdb sdba 4096 Mar 13 02:25 .

drwxrwx--- 6 sdb sdba 4096 Apr 26 16:30 ..

drwxrwxrwx 4 sdb sdba 4096 Mar 13 02:25 DIAGHISTORY

-rw-rw---- 1 sdb sdba 403235 Mar 13 02:25 KnlMsg

-rw-rw---- 1 sdb sdba 295789 Mar 13 02:25 KnlMsg.old

-rw-rw---- 1 sdb sdba 36864 Mar 13 02:25 KnlMsgArchive

drwxrwx--- 2 sdb sdba 4096 Mar 13 02:25 analyzer

-rw-rw---- 1 sdb sdba 120104 Mar 13 02:25 comseg.dump

drwxrwx--- 2 sdb sdba 4096 Mar 13 02:25 dbahist

-rw-rw---- 1 sdb sdba 23 Mar 13 02:25 dbm.cfg

-rw-rw---- 1 sdb sdba 1228331 Mar 13 02:25 dbm.ins

-rw-rw---- 1 sdb sdba 3686 Mar 13 02:25 dbm.knl

-rw-rw---- 1 sdb sdba 1164 Mar 13 02:25 dbm.mdf

-rw-rw---- 1 sdb sdba 195 Mar 13 02:25 dbm.mmm

-rw-rw---- 1 sdb sdba 331834 Apr 26 14:41 dbm.prt

-rw-rw---- 1 sdb sdba 2048 Mar 13 02:25 dbm.upc

-rw-rw---- 1 sdb sdba 819234 Mar 13 02:25 dbm.utl

-rw-rw---- 1 sdb sdba 851843 Mar 13 02:25 knldiag

-rw-rw---- 1 sdb sdba 10620 Mar 13 02:25 knldiag.err

-rw-rw---- 1 sdb sdba 851847 Mar 13 02:25 knldiag.old

-rw-rw---- 1 sdb sdba 7946240 Mar 13 02:25 knltrace

you can see, that the knldiag.* are from 13th March .... looks not actually ...

Best Regards

Franz

[markus_doehr2]

This seems to be a MaxDB 7.7, here all the logs are in an XML file.

Logon as use <sid>adm, step to the directory and execute

protconv

This will convert the XML into a human readable format.

Markus

[Former Member]

Hi Markus,

the user ec6adm has no permission's for directory wrk .... is this right ?

kurt:ec6adm 67> cd wrk

wrk: Keine Berechtigung.

kurt:ec6adm 68> ls -al

insgesamt 44

drwxrwxr-x 11 sdb sdba 4096 2010-03-12 22:19 .

drwxr-xr-x 5 sdb sdba 4096 2010-04-26 11:28 ..

drwxrwxr-x 3 sdb sdba 4096 2010-04-27 09:27 config

drwxrwx--- 2 sdb sdba 4096 2010-03-13 02:25 dbspeed

drwxrwx--- 2 sdb sdba 4096 2010-03-12 22:19 diag

drwxrwxr-x 2 sdb sdba 4096 2010-04-26 16:19 fifo

drwxrwxr-x 5 sdb sdba 4096 2010-04-25 16:49 ipc

drwxrwxr-x 3 sdb sdba 4096 2010-03-12 22:19 pid

drwxrwx--- 2 sdb sdba 4096 2010-03-12 22:19 pipe

drwxrwxr-x 2 sdb sdba 4096 2010-03-12 22:19 ppid

drwxrwx--- 6 sdb sdba 4096 2010-04-26 16:30 wrk

[markus_doehr2]

> the user ec6adm has no permission's for directory wrk .... is this right ?

Yes.

Add the user ec6adm to the group sdba in /etc/group - logoff and log on and try again - or use user sqdec6.

Markus

[Former Member]

/sapdb/programs/bin/sdbregview -l

DB Analyzer /sapdb/programs 7.6.03.09 64 bit valid

Server Utilities /sapdb/programs 7.6.03.09 64 bit valid

PCR 7300 /sapdb/programs 7.3.00.58 invalid

PCR 7301 /sapdb/programs 7.3.01.22 valid

PCR 7500 /sapdb/programs 7.5.00.46 64 bit valid

SAP Utilities /sapdb/programs 7.6.03.09 64 bit valid

Redist Python /sapdb/programs 7.6.03.09 64 bit valid

Base /sapdb/programs 7.6.03.09 64 bit invalid

JDBC /sapdb/programs 7.6.03.03 invalid

Messages /sapdb/programs MSG 0.5603 invalid

ODBC /sapdb/programs 7.6.03.09 64 bit invalid

Database Kernel /sapdb/KRT/db 7.6.03.09 64 bit invalid

Loader /sapdb/programs 7.6.03.09 64 bit valid

SQLDBC /sapdb/programs 7.6.03.09 64 bit invalid

SQLDBC 76 /sapdb/programs 7.6.03.09 64 bit invalid

Fastload API /sapdb/programs 7.6.03.09 64 bit invalid

Are the lines with "invalid" the problem ?

Could we solve these problems without a new installation (i'm really not an expert) ?

Again .... thank's a lot

Franz

[former_member229109]

Hello Franz,

You run u201C/sapdb/programs/bin/sdbregview u2013lu201D

And saw that you have invalid database software packages.

You started the program sdbregview with the option --set_corrupted_invalid and answered every question (to marked it as invalid) with yes ...

Did you follow Markus recommendation to reinstall invalid database packages?

You need the database software of the version 7.6.03.09 and access to the database server as root.

Could you please post the current output of u201C/sapdb/programs/bin/sdbregview u2013lu201D.

What was the version of the source database, which was crashed?

Thank you and best regards, Natalia Khlopina

[Former Member]

/sapdb/programs/bin/dbmcli db_enum -s

OK

TEST /sapdb/KRT/db 7.6.03.09 fast offline

TEST /sapdb/KRT/db 7.6.03.09 quick offline

TEST /sapdb/KRT/db 7.6.03.09 slow offline

TEST /sapdb/KRT/db 7.6.03.09 test offline

KRT /sapdb/KRT/db 7.6.03.09 fast offline

KRT /sapdb/KRT/db 7.6.03.09 quick offline

KRT /sapdb/KRT/db 7.6.03.09 slow offline

KRT /sapdb/KRT/db 7.6.03.09 test offline

.M760309 /sapdb/KRT/db 7.6.03.09 fast offline

.M760309 /sapdb/KRT/db 7.6.03.09 quick offline

.M760309 /sapdb/KRT/db 7.6.03.09 slow offline

.M760309 /sapdb/KRT/db 7.6.03.09 test offline

/sapdb/programs/bin/dbmcli -R /sapdb/KRT/db inst_reg -k /sapdb/KRT/db

OK

/sapdb/programs/bin/dbmcli inst_enum

OK

7.6.03.09 /sapdb/KRT/db

[Former Member]

ls -l /etc/opt/sdb

-rw-rw-rw- 1 root sapinst 90 Jan 11 21:22 /etc/opt/sdb

ls -l /sapdb/data

total 36

drwxrwxr-x 3 sdb sdba 4096 Apr 26 15:58 config

drwxrwx--- 2 sdb sdba 4096 Mar 13 02:25 dbspeed

drwxrwx--- 2 sdb sdba 4096 Mar 12 22:19 diag

drwxrwxr-x 2 sdb sdba 4096 Apr 26 16:19 fifo

drwxrwxr-x 5 sdb sdba 4096 Apr 25 16:49 ipc

drwxrwxr-x 3 sdb sdba 4096 Mar 12 22:19 pid

drwxrwx--- 2 sdb sdba 4096 Mar 12 22:19 pipe

drwxrwxr-x 2 sdb sdba 4096 Mar 12 22:19 ppid

drwxrwx--- 6 sdb sdba 4096 Apr 26 16:30 wrk

ls -l /sapdb/data/config

total 404

-rw-rw---- 1 sdb sdba 9654 Apr 26 15:58 .M760309

-rw-rw-r-- 1 sdb sdba 190704 Apr 26 15:58 .M760309.pah

-rw-rw-r-- 1 sdb sdba 1536 Apr 26 15:58 .M760309.upc

-rw-rw---- 1 sdb sdba 73 Apr 26 15:58 Databases.ini

-rrr-- 1 sdb sdba 53 Apr 26 15:58 Installations.ini

-rw-rw-r-- 1 sdb sdba 12136 Apr 25 17:47 KRT

-rrr-- 1 sdb sdba 12136 Apr 25 17:47 KRT.01

-rrr-- 1 sdb sdba 11990 Apr 25 17:47 KRT.02

-rw-rw-r-- 1 sdb sdba 46 Apr 25 17:47 KRT.cfg

-rw-rw-r-- 1 sdb sdba 832 Apr 25 17:47 KRT.mmm

-rw-rw-r-- 1 sdb sdba 125766 Apr 25 17:47 KRT.pah

-rw-rw-r-- 1 sdb sdba 2048 Apr 25 17:47 KRT.upc

-rrr-- 1 sdb sdba 48 Apr 25 17:47 Runtimes.ini

-rw-rw---- 1 sdb sdba 1536 Apr 26 14:47 TEST.upc

drwxr-xr-x 2 root root 4096 Apr 26 16:30 install

/sapdb/programs/bin/xinstinfo KRT

IndepData : /sapdb/data

IndepPrograms : /sapdb/programs

InstallationPath : /sapdb/KRT/db

Kernelversion : KERNEL 7.6.03 BUILD 009-123-163-622

Rundirectory : /sapdb/data/wrk/KRT

[Former Member]

Some additional informations:

/home/ec6adm/startdb.log:

-

---

Di Apr 27 09:04:34 CEST 2010

LOGFILE FOR STARTING DATABASE

Trying to start database ...

-

---

Di Apr 27 09:04:34 CEST 2010

Checking required environment variables

SAPSYSTEMNAME is >EC6<

Start database with xuserkey >c<

-

---

Di Apr 27 09:04:34 CEST 2010

Connect to the database to check the database state

dbmcli: connect check finished with return code: 0

Database not available

-

---

Di Apr 27 09:04:34 CEST 2010

Starting XServer

12916 XSERVER Found other running x_server with version 'X64/LIX86 7.6.03 Build 009-123-163-622'

12902 XSERVER started, 'already...'

-

---

Di Apr 27 09:04:34 CEST 2010

Starting database

Starting Database Instance...

Error! Connection failed to node kurt for database KRT:

database not found

Opening Database...

Error! Connection failed to node kurt for database KRT:

database not found

-

---

Di Apr 27 09:04:34 CEST 2010

Connect to the database to verify the database is now open

dbmcli check finished with return code: 0

Database start failed