MAXDB - SAP System not coming up after refresh - R3trans -d coming as 0012

[Former Member]

Dear Team,

      I have refreshed my DEV SAP system with MaxDB Database using QAS Database with Initialize DB option .

      After refresh I changed the password for SUPERDBA using sql_execute alter password SUPERDBA, pass command and executed

      load_systab successfully after that. I have also changed Xuser entries following note 39439 but still R3trans-d is coming as 0012.

     I can see below error in trans.log file -

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

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

4 ETW000                                                                                              860680  0.871941

4 ETW000  [     dev trc,00000]   -> SetSapdbCA(errcode=4294963288)                                        34  0.871975

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

4 ETW000  [     dev trc,00000]   -> sdb_free(p=0x3e5fcb0, size=608 (1162224 bytes allocated))            144  0.872204

4 ETW000  [     dev trc,00000]   -> sdb_free(p=0x3e5f010, size=1936 (1160272 bytes allocated))           117  0.872321

4 ETW000  [     dev trc,00000]  } DbSlSdbConnect(rc=99)                                                   35  0.872356

4 ETW000  [    dblink  ,00433]  ***LOG BY2=>sql error -4008  performing CON [dblink#4 @ 433]             100  0.872456

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

I am not sure why this error is coming xuser list gives below result :-

dtdcerpdev:de1adm 90> xuser list

-----------------------------------------------------------------

XUSER Entry  1

--------------

Key         :DEFAULT

Username    :SAPDE1

UsernameUCS2:S.A.P.D.E.1. . . . . . . . . . . . . . . . . . . . . . . . . . .

Password      :?????????

PasswordUCS2  :?????????

Dbname      :DE1

Nodename    :dtdcerpdev

Sqlmode     :SAPR3

Cachelimit  :-1

Timeout    

Isolation  

Charset     :<unspecified>

-----------------------------------------------------------------

XUSER Entry  2

--------------

Key         :c

Username    :MAXDBDE1

UsernameUCS2:M.A.X.D.B.D.E.1. . . . . . . . . . . . . . . . . . . . . . . . .

Password      :?????????

PasswordUCS2  :?????????

Dbname      :DE1

Nodename    :dtdcerpdev

Sqlmode     :INTERNAL

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      :DE1

Nodename    :dtdcerpdev

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      :DE1

Nodename    :dtdcerpdev

Sqlmode     :INTERNAL

Cachelimit  :-1

Timeout     :-1

Isolation   :-1

Charset     :<unspecified>

-----------------------------------------------------------------

XUSER Entry  5

--------------

Key         :list

Username    :<unspecified>

UsernameUCS2:<unspecified>

Password      :<unspecified>

PasswordUCS2  :<unspecified>

Dbname      :<unspecified>

Nodename    :<unspecified>

Sqlmode     :<unspecified>

Cachelimit  :-1

Timeout     :-1

Isolation   :-1

Charset     :<unspecified>

dtdcerpdev:de1adm 91>

Please help I am not sure what to do now.

Regards,

Aman

[Former Member]

hi alok,

If the suggestions given by me and others are not working you might want to try to do a restore again if it is possible.

Regards,

Ram

[former_member182657]

Hi Alok,

ERR_AUTOLOADSYSTAB: Automatic loading of the System Tables failed
ERR_DBAUNKNOWN: Database system administrator unknown

Addition to it could you share SAP MaxDB version and suggest you to go through SAP Notes

1090087 - db_online sets database online despite error message

1882932 - Connection problems after database upgrade

Hope these two notes will help you.

Regards,

Gaurav

[former_member182657]

Hi Alok,

Could you share current kernel release & patch level for the system ? If possible try to patch it with latest available and re share trans.log file

Regards,

[former_member182657]

Hi,

Could you check with SAP Note  25591 - Password change for DBM and DBA users

2081702 - Problems after recovery with initialization

Regards,

[Former Member]

Hi Gaurav,

Already checked this note changed all the passwords but issue still same.

Regards,

Alok

[Former Member]

Hi Alok,

Do try to change the password for the All Max DB user including Conrol, superdba & SAP<SID>.

The -4008 user issue normally comes due to user authorization issue like user /password combination not working.

Please use below command lines for your your reference:-

Stop MAx DB using DBMGUI

dbmcli -d <SID> -n  <Hostname> -u control,***** db_warm

dbmcli -d  <SID> -n <Hostname> -u control,*****  -uSQL superdba ,***** sql_execute rename user SAP <Source SID> to SAP <Target SID>

dbmcli -d  <SID> -n <Hostname> -u control,*****  user_sap SAP<Prod>,*****

dbmcli -d  <SID> -n <Hostname> -u control,*****  db_offline

Start MaxDB using DBMGUI

Let me know if this helps.

Regards,

Ram

[Former Member]

Hi,

  Issue still remain same and I am getting below error for db_warm :-

dtdcerpdev:de1adm 60> dbmcli -d DE1 -n  dtdcerpdev -u MAXDBDE1,maxdbde1 db_warm

ERR

-24622,ERR_AUTOLOADSYSTAB: Automatic loading of the System Tables failed

-24907,ERR_DBAWRONG: Wrong database system administrator

-24988,ERR_SQL: SQL error

-4008,Unknown user name/password combination

dtdcerpdev:de1adm 61>

Any Idea ?

Regards,

Aman

[Former Member]

hi Alok,

Try the below OSS note after changing the SUPERDBA password

1090087 - db_online sets database online despite error message

Which talks about system tables load. dbmcli command load_systab.

And refere below threads:-

http://scn.sap.com/thread/3165601

http://scn.sap.com/thread/816727

Note:- Also Always mask your server names/User id /password while putting on SCN.

Hope this helps.

Regards,

Ram

[Former Member]

Hi Ram,

   I have already checked all these links tried all Notes possible . But this error is not going anywhere. No clue at all why this happening.

Regards,

Alok

[Former Member]

hi Alok,

The issue your seeing is due to the max db refresh activity only, and as the production system password came to target normally this happenes and we had simmilar issue earlier and after running the above mentioned command and doing the load_systab using dbmcli issue got resolved.

also can you try below commands

dbmcli -d <SID> -n  <Hostname> -u control,***** show state

dbmcli -d <SID> -n  <Hostname> -u control,***** user_sap SAP<SID>,password

And let us know the output.

Regards,

ram

[Former Member]

Hi Ram,

   Tried these commands but R3trans -d still 0012 .

host:SIDadm 58>  dbmcli -d SID -n  host -u CONTROL,control show state

OK

SERVERDB: SID

The SERVERDB state is ONLINE

hostsidadm 59> dbmcli -d SID -n  host -u CONTROL,control user_sap SAPSID,sap

OK

host:sidadm 60> R3trans -d

This is R3trans version 6.14 (release 701 - 03.06.11 - 17:57:00).

unicode enabled version

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

R3trans finished (0012).

Regards,

Alok

[Sriram2009]

Hi Aman

Could you refer  the SAP KBA

1875264 - SAP does not start in Windows systems with MaxDB: XUSER problem

BR

SS

[Former Member]

Hi,

  We have a LINUX system here. Still I have tried xuser clear and then setting all entries again but it still does not work and I am getting same error in R3trans -d

Regards,

Aman

[former_member182657]

Hi,

Have you checked  739985 - Error -4008 when starting the database analyzer

& SAP Note  442944 - No authorization to start database (-4008)

Regards,

[Former Member]

Hi,

  Note - 442944 - not relevant for my MaxDb Version.

  Note - 739985 - Followed instructions but issue remain same.

Try to connect (DEFAULT) on connection 0 ...                             105  0.013128

4 ETW000  [     dev trc,00000]  Fri Feb 13 13:19:36 2015                                             1007378  1.020506

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

4 ETW000                                                                                                  60  1.020566

4 ETW000  [     dev trc,00000]   -> SetSapdbCA(errcode=4294963288)                                        21  1.020587

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

4 ETW000  [     dev trc,00000]   -> sdb_free(p=0x159cdcb0, size=608 (1162224 bytes allocated))           101  1.020737

4 ETW000  [     dev trc,00000]   -> sdb_free(p=0x159cd010, size=1936 (1160272 bytes allocated))          108  1.020845

4 ETW000  [     dev trc,00000]  } DbSlSdbConnect(rc=99)                                                   22  1.020867

4 ETW000  [    dblink  ,00433]  ***LOG BY2=>sql error -4008  performing CON [dblink#4 @ 433]              54  1.020921

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

Regards,

Aman