Error while connecting to database.

[I056372]

Hi ,

We have a sap netweaver system running on linux X86_64 bit suse 11 enterprise version, on max db 7.7.6.10

Facing the following issue

lidt50796060:anradm 50> dbmcli -d ANR -u control,devadmin2

Absolute path /sapdb/ANR/db/pgm/starter/sdbstarter from relative path /sapdb/ANR/db/pgm/starter not accessible

RTE_CallSdbStarter(): No absolute path for start directory: /sapdb/ANR/db/pgm/starter

Error! Connection failed to node (local) for database ANR:

Reading header from pipe:closed by serv

can anybody help me with this error.

Regards,

Jay

[former_member229109]

Hello Jay

Please update with additional information:

a) Login as root<!> user to the server lidt50796060. run:

id anradm

/sapdb/programs/bin/sdbregview -l

/sapdb/programs/bin/xinstinfo ANR

more /etc/opt/sdb

ls -l /sapdb/ANR/db/pgm

< update with output >

/sapdb/programs/bin/sdbverify

< update with summary results at the end >

b) Did you add user anradm to sdba group?

Post the results of the command:

lidt50796060:anradm XX> dbmcli -d ANR -n localhost -u control,devadmin2

<enter>

Regards, Natalia Khlopina

[I056372]

id anradm

uid=1003(anradm) gid=1001(sapsys) groups=0(root),1001(sapsys),1002(sdba)

./sdbregview -l

DB Analyzer /sapdb/programs 7.7.06.10 64 bit valid

Server Utilities /sapdb/programs 7.7.06.10 64 bit valid

PCR 7300 /sapdb/programs 7.3.00.60 valid

PCR 7301 /sapdb/programs 7.3.01.22 valid

PCR 7500 /sapdb/programs 7.5.00.50 64 bit valid

SAP Utilities /sapdb/programs 7.7.06.10 64 bit valid

Redist Python /sapdb/programs 7.7.06.10 64 bit valid

Base /sapdb/programs 7.7.06.10 64 bit valid

JDBC /sapdb/programs 7.6.06.02 valid

Messages /sapdb/programs MSG 0.7732 valid

ODBC /sapdb/programs 7.7.06.10 64 bit valid

Database Kernel /sapdb/ANR/db 7.7.06.10 64 bit valid

Database Kernel /sapdb/RNA/db 7.6.00.18 64 bit valid

SQLDBC 77 /sapdb/programs 7.7.06.10 64 bit valid

Loader /sapdb/programs 7.7.06.10 64 bit valid

SQLDBC /sapdb/programs 7.7.06.10 64 bit valid

SQLDBC 76 /sapdb/programs 7.6.05.15 64 bit valid

Fastload API /sapdb/programs 7.7.06.10 64 bit valid

/sapdb/programs/bin # ./xinstinfo ANR

IndepData : /sapdb/data

IndepPrograms : /sapdb/programs

InstallationPath : /sapdb/ANR/db

Kernelversion : KERNEL 7.7.06 BUILD 010-123-204-327

Rundirectory : /sapdb/data/wrk/ANR

lidt50796060:/ # more /etc/opt/sdb

[Globals]

IndepData=/sapdb/data

IndepPrograms=/sapdb/programs

SdbOwner=sdb

SdbGroup=sdba

-r-xr-x--- 1 sdb sdba 1585074 Feb 19 2009 backup

-r-xr-x--- 1 sdb sdba 2034845 Feb 18 2009 cons

-r-xr-x--- 1 sdb sdba 1683045 Feb 19 2009 dbmdrop

-r-xr-x--- 1 sdb sdba 1683022 Feb 19 2009 dbmreg

-r-xr-x--- 1 sdb sdba 8365308 Feb 19 2009 dbmshm

-r-sr-s--x 1 sdb sdba 8363056 Feb 19 2009 dbmsrv

-r-xr-x--- 1 sdb sdba 1683068 Feb 19 2009 dbmstart

