maxdb error

[Former Member]

Hi,

I am unable to start the MAXDB., AND GETTING THE ERROR

./dbmcli -u control,control12 -d CME db_online

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

-24875, ERR_NEEDADMI: The operating system user is not a member of the database administrator group

-24994,ERR_RTE: Runtime environment error

20130, UNIX user 'CONTROL' unknown

What OS user is it complaining about and which DBA group should it belong to.

Thanks,

[markus_doehr2 · Accepted solution]

> I am unable to start the MAXDB., AND GETTING THE ERROR

>

> ./dbmcli -u control,control12 -d CME db_online

> Error! Connection failed to node (local) for database (no dbname):

> -24875, ERR_NEEDADMI: The operating system user is not a member of the database administrator group

> -24994,ERR_RTE: Runtime environment error

> 20130, UNIX user 'CONTROL' unknown

Are you executing this command as root?

Markus

[Former Member · Accepted solution]

I am executing the command as sdb user, I got the above error.

Then I executed the command as sqdcme, cmecs, cmecsc. I got the same error.

1- What could be the reason for the above error?

The users have been assigned to the following groups

cmecsc -> sapsys

cmecs -> sapsys

sqlcme -> sapsys

sqdcme -> sapsys

sdb -> sdba

2- Please let me know, if the above assignments of users and groups is right?

[lbreddemann · Accepted solution]

Hi there,

please check whether the filesystem where you put the /sapdb/ folder to supports the setuid call.

This is e.g. often not the case when you did something super-clever like installing the software to a NFS drive or something like that.

Since the dbmsrv implicitly changes the security context to sdb:sdba and checks on this as well, all calls via the dbmserver will fail, when the setuid call does not work as expected.

Therefore: check the /etc/fstab line for the filesystem and make sure that there is no entry like nosetuid.

regards,

Lars

p.s.

and you may want to do yourself a favor and provide the dbmcli command line arguments in a sensible order:

dbmcli -n <dbhostname> -d <DBSID> -u control,<pw> ...

-n => hostname
-d => database instance on that host
-u => dbm manager for that database instance

Edited by: Lars Breddemann on Nov 3, 2009 6:16 PM

[Former Member · Accepted solution]

Thanks for the update. I confirm that the software was not installed on NFS drive and was installed locally.

Also, there is no entry nosetuid set in /etc/fstab.

When I type dbmcli -n <dbhostname> -d <DBSID> -u control,<pw> db_online,

I am getting the following error seen below.

Bad path '/sapdb/CME/db/pgm/dbmsrv

Wanted (UserId 3235, GroupId 5003, Mode 106555 '-r-sr-sr-x')

Got (UserId 3235, GroupId 5003, Mode 100775 '-rwxrwxr-x')

RTE_CallSdbStarter(): Wrong ownership for own program absolute path

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

