database failing to start as sidadm

[Former Member]

Hi

i have upgrade my database to MAXDB 7.6 ans OS to SUSE 9.1 all was ok until when i rebooted the system.I started getting this error when trying to start sap as sidadm.i didnt change any of the permissions.i i add sidadm to group 1000 i still get the same error ,any hints.

Starting SAP-Collector Daemon

-

---

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

• This is Saposcol Version COLL 20.94 640 - v2.00, Intel x86 with Linux, 2007/02/20

• 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 3491) is already running .....

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

saposcol already running

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

Trying to start database ...

Log file: /home/pfmadm/startdb.log

Must be called by root or effective user 1000 effective group 1000

Must be called by root or effective user 1000 effective group 1000

Must be called by root or effective user 1000 effective group 1000

Must be called by root or effective user 1000 effective group 1000

Database start failed

DB startup failed

pfm41:pfmadm 56>

Log file: /home/pfmadm/startdb.log

Starting XServer

Must be called by root or effective user 1000 effective group 1000

-

---

Tue Jul 24 17:52:40 SAST 2007

Starting database

Starting Database Instance...

Must be called by root or effective user 1000 effective group 1000

Error! Connection failed to node pfm1 for database PFM: Error writing to pipe:(3

2:Broken pipe)

Opening Database...

Must be called by root or effective user 1000 effective group 1000

Error! Connection failed to node pfm1 for database PFM: Error writing to pipe:(3

2:Broken pipe)

-

---

Tue Jul 24 17:52:40 SAST 2007

Connect to the database to verify the database is now open

dbmcli check finished with return code: 0

Database start failed

who should own X_SERVER and X_START after the upgrade and which group as it looks like its complaining abt that

[former_member229109]

Hello Tsungy,

-> What are the effective user 1000 & effective group 1000?

Is effective group 1000 'sdba' group?

-> Is the pfmadm user a member of the 'sdba' group? Please update with output of the following commands on the server pfm1:

id pfmadm

id sdb

xinstinfo PFM

sdbregview -l

more /etc/opt/sdb

ls -l /sapdb/programs/pgm

ls -l /sapdb/PFM/db/pgm

-> You should be able to start the database by the user in the 'SdbGroup' group.

Reference to MAXDB library :: http://dev.mysql.com/doc/maxdb/en/default.htm

As you know, to protect database resources from unauthorized access, MaxDB uses special operating system users and groups on UNIX and Linux.

Please review the user rights in the document "Special Operating System Users and Groups (UNIX/Linux)" at

http://dev.mysql.com/doc/maxdb/en/23/cb4440eff00272e10000000a155106/content.htm

-> Please run the command 'sdbverify' as root user (see SAP note 546737) & check the results. If you will get errors, please post them.

Run as root user:

Cd /sapdb/programs/bin

./sdbverify

Thank you and best regards, Natalia Khlopina

[Former Member]

hi

sdb is user id 1000

sdba is group id 1000

pfmadm is not in group sdba(i added him but it came with the same error)in /etc/group

pfm1:pfmadm 51> xinstinfo PFM

IndepData : /sapdb/data

IndepPrograms : /sapdb/programs

InstallationPath : /sapdb/PFM/db

Kernelversion : KERNEL 7.6.00 BUILD 018-121-119-055

Rundirectory : /sapdb/data/wrk/PFM

pfm1:pfmadm 52> sdbregview -l

DB Analyzer /sapdb/programs 7.6.00.18 32 bit valid

Server Utilities /sapdb/programs 7.6.00.18 32 bit valid

PCR 7300 /sapdb/programs 7.3.00.54 valid

Base /sapdb/programs 7.6.00.18 32 bit valid

Redist Python /sapdb/programs 7.6.00.18 32 bit valid

PCR 7301 /sapdb/programs 7.3.01.18 valid

JDBC /sapdb/programs 7.6.00.16 valid

PCR 7500 /sapdb/programs 7.5.00.30 32 bit valid

Messages /sapdb/programs MSG 0.3017 valid

ODBC /sapdb/programs 7.6.00.18 32 bit valid

Database Kernel /sapdb/PFM/db 7.6.00.18 32 bit valid