-r-xr-x--- 1 sdb sdba 1683045 Feb 19 2009 dbmstop

-r-xr-x--- 1 sdb sdba 1683068 Feb 19 2009 dbmunreg

-r-xr-x--- 1 sdb sdba 2977109 Feb 18 2009 diagnose

-r-xr-x--- 1 sdb sdba 24972733 Feb 19 2009 kernel

-r-xr-x--- 1 sdb sdba 7547216 Feb 19 2009 lserver

-r-xr-x--- 1 sdb sdba 5522110 Feb 18 2009 python

-r-xr-x--- 1 sdb sdba 33455036 Feb 18 2009 slowknl

-r-xr-x--- 1 sdb sdba 1728842 Feb 18 2009 start

dr-x------ 2 sdb sdba 4096 Jul 5 07:49 starter

-r-xr-x--- 1 sdb sdba 1724710 Feb 18 2009 stop

-r-xr-x--- 1 sdb sdba 25319 Feb 18 2009 sysrc

-r-xr-x--- 1 sdb sdba 1489014 Feb 19 2009 tracesort

lidt50796060:/sapdb/programs/bin # ./sdbverify

VERIFICATION SUMMARY:

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

NUMBER OF INVALID PACKAGES: 0

NUMBER OF VALID PACKAGES: 18

NUMBER OF INCONSISTENT PACKAGES: 3

INCONSISTENT PACKAGES:

PCR 7300 in /sapdb/programs

Database Kernel in /sapdb/ANR/db

Database Kernel in /sapdb/RNA/db

TOTAL NUMBER OF FILES: 478

NUMBER OF MISSED FILES: 0

NUMBER OF MODIFIED FILES: 0

NUMBER OF FILES WITH MODIFIED PERMISSIONS: 3

b) Did you add user anradm to sdba group?

it is already added to the group

lidt50796060:anradm 51> dbmcli -d ANR -n lidt50796060 -u control,devadmin2

Absolute path /sapdb/ANR/db/pgm/starter/sdbstarter from relative path /sapdb/ANR /db/pgm/starter not accessible

RTE_CallSdbStarter(): No absolute path for start directory: /sapdb/ANR/db/pgm/st arter

Error! Connection failed to node lidt50796060 for database ANR:

Reading header from pipe:closed by serv

these are the outputs of the requested quesions.Please let me know in case you need any further info...

[former_member229109]

Hello,

1.

Please run as root:

/sapdb/programs/bin/sdbverify

or

/sapdb/programs/bin/sdbverify > sdbverify_result.txt

then display sdbverify_result.txt and let me know what file listed with modified permissions for the database kernel in /sapdb/ANR/db package.

2.

Restart the x_server first.

Post the results of the command:

lidt50796060:anradm XX> dbmcli -d ANR -n localhost -u control,devadmin2

<enter>

don't replace the localhost by lidt50796060.

Regards, Natalia Khlopina

[I056372]

lidt50796060:/sapdb/programs/bin # ./sdbverify

DB Analyzer 7.7.06.10 64 bit in /sapdb/programs

-

---

check files... ok

check dependencies... ok

package data is consistent

Server Utilities 7.7.06.10 64 bit in /sapdb/programs

-

---

check files... ok

check dependencies... ok

package data is consistent

PCR 7300 7.3.00.60 in /sapdb/programs

-

---

check files... ok

check dependencies... ok

check rte registration of package... failed

package data is inconsistent

PCR 7301 7.3.01.22 in /sapdb/programs

-

---

check files... ok

check dependencies... ok

check rte registration of package... ok

package data is consistent

PCR 7500 7.5.00.50 64 bit in /sapdb/programs

-

---

check files... ok

check dependencies... ok

check rte registration of package... ok

package data is consistent

SAP Utilities 7.7.06.10 64 bit in /sapdb/programs

-

---

check files... ok

check dependencies... ok

package data is consistent

Redist Python 7.7.06.10 64 bit in /sapdb/programs

-

---

check files... ok

