on 07-05-2013 11:37 AM
Hi,
I installed Database Studio 7.9.08.11 on a Windows PC. I have Maxdb 7.6 installed on a AIX server used for Content Server purpose. Is it possible to use Windows Database Studio to manage the Maxdb database on Unix?
When I start up Database Studio and try to add a new server for the Maxdb database, I got an error saying:
User management exception: Cannot connect to host DPSDCONT01:7210 [Connection refused: connect], -813.
Can someone help?
Rdgs,
Lim
Hi lim,
yes it is possible to adminsitrate database on linux , Unix and Windows with the same database Studio running on Windows.
On your database server is there an x_server running , when you try to connect with DBstudio?
It sounds that there is no x-server running.
Please LOGON on Unix level as user sqd<SID> and start the folowing command to start the x-server:
x_server start
Please try it again to connect this database with database Studio.
Regards, Christiane
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
DB Studio is showing the error
User management exception: Cannot connect to host 192.168.10.100:7210 [Connection timed out: connect], -813.
I already checked
> x_server stop
2016-01-21 18:03:48 8544 INF 12905 sdbgloballistener on port 7210 stopped
> x_server start
2016-01-21 18:03:52 6976 INF 12916 Found running XServer on port 7200
2016-01-21 18:03:52 6976 INF 13011 version 'U64/LIX86 7.8.02 Build 041-121-251-982'
2016-01-21 18:03:52 6976 INF 13010 installation sid - path:/sapdb/sid/db
2016-01-21 18:03:52 7584 INF 12798 NISERVER NI support started.
2016-01-21 18:03:52 96992 WNG 12453 NISSLSRV NISSL Init: SSL: Could not locate ticket file
2016-01-21 18:03:52 54048 INF 12903 sdbgloballistener on port 7210 started
> x_server
2016-01-21 18:07:34 91744 INF 12916 Found running XServer on port 7200
2016-01-21 18:07:34 91744 INF 13011 version 'U64/LIX86 7.8.02 Build 041-121-251-982'
2016-01-21 18:07:34 91744 INF 13010 installation sid - path: /sapdb/sid/db
2016-01-21 18:07:34 42528 INF 12916 Found running sdbgloballistener on port 7210
2016-01-21 18:07:34 42528 INF 13011 version 'U64/LIX86 7.8.02 Build 031-121-246-245'
> sdbregview -l
Installation: Global /sapdb/programs
Global Listener 7.8.02.31 valid 64 bit
Installation Compatibility 7.8.02.31 valid 64 bit
Installer 7.8.02.31 valid
SAP Utilities Compatibility 7.8.02.31 valid 64 bit
Installation: SID /sapdb/SID/db
Base 7.8.02.41 valid 64 bit
DB Analyzer 7.8.02.41 valid 64 bit
Database Kernel 7.8.02.41 valid 64 bit
Fastload API 7.8.02.41 valid 64 bit
JDBC 7.6.09.00 valid
Loader 7.8.02.41 valid 64 bit
Messages MSG 0.10269 valid
ODBC 7.8.02.41 valid 64 bit
Redist Python 7.8.02.41 valid 64 bit
SAP Utilities 7.8.02.41 valid 64 bit
SQLDBC 7.8.02.41 valid 64 bit
SQLDBC 76 7.6.06.27 valid 64 bit
SQLDBC 77 7.8.02.41 valid 64 bit
Server Utilities 7.8.02.41 valid 64 bit
Installation: CL_SID /sapdb/clients/SID
Base 7.8.02.41 valid 64 bit
Fastload API 7.8.02.41 valid 64 bit
JDBC 7.6.09.00 valid
Loader 7.8.02.41 valid 64 bit
Messages MSG 0.10269 valid
ODBC 7.8.02.41 valid 64 bit
Redist Python 7.8.02.41 valid 64 bit
SAP Utilities 7.8.02.41 valid 64 bit
SQLDBC 7.8.02.41 valid 64 bit
SQLDBC 76 7.6.06.27 valid 64 bit
SQLDBC 77 7.8.02.41 valid 64 bit
> xinstinfo SID
GlobalDataPath : /sapdb/data
GlobalProgramsPath : /sapdb/programs
PrivateDataPath : /sapdb/SID/data
Rundirectory : /sapdb/SID/data/wrk/SID
InstallationPath : /sapdb/SID/db
Kernelversion : KERNEL 7.8.02 BUILD 041-121-251-982
:~ # /sapdb/programs/bin/sdbverify
Checking installation "Global" (/sapdb/programs, 7.8.02.31)
Checking package Installer
Checking package SAP Utilities Compatibility
Checking package Global Listener
Checking package Installation Compatibility
Checking installation "Legacy" (/sapdb/programs, )
Checking installation "sid" (/sapdb/sid/db, 7.8.02.41)
Checking package Base
Checking package SQLDBC
Checking package SQLDBC 77
Checking package Fastload API
Checking package SQLDBC 76
Checking package SAP Utilities
Checking package Server Utilities
Checking package Database Kernel
Checking package Redist Python
Checking package Loader
Checking package ODBC
Checking package Messages
Checking package JDBC
Checking package DB Analyzer
Checking installation "CL_sid" (/sapdb/clients/sid, 7.8.02.41)
Checking package Base
Checking package SQLDBC
Checking package SQLDBC 77
Checking package Fastload API
Checking package SQLDBC 76
Checking package SAP Utilities
Checking package Redist Python
Checking package Loader
Checking package ODBC
Checking package Messages
Checking package JDBC
Successfully done
> xuser list
-----------------------------------------------------------------
XUSER Entry 1
--------------
Key :DEFAULT
Username :SAPSID
UsernameUCS2 :S.A.P.S.I.D. . . . . . . . . . . . . . . . . . . . . . . . . . .
Password :?????????
PasswordUCS2 :?????????
Long Password :?????????
Dbname :SID
Nodename :bigmama
Sqlmode :SAPR3
Cachelimit :-1
Timeout 0
Isolation 0
Charset :<unspecified>
-----------------------------------------------------------------
XUSER Entry 2
--------------
Key :w
Username :SUPERDBA
UsernameUCS2 :S.U.P.E.R.D.B.A. . . . . . . . . . . . . . . . . . . . . . . . .
Password :?????????
PasswordUCS2 :?????????
Long Password :?????????
Dbname :SID
Nodename :bigmama
Sqlmode :SAPR3
Cachelimit :-1
Timeout 0
Isolation 0
Charset :<unspecified>
-----------------------------------------------------------------
XUSER Entry 3
--------------
Key :c
Username :CONTROL
UsernameUCS2 :C.O.N.T.R.O.L. . . . . . . . . . . . . . . . . . . . . . . . . .
Password :?????????
PasswordUCS2 :?????????
Long Password :?????????
Dbname :SID
Nodename :bigmama
Sqlmode :SAPR3
Cachelimit :-1
Timeout 0
Isolation 0
Charset :<unspecified>
-----------------------------------------------------------------
XUSER Entry 4
--------------
Key :c_J2EE
Username :CONTROL
UsernameUCS2 :C.O.N.T.R.O.L. . . . . . . . . . . . . . . . . . . . . . . . . .
Password :?????????
PasswordUCS2 :?????????
Long Password :?????????
Dbname :SID
Nodename :bigmama
Sqlmode :SAPR3
Cachelimit :-1
Timeout 0
Isolation 0
Charset :<unspecified>
Hi,
please check whether you can reach the database.
From the server where Database Studio is installed execute
c:\sapdb\clients\DatabaseStudio\bin\x_ping -d <database> -n <servername>.
Or on you server, where MaxDB is installed execute:
/sapdb/<id>/db/bin/x_ping localhost.
Please tell us the result.
Regards,
Barbara
x_ping -d SID -n bigmama
Pinging SID on bigmama with 512 bytes of data over a maximum of 10 hops.
Hop Server
0 XServer
1 SID
SID: reply time=904us
SID: reply time=653us
SID: reply time=552us
SID: reply time=502us
SID: reply time=533us
SID: 'UNKNOWN'
Approximate round trip times:
Minimum = 502us, Maximum = 904us, Average = 628us
x_ping localhost
Checking connection to 'localhost' ... ok.
Version of Server is
----------------------------------------------------------
UNKNOWN
----------------------------------------------------------
This looks good.
Does DB Studio still show an error?
If you still see the error in DB Studio, try the following check on java level.
1. On the windows server, where Database Studio is installed, search for sapdbc.jar. It could be under c:\sapdb\clients\SID\runtime\jar
2. cd \sapdb\clients\DatabaseStudio
3. java -jar C:\sapdb\clients\SID\runtime\jar\sapdbc.jar -d SID -n 192.168.10.100:7210 -u <superdba>,<pwd> -a db_state
Assuming that 192.168.10.100 is still the bigmama server.
4. On the AIX server execute:
x_cons SID show act
What are the results of 3. andl 4.?
Regards,
Barbara
Alright Barbara,
this helped me to clarify and find the root cause:
X:\>java -jar C:\sapdb\clients\DatabaseStudio\eclipse\plugins\com.sap.sdb.tools.library_7.9.8.v201511201922\li
b\sapdbc.jar -d SID -n 192.168.10.100:7210 -u superdba,admin -a db_state
<DBMException -24950 ERR_USRFAIL User authorization failed>
at com.sap.dbtech.powertoys.DBMException.create(DBMException.java:113)
at com.sap.dbtech.powertoys.DBM.processCompressionResult(DBM.java:751)
at com.sap.dbtech.powertoys.DBM.cmdCompressed(DBM.java:442)
at com.sap.dbtech.powertoys.DBM.cmd(DBM.java:366)
at com.sap.dbtech.util.security.AuthenticationManager.<init>(AuthenticationManager.java:78)
at com.sap.dbtech.powertoys.DBM.userLogonNewStyle(DBM.java:293)
at com.sap.dbtech.powertoys.DBM.userLogon(DBM.java:260)
at com.sap.dbtech.powertoys.DBM.cmdCompressed(DBM.java:404)
at com.sap.dbtech.powertoys.DBM.cmd(DBM.java:366)
at com.sap.dbtech.jdbc.DriverSapDB.main(DriverSapDB.java:671)
The admin had firewall enabled and port was locked. After proper configuration system came up with a reply
X:\>java -jar C:\sapdb\clients\DatabaseStudio\eclipse\plugins\com.sap.sdb.tools.library_7.9.8.v201511201922\li
b\sapdbc.jar -d SID -n 192.168.10.100:7210 -u superdba,admin -a db_state
State
ADMIN
Thanks so much!
User | Count |
---|---|
84 | |
24 | |
11 | |
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.