Unable to Start Sap After Performing System Copy

[Former Member]

Hi,

I have a problem in starting up SAP in system BAP aftter system copy from BAD to BAP. I performed the system copy (backup and recovery) through Database Studio. The database version is 7.9.08.23. The whole process of recovery was perfomed succesfully (database BAP is in online mode). However, when I start the SAP using command startsap r3, it is said that the database must be started first even though the database is already in online mode.

When I ran R3trans -d, here is the result:

bapadm> R3trans -d

This is R3trans version 6.24 (release 721 - 26.09.13 - 20:13:07 ).

unicode enabled version

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

R3trans finished (0012).

On the trans.log, I found this entry:

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

Is this related to the source database name is different to target database? Is there anyway to change the username/password mentioned on the trans log?

Thanks,

Kris

[prashb · Accepted solution]

In case of connect problems of an SAP system (e.g. R3trans, the work processes, ...) you should always check the XUSER data.

To maintain the XUSER data you can use Database Manager CLI (DBMCLI) or XUSER. How the XUSER entries should look like for an SAP system is described in note 39439.

[Former Member · Accepted solution]

Prashanth Bidare wrote:

In case of connect problems of an SAP system (e.g. R3trans, the work processes, ...) you should always check the XUSER data.

To maintain the XUSER data you can use Database Manager CLI (DBMCLI) or XUSER. How the XUSER entries should look like for an SAP system is described in note 39439.

Hi Prashanth,

I already check the user list using command "xuser list", and it shows all users required to be put in xuser list: SAP<SID> (SAPBAP), CONTROL, SUPERDBA.

bapadm> xuser list

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

XUSER Entry  1

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

Key           :DEFAULT

Username      :SAPBAP

UsernameUCS2  :.S.A.P.B.A.P. . . . . . . . . . . . . . . . . . . . . . . . . .

Password      :?????????

PasswordUCS2  :?????????

PasswordUTF8  :?????????

Dbname        :BAP

Nodename      :devbap

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

PasswordUTF8  :?????????

Dbname        :BAP

Nodename      :devbap

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

PasswordUTF8  :?????????

Dbname        :BAP

Nodename      :devbap

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

PasswordUTF8  :?????????

Dbname        :BAP

Nodename      :devbap

Sqlmode       :SAPR3

Cachelimit    :-1

Timeout      

Isolation    

Charset       :<unspecified>

Thanks,

Kris

[Former Member · Accepted solution]

Hi Kris,
first check if you have the right passwords and user names.
To check you should a native MaxDB tool like sqlcli instead of R3trans.

>sqlcli -d BAP -n devbap -u SAPBAP,<pwd> select user from dual

and next test the XUSER entry with the option -U <xuserkey>.

>sqlcli -U DEFAULT select user from default

Burkhard

[Former Member · Accepted solution]

Burkhard Diesing wrote:

Hi Kris,
first check if you have the right passwords and user names. 
To check you should a native MaxDB tool like sqlcli instead of R3trans.

>sqlcli -d BAP -n devbap -u SAPBAP,<pwd> select user from dual

and next test the XUSER entry with the option -U <xuserkey>.

>sqlcli -U DEFAULT select user from default


Burkhard

Hi Burkhard,

Here is the result when I execute your sql command mentioned above:

Using user SAPBAP:

sqlcli -d BAP -n devbap -u SAPBAP,<pwd> select user from dual

* -4008: POS(1) Unknown user name/password combination SQLSTATE: 28000

* -4008: POS(1) Unknown user name/password combination SQLSTATE: 28000

Using user SUPERDBA:

sqlcli -d BAP -n devbap -u SUPERDBA,<pwd> select user from dual

| EXPRESSION1                      |

| -------------------------------- |

| SUPERDBA                         |

1 row selected (619 usec)

Since the database restored from BAD, I try to execute using user SAPBAD

sqlcli -d BAP -n devbap -u SAPBAD,<pwd> select user from dual

| EXPRESSION1                      |

| -------------------------------- |

| SAPBAD                           |

1 row selected (1388 usec)

sqlcli -U DEFAULT select user from default

* -4008: POS(1) Unknown user name/password combination SQLSTATE: 28000

I think the user SAPBAP does not exist in the database. How to convert or changes the user from SAPBAD into SAPBAP?

Thanks,

