Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Bad /sapdb/PRD/db/pgm/dbmsrv

hello!

i have a SAP 4.6C with 4.6D_EXT kernel and maxdb 7.5.0.26 64bit on a RHEL5 x86_64

i have installed sucessefully sap and maxdb, db is running and so does SAP.

but when i try using dbmcli with any user(except root) i get the folowing errors:

with SDB user:

[sdb@node1 bin]$ ./dbmcli -d PRD -u control,control

Bad /sapdb/PRD/db/pgm/dbmsrv Wanted (205,201,106555) got (205,201,100776)

Wrong ownership for own program absolute path

Error! Connection failed to node (local) for database PRD: Error writing to pipe:(32:Broken pipe)

with SQDPRD and PRDADM user:

node1:sqdprd 2> ./dbmcli -d PRD -u control,control

Bad /sapdb/programs/bin Wanted (205,201,42555) got (205,201,40777)

Wrong ownership for parent directory absolute path

Argument list

Got 6 arguments and argv is 0 terminated

argv[0]:'/sapdb/programs/bin/starter/sdbstarter'

argv[1]:'/sapdb/programs/bin/getdbroot'

argv[2]:'204'

argv[3]:'200'

argv[4]:'A'

argv[5]:'PRD'

Syntax: sdbstarter program [{<arguments>}]

Usage: Start given program for parent directory with

argument list -starter followed by given arguments

The started program will be started as SdbOwner and

with supementary groups reinitialized for SdbOwner

Error! Connection failed to node (local) for database PRD: database not found

wasnt i supposed to be able to enter dbmcli with SDB user ?

with root, the sdbverify return 1 inconsistency:

Database Kernel 7.5.00.26 64 bit in /sapdb/PRD/db

-


check files... failed

mode of /sapdb/PRD/db/misc/sapdb/dbm.py was modified

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

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

mode of /sapdb/PRD/db/lib/python1.5/site.py was modified

mode of /sapdb/PRD/db/lib/python1.5/ntpath.py was modified

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

mode of /sapdb/PRD/db/lib/python1.5/posixpath.py was modified

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

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

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

mode of /sapdb/PRD/db/bin/sdbfill was modified

mode of /sapdb/PRD/db/demo/HOTELDB_COMPLETE.py was modified

mode of /sapdb/PRD/db/doc/FirstSteps/Precompiler/Makefile was modified

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

mode of /sapdb/PRD/db/misc/sapdb/python-py15/loadermodule.so was modified

mode of /sapdb/PRD/db/misc/updcol was modified

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

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

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

mode of /sapdb/PRD/db/misc/pchtab was modified

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

mode of /sapdb/PRD/db/lib/python1.5/types.py was modified

mode of /sapdb/PRD/db/env/dbmevtdisp.cfg was modified

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

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

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

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

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

mode of /sapdb/PRD/db/pgm/sqlfilter was modified

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

mode of /sapdb/PRD/db/lib/python1.5/os.py was modified

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

mode of /sapdb/PRD/db/lib/python1.5/glob.py was modified

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

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

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

mode of /sapdb/PRD/db/pgm/quickknl was modified

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

mode of /sapdb/PRD/db/sap/updcol was modified

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

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

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

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

mode of /sapdb/PRD/db/lib/python1.5/traceback.py was modified

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

mode of /sapdb/PRD/db/misc/sapdb/python-py15/sqlmodule.so was modified

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

mode of /sapdb/PRD/db/lib/python1.5/linecache.py was modified

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

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

mode of /sapdb/PRD/db/misc/sapdb/dbapi.py was modified

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

mode of /sapdb/PRD/db/doc/FirstSteps/Precompiler/HowToEmbedSQL.html was modified

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

mode of /sapdb/PRD/db/lib/python1.5/stat.py was modified

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

mode of /sapdb/PRD/db/misc/sapdb/loader.py was modified

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

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

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

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

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

mode of /sapdb/PRD/db/misc/sapdb/sql.py was modified

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

mode of /sapdb/PRD/db/misc/dbm.py was modified

mode of /sapdb/PRD/db/misc/loader.py was modified

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

mode of /sapdb/PRD/db/misc/bgrep was modified

mode of /sapdb/PRD/db/lib/python1.5/cmd.py was modified

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

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

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

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

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

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

mode of /sapdb/PRD/db/lib/python1.5/UserDict.py was modified

mode of /sapdb/PRD/db/misc/sapdb/__init__.py was modified

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

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

mode of /sapdb/PRD/db/pgm/pu was modified

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

mode of /sapdb/PRD/db/lib/python1.5/UserList.py was modified

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

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

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

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

mode of /sapdb/PRD/db/env/AS.py was modified

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

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

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

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

mode of /sapdb/PRD/db/lib/python1.5/lib-dynload/dummy.py was modified

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

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

mode of /sapdb/PRD/db/misc/sapdb/python-py15/__init__.py was modified

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

mode of /sapdb/PRD/db/env/QP.py was modified

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

mode of /sapdb/PRD/db/lib/python1.5/exceptions.py was modified

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

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

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

mode of /sapdb/PRD/db/bin/dbmevthndl_extendDB was modified

mode of /sapdb/PRD/db/lib/python1.5/optlib.py was modified

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

mode of /sapdb/PRD/db/lib/python1.5/fnmatch.py was modified

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

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

mode of /sapdb/PRD/db/env/WEBDAV.py was modified

mode of /sapdb/PRD/db/lib/python1.5/string.py was modified

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

mode of /sapdb/PRD/db/misc/patchb was modified

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

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

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

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

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

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

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

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

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

mode of /sapdb/PRD/db/bin/ireport.py was modified

mode of /sapdb/PRD/db/pgm/dbmext was modified

mode of /sapdb/PRD/db/misc/repman.py was modified

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

mode of /sapdb/PRD/db/lib/python1.5/tempfile.py was modified

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

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

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

mode of /sapdb/PRD/db/env/XMLIMAPI.py was modified

mode of /sapdb/PRD/db/doc/FirstSteps/Precompiler/HelloMaxDB.cpc was modified

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

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

mode of /sapdb/PRD/db/misc/sapdb/python-py15/dbmmodule.so was modified

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

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

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

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

mode of /sapdb/PRD/db/misc/puclst was modified

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

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

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

mode of /sapdb/PRD/db/lib/python1.5/re.py was modified

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

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

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

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

mode of /sapdb/PRD/db/env/repmanEx.py was modified

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

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

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

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

mode of /sapdb/PRD/db/misc/sapdbapi.py was modified

check dependencies... ok

check rte registration of package... ok

package data is inconsistent

with sdb , sqdprd or prdadm it returns 3 insconsistencys

i cant even log onto the database with database manager...

Former Member
replied

Hi Joaquim,

the problem here is that the filepermissions are not setup correcty.

Please run sdbverify as root user and check if still all the inconsistencies are reported.

Since you get warnings about the filepermissions it's always a got guess to check if the filesystem where you've installed the whole thing to is capable of holding s-bits (e.g. NFS-mount usually won't support this).

Moreover, the sqd<sid>-user is not used for MaxDB 7.5 and greater. It's just the sdb-user and the sdba-group.

Also you should consider to use at least the most current version of MaxDB 7.5 or move to 7.6 all together (this is something you should do as soon as you've fixed this issue).

After you veryfied that the filesystem is OK (see above) you can try to reinstall the software by using SDBINST. It will simply re-extract the files with the correct permissions.

If this still does not lead to a working installation it may be time to create a support message. I assume a deeper analysis will than have to be done.

Best regards,

Lars

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question