cancel
Showing results for 
Search instead for 
Did you mean: 

Unknown Host sidhost (see /etc/hosts)

Former Member
0 Kudos

Hi experts,

    I'm facing a problem in maxdb please help us the issue

Error:

starting database instance ...

Error! Connection failed to node devhost for database DEV:

unknown host devhost (see /etc/hosts)

Opening Database...

Error! Connection failed to node devhost for database DEV:

unknown host devhost (see /etc/hosts)

........................

connect to the database to verify the database is now open

dbmcli check finished with return code: 0

database start failed

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi,

Have a look to this link

Hope it helps

BR Vaibhav

Reagan
Advisor
Advisor
0 Kudos

Hello


2014-03-03 17:45:00      14902 INF        283 DBMSrv   Command 'db_offline' is being executed.

2014-03-03 17:45:01      14902 INF        419 DBMSrv   Command 'db_offline' has ended with return code 0.

2014-03-03 17:45:01      14902 INF          2 DBMSrvCo A DBM Server client connection was released (client process has process ID 14900 on computer transids.transaltus.com

These are old log entries and not from today.

Restart the linux machine and then try starting the database.

Regards

RB

Former Member
0 Kudos

Hi everyone,

          I restarted OS but dbm.prt showing like this data only, is there anything to need some other logfiles to send.

Reagan
Advisor
Advisor
0 Kudos

What is the version of MaxDB you are using ?

You need to check the logs generated in the /sapdb/data/wrk directory.

Log Files - SAP Documentation

Regards

RB

former_member188883
Active Contributor
0 Kudos

Hi Adoni,

Please replicate the issue and then share latest logs for

1) knldiag

2) dbm.prt

Regards,

Deepak Kori

srinivasan_vinayagam
Active Contributor
0 Kudos

Dear Adoni,

Which operation system installed MaxDB?

Please entry below line to your server hosts file

If Unix:  /etc/hosts

127.0.0.1     localhost

IPaddress     hostname

If Windows C:\Windows\System32\Drivers\etc\hosts

Thanks & Regards,

V Srinivasan

Former Member
0 Kudos

Hi,

Srinivasan

  

           Thanks for your reply, and we are using RedhatLinux-6 and before it working properly suddenly it got some error and the hosts file is correct as you mentioned

If you want any logs for analysing?

former_member188883
Active Contributor
0 Kudos

Hi Adoni,

Please share dbm.prt log

Regards,

Deepak Kori

Former Member
0 Kudos

Hi Deepak,

                   This is the DBM.PRT log file.

'db_warm' is being executed.

2014-02-28 09:50:00       4993 INF          1 DBMKnl   Sending an administrative statement to the database DEV on computer localhost

                          4993 INF          8 DBMKnl   Statement:  RESTART

2014-02-28 09:50:50       4993 INF          3 DBMKnl   Received the result of an administrative statement from the database DEV on computer localhost

                          4993 INF          9 DBMKnl   Statement:  RESTART

                          4993 INF         10 DBMKnl   Returncode: 0

2014-02-28 09:50:59       4993 INF        419 DBMSrv   Command 'db_warm' has ended with return code 0.

2014-02-28 09:50:59       4993 INF          2 DBMSrvCo A DBM Server client connection was released (client process has process ID 4991 on computer transids.transaltus.com).

2014-02-28 09:59:35       7407 INF          1 DBMSrvCo A DBM Server client connection was established at 2014-02-28 09:59:35 (client process has process ID 7194 on computer transids.transaltus.com).

2014-02-28 09:59:36       7407 INF        283 DBMSrv   Command 'dban_start ...' is being executed.

2014-02-28 10:00:41       7407 INF        419 DBMSrv   Command 'dban_start' has ended with return code 0.

2014-02-28 10:16:57       7407 INF          2 DBMSrvCo A DBM Server client connection was released (client process has process ID 7194 on computer transids.transaltus.com).

2014-02-28 17:55:12      14698 INF          1 DBMSrvCo A DBM Server client connection was established at 2014-02-28 17:55:12 (client process has process ID 14696 on computer transids.transaltus.com).

2014-02-28 17:55:12      14698 INF        283 DBMSrv   Command 'dban_stop' is being executed.

2014-02-28 17:55:14      14698 INF        419 DBMSrv   Command 'dban_stop' has ended with return code 0.

2014-02-28 17:55:14      14698 INF          2 DBMSrvCo A DBM Server client connection was released (client process has process ID 14696 on computer transids.transaltus.com).

2014-02-28 17:55:15      14724 INF          1 DBMSrvCo A DBM Server client connection was established at 2014-02-28 17:55:14 (client process has process ID 14722 on computer transids.transaltus.com).

2014-02-28 17:55:15      14724 INF        283 DBMSrv   Command 'db_cold' is being executed.

2014-02-28 17:55:15      14724 INF          1 DBMKnl   Sending an administrative statement to the database DEV on computer localhost

                         14724 INF          8 DBMKnl   Statement:  SHUTDOWN

2014-02-28 17:55:15      14724 INF          3 DBMKnl   Received the result of an administrative statement from the database DEV on computer localhost

                         14724 INF          9 DBMKnl   Statement:  SHUTDOWN

                         14724 INF         10 DBMKnl   Returncode: 0

2014-02-28 17:55:30      14724 INF        419 DBMSrv   Command 'db_cold' has ended with return code 0.

2014-02-28 17:55:30      14724 INF          2 DBMSrvCo A DBM Server client connection was released (client process has process ID 14722 on computer transids.transaltus.com).

2014-02-28 17:55:30      14769 INF          1 DBMSrvCo A DBM Server client connection was established at 2014-02-28 17:55:30 (client process has process ID 14767 on computer transids.transaltus.com).