Kris

[Former Member · Accepted solution]

Hello Kris,
first check which users are exists on the database

>sqlcli -d BAP -n devbap -u SUPERDBA,<pwd> select username from users

If the user exists try to set the password new to ensure that you have the correct one.

>sqlcli -d BAP -n devbap -u SUPERDBA,<pwd> alter password SAPBAP <pwd>

Then try to connect again with sqlcli an user SAPBAP

Burkhard

[Former Member · Accepted solution]

Burkhard Diesing wrote:

Hello Kris,
first check which users are exists on the database

>sqlcli -d BAP -n devbap -u SUPERDBA,<pwd> select username from users

If the user exists try to set the password new to ensure that you have the correct one. 

>sqlcli -d BAP -n devbap -u SUPERDBA,<pwd> alter password SAPBAP <pwd>

Then try to connect again with sqlcli an user SAPBAP

Burkhard

Hi Burkhard,

The SAPBAP user does not exist. Below is the result:

devbap:> sqlcli -d BAP -n devbap -u SUPERDBA,<pwd> select username from users

| USERNAME                         |

| -------------------------------- |

| CONTROL                          |

| SUPERDBA                         |

| SAPBAD                           |

3 rows selected (8320 usec)

Thanks,

Kris

[Former Member · Accepted solution]

You have a user SAPBAD.

Was the system copy from your development system BAD?

[Former Member · Accepted solution]

Burkhard Diesing wrote:

You have a user SAPBAD.

Was the system copy from your development system BAD?

HI Burkhard,

Yes, it was system copy from BAD.

Thanks,

Kris

[Former Member · Accepted solution]

Kris Adrianto wrote:





HI Burkhard,

Yes, it was system copy from BAD.

Thanks,
Kris

The user SAPBAD owns all tables and data of your SAP System.
So the user SAP User exists but did not has the right name.

I am not an upgrade expert. I guess you have not made a simple system copy. This was a system copy and system rename.

You should check the system copy guides and note. If a manual rename user is required. I guess it should happen when you execute the rename tasks.

Burkhard

[Former Member · Accepted solution]

Burkhard Diesing wrote:


Kris Adrianto wrote:





HI Burkhard,

Yes, it was system copy from BAD.

Thanks,
Kris


The user SAPBAD owns all tables and data of your SAP System. 
So the user SAP User exists but did not has the right name.

I am not an upgrade expert. I guess you have not made a simple system copy. This was a system copy and system rename.

You should check the system copy guides and note. If a manual rename user is required. I guess it should happen when you execute the rename tasks.

Burkhard

Hi,

I was checking on Note http://service.sap.com/sap/support/notes/129352 and there is one command I have to execute to rename the SAP<SID> user:

dbmcli -d <new_database_name> -u <dbm_operator>,<password> -uSQL <database_system_administrator>,<password> sql_execute rename user SAP<SAPSID> to SAP<NEWSID>

or using this command in database studio:

sql_execute rename user SAP<SAPSID> to SAP<NEWSID>

Thanks,

Kris

[Former Member]

can you please check following link for reference

http://scn.sap.com/docs/DOC-40842

[Former Member]

Anand Naroji wrote:

can you please check following link for reference

http://scn.sap.com/docs/DOC-40842

Hi Anand,

I check on your link, all user list has correct DB name as we can see from the "xuser list" result I mentioned above

Thanks,

Kris

[former_member74206]

Hi Kris,

        I dont know what sort of System your trying to copy (ecc, netweaver etc) but in the SAP portal look at the user guides link and follow it for your environment you will eventually get to the system copy guide.

below is my link to to netweaver 7.4 - maxdb

https://websmp104.sap-ag.de/~sapidb/011000358700000877172012E

[former_member74206]

Hi,

      There are Database copy completion steps to be performed after the restore using the SAP toolset.

      Follow the system copy documentation.

Regards,

             Ryan

[Former Member]

Fernandez Ryan wrote:

Hi,
      There are Database copy completion steps to be performed after the restore using the SAP toolset.
      Follow the system copy documentation.

Regards,
             Ryan

Hi,

I only found these documentation about system copy in MaxDB:

Restoring Databases - Database Administration - SAP Library

Restoring Databases - Database Studio - SAP Library

Is there any other documentation other than that?

Thanks,

Kris