check dependencies... ok

package data is consistent

Base 7.7.06.10 64 bit in /sapdb/programs

-

---

check files... ok

check dependencies... ok

check rte registration of package... ok

package data is consistent

JDBC 7.6.06.02 in /sapdb/programs

-

---

check files... ok

check dependencies... ok

package data is consistent

Messages MSG 0.7732 in /sapdb/programs

-

---

check files... ok

check dependencies... ok

package data is consistent

ODBC 7.7.06.10 64 bit in /sapdb/programs

-

---

check files... ok

check dependencies... ok

package data is consistent

Database Kernel 7.7.06.10 64 bit in /sapdb/ANR/db

-

---

check files... failed

mode of /sapdb/ANR/db/pgm/starter/dbmverifypw was modified

owner of /sapdb/ANR/db/pgm/starter/dbmverifypw was modified

mode of /sapdb/ANR/db/pgm/starter/sdbstarter was modified

owner of /sapdb/ANR/db/pgm/starter/sdbstarter was modified

check dependencies... ok

check rte registration of package... ok

package data is inconsistent

Database Kernel 7.6.00.18 64 bit in /sapdb/RNA/db

-

---

check files... failed

mode of /sapdb/RNA/db/pgm/starter/sdbstarter was modified

check dependencies... ok

check rte registration of package... ok

package data is inconsistent

SQLDBC 77 7.7.06.10 64 bit in /sapdb/programs

-

---

check files... ok

check dependencies... ok

package data is consistent

Loader 7.7.06.10 64 bit in /sapdb/programs

-

---

check files... ok

check dependencies... ok

package data is consistent

SQLDBC 7.7.06.10 64 bit in /sapdb/programs

-

---

check files... ok

check dependencies... ok

package data is consistent

SQLDBC 76 7.6.05.15 64 bit in /sapdb/programs

-

---

check files... ok

check dependencies... ok

package data is consistent

Fastload API 7.7.06.10 64 bit in /sapdb/programs

-

---

check files... ok

check dependencies... ok

package data is consistent

VERIFICATION SUMMARY:

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

NUMBER OF INVALID PACKAGES: 0

NUMBER OF VALID PACKAGES: 18

NUMBER OF INCONSISTENT PACKAGES: 3

INCONSISTENT PACKAGES:

PCR 7300 in /sapdb/programs

Database Kernel in /sapdb/ANR/db

Database Kernel in /sapdb/RNA/db

TOTAL NUMBER OF FILES: 478

NUMBER OF MISSED FILES: 0

NUMBER OF MODIFIED FILES: 0

NUMBER OF FILES WITH MODIFIED PERMISSIONS: 3

lidt50796060:anradm 51> x_server stop

lidt50796060:anradm 52> 12905 XSERVER stopped

lidt50796060:anradm 52> x_server start

lidt50796060:anradm 53> 12798 NISERVER NI support started.

WNG 12453 NISSLSRV NISSL Init: SSL: Could not locate ticket file

12902 XSERVER started, 'U64/LIX86 7.7.06 Build 010-123-204-327'

lidt50796060:anradm 53> dbmcli -d ANR -n localhost -u control,devadmin2

Error! Connection failed to node localhost for database ANR:

packet too small

thanks for the help here. Please let me know what is to be done to fix this.

[former_member229109]

Hello,

1.

A) Please check/change as root:

ownership/permission of /sapdb/ANR/db/pgm/starter/dbmverifypw :

-r-sr-x--- 1 root sdba .... dbmverifypw

ownership/permission of /sapdb/ANR/db/pgm/starter/sdbstarter:

-r-sx- 1 root sdba ... sdbstarter

B) run as root after that :

/sapdb/programs/bin/sdbverify

and post the results.

C) Try to connect to the database ANR & post the results.

2.

The ownership and permissions should set correctly by database installation/update tools.

Please don't change then manualy.

Regards, Natalia Khlopina

Edited by: Natalia Khlopina on Jul 8, 2011 12:57 PM