2014-02-28 17:55:30      14769 INF        283 DBMSrv   Command 'db_offline' is being executed.

2014-02-28 17:55:32      14769 INF        419 DBMSrv   Command 'db_offline' has ended with return code 0.

2014-02-28 17:55:32      14769 INF          2 DBMSrvCo A DBM Server client connection was released (client process has process ID 14767 on computer transids.transaltus.com).

2014-03-03 09:19:32       4829 INF          1 DBMSrvCo A DBM Server client connection was established at 2014-03-03 09:19:32 (client process has process ID 4827 on computer transids.transaltus.com).

2014-03-03 09:19:32       4829 INF        283 DBMSrv   Command 'db_clear' is being executed.

2014-03-03 09:19:32       4829 INF        419 DBMSrv   Command 'db_clear' has ended with return code 0.

2014-03-03 09:19:32       4829 INF          2 DBMSrvCo A DBM Server client connection was released (client process has process ID 4827 on computer transids.transaltus.com).

2014-03-03 09:19:32       4834 INF          1 DBMSrvCo A DBM Server client connection was established at 2014-03-03 09:19:32 (client process has process ID 4832 on computer transids.transaltus.com).

2014-03-03 09:19:32       4834 INF        283 DBMSrv   Command 'db_start' is being executed.

2014-03-03 09:19:47       4834 INF        419 DBMSrv   Command 'db_start' has ended with return code 0.

2014-03-03 09:19:47       4834 INF          2 DBMSrvCo A DBM Server client connection was released (client process has process ID 4832 on computer transids.transaltus.com).

2014-03-03 09:19:47       4879 INF          1 DBMSrvCo A DBM Server client connection was established at 2014-03-03 09:19:47 (client process has process ID 4877 on computer transids.transaltus.com).

2014-03-03 09:19:47       4879 INF        283 DBMSrv   Command 'db_warm' is being executed.

2014-03-03 09:19:47       4879 INF          1 DBMKnl   Sending an administrative statement to the database DEV on computer localhost

                          4879 INF          8 DBMKnl   Statement:  RESTART

2014-03-03 09:20:41       4879 INF          3 DBMKnl   Received the result of an administrative statement from the database DEV on computer localhost

                          4879 INF          9 DBMKnl   Statement:  RESTART

                          4879 INF         10 DBMKnl   Returncode: 0

2014-03-03 09:20:50       4879 INF        419 DBMSrv   Command 'db_warm' has ended with return code 0.

2014-03-03 09:20:50       4879 INF          2 DBMSrvCo A DBM Server client connection was released (client process has process ID 4877 on computer transids.transaltus.com).

2014-03-03 09:39:11       7414 INF          1 DBMSrvCo A DBM Server client connection was established at 2014-03-03 09:39:10 (client process has process ID 7098 on computer transids.transaltus.com).

2014-03-03 09:39:11       7414 INF        283 DBMSrv   Command 'dban_start ...' is being executed.

2014-03-03 09:40:01       7414 INF        419 DBMSrv   Command 'dban_start' has ended with return code 0.

2014-03-03 09:41:13       7414 INF          2 DBMSrvCo A DBM Server client connection was released (client process has process ID 7098 on computer transids.transaltus.com).

2014-03-03 17:44:38      14827 INF          1 DBMSrvCo A DBM Server client connection was established at 2014-03-03 17:44:38 (client process has process ID 14825 on computer transids.transaltus.com).

2014-03-03 17:44:38      14827 INF        283 DBMSrv   Command 'dban_stop' is being executed.

2014-03-03 17:44:40      14827 INF        419 DBMSrv   Command 'dban_stop' has ended with return code 0.

2014-03-03 17:44:40      14827 INF          2 DBMSrvCo A DBM Server client connection was released (client process has process ID 14825 on computer transids.transaltus.com).

2014-03-03 17:44:40      14853 INF          1 DBMSrvCo A DBM Server client connection was established at 2014-03-03 17:44:40 (client process has process ID 14851 on computer transids.transaltus.com).

2014-03-03 17:44:40      14853 INF        283 DBMSrv   Command 'db_cold' is being executed.

2014-03-03 17:44:40      14853 INF          1 DBMKnl   Sending an administrative statement to the database DEV on computer localhost

                         14853 INF          8 DBMKnl   Statement:  SHUTDOWN

2014-03-03 17:44:44      14853 INF          3 DBMKnl   Received the result of an administrative statement from the database DEV on computer localhost

                         14853 INF          9 DBMKnl   Statement:  SHUTDOWN

                         14853 INF         10 DBMKnl   Returncode: 0

2014-03-03 17:45:00      14853 INF        419 DBMSrv   Command 'db_cold' has ended with return code 0.

2014-03-03 17:45:00      14853 INF          2 DBMSrvCo A DBM Server client connection was released (client process has process ID 14851 on computer transids.transaltus.com).

2014-03-03 17:45:00      14902 INF          1 DBMSrvCo A DBM Server client connection was established at 2014-03-03 17:45:00 (client process has process ID 14900 on computer transids.transaltus.com).

2014-03-03 17:45:00      14902 INF        283 DBMSrv   Command 'db_offline' is being executed.

2014-03-03 17:45:01      14902 INF        419 DBMSrv   Command 'db_offline' has ended with return code 0.

2014-03-03 17:45:01      14902 INF          2 DBMSrvCo A DBM Server client connection was released (client process has process ID 14900 on computer transids.transaltus.com).

srinivasan_vinayagam
Active Contributor
0 Kudos

Dear Adoni,

Please attach the log.

former_member188883
Active Contributor
0 Kudos

Hi Adoni,

Please check the entries from /etc/hosts file on your server. It should have correct IP and hostname for the MaxDB database.

Regards,

Deepak Kori