on 02-02-2016 1:14 PM
Hello,
I have a problem in connection between SAP and its database (MaxDB 7.9). When I check using DB59 -> Connection Test -> Connection Test, the check result was error. Here is the log:
Application Server: prodbap_BAP_30 ( SunOS )
1. Connect. test with "dbmcli db_state" Unsuccessful
dbmcli_command_execute_error
Error! Connection failed to node prodbap for database BAP:
tp error: connect failed
External program terminated with exit code 2
2. Connect. test with command mode "dbmrfc db_state" Unsuccessful
dbm_system_error
Name and Server : BAP - prodbap
DBMRFC Function : DBM_EXECUTE
Command : db_state
Error : DBM Error
Return Code : -11
Error Message : tp error: connect failed#
3. Connect. test with session mode "dbmrfc db_state" Unsuccessful
dbm_system_error
Name and Server : BAP - prodbap
DBMRFC Function : DBM_CONNECT
Error : DBM Error
Return Code : -11
Error Message : tp error: connect failed#
The SAP are unable to get the database state through the db_state command. When I check using dbmcli, I was succesfully get the database state. Here is the result:
dbmcli -d BAP
dbmcli on BAP>user_logon SUPERDBA,<pwd>
OK
---
dbmcli on BAP>db_state
OK
State
ONLINE
---
I already check on KnlMsg but couldn't find any error on that log. I think that this issue is only about connecting the SAP and database but I have no idea what should I adjust.
Thanks for your help,
Kris
Hi Kris,
Is it a livecache or maxdb is the primary database of the system?
What is the result of "R3trans -d" by executing on SAP application server via user sidadm?
Best regards,
James
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
James Zhang wrote:
Hi Kris,
Is it a livecache or maxdb is the primary database of the system?
What is the result of "R3trans -d" by executing on SAP application server via user sidadm?
Best regards,
James
Hi James,
It's a maxdb and yes, it's the primary database of the system.
Here is the result of the R3trans -d:
R3trans -d
This is R3trans version 6.24 (release 721 - 26.09.13 - 20:13:07 ).
unicode enabled version
R3trans finished (0000).
Thanks,
Kris
Hi Kris,
If the SAP system can be up? I think so.
Please do the comprehensive check as link below:
HowTo - Analyze Connection Problems in DBACockpit, DB50 and LC10 - MaxDB - SCN Wiki
Best regards,
James
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.