Loader /sapdb/programs 7.6.00.18 32 bit valid

SQLDBC /sapdb/programs 7.6.00.18 32 bit valid

SQLDBC 7600 /sapdb/programs 7.6.00.18 32 bit valid

PCR 7403 /sapdb/programs 7.4.03.40 32 bit valid

pfm1:pfm1adm 53> more /etc/opt/sdb

[Globals]

IndepData=/sapdb/data

IndepPrograms=/sapdb/programs

SdbOwner=sdb

SdbGroup=sdba

pfm1:~ # ls -l /sapdb/programs/pgm

total 15340

drwxrwxrwx 3 sdb sdba 4096 Jul 21 09:15 .

drwxrwxrwx 15 sdb sdba 4096 Jul 21 09:15 ..

-rwxrwxrwx 1 sdb sdba 5348368 Feb 21 2006 lserver

-rwxrwxrwx 1 sdb sdba 886262 Feb 21 2006 maketi

-rwxrwxrwx 1 sdb sdba 860759 Feb 21 2006 niserver

-rwxrwxrwx 1 sdb sdba 860833 Feb 21 2006 nisslserver

-rwxrwxrwx 1 sdb sdba 5198689 Feb 21 2006 python

-rwxrwxrwx 1 sdb sdba 762259 Feb 21 2006 regupd

-rwxrwxrwx 1 sdb sdba 737029 Feb 21 2006 sqlping

drwxrwxrwx 2 sdb sdba 4096 Jul 21 09:15 starter

-rwxrwxrwx 1 sdb sdba 973023 Feb 21 2006 vserver

pfm1:~ # ls -l /sapdb/PFM/db/pgm

total 73092

drwxrwxrwx 3 sdb sdba 4096 Jul 21 09:15 .

drwxrwxrwx 14 sdb sdba 4096 Jul 21 09:15 ..

-rwxrwxrwx 1 sdb sdba 809314 Feb 21 2006 backup

-rwxrwxrwx 1 sdb sdba 1030818 Feb 21 2006 cons

-rwxrwxrwx 1 sdb sdba 1656459 Feb 21 2006 dbmshm

-rwxrwxrwx 1 sdb sdba 4531142 Feb 21 2006 dbmsrv

-rwxrwxrwx 1 sdb sdba 4461376 Feb 21 2006 dbmsrvscd

-rwxrwxrwx 1 sdb sdba 4334506 Feb 21 2006 dbmstart

-rwxrwxrwx 1 sdb sdba 4334451 Feb 21 2006 dbmstop

-rwxrwxrwx 1 root sdba 818589 Feb 21 2006 dbmverifypw

-rwxrwxrwx 1 sdb sdba 1938507 Feb 21 2006 diagnose

-rwxrwxrwx 1 sdb sdba 16873979 Feb 21 2006 kernel

-rwxrwxrwx 1 sdb sdba 5348368 Feb 21 2006 lserver

-rwxrwxrwx 1 sdb sdba 5198689 Feb 21 2006 python

-rwxrwxrwx 1 sdb sdba 21341735 Feb 21 2006 slowknl

-rwxrwxrwx 1 sdb sdba 955253 Feb 21 2006 start

drwxrwxrwx 2 sdb sdba 4096 Jul 21 09:15 starter

-rwxrwxrwx 1 sdb sdba 953274 Feb 21 2006 stop

-rwxrwxrwx 1 sdb sdba 17743 Feb 21 2006 sysrc

-rwxrwxrwx 1 sdb sdba 35065 Feb 21 2006 tracesort

sdbverify:

check dependencies... ok

package data is inconsistent

ODBC 7.6.00.18 32 bit in /sapdb/programs

-

---

check files... failed

mode of /sapdb/programs/incl/sqlucode.h was modified

mode of /sapdb/programs/lib/libsqlodw.a was modified

mode of /sapdb/programs/incl/WINDOWS.H was modified

mode of /sapdb/programs/incl/sql.h was modified

mode of /sapdb/programs/lib/libsqlodw.so was modified

mode of /sapdb/programs/lib/libsqlod.a was modified

mode of /sapdb/programs/incl/sqlext.h was modified

mode of /sapdb/programs/incl/sqltypes.h was modified

