DB-Connect Failed, Return Code 000256

[Former Member]

Hello All.

After restoring the DB while i m trying to bring the SAP Instance up, i m getting "DB-Connect Failed, Return Code 000256" in Syslog.

Can anyone tell me how this can be solved.

The DB is MaxDB 7.6.05.15 & SAP ECC 6.0.

Thanks.

Regards,

Mudassir.Imtiaz

P.S I tried to add the Developer Trace with this message but somehow i couldn't.

I guess its exceeding more than 15000 characters.

[Former Member · Accepted solution]

well , if this system is called HIS, I suggest you rename this user

from SAPDEV to SAPHIS

if you read sap note 129352 you will find out how to do it

"sql_execute rename user SAP<SID> to SAP<NEWSID> "

Regards

Ivan

[Former Member · Accepted solution]

Hello Ivan,

Thanks for your support.

And also i thank Sunil who have been really patient in helping me resolving.

The issue is resolved now.

I changed/rename the SAPDEV to SAPHSD by following the below steps:

C:\Documents and Settings\hsdadm>dbmcli -d HSD -u control,admin123 -uSQL superdb

a,admin123

dbmcli on HSD>sql_execute rename user SAPDEV to SAPHSD

OK

Then i updated the XUSER with the following commands:

xuser -U DEFAULT -u SAPHSD,password -d HSD -n sap-dr set

xuser -U c -u CONTROL,password -d HSD -n sap-dr set

xuser -U w -u SUPERDBA,password -d HSD -n sap-dr set

After completing these steps i started my DB and HSD (sap instance)

It started.

Thanks.

Regards,

Mudassir.Imtiaz

[Former Member]

Hello,

let me step into this comversation as I have feeling it is not going to right dirrection

you do not deen user SAP<SID> on DBM level

if user_getall does not show SAP<SID> user , there is no problem

SAP<SID> user is DBA user

please test following commands as <sid>adm user

dbmcli -U c -d HSD

dbmcli -U w -d HSD

dbmcli -U w -d HSD -USQL w

dbmcli -U w -d HSD -USQL DEFAULT

please test same commands as SAPService<SID> user if tis is Windows

as well please run

dbmcli -U w -d HSD -USQL w sql_execute select username from users

regards

Ivan

[Former Member]

Hello Ivan.

I have executed the commands with the HSDADM and the result for

dbmcli -U w -d HSD -USQL DEFAULT

C:\Documents and Settings\hsdadm>dbmcli -U w -d HSD -USQL DEFAULT

ERR

-24988,ERR_SQL: SQL error

-4008,Unknown user name/password combination

and when i executed the last command i.e. dbmcli -U w -d HSD -USQL w sql_execute select username from users

the result was:

C:\Documents and Settings\hsdadm>dbmcli -U w -d HSD -USQL w sql_execute select

sername from users

OK

END

'CONTROL'

'SUPERDBA'

'SAPDEV'

I was checking for SAPHSD but to my surprise here it is SAPDEV.

Perhaps i restored a wrong backup file.

Still if i want to get through in this situation what should i do?

Thanks A Lot.

[Former Member]

Check whether xserver service is running?

also perform R3trans -d and post the output from trans.log will be created (current path).

[Former Member]

Hi Sunil,

Thanks for your reply.

I executed R3trans -d and please find the trans.log below.

