on 06-21-2013 9:12 AM
Hi
I have done a distributed installation of NW 7.3 on Windows 2008 Server R2 on host which has two virtual hostnames.
After completion of installation, I have tried to configure the this host machine in the SAP LVM.
When I entered the MaxDB credentials and press the Test DBConnection its throwing the below error.
error stack:
Test of database admin credentials failed for W31 System Database (ABAP): MaxDB, w312017db.
caused by Error occured while trying to get the status of the db from host agent. Used endpoint: 'http://w312017src:1128' [com.sap.nw.lm.aci.engine.base.exception.EngineException]
caused by Database permission denied: username or password not set Please provide username and password of a database manager (DBM) user (a default DBM user is the 'control' user). [com.sap.engine.services.webservices.espbase.client.bindings.exceptions.SOAPFaultException]
I am very sure that I gave correct credentials while installing. My OS password and master, DB passwords for all the three SAP Instances(CS,DB,CI) are the same.
Even I have reentered the passwords for all the users of the DB using the XUSER.
xuser list
xuser clear
xuser -U c_J2EE -u CONTROL,password -d W31 -t 0 -I 0 -S SAPR3 -n W312017db
xuser -U DEFAULT -u SAPW31,password -d W31 -t 0 -I 0 -S SAPR3 -n W312017db
xuser -U c -u CONTROL,password -d W31 -t 0 -I 0 -S SAPR3 -n W312017db
xuser -U w -u SUPERDBA,password -d W31 -t 0 -I 0 -S SAPR3 -n W312017db
Can anyone help us in resolving the issue. Please let us know which logs needed to find out the exact issue.
I am attaching the dev_sapdbctrl log file for your reference.
Regards,
Sivasankar
Hi Sivasankar,
Are you able to log on database directly via dbmcli:
dbmcli -d <dbsid> -u control,<password> db_state
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.
Do you have any solution.
I am trying to add Database (oracle) on SunOS server.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Rekha,
Please check the point number 20 of this SAP Note.
Note 1020175 - FAQ: SAP MaxDB installation/upgrade or applying a patch
also have a look its related notes
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I came across a similar error with some other setup while I am trying to configure in SAP LVM.
error stack:
Test of database admin credentials failed for W31 System Database (ABAP): MaxDB, w312017db.
caused by Error occured while trying to get the status of the db from host agent. Used endpoint: 'http://w312017db:1128' [com.sap.nw.lm.aci.engine.base.exception.EngineException]
caused by Invalid Response code (401). Server [http://w312017db:1128] returned message [Unauthorized]. Http proxy info: none [javax.xml.ws.WebServiceException]
caused by Invalid Response code (401). Server [http://w312017db:1128] returned message [Unauthorized]. Http proxy info: none [com.sap.engine.services.webservices.espbase.client.bindings.exceptions.TransportBindingException]
If anyone has some idea about this issue please share your thoughts with us.
Regards,
Sivasankar
Did anyone get solution. I am facing below error
Test of database administration credentials failed for <SID> System database (ABAP/JAVA): Oracle, <server name>
I have distributed system and I am trying to add database to LVM.
Where i need to provide database admin password. I have oracle database on sun solaris.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
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.