mode of /sapdb/programs/lib/libsqlod.so was modified

check dependencies... ok

package data is inconsistent

Database Kernel 7.6.00.18 32 bit in /sapdb/PFM/db

-

---

check files... failed

mode of /sapdb/PFM/db/doc/FirstSteps/ODBC/HowToODBC.html was modified

mode of /sapdb/PFM/db/pgm/slowknl was modified

mode of /sapdb/PFM/db/env/APPS.py was modified

mode of /sapdb/PFM/db/env/kernprot.use was modified

mode of /sapdb/PFM/db/env/INFO.py was modified

mode of /sapdb/PFM/db/pgm/cons was modified

mode of /sapdb/PFM/db/pgm/lserver was modified

mode of /sapdb/PFM/db/bin/pipe2file was modified

mode of /sapdb/PFM/db/bin/dbmevtdisp was modified

mode of /sapdb/PFM/db/env/ORADDSYN.py was modified

mode of /sapdb/PFM/db/lib/python2.3/sdb/loadermodule.so was modified

mode of /sapdb/PFM/db/pgm/dbmstart was modified

mode of /sapdb/PFM/db/doc/FirstSteps/maxdbenv.sh was modified

mode of /sapdb/PFM/db/env/SYSINFOCOM.py was modified

mode of /sapdb/PFM/db/lib/python23.zip was modified

mode of /sapdb/PFM/db/pgm/dbmsrvscd was modified

mode of /sapdb/PFM/db/lib/python2.3/sdb/__init__.py was modified

mode of /sapdb/PFM/db/lib/libhsscopy.so was modified

mode of /sapdb/PFM/db/env/CNR3DATA.py was modified

mode of /sapdb/PFM/db/sap/lcinit was modified

mode of /sapdb/PFM/db/doc/FirstSteps/index.html was modified

mode of /sapdb/PFM/db/doc/FirstSteps/SQLDBC/HelloMaxDB.cpp was modified

mode of /sapdb/PFM/db/doc/FirstSteps/Java/HowToJava.html was modified

mode of /sapdb/PFM/db/doc/FirstSteps/Perl/demodbData.pm was modified

mode of /sapdb/PFM/db/demo/ltutorial.py was modified

mode of /sapdb/PFM/db/doc/FirstSteps/Python/HelloMaxDB-API.py was modified

mode of /sapdb/PFM/db/env/REPOSITORY.py was modified

mode of /sapdb/PFM/db/pgm/sysrc was modified

mode of /sapdb/PFM/db/lib/python2.3/optlib.py was modified

mode of /sapdb/PFM/db/sap/lvcbench.so was modified

mode of /sapdb/PFM/db/env/ORADDCOM.py was modified

mode of /sapdb/PFM/db/sap/grantxdb.dbm was modified

mode of /sapdb/PFM/db/demo/tutoriallib.py was modified

mode of /sapdb/PFM/db/demo/HOTEL.py was modified

mode of /sapdb/PFM/db/doc/FirstSteps/SQLDBC/Makefile was modified

mode of /sapdb/PFM/db/env/cserv.pcf was modified

mode of /sapdb/PFM/db/doc/FirstSteps/Perl/HowToPerl.html was modified

mode of /sapdb/PFM/db/doc/FirstSteps/Python/HowToPython.html was modified

mode of /sapdb/PFM/db/bin/backint was modified

mode of /sapdb/PFM/db/lib/python2.3/sdb/sqlmodule.so was modified

mode of /sapdb/PFM/db/doc/FirstSteps/ODBC/HelloMaxDB.c was modified

mode of /sapdb/PFM/db/env/vserver.use was modified

mode of /sapdb/PFM/db/doc/FirstSteps/Java/DemodbData.java was modified

mode of /sapdb/PFM/db/pgm/python was modified

mode of /sapdb/PFM/db/sap/saprfc.ini was modified

mode of /sapdb/PFM/db/doc/FirstSteps/Java/StateMaxDB.class was modified

mode of /sapdb/PFM/db/lib/python2.3/sdb/dbmmodule.so was modified

mode of /sapdb/PFM/db/env/SAPDBLOADER.py was modified