4 ETW000 R3trans version 6.14 (release 700 - 14.02.08 - 14:55:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 19.10.2010 - 14:13:25

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Tue Oct 19 14:13:27 2010 6978 0.006978

4 ETW000 [dev trc ,00000] db_con_init called 39 0.007017

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 45 0.007062

4 ETW000 [dbcon.c ,00000] *** ERROR => Invalid profile parameter dbms/type (or environment variable dbms_type) = <undef>, cannot load DB library

4 ETW000 234 0.007296

2EETW169 no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED."

I have checked the XSERVER its started.

Thanks.

Mudassir.Imtiaz

[Former Member]

There is missing env variable dbms/type

on command prompt perform following

set dbms/type=ADA

and then again run R3trans -d

This should work, then you have set the same variable in users profile. My computer > properties> advanced --> environment variable.

[Former Member]

Hello Sunil,

I have added the environment variable dbms/type=ADA

But still its giving the same error.

Is there anything else i m missing.

Thanks.

Regards,

Mudassir.Imtiaz

[Former Member]

Can you please paste the content from DEFAULT profile.

Check what you have set for dbms/type=ada

[Former Member]

Hello Sunil,

This is the trans.log after setting the environment variable.

4 ETW000 R3trans version 6.14 (release 700 - 14.02.08 - 14:55:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 19.10.2010 - 14:56:12

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Tue Oct 19 14:56:14 2010 0 0.000000

4 ETW000 [dev trc ,00000] db_con_init called 0 0.000000

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 0 0.000000

4 ETW000 [dev trc ,00000] Loading DB library 'dbsdbslib.dll' ... 0 0.000000

4 ETW000 [dev trc ,00000] load shared library (dbsdbslib.dll), hdl 0 8537 0.008537

4 ETW000 [dev trc ,00000] using "K:\usr\sap\HSD\DVEBMGS07\exe\dbsdbslib.dll"

4 ETW000 16 0.008553

4 ETW000 [dev trc ,00000] Library 'dbsdbslib.dll' loaded 7 0.008560

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dbsdbslib.dll

4 ETW000 21 0.008581

4 ETW000 [dev trc ,00000] Version of 'dbsdbslib.dll' is "700.08", patchlevel (0.144)

4 ETW000 99 0.008680

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dbsdbslib.dll

4 ETW000 12 0.008692

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dbsdbslib.dll

4 ETW000 15 0.008707

4 ETW000 [dev trc ,00000] } DbSlSdbControl(rc=0) 7327 0.016034

4 ETW000 [dev trc ,00000] { DbSlSdbControl(con_hdl=-1,command=39,arg_p=0000000000000000)

4 ETW000 47 0.016081

4 ETW000 [dev trc ,00000] } DbSlSdbControl(rc=0) 13 0.016094

4 ETW000 [dev trc ,00000] { DbSlSdbControl(con_hdl=-1,command=10,arg_p=00000000039EF930)

4 ETW000 20 0.016114

4 ETW000 [dev trc ,00000] } DbSlSdbControl(rc=0) 11 0.016125

4 ETW000 [dev trc ,00000] New connection 0 created 12 0.016137

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 35 0.016172

4 ETW000 [dev trc ,00000] { DbSlSdbControl(con_hdl=-1,command=10,arg_p=000000000189F6C8)

4 ETW000 19 0.016191

4 ETW000 [dev trc ,00000] } DbSlSdbControl(rc=0) 6 0.016197

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 7 0.016204

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 11 0.016215

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 15 0.016230

4 ETW000 [dev trc ,00000] { DbSlSdbConnect(con_info_p=0000000000000000) 14 0.016244

4 ETW000 [dev trc ,00000] DBSDBSLIB : version 700.08, patch 0.144 (Make PL 0.144)

4 ETW000 23 0.016267

4 ETW000 [dev trc ,00000] MAXDB shared library (dbsdbslib) patchlevels (last 10)

4 ETW000 43 0.016310

4 ETW000 [dev trc ,00000] (0.144) MSSQL: ODBC fastload on separate connection (note 1131805)

4 ETW000 11 0.016321

4 ETW000 [dev trc ,00000] (0.144) I5/OS ldappasswd support for 5250 terminal. (note 1129573)

4 ETW000 11 0.016332

4 ETW000 [dev trc ,00000] (0.139) Return DS_SQLERR instead of DS_CONNECTERR (note 1121076)

4 ETW000 11 0.016343

4 ETW000 [dev trc ,00000] (0.131) Do not trace password of SQLOPT into dev trace (note 1097930)

4 ETW000 11 0.016354

4 ETW000 [dev trc ,00000] (0.130) Performance optimization for UPDSTAT PREPARE (note 1096387)

4 ETW000 11 0.016365

4 ETW000 [dev trc ,00000] (0.125) Update statistic prepare on row level (note 1086430)

4 ETW000 11 0.016376

4 ETW000 [dev trc ,00000] (0.104) Update statistic with empty schemas (note 1041547)

4 ETW000 11 0.016387

4 ETW000 [dev trc ,00000] (0.095) MaxDB DBSL patch collection 1 2007 (note 1014270)

4 ETW000 10 0.016397

4 ETW000 [dev trc ,00000] (0.082) MaxDB DBSL patch collection 3 2006 (note 991258)

4 ETW000 11 0.016408

4 ETW000 [dev trc ,00000] (0.079) MaxDB DBSL patch collection 2 2006 (note 984406)

4 ETW000 10 0.016418

4 ETW000 [dev trc ,00000] 6 0.016424

4 ETW000 [dev trc ,00000] -> init() 8 0.016432

4 ETW000 [dev trc ,00000] -> sdb_malloc(size=14) : 000000000022A490 (30 bytes allocated)

4 ETW000 23 0.016455

4 ETW000 [dev trc ,00000] STATEMENT_CACHE_SIZE = 1000 2028 0.018483

4 ETW000 [dev trc ,00000] -> sdb_malloc(size=152000) : 00000000073C0080 (152046 bytes allocated)

4 ETW000 56 0.018539

4 ETW000 [dev trc ,00000] -> sdb_malloc(size=656000) : 00000000073E6080 (808062 bytes allocated)

4 ETW000 29 0.018568

4 ETW000 [dev trc ,00000] -> sdb_malloc(size=288000) : 0000000007487080 (1096078 bytes allocated)

4 ETW000 26 0.018594

4 ETW000 [dev trc ,00000] -> sdb_malloc(size=16144) : 0000000000317CE0 (1112238 bytes allocated)

4 ETW000 23 0.018617

4 ETW000 [dev trc ,00000] -> sdb_malloc(size=32048) : 00000000074CE080 (1144302 bytes allocated)

4 ETW000 15 0.018632

4 ETW000 [dev trc ,00000] -> loadClientRuntime() 382 0.019014

4 ETW000 [dev trc ,00000] Loading SQLDBC client runtime ... 9 0.019023

4 ETW000 [dev trc ,00000] SQLDBC SDK Version : SQLDBC.H 7.6.0 BUILD 007-123-091-175

4 ETW000 338 0.019361

4 ETW000 [dev trc ,00000] SQLDBC Library Version : libSQLDBC 7.6.5 BUILD 015-123-202-938

4 ETW000 13 0.019374

4 ETW000 [dev trc ,00000] SQLDBC client runtime is MaxDB 7.6.5.015 CL 202938

4 ETW000 21 0.019395

4 ETW000 [dev trc ,00000] SQLDBC supports new DECIMAL interface : 0 14 0.019409

4 ETW000 [dev trc ,00000] SQLDBC supports VARIABLE INPUT data : 1 7 0.019416

4 ETW000 [dev trc ,00000] SQLDBC supports keepAlive indicator : 0 8 0.019424

4 ETW000 [dev trc ,00000] -> getNewConnection() 6 0.019430

4 ETW000 [dev trc ,00000] -> sdb_malloc(size=1672) : 00000000002EFD00 (1145990 bytes allocated)

4 ETW000 14 0.019444

4 ETW000 [dev trc ,00000] -> sdb_malloc(size=608) : 0000000000313910 (1146614 bytes allocated)

4 ETW000 33 0.019477

4 ETW000 [dev trc ,00000] <- getNewConnection(con_hdl=0) 23 0.019500

4 ETW000 [dev trc ,00000] -> checkEnvironment(con_hdl=0) 12 0.019512

4 ETW000 [dev trc ,00000] -> connect() 11 0.019523

4 ETW000 [dev trc ,00000] INFO : SQLOPT= -I 0 -t 0 -S SAPR3 32 0.019555

4 ETW000 [dev trc ,00000] Try to connect (DEFAULT) on connection 0 ... 35 0.019590

4 ETW000 [dbsdbsql ,00000] *** ERROR => Connect to database failed, rc = -4008 (POS(1) Unknown user name/password combination)

4 ETW000 293358 0.312948

4 ETW000 [dev trc ,00000] -> SetSapdbCA(errcode=-4008) 17 0.312965

4 ETW000 [dev trc ,00000] -> freeConnection(con_hdl=0) 17 0.312982

4 ETW000 [dev trc ,00000] -> sdb_free(p=0000000000313910, size=608 (1145990 bytes allocated))

4 ETW000 38 0.313020

4 ETW000 [dev trc ,00000] -> sdb_free(p=00000000002EFD00, size=1672 (1144302 bytes allocated))

4 ETW000 22 0.313042

4 ETW000 [dev trc ,00000] } DbSlSdbConnect(rc=99) 7 0.313049

4 ETW000 [dblink ,00431] ***LOG BY2=>sql error -4008 performing CON [dblink#5 @ 431]

4 ETW000 16306 0.329355

4 ETW000 [dblink ,00431] ***LOG BY0=>POS(1) Unknown user name/password combination [dblink#5 @ 431]

4 ETW000 26 0.329381

4 ETW000 [dev trc ,00000] { DbSlSdbControl(con_hdl=0,command=41,arg_p=000000000091E0E8)

4 ETW000 489 0.329870

4 ETW000 [dev trc ,00000] } DbSlSdbControl(rc=0) 20 0.329890

4 ETW000 [dev trc ,00000] { DbSlSdbControl(con_hdl=0,command=14,arg_p=00000000039EFB10)

4 ETW000 23 0.329913

4 ETW000 [dev trc ,00000] } DbSlSdbControl(rc=0) 11 0.329924

4 ETW000 [dev trc ,00000] { DbSlSdbControl(con_hdl=0,command=50,arg_p=00000000039EFBD0)

4 ETW000 20 0.329944

4 ETW000 [dev trc ,00000] } DbSlSdbControl(rc=0) 24 0.329968

4 ETW000 [dev trc ,00000] { DbSlSdbControl(con_hdl=0,command=13,arg_p=00000000039EFB20)

4 ETW000 22 0.329990

4 ETW000 [dev trc ,00000] } DbSlSdbControl(rc=0) 9 0.329999

4 ETW000 [dev trc ,00000] { DbSlSdbControl(con_hdl=0,command=52,arg_p=00000000039EFB70)

4 ETW000 15 0.330014

4 ETW000 [dev trc ,00000] } DbSlSdbControl(rc=0) 6 0.330020

2EETW169 no connect possible: "DBMS = ADABAS D --- DBNAME = ''"

4 ETW000 [dev trc ,00000] -> sdb_free(p=000000000022A490, size=14 (1144272 bytes allocated))

4 ETW000 1193 0.331213

[Former Member]

Please find the contents of the DEFAULT.PFL

SAPDBHOST = SAP-DR

j2ee/dbtype = sap

j2ee/dbname = HSD

j2ee/dbhost = SAP-DR

j2ee/dbadminurl = http://SAP-DR:9999/webdbm?Server=SAP-DR&Database=HSD&User=control

SAPSYSTEMNAME = HSD

SAPGLOBALHOST = SAP-DR

rdisp/bufrefmode = sendoff,exeauto

#----

---

1. SAP Message Server for ABAP

#----

---

rdisp/mshost = SAP-DR

rdisp/msserv = sapmsHSD

rdisp/msserv_internal = 3907

#----

---

1. SAP Message Server for ABAP

#----

---

#----

---

1. SAP Message Server for ABAP

#----

---

#----

---

1. SAP Message Server for ABAP

#----

---

login/system_client = 001

[Former Member]

Looks good, your inital issue seems to be resolved,

but now you have *** ERROR => Connect to database failed, rc = -4008 (POS(1) Unknown user name/password combination)

check userID and password.

[Former Member]

I can actually connect the database from DBM Gui.

And its working online.

I wonder why this error of userid and password is haunting.

Which user id you want me to check, the user CONTROL or SUPERDBA?

Can i reset/change the password.

Thanks.

[Former Member]

I think you need to follow

[Former Member]

Hello Sunil,

SAP was already running successfully on the server on which i performed this installation.

The requirement was to install two Different SAP instances on one server.

I made a new installation yesterday (on a server on which SAP is running) and then i restored the backup of the old system on this new installed DB.

And when i m trying to start this instance, m facing these problems.

If i change the xuser settings will it make any more problem or will it disturb the other SAP instance which is already running.

Thanks.

[Former Member]

Hm! you should have mentioned this before.

Anyway, can you please perform command 'xuser list' and paste the output.

[Former Member]

My apoligise sir.

Please find the output of the xuser list

C:\Documents and Settings\hsdadm>xuser list

-

---

XUSER Entry 1

-

---

Key :DEFAULT

Username :SAPHSD

UsernameUCS2:S.A.P.H.S.D. . . . . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :HSD

Nodename :SAP-DR

Sqlmode :SAPR3

Cachelimit :-1

Timeout

Isolation

Charset :<unspecified>

-

---

XUSER Entry 2

-

---

Key :c

Username :CONTROL

UsernameUCS2:C.O.N.T.R.O.L. . . . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :HSD

Nodename :SAP-DR

Sqlmode :SAPR3

Cachelimit :-1

Timeout

Isolation

Charset :<unspecified>

-

---

XUSER Entry 3

-

---

Key :c_J2EE

Username :CONTROL

UsernameUCS2:C.O.N.T.R.O.L. . . . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :HSD

Nodename :SAP-DR

Sqlmode :SAPR3

Cachelimit :-1

Timeout

Isolation

Charset :<unspecified>

-

---

XUSER Entry 4

-

---

Key :w

Username :SUPERDBA

UsernameUCS2:S.U.P.E.R.D.B.A. . . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :HSD

Nodename :SAP-DR

Sqlmode :SAPR3

Cachelimit :-1

Timeout

Isolation

Charset :<unspecified>

Thanks.

Mudassir.Imtiaz

[Former Member]

You should be able to add new entry for your new DB instance to XUSER.

As xuser has Dbname parameter hence your existing entries will not be affected.

[Former Member]

I would be really thankful to you if you can help me with the procedure to do this.

Could you please tell me:

How to locate XUSER?

What entries to be made?

Under which user i should add those entries?

Thanks.

Mudassir.Imtiaz

[Former Member]

I have done two system config for XUSER, hence not sure but I think you need to create entries for CONTROL, SUPERDBA & SAPHSD (new). Change HSD with new <SID>

Syntax: http://help.sap.com/saphelp_nw70ehp1/helpdata/en/cd/883e4045796913e10000000a1550b0/frameset.htm

Key :c

Username :CONTROL

UsernameUCS2:C.O.N.T.R.O.L. . . . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :HSD

Nodename :SAP-DR

Sqlmode :SAPR3

Cachelimit :-1

Timeout

Isolation

Charset :<unspecified>

Key :DEFAULT

Username :SAPHSD

UsernameUCS2:S.A.P.H.S.D. . . . . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :HSD

Nodename :SAP-DR

Sqlmode :SAPR3

Cachelimit :-1

Timeout

Isolation

Charset :<unspecified>

Key :w

Username :SUPERDBA

UsernameUCS2:S.U.P.E.R.D.B.A. . . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :HSD

Nodename :SAP-DR

Sqlmode :SAPR3

Cachelimit :-1

Timeout

Isolation

Charset :<unspecified>

[Former Member]

Hii Sunil,

I have created entries in the xuser with the SIDADM user.

xuser -U DEFAULT -u SAPHSD,password -d HSD -n sap-dr set

xuser -U c -u CONTROL,password -d HSD -n sap-dr set

xuser -U w -u SUPERDBA,password -d HSD -n sap-dr set

Please find the xuser list output:

-

---

XUSER Entry 1

-

---

Key :DEFAULT

Username :SAPHSD

UsernameUCS2:S.A.P.H.S.D. . . . . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :HSD

Nodename :sap-dr

Sqlmode :<unspecified>

Cachelimit :-1

Timeout :-1

Isolation :-1

Charset :<unspecified>

-

---

XUSER Entry 2

-

---

Key :c

Username :CONTROL

UsernameUCS2:C.O.N.T.R.O.L. . . . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :HSD

Nodename :sap-dr

Sqlmode :<unspecified>

Cachelimit :-1

Timeout :-1

Isolation :-1

Charset :<unspecified>

-

---

XUSER Entry 3

-

---

Key :c_J2EE

Username :CONTROL

UsernameUCS2:C.O.N.T.R.O.L. . . . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :HSD

Nodename :SAP-DR

Sqlmode :SAPR3

Cachelimit :-1

Timeout

Isolation

Charset :<unspecified>

-

---

XUSER Entry 4

-

---

Key :w

Username :SUPERDBA

UsernameUCS2:S.U.P.E.R.D.B.A. . . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :HSD

Nodename :sap-dr

Sqlmode :<unspecified>

Cachelimit :-1

Timeout :-1

Isolation :-1

Charset :<unspecified>

HSD is my new SID

After doing this when i tried to start the instance it is still showing dispatcher stopped.

Then again i tried to execute R3trans -d (see the trans.log below)

4 ETW000 R3trans version 6.14 (release 700 - 14.02.08 - 14:55:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 19.10.2010 - 18:00:12

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Tue Oct 19 18:00:14 2010 0 0.000000

4 ETW000 [dev trc ,00000] db_con_init called 0 0.000000

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 0 0.000000

4 ETW000 [dbcon.c ,00000] *** ERROR => Invalid profile parameter dbms/type (or environment variable dbms_type) = <undef>, cannot load DB library

4 ETW000 0 0.000000

2EETW169 no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED."

The error which i faced earlier i think not yet resolved.

[Former Member]

Please find the Developer Trace below :

-

---

trc file: "dev_w0", trc level: 1, release: "700"

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, MJ

*

B

B Tue Oct 19 18:15:29 2010

B create_con (con_name=R/3)

B Loading DB library 'K:\usr\sap\HSD\DVEBMGS07\exe\dbsdbslib.dll' ...

B Library 'K:\usr\sap\HSD\DVEBMGS07\exe\dbsdbslib.dll' loaded

B Version of 'K:\usr\sap\HSD\DVEBMGS07\exe\dbsdbslib.dll' is "700.08", patchlevel (0.144)

B New connection 0 created

M sysno 07

M sid HSD

M systemid 562 (PC with Windows NT)

M relno 7000

M patchlevel 0

M patchno 144

M intno 20050900

M make: multithreaded, Unicode, 64 bit, optimized

M pid 5760

M

M kernel runs with dp version 232000(ext=109000) (@(#) DPLIB-INT-VERSION-232000-UC)

M length of sys_adm_ext is 576 bytes

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 5760) [dpxxdisp.c 1305]

I MtxInit: 30000 0 0

M DpSysAdmExtCreate: ABAP is active

M DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active

M DpShMCreate: sizeof(wp_adm) 25168 (1480)

M DpShMCreate: sizeof(tm_adm) 5652128 (28120)

M DpShMCreate: sizeof(wp_ca_adm) 24000 (80)

M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

M DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552064/552080

M DpShMCreate: sizeof(comm_adm) 552080 (1088)

M DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0

M DpShMCreate: sizeof(slock_adm) 0 (104)

M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

M DpShMCreate: sizeof(file_adm) 0 (72)

M DpShMCreate: sizeof(vmc_adm) 0 (1864)

M DpShMCreate: sizeof(wall_adm) (41664/36752/64/192)

M DpShMCreate: sizeof(gw_adm) 48

M DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000EE80050, size: 6348592)

M DpShMCreate: allocated sys_adm at 000000000EE80050

M DpShMCreate: allocated wp_adm at 000000000EE82150

M DpShMCreate: allocated tm_adm_list at 000000000EE883A0

M DpShMCreate: allocated tm_adm at 000000000EE88400

M DpShMCreate: allocated wp_ca_adm at 000000000F3EC2A0

M DpShMCreate: allocated appc_ca_adm at 000000000F3F2060

M DpShMCreate: allocated comm_adm at 000000000F3F3FA0

M DpShMCreate: system runs without slock table

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 000000000F47AC30

M DpShMCreate: allocated gw_adm at 000000000F47ACB0

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 000000000F47ACE0

M DpShMCreate: allocated wall_adm at 000000000F47ACF0

M ThTaskStatus: rdisp/reset_online_during_debug 0

X EmInit: MmSetImplementation( 2 ).

X MM global diagnostic options set: 0

X <ES> client 0 initializing ....

X Using implementation view

X <EsNT> Using memory model view.

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

M

M Tue Oct 19 18:15:30 2010

M ThInit: running on host SAP-DR

M

M Tue Oct 19 18:15:31 2010

M calling db_connect ...

C

C DBSDBSLIB : version 700.08, patch 0.144 (Make PL 0.144)

C MAXDB shared library (dbsdbslib) patchlevels (last 10)

C (0.144) MSSQL: ODBC fastload on separate connection (note 1131805)

C (0.144) I5/OS ldappasswd support for 5250 terminal. (note 1129573)

C (0.139) Return DS_SQLERR instead of DS_CONNECTERR (note 1121076)

C (0.131) Do not trace password of SQLOPT into dev trace (note 1097930)

C (0.130) Performance optimization for UPDSTAT PREPARE (note 1096387)

C (0.125) Update statistic prepare on row level (note 1086430)

C (0.104) Update statistic with empty schemas (note 1041547)

C (0.095) MaxDB DBSL patch collection 1 2007 (note 1014270)

C (0.082) MaxDB DBSL patch collection 3 2006 (note 991258)

C (0.079) MaxDB DBSL patch collection 2 2006 (note 984406)

C

C

C Loading SQLDBC client runtime ...

C SQLDBC SDK Version : SQLDBC.H 7.6.0 BUILD 007-123-091-175

C SQLDBC Library Version : libSQLDBC 7.6.5 BUILD 015-123-202-938

C SQLDBC client runtime is MaxDB 7.6.5.015 CL 202938

C SQLDBC supports new DECIMAL interface : 0

C SQLDBC supports VARIABLE INPUT data : 1

C SQLDBC supports keepAlive indicator : 0

C INFO : SQLOPT= -I 0 -t 0 -S SAPR3

C Try to connect (DEFAULT) on connection 0 ...

C

C Tue Oct 19 18:15:32 2010

C *** ERROR => Connect to database failed, rc = -4008 (POS(1) Unknown user name/password combination)

[dbsdbsql.cpp 137]

B ***LOG BY2=> sql error -4008 performing CON [dbsh#2 @ 1204] [dbsh 1204 ]

B ***LOG BY0=> POS(1) Unknown user name/password combination [dbsh#2 @ 1204] [dbsh 1204 ]

B ***LOG BY2=> sql error -4008 performing CON [dblink#5 @ 431] [dblink 0431 ]

B ***LOG BY0=> POS(1) Unknown user name/password combination [dblink#5 @ 431] [dblink 0431 ]

M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1440]

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10468]

M

M Info for wp 0

M

M stat = WP_RUN

M waiting_for = NO_WAITING

M reqtype = DP_RQ_DIAWP

M act_reqtype = NO_REQTYPE

M rq_info = 0

M tid = -1

M mode = 255

M len = -1

M rq_id = 65535

M rq_source =

M last_tid = 0

M last_mode = 0

M semaphore = 0

M act_cs_count = 0

M csTrack = 0

M csTrackRwExcl = 0

M csTrackRwShrd = 0

M mode_cleaned_counter = 0

M control_flag = 0

M int_checked_resource(RFC) = 0

M ext_checked_resource(RFC) = 0

M int_checked_resource(HTTP) = 0

M ext_checked_resource(HTTP) = 0

M report = > <

M action = 0

M tab_name = > <

M attachedVm = no VM

M

M *****************************************************************************

M *

M * LOCATION SAP-Server SAP-DR_HSD_07 on host SAP-DR (wp 0)

M * ERROR ThInit: db_connect

M *

M * TIME Tue Oct 19 18:15:32 2010

M * RELEASE 700

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 10688

M * COUNTER 1

M *

M *****************************************************************************

M

M PfStatDisconnect: disconnect statistics

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 724]

M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 261]

M Entering ThSetStatError

M ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 5760) [dpnttool.c 327]

May be this can give some clue.

Thanks.

[Former Member]

Sorry, but you mentioned that you are going to have to DB instances on one host?

then if your new instance is HSD then whats SID for old?

How come you do not have the xuser configuration for your old SID.

[Former Member]

Sorry Sunil i got you confused.

This is what i mentioned in my earlier message.

+I made a new installation yesterday (on a server on which SAP is running) and then i restored the backup of the old system on this new installed DB.

And when i m trying to start this instance, m facing these problems.+

Anyway, the situation now is

The SAP instance already running on the server is with SID - PRD.

Then i installed another new SAP instance with this new SID - HSD.

So now there are two SAP & DB instances on this server. And i m trying to bring up the new SAP instance i.e. HSD

The XUSER didn't give any information about PRD in the outputs i have provided earlier. TRUE

But is it because i was logged in as HSDADM and it will only give the output of the instance we are selecting.

Please correct me if i m wrong.

I don't know if it makes any sense.

Thanks.

Regards,

Mudassir.Imtiaz

[Former Member]

Ok, fine can you please make sure you are able to logon from command prompt to your database.

dbmcli -u control,<your_password> -d HSD

dbmcli -u SAPHSD,<your_password> -d HSD

dbmcli -u SUPERDBA,<your_password> -d HSD

If you are able to connect then pleas make sure that you have maintained the same passwords in XUSER

[Former Member]

Hello Sunil.

I have tried conneting to the database with the commands you have mentioned.

I can access the database by CONTROL and SUPERDBA.

But when i m trying to connect the database with SAPHSD its giving me the following error:

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

-24950,ERR_USRFAIL: User authorization failed

How can i change the password?

Can i change it from DBM Gui directly?

Thanks.

[Former Member]

Ok, logon as control userID and execute below command to get existing users from your database.

user_getall

[Former Member]

I executed it, and the output was only two users.

CONTROL

SUPERDBA

There is no SAPHSD in the list of DB User's.

[Former Member]

Here you go. Have you followed the complete system copy procedure specially for database? looks like you have missed few steps.

I suggest you revisit the system copy guide.

[Former Member]

I have checked for the user already in the other systems DEV QAS PRD

And in all the systems i can only see two users in DBM Gui DBM Operators.

And after you have asked me to check for the users using "user_getall"

I did and got the same result of two users only.

I did the system copy earlier on the test server. And..

I followed the same for building a disaster recovery system.

Took the backup of PRD and restored and then started the SAP MMC. It worked fine.

The same steps i m following for the HSD but could succeed.

What step did i miss after restoring the Backup?

Are there any commands to be executed?

Thanks Sunil.

[Former Member]

When I was going through the installatin guide for MAXDB I found below information. Mean there has to be a user SAP<SID>. When you execute "user_getall" command you are not getting SAP<SID> let me search for other command.

SAP<SAPSID> SAP MaxDB database owner (that is, the owner of the database tables)

CONTROL SAP MaxDB database manager operator

SUPERDBA SAP MaxDB database system administrator

[Former Member]

Thanks Sunil.

Can i create this user SAPHSD in Database User in DBM Gui?

[Former Member]

Can you please logon to DBMGUI --> Connect to your DB --> Clock on Tools --> SQL Studio.

Click on connect --> with your SAPHSD userID and password. If you are able to connect then mean you have the database userID working correctly. if not then your password may be wrong.

[Former Member]

Hi Sunil.

I tried to connect SAPHSD through SQL Studio.

But i throwed me the following error.

ODBC-Error: [SAP AG][SQLOD32 DLL][MaxDB] Invalid authorization specification;-4008 POS(1) Unknown user name/password combination return-code: SQL_ERROR (-4008)