Reading header from pipe: (0:NO ERROR(0)

Please help.

[former_member229109 · Accepted solution]

Hello ,

Please use the 'sdbverify' MAXDB tool to check the database software installation.

Run the tool as root user!

According your information, /sapdb/CME/db/pgm/dbmsrv database file has wrong ownership/permissions.

The ownership/permissions of the MAXDB software are set correctly during the installation/upgrade by the MAXDB installation/upgrade tools. And you should not change the ownership/permissions of the MAXDB software manually to avoid this problem.

Are you SAP customer?

Thank you and best regards, Natalia Khlopina

[Former Member · Accepted solution]

Yes, I am a SAP Customer.

Actually after maxdb software install with content server, the Solaris admins changed the ZFS filesystem layout in distributing the pools in the zone. So probably due to the this unix admin change, the file system permission might have been lost or might have got changed.

I will be doing a reinstall once again.

Please let me know the syntax for running 'sdbverify' MAXDB tool to check the database software installation, as root user.

[former_member229109 · Accepted solution]

Hello ,

Logon as root user to the server. Go to the <IndepProgPath>/bin & use the tool.

For example:

cd /sapdb/programs/bin

<enter>

./sdbverify

<enter>

Or

./sdbverify >check_installation.txt

<enter>

more check_installation.txt

<close>

rm check_installation.txt

<enter>

Regards, Natalia Khlopina

[Former Member · Accepted solution]

Thanks once again Natalia for your kind update.

I ran the tool sdbverify and got all the tests as Ok, except 3 checks got failed, as seen below

Base 7.6.03.09 64 bit in /sapdb/programs

-

---

check files.... failed

/sapdb/programs/bin/starter/sdbstarter was modified

check dependencies... ok

check rte registration of package... ok

package data is inconsistent -> REPEATED 3 TIMES

VERIFICATION SUMMARY

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

INVALID PACKAGES 0

VALID PACKAGES 17

INCONSISTENT PACKAGES 3

TOTAL FILES: 355

MISSED FILES: 0

MODIFIED FILES: 3

FILES WITH MODIFIED PERMISSIONS: 0

Question 1: After unix admins fixed the error, I am now able to start the MaxDB system. Can my the maxdb system function normally with above error?

Question 2: What does package inconsistency mean? How can I fix it?

Thanks,

Haleem

[former_member229109 · Accepted solution]

Hello Haleem,

You are SAP customer. I recommend you to create the SAP ticket to the BC-DB-SDB component,

So we could login to the database server and the status of the database installation.

Run './sdbverify >check_installation.txt' as root <!!> user and attach check_installation.txt to

the ticket.

Please update the thread with additional information to answer on your questions:

1. What unix admins did to fix the error?

2. What are the outputs of the following commands:

sdbregview -l

dbmcli db_enum

dbmcli -d -u control,control12 CME db_state

x_serer stop

x_server start

dbmcli -d CME -n <DB-servername> -u control,control12 CME db_state

ps -efe | grep sdb

Thank you and best regards

[Former Member · Accepted solution]

Thanks Natalia

As per your recommendation, I have created the SAP ticket to the BC-DB-SDB component and attached the check_installation.txt to the ticket.

Please update the thread with additional information to answer on your questions:

1. What unix admins did to fix the error?

Ans- The unix admin executed tar -xvfp, due to which file permission were also copied. That fixed the startup error

2. What are the outputs of the following commands:

./ sdbregview -l

Ans- All the packages are valid. No invalid package is shown here.

dbmcli db_enum

Ans- CME /sapdb/CME/db fast -> running, quick -> offline, slow -> offline, test -> offline

dbmcli -d -u control,control12 CME db_state

Ans- Enter database name: CME

-24977, ERR_COMMAND: Unknown DBM command "CME"

x_serer stop

x_server start

Ans - 12798 NISERVER NI support started

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

12902 XSERVER started, 'X64/SUN 7.6.03 Build 009-123-163-622'

dbmcli -d CME -n <DB-servername> -u control,control12 CME db_state

Ans - Enter database name: CME

-24977, ERR_COMMAND: Unknown DBM command "CME"

ps -efe | grep sdb

Ans- sdb process no -csh

sdb process no /sapdb/programs/pgm/niserver

sdb process no /sapdb/CME/db/pgm/kernel CME

sdb process no /sapdb/CME/db/pgm/kernel CME

sdb process no /sapdb/programs/pgm/vserver start

sdb process no /sapdb/programs/pgm/vserver start

Please let me know, what is niserver and vserver. Thanks in advance

[former_member229109 · Accepted solution]

Hello Haleem,

1. Please post the output of the commands:

dbmcli -d CME -u control,control12 db_state

dbmcli -d CME -n <DB-servername> -u control,control12 db_state

2. "Please let me know, what is niserver and vserver."

Please see the definition and more information in "SAP MaxDB Library 7.6"

< Glossary -> X Server >

Please see the SAP note < #3. question & answer >

3. What errors did you get to start MAXDB?

Thank you and best regards