No username of Source system is avbl after livecache system copy

[Former Member]

Hi Experts

I have done a livecache system copy from the source system to target system. Here the steps are

Assume my Source SYstem Livecache is RP1 and Target System livecache is RS1.

1. Taken Source system livecache DATA and LOG Area backup RP1.

2. Defined the same source system backup medium name in Target System (RS1 and moving the Source system Liveacache backuped files to Target system and defined the medium name as per that)

3. put the livecache db_admin mode

4. db_activate RECOVER <medium_name>.

5. recover_start <log_medium_name> LOG <nnn>

6. db_online.

Here we faced that

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

So we activated the SUPERDBA as " db_activate SUPERDBA,<password>

then it came to online. and afterwards we have used the load_systab command to load the tables.

BUT we could not find any Source System name like "RP1ADM" in the tables of the livecache database. Only there are CONTROL,SUPERDBA username availbale. Usually there will be also the source admin name . I dont know why it is missing

Before a month we have done livecahe restore same as now in that time we got the source system name admin also. ( RP1ADM) and also tables which owned by RP1ADM. alos i could find APPSYSPARAM table and the instance also registered.

But now in this restore we could not find the above.

We followed the same procedure and there is no change in the steps also.

Could anyone help me...

Regards

bala

[Former Member]

Hi Markus

Before receiving the reply from u we thought the superdba user password is different and we tried with source system superdba password and we got all the application tables. However thanks for the suggestiona dn ideas given by you.

I have tried like this

after db_activate recover <medium_name>

login as control,password

db_admin

user_sysdba superdba,<password of source system>

db_online

We got all the tables.

But whether it is necessary to use load_systab -u superdba,password to load the tables and why need it to be done

REgards

bala

[former_member229109]

Hello Bala,

1. As I wrote you already, the notes:

886103 System Landscape Copy for SAP SCM

877203 Post steps after the Homogenous liveCache copy using backup/

457425 Homogenous liveCache copy using backup/restore

has all recommended steps to do, when you will run the u201CSystem Landscape Copy for SAP SCMu201D

2. If you run the u201CHomogenous liveCache copy using backup/restoreu201D you should pay attention to the note 457425. After you imported the complete data backup < step 2. > you need to update the system tables.

To update the system tables you need to know the correct database SYSDBA user & password.

After you restored the databackup of the source database, start the database online & run u201Cselect * from usersu201D SQL command to see the SYSDBA user. Then check that you know the DBA user ( DataBase Administrator ) & password of the source database instance => Open the SQL session with this

user & password.

Example:

after db_activate recover <medium_name>

login as control,password

db_online

sql_execute select * from users

sql_connect superdba,<password of source system>

If you didnu2019t get error with the last command, then you could update the system tables with the superdba,<password of source system> using load_systab command.

The system tables will be updated & the correct SYSDBA user & password will be updated in *.UPC file.

3.

user_sysdba:

You make the database system administrator known to Database Manager. It is only necessary to use this DBM command if the database administrator is not known or is incorrectly known to Database Manager.

u201CI have tried like this

after db_activate recover <medium_name>

login as control,password

db_admin

user_sysdba superdba,<password of source system>

db_onlineu201D

You could update the .upc files with the wrong SYSDBA user password u2026

You was lucky, that you knew the correct SYSDBA user and password of the source database.

Example < NLK is my local database >:

A. I could update the .upc file with wrong password of SYSDBA user:

dbmcli -d NLK -u control,control

dbmcli on NLK>user_sysdba superdba,test

OK

dbmcli on NLK>db_online

OK

dbmcli on NLK>load_systab

ERR

-24909,ERR_DBAUNKNOWN: SYSDBA unknown

dbmcli on NLK>exit

B. I could update the .upc file with wrong SYSDBA user:

dbmcli -d NLK -u control,control

dbmcli on NLK>user_sysdba test,test

OK

dbmcli on NLK> user_get test

OK

u2026

dbmcli on NLK>sql_connect test,test

ERR

-24988,ERR_SQL: SQL error

-4008,Unknown user name/password combination

dbmcli on NLK> dbmcli on NLK>sql_connect superdba,admin

OK

I could connect as test,test; but the test user is NOT SYSDBA user u2026

dbmcli -d NLK -u test,test

dbmcli on NLK>

Itu2019s recommended to user the load_systab command, so the .upc files will be updated with the correct SYSDBA user/password or

you will get error.

4. http://maxdb.sap.com/doc/7_7/86/68627a1bc642e6a6f73d3bc7a55fe1/content.htm

You got error:

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

The automatically updating the system tables, according to the default value, is switched on.

After you will run the update system tables with the correct SYSDBA user & password the *.UPC file will be updated,

and with the next liveCache restart you will not get this error.

5. See more information in the MAXDB library:

http://maxdb.sap.com/doc/7_7/45/11cbd6459d7201e10000000a155369/content.htm

Thank you and best regards, Natalia Khlopina

Edited by: Natalia Khlopina on May 19, 2010 2:58 PM

[Former Member]

Hi

As you exactly said the last monthe exercise we have done only the following steps where the LVC database came online

1. db_admin

2. db_connect

3 db_activate recover <medium_name>

4. recover_start <logmedium_name> LOG <nnn>

5. db_online

and the database came online.

This time also we done the same procedure but it triggered the following error and

dbmcli on RS1>db_online

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

we have to activate the SUPERDBA,Password user from the login and then database got opened but we could not the source system application tables and username.

How to avoid these sitiaution or where i am doing error.

regards

bala

[markus_doehr2]

> dbmcli on RS1>db_online

> 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

>

> we have to activate the SUPERDBA,Password user from the login and then database got opened but we could not the source system application tables and username.

The problem you face is the fact, that the system tries to automatically load the system tables. This fails since the superdba user and/or password of source and destination system are different.

An activation will do that, format the log and the converter and your database is empty, db_activate initializes everything.

So I'd load the system tables manually such as

dbmcli -U c load_systab -u superdba,<password> -ud domain

Markus

[Former Member]

Hi Mark

A month before we have done the same execise but at that time we could able to see the username of the source system in the target instance. I know it would format the data and log areas but when we done last time i could see the username avaible in the

select * from domain.users

CONTROL

SUPERDBA

RP1ADM

How come this?

regards

bala

[former_member229109]

Dear Mr. Bala,

1. Markus was correct. And it was written in the documentation.

For SAP liveCache documentation see the SAP note 767598.

After you run " db_activate SUPERDBA,<password>u201D dbm command the database will be

initialized and the application data will be lost

Please check the definition of the dbm command at MAXDB library before

to use it in your database:

http://maxdb.sap.com/doc/7_6/default.htm

-> Tools -> Database Manager CLI ...

-> db_activate

< "Initializing a database instance" >

< click on "db_activate" to see more information >

2. Please follow the recommended steps in the SAP note

886103 System Landscape Copy for SAP SCM

when you will run the u201CSystem Landscape Copy for SAP SCMu201D

3. u201CA month before we have done the same execise but at that time we could able to see the username of the source system in the target instance.u201D

I think that you didnu2019t run " db_activate SUPERDBA,<password>u201D at the end a month ago.

Thank you and best regards, Natalia Khlopina

[markus_doehr2]

> Here we faced that

> 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

>

> So we activated the SUPERDBA as " db_activate SUPERDBA,<password>

...and with that step you just deleted the whole database. A 'db_activate' will format log and data areas.

Markus