cancel
Showing results for 
Search instead for 
Did you mean: 

Using Windows based Database Studio to manage Maxdb on Unix

former_member323185
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member

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

former_member323185
Participant
0 Kudos

Hi Christiane,

Thanks for the help. I can connect with DB Studio now.

Regards,

Lim

former_member188065
Participant
0 Kudos

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>

0 Kudos

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

former_member188065
Participant
0 Kudos

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

----------------------------------------------------------

0 Kudos

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

former_member188065
Participant
0 Kudos

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!

0 Kudos

Thanks for the good news. 

Best regards,
Barbara

Answers (0)