MaxDB instance not able to connect through DBM tool

[Former Member]

Hello,

We are facing very critical problem. MaxDB database instance is not able to connect from Database Manager tool. I tried everything. DB instance is down.

I stopped apache ,DB instance then x_server. Then I started x_server , apache but when I 'm trying to connect MaxDB instance, getting "-4 connection refused". "Server refused the connection".

I checked everything User password are Ok(superdba, control). I tried by rebooting server too.

Could anybody please help me out if faced this problem.

Earlier everything working fine. But now It 's not able to connect through DBM tool.

Any help would of great help..

Tks

Anju

[former_member229109 · Accepted solution]

Hi Anju,

Please post also xserver_*.prt located in /sapdb/data/wrk on the database server.

And update with additional information:

/sapdb/programs/bin/sdbregview -l

/sapdb/programs/bin/dbmcli db_enum -s

/sapdb/programs/bin/dbmcli inst_enum

/sapdb/programs/bin/xinstinfo

Thank you and best regards, Natalia Khlopina

[Former Member · Accepted solution]

Hello,

Thanks you very much for your help. I corrected the problem. There was some permission problem.

now it 's working fine. But there is another problem, now when I 'm linking this to my ECC sandbox system. I configured all settings in CSADMIN in ECC sandbox.

But when I 'm running report RSCMST in Sandbox sysem it shows me some time difference -223 seconds.

I checked time is OK in sandbox. But there is time difference on content server.

Could you help me out how to correct time on content server. This is AIX 5.3.

I checked from smitty but could you please post the steps..

Tks

Anju

[lbreddemann]

Hi Anju,

looks like you misentered the connection details.

Please try the following to check where/what went wrong:

- ping <hostname of db server>
 - x_ping -n <hostname of db server> -d <DBSID>
 - dbmcli -n <hostname of db server> -d <DBSID> -u superdba,<pw>

regards,

Lars

[Former Member]

Hello,

Tks for reply..when I execute x_ping -n -d getting following message :

sdb@mtlcmstby01(/sapdb/programs/bin) $ x_ping -n -d

Checking connection to 'ERR 11377 CONNECT TCP/IP host name '-d' not found

-d' ... ERROR

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Error: unknown host -d (see /etc/hosts)

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

But I cehcked in my /etc/hosts entry is there for host.

Tks

Anju

[lbreddemann]

Hi Anju,

please re-read what I wrote.

I didn't ask you to run

x_ping -n -d

but instead

x_ping -n <hostname of database server> -d <DBSID>

You've to fill in the correct values for

<hostname of database server>

and

<DBSID>

regards,

Lars