on 09-15-2011 2:28 PM
Hello,
Currently I'm trying to implement a standy instance via system copy with backup/restore.
I'm using the Installation Master Installation_Master_6.20_6.40_05_08 and have already installed the Central Instance successfully. Anymore I have restored the database in the target system too. Everything seems to be fine. When I start the Installer again to finalise the system copy it begins from the last transaction and following Error occurs:
Could not load the system tables. SOLUTION: Check the files "dbm.prt" and "dbm.ins" in the run directory of the database (search for "load_systab") or contact SAP Support.
I already have loaded the system tables without any error
load_systab -u <SYSDBA-source>,<pwd> -ud domain
I checked the Logs dbm.prt
0x0000061e INF 1 DBMSrvCo A DBM Server client connection was established at 2011-09-15 13:45:52 (client process has process ID 1563 on computer xxx.xx.net).
0x0000061e INF 421 DBMSrv Command 'user_response ...' was executed since 2011-09-15 13:45:52.
0x0000061e ERR -24580 DBMSrv ERR_COMMAND_FAILED: Command 'user_response' has ended and failed with return code -24950.
0x0000061e ERR -24950 DBMSrv ERR_USRFAIL: User authorization failed
0x0000061e INF 2 DBMSrvCo A DBM Server client connection was released (client process has process ID 1563 on computer xxx.xx.net).
dbm.ins looks fine:
// *
...
// M START 20110915 00114944
// *
COMMIT
// *
// R ==================================
// *
// R Installation successfully finished
// *
// R ==================================
// *
// M Releasing user connection (USER: 'SUPERDBA'). Open transactions are rolled back (AUTOCOMMIT OFF session)
// *
ROLLBACK WORK
// *
// E -25392: ''
...
I also checked the KnlMsg (converted with protconv):
Thread 0x4C0 Task 142 2011-09-15 11:48:01 RTESec 2: User SUPERDBA attempts to connect
2011-09-15 11:48:01 RTESec 0: Authentication method: EXTERNAL
2011-09-15 11:48:01 RTESec 0: Authenticated identity: sdb
2011-09-15 11:48:01 RTESec 0: Authentication rejected
2011-09-15 11:48:01 RTESec 0: Authentication method: SCRAMMD5
2011-09-15 11:48:01 RTESec 0: Authentication rejected
Thread 0x4C0 Task 142 2011-09-15 11:48:02 CONNECT 12651: Connection released (ERP, T142, connection obj. 7f716d960bb0)
The database versions are equal (MaxDB 7.7.07.32).
Operating System: SUSE Linux Enterprise Server 11 (x86_64) (both)
By the way the passwords in both systems are equal.
When analysing the problem I noticed that the DOMAIN user is missing in the standby instance. In the source system the user is existing.
user_getall
Therefor I checked the dbm.cfg in the standby instance. It's empty. In the source system the file contains following
AUTOSAVE =1
DBADTL =1
In fact, the database works fine. But I can't finalize the system copy.
Anyone an idea what the problem is and how to solve it?
Regards,
Veysel
Hello
The problem is solved. I have reset the passwords of all users (superdba, control nad sap<sid>) to the standards. The Installer could not process the installation with my new passwords.
Thank you all for your help.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
It's because of XUSER Authorization.
Follow the procedure as maintained in SAP Note 39439 - XUSER entries for SAP DB and MaxDB
Regards,
Darshan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you.
I exactly followed the instructions described in note 129352 except for the declaring the SYSDBA. In the target system I have had an older version of the
database 7.5 but I have upgraded it to the same version afterwards. Both database version are equal.
Output of the query select * from users in the source system:
'CONTROL';'';'CONTROL';'ADMIN';'MULTIPLE';(null);(null);(null);'DEFAULT';'20110618';'00131504';'20110618';'00131504';'20110618';'00131504';'ERP';'fleuerhr3p1';0;'NO';(null)
'SUPERDBA';'';'SUPERDBA';'SYSDBA';'MULTIPLE';(null);(null);(null);'DEFAULT';'20100829';'00122321';'20110820';'00190015';'20110820';'00190015';'ERP';'fleuerhr3p1';10;'NO';(null)
'SUPERDBA';'';'SAPERP';'DBA';'MULTIPLE';(null);(null);(null);'ASCII';'20100829';'00122331';'20110820';'00190325';'20110820';'00190325';'ERP';'fleuerhr3p1';14;'NO';(null)
Output of the command user_getall in the target system:
CONTROL
SUPERDBA
Output of the command user_getall in the source system:
CONTROL
SUPERDBA
DOMAIN
Output of the command param_directget CONTROLUSERID in the target system:
CONTROLUSERID CONTROL
I have executed following commands in right order as desribed:
db_offline
user_sysdba SUPERDBA,admin
db_online
load_systab -u SUPERDBA,admin
As you can see in the dbm.prt the system tables was installed successfully but the error still exists.
Output of the dbm.prt
2011-09-16 10:02:28 0x000012c0 INF 283 DBMSrv Command 'user_sysdba ...' is being executed.
2011-09-16 10:02:28 0x000012c0 INF 419 DBMSrv Command 'user_sysdba' has ended with return code 0.
2011-09-16 10:02:31 0x000012c0 INF 283 DBMSrv Command 'db_online' is being executed.
2011-09-16 10:02:31 0x000012c0 INF 419 DBMSrv Command 'db_online' has ended with return code 0.
2011-09-16 10:03:20 0x000012c0 INF 283 DBMSrv Command 'load_systab ...' is being executed.
2011-09-16 10:03:24 0x000012c0 INF 419 DBMSrv Command 'load_systab' has ended with return code 0.
2011-09-16 10:12:55 0x0000133a INF 1 DBMSrvCo A DBM Server client connection was established at 2011-09-16 10:12:55 (client process has process ID 4920 on computer fleuerhr3p2.groupdomain.net).
2011-09-16 10:12:55 0x0000133a INF 421 DBMSrv Command 'user_response ...' was executed since 2011-09-16 10:12:55.
2011-09-16 10:12:55 0x0000133a ERR -24580 DBMSrv ERR_COMMAND_FAILED: Command 'user_response' has ended and failed with return code -24950.
0x0000133a ERR -24950 DBMSrv ERR_USRFAIL: User authorization failed
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Veysel
1. Are you SAP customer?
If Yes => SAP Note 129352 (Homogeneous System Copy with MaxDB)
SAP Note 1014782 (FAQ: MaxDB System Copy)
2. Please update the message with additonal information:
What are the DBM and SYSDBA users of the source database?
Post the output of SQL statement "select * from users"
With what dbm user did you create the target database?
Post output of the dbm commands:
user_getall
param_directget CONTROLUSERID
3. You have 7.7 database version => You have not "domain" user any more.
MAXDB library:
see document "Managing Users" at
http://maxdb.sap.com/doc/7_7/45/01f20034166c32e10000000a114a6b/content.htm
In some cases, as of Version 7.7, db_online automatically restarts load_systab. So before db_online, after you done the restore of the source database backup in the target database, you need to run the following command to declare the SYSDBA user:
dbmcli -d <database_name> -u <dbm_user>,<password> user_sysdba <sysdba_user_source>,<sysdba_user_password_source>
Regards, Natalia Khlopina
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.