mode of /sapdb/PFM/db/bin/xsql was modified

mode of /sapdb/PFM/db/bin/x_python was modified

mode of /sapdb/PFM/db/env/general.use was modified

mode of /sapdb/PFM/db/misc/drop_demo_db.sh was modified

mode of /sapdb/PFM/db/sap/dbpinstall.lst was modified

mode of /sapdb/PFM/db/sap/sphsapdb.so was modified

mode of /sapdb/PFM/db/doc/FirstSteps/Java/StateMaxDB.java was modified

mode of /sapdb/PFM/db/pgm/dbmsrv was modified

mode of /sapdb/PFM/db/bin/dbmsrvctl was modified

mode of /sapdb/PFM/db/pgm/start was modified

mode of /sapdb/PFM/db/env/en/DBM.en was modified

mode of /sapdb/PFM/db/env/SQLDBC.py was modified

mode of /sapdb/PFM/db/env/lapps.py was modified

mode of /sapdb/PFM/db/env/getpackages.py was modified

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

mode of /sapdb/PFM/db/env/WA.py was modified

mode of /sapdb/PFM/db/bin/x_diagnose was modified

mode of /sapdb/PFM/db/bin/xtracesort was modified

mode of /sapdb/PFM/db/doc/FirstSteps/Python/HelloMaxDB.py was modified

mode of /sapdb/PFM/db/sap/sphsapdb.lst was modified

mode of /sapdb/PFM/db/lib/ContentStorage.so was modified

mode of /sapdb/PFM/db/lib/python2.3/sdb/dbapi.py was modified

mode of /sapdb/PFM/db/etc/VERSIONS was modified

mode of /sapdb/PFM/db/doc/FirstSteps/Java/HelloMaxDB.java was modified

mode of /sapdb/PFM/db/env/ORADDV.py was modified

mode of /sapdb/PFM/db/env/UDE.py was modified

mode of /sapdb/PFM/db/env/GARBAGE.py was modified

mode of /sapdb/PFM/db/pgm/dbmstop was modified

mode of /sapdb/PFM/db/env/SYSINFO.py was modified

mode of /sapdb/PFM/db/doc/FirstSteps/Java/DemodbData.class was modified

mode of /sapdb/PFM/db/env/lsystab.py was modified

mode of /sapdb/PFM/db/env/XDDCOM.py was modified

mode of /sapdb/PFM/db/doc/FirstSteps/Perl/StateMaxDB.pl was modified

mode of /sapdb/PFM/db/lib/dbpinstall.so was modified

mode of /sapdb/PFM/db/env/XDD.py was modified

mode of /sapdb/PFM/db/doc/FirstSteps/SQLDBC/HowToSQLDBC.html was modified

mode of /sapdb/PFM/db/bin/dbmevthndl_display was modified

mode of /sapdb/PFM/db/env/ODBC.py was modified

mode of /sapdb/PFM/db/doc/FirstSteps/Java/HelloMaxDB.class was modified

mode of /sapdb/PFM/db/env/SYSDBA.py was modified

mode of /sapdb/PFM/db/env/installib.py was modified

mode of /sapdb/PFM/db/bin/xkernprot was modified

mode of /sapdb/PFM/db/env/CNR3TAB.py was modified

mode of /sapdb/PFM/db/env/ORADD.py was modified

mode of /sapdb/PFM/db/env/PRECOM.py was modified

mode of /sapdb/PFM/db/pgm/diagnose was modified

mode of /sapdb/PFM/db/lib/liboms.so was modified

mode of /sapdb/PFM/db/env/SHOWCMD.py was modified

mode of /sapdb/PFM/db/doc/FirstSteps/Python/StateMaxDB.py was modified

mode of /sapdb/PFM/db/env/TRIGGER.py was modified

mode of /sapdb/PFM/db/pgm/dbmshm was modified

mode of /sapdb/PFM/db/pgm/tracesort was modified

mode of /sapdb/PFM/db/env/SYSDBACOM.py was modified

mode of /sapdb/PFM/db/pgm/dbmverifypw was modified

mode of /sapdb/PFM/db/pgm/kernel was modified

mode of /sapdb/PFM/db/lib/libSQLDBC.so was modified

