problem creating new instance on existing DB

[Former Member]

Hi all,

I do have a system Suse Linux 10 with an existing MaxDB 7.6.035 and a database called SDB. Now I want to create a new DB called SD1 besides this one using DMBGUI.

So I logged on to SDB using DBMGUI and tried Instance create with database configuration "custom" using the remote server and the new DB name SD1 to do a recovery with initialization.

So far so good, now I am asked for credentials of the os user, here is the problem: Which user do I have to take? I always get a "-24875 The operating system user is not a member of the database administrators group (user_system...); -24994,ERR_RTE: Runtime environment error"

It does not matter which user I try (I think sdbadm should be right)... even root does not work

The /etc/groups shows:

sdba:x:1001:sdbadm

The /etc/passwd shows:

sdbadm:x:1000:1000:SAP System Administrator:/home/sdbadm:/bin/csh

sqdsdb:x:1001:1000:SAP Database Administration User:/sapdb/SDB:/bin/csh

sdb:x:1002:1001:SAP Database Administration User:/home/sdb:/bin/csh

Why do I try this? I want to rename the database in a copy of virtual container. (nearly homogenous systemcopy)

Does anybody have any idea?

Thank you,

best regards

Christian

[Former Member]

Hello Natalia,

thank you for the information, note 951712 was the note I found ancient times ago and I rembered when I found note 960583.

I wish you a nice weekend,

Chrisitan

[Former Member]

This does not work either anymore:

---

ztbadm@frenchie:/sapdb/programs/bin$ ./dbmcli -U c_J2EE db_start

Must be called by root or effective user 1002 effective group 1003

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

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

-

---

Now what in the world is this about, where does it get those user id's from ? is that from .XUSER62 ? if so i did try to do:

xuser -U c_j2EE -u SDB,***** -d ZTB set

so that the c_j2EE key would point to the right user (SDB) with id 1002:1003

But still no dice.

Any help appreciated, this is just such a major pain.

[Former Member]

Hello Natalia,

I was working hard at this toppic ... and found a solution:

I was trying to reload the system tables with

 dbmcli -d <database_name> -u <dbm_user>,<password> load_systab -u <sysdba_user> 

this did not help.

I tried to set a new password with

 user_sysdba <sysdba_user>,<sysdba_user_password> 

this did not help.

Finally I found note 960583 - Installation fails: PAM module not available ...

ok, this could be a possibility ...

Entering PAM=NOT_USED in /etc/opt/sdb did not work.

But I am using Blowfisch... so I chaged the default encryption for passwords to MD5 and reset the password.

Now it works!

Best regards

Christian

[former_member229109]

Hello Christian,

Good to know, that you found the solution to your problem.

1) According your information on the problem, you had the symptom of

the know issue discribed in the SAP Note No. 951712 .

Please check the note for the solution.

2) You got the error in the dbmsrv protocol:

"0x00006778 ERR -24994 DBMSrv ERR_RTE: Runtime environment error

0x00006778 ERR -24778 DBMSrv 20145,UNIX password mismatch

"

=> The dbmsrv was not able to read the UNIX password of the sdbadm user < OS user >.

… The loading system tables will not help in this case.

Please review the SAP note 25591, it has the Brief description of the database user types.

One of the database users is the SYSDBA user, SUPERDBA by default < It's NOT the OS User >.

You could use the dbm command 'user_sysdba' to "make the database system administrator

< SYSDBA user, SUPERDBA by default > known to the Database Manager. It is only

necessary to use this DBM command if the database administrator is not known or is incorrectly

known to the Database Manager."

< See the DataBase documentation. SAP note: 767598 Available documentation >

Thank you and best regards, Natalia Khlopina

[Former Member]

Hello Natalia,

thank you for you fast reply.

Here the requested information:

I am using the newest version of DMBGui (7.6.03.10) but I can't connect this way by using Database Studio 7.7.03.18, too.