mode of /sapdb/PFM/db/doc/FirstSteps/ODBC/Makefile was modified

mode of /sapdb/PFM/db/doc/FirstSteps/Python/demodbData.py was modified

mode of /sapdb/PFM/db/env/DBMVIEWS.py was modified

mode of /sapdb/PFM/db/misc/create_demo_db.sh was modified

mode of /sapdb/PFM/db/env/JDBC.py was modified

mode of /sapdb/PFM/db/lib/libSQLDBC_C.so was modified

mode of /sapdb/PFM/db/bin/ps_all was modified

mode of /sapdb/PFM/db/pgm/stop was modified

mode of /sapdb/PFM/db/pgm/backup was modified

check dependencies... ok

check rte registration of package... ok

package data is inconsistent

Loader 7.6.00.18 32 bit in /sapdb/programs

-

---

check files... failed

mode of /sapdb/programs/config/loader.cfg was modified

mode of /sapdb/programs/pgm/lserver was modified

mode of /sapdb/programs/env/ISO_8859_4.TXT was modified

mode of /sapdb/programs/env/ISO_8859_6.TXT was modified

mode of /sapdb/programs/env/ISO_8859_5.TXT was modified

mode of /sapdb/programs/lib/python2.3/sdb/loader/transport.py was modified

mode of /sapdb/programs/env/ISO_8859_3.TXT was modified

mode of /sapdb/programs/env/ISO_8859_2.TXT was modified

mode of /sapdb/programs/env/ISO_8859_7.TXT was modified

mode of /sapdb/programs/env/ISO_8859_1.TXT was modified

check dependencies... ok

package data is inconsistent

SQLDBC 7.6.00.18 32 bit in /sapdb/programs

-

---

check files... failed

mode of /sapdb/programs/sdk/sqldbc/incl/SQLDBC_C.h was modified

mode of /sapdb/programs/sdk/sqldbc/incl/SQLDBC.h was modified

mode of /sapdb/programs/lib/libSQLDBC.so was modified

mode of /sapdb/programs/lib/libSQLDBC_C.so was modified

mode of /sapdb/programs/sdk/sqldbc/incl/SQLDBC_Types.h was modified

check dependencies... ok

package data is inconsistent

SQLDBC 7600 7.6.00.18 32 bit in /sapdb/programs

-

---

check files... failed

mode of /sapdb/programs/lib/libSQLDBC76.so was modified

check dependencies... ok

package data is inconsistent

PCR 7403 7.4.03.40 32 bit in /sapdb/programs

-

---

check files... failed

mode of /sapdb/programs/runtime/7403/lib/libpcr.so was modified

mode of /sapdb/programs/runtime/7403/bin/irconf was modified

mode of /sapdb/programs/runtime/7403/bin/irtrace was modified

check dependencies... ok

check rte registration of package... ok

package data is inconsistent

VERIFICATION SUMMARY:

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

INVALID PACKAGES: 0

VALID PACKAGES: 15

INCONSISTENT PACKAGES: 15

TOTAL FILES: 320

MISSED FILES: 0

MODIFIED FILES: 0

FILES WITH MODIFIED PERMISSIONS: 284

so isnt the modification being caused by the upgrade?and how do i make them consistent?How do i check the permissions for the database programs i.e rights they are supposed to have e.g rw,r etc...

help appreciated

[Former Member]

hi left this info:

pfmadm id 201 group 200

sdb id 1000 group 1000

[nelis]

Hello Tsungy,

Certain files need to have the sticky bit set. Please try run the script saproot.sh located in your kernel directory(/usr/sap/PFM/SYS/exe/run) and see if it helps. You must run this script as root and specify your SID eg ./saproot.sh PFM

Regards,

Nelis

[Former Member]

hi

I have managed to fix the problem .it was being caused by permissions of the sapdb directory structure.But i have now another pain when i run db13 iam getting this error now.

Name and Server : PFM - pfm1

DBMRFC Function : DBM_GETF

Command : DBMMDF

Error : DBM Error

Return Code : -11

Error message : tp error: connect failed#

i thought it was my tp so i downaloaded and applied the latest one still no joy.so i think it could be dbmrfc in my exe...

any ideas