:~ # more /etc/opt/sdb [Globals] IndepData=/sapdb/data IndepPrograms=/sapdb/programs SdbOwner=sdb SdbGroup=sdba :~ # id sdbadm uid=1000(sdbadm) gid=1000(sapsys) groups=1000(sapsys),16(dialout),33(video),1001(sdba) :~ # /sapdb/programs/bin/dbmcli user_system sdbadm,<theosuserpassword> Password mismatch ERR -24875,ERR_NEEDADMI: The operating system user is not a member of the database administrators group -24994,ERR_RTE: Runtime environment error 20145,UNIX password mismatch :~ # /sapdb/programs/bin/sdbregview -l DB Analyzer /sapdb/programs 7.6.00.35 32 bit valid Server Utilities /sapdb/programs 7.6.00.35 32 bit valid PCR 7300 /sapdb/programs 7.3.00.55 valid PCR 7301 /sapdb/programs 7.3.01.18 valid PCR 7500 /sapdb/programs 7.5.00.37 32 bit valid SAP Utilities /sapdb/programs 7.6.00.35 32 bit valid Base /sapdb/programs 7.6.00.35 32 bit valid Redist Python /sapdb/programs 7.6.00.35 32 bit valid JDBC /sapdb/programs 7.6.00.30 valid Messages /sapdb/programs MSG 0.3951 valid ODBC /sapdb/programs 7.6.00.35 32 bit valid Database Kernel /sapdb/SDB/db 7.6.00.35 32 bit valid Loader /sapdb/programs 7.6.00.35 32 bit valid SQLDBC /sapdb/programs 7.6.00.35 32 bit valid Fastload API /sapdb/programs 7.6.00.35 32 bit valid SQLDBC 76 /sapdb/programs 7.6.00.35 32 bit valid PCR 7403 /sapdb/programs 7.4.03.44 32 bit valid :~ # /sapdb/programs/bin/dbmcli inst_enum OK 7.6.00.35 /sapdb/SDB/db 7.3.00.28 /sapdb/SDB/db :~ # /sapdb/programs/bin/dbmcli db_enum OK SDB /sapdb/SDB/db 7.6.00.35 fast offline SDB /sapdb/SDB/db 7.6.00.35 quick offline SDB /sapdb/SDB/db 7.6.00.35 slow offline SDB /sapdb/SDB/db 7.6.00.35 test offline SDB /sapdb/SDB/db 7.3.00.28 fast offline SDB /sapdb/SDB/db 7.3.00.28 quick offline SDB /sapdb/SDB/db 7.3.00.28 slow offline :~ # ls -l /sapdb/SDB/db/pgm/dbmverifypw -r-sr-x--- 1 root sdba 821960 Nov 7 2006 /sapdb/SDB/db/pgm/dbmverifypw :~ # cd /sapdb/programs/bin :/sapdb/programs/bin # ./sdbverify ... VERIFICATION SUMMARY: ********************* INVALID PACKAGES: 0 VALID PACKAGES: 17 INCONSISTENT PACKAGES: 0 TOTAL FILES: 333 MISSED FILES: 0 MODIFIED FILES: 0 FILES WITH MODIFIED PERMISSIONS: 0 :/sapdb/data/wrk # more dbmsrv_my.prt 2008-02-14 08:09:04 0x00006778 INF 216 DBMSrv DBM Server client connection (established at 2008-02-14 08:09:03): PID 26487 on computer my.host.com 2008-02-14 08:09:04 0x00006778 INF 283 DBMSrv command user_system ... 2008-02-14 08:09:04 0x00006778 ERR -24875 DBMSrv ERR_NEEDADMI: The operating system user is not a member of the database administrators group 0x00006778 ERR -24994 DBMSrv ERR_RTE: Runtime environment error 0x00006778 ERR -24778 DBMSrv 20145,UNIX password mismatch 2008-02-14 08:09:04 0x00006778 INF 226 DBMSrv DBM Server client disconnect: PID 26487 on computer my.host.com

It seems, that the password stored in the DB and the password on OS level does not fit? Do I have to reload the system tables?

Thank you,

Christian

p.s. Yes, I am SAP Customer

[former_member229109]

Hello Christian,

-> Are you SAP customer?

-> Please update the thread with additional information::

What is the version of the DBMGUI?

Post the output of the following commands:

more /etc/opt/sdb

id sdbadm

/sapdb/programs/bin/dbmcli user_system sdbadm,<pwd-sdbadm>

/sapdb/programs/bin/sdbregview -l

/sapdb/programs/bin/dbmcli inst_enum

/sapdb/programs/bin/dbmcli db_enum

ls -l /sapdb/SDB/db/pgm/dbmverifypw

Did you change the ownership, permissions of the database software manually?

Please run as root user:

cd /sapdb/programs/bin

./sdbverify

and review the results.

Did you get not 0 value for 'INVALID PACKAGES' or 'INCONSISTENT PACKAGES' or

'MISSED FILES' or 'MODIFIED FILES' or 'FILES WITH MODIFIED PERMISSIONS'

in the VERIFICATION SUMMARY ?

-> Post server_<servername>.prt file errors , file located in /sapdb/data/wrk.

Thank you and best regards, Natalia Khlopina