Unable to start MaxDB on NW04s test drive

[Former Member]

Hi all,

I got the following error when a trying to start the database after installing NW04s test drive:

n4shost:n4sadm 2> dbmcli -U c db_warm

Error! Connection failed to node n4shost for database N4S: cannot connect to server socket

The startdb.log entries as follow:

-

---

Wed Nov 24 18:14:02 SGT 2010

LOGFILE FOR STARTING DATABASE

Trying to start database ...

-

---

Wed Nov 24 18:14:02 SGT 2010

Checking required environment variables

SAPSYSTEMNAME is >N4S<

Start database with xuserkey >c<

-

---

Wed Nov 24 18:14:02 SGT 2010

Connect to the database to check the database state

dbmcli: connect check finished with return code: 0

Database not available

-

---

Wed Nov 24 18:20:20 SGT 2010

Starting XServer

12916 XSERVER Found other running x_server with version 'X64/LINUX 7.6.00

Build 018-123-119-055'

12902 XSERVER started, 'already...'

-

---

Wed Nov 24 18:20:20 SGT 2010

Starting database

Starting Database Instance...

Error! Connection failed to node n4shost for database N4S: cannot connect to ser

ver socket

Opening Database...

-

---

Wed Nov 24 18:29:06 SGT 2010

/usr/sap/N4S/SYS/exe/run/startdb was killed or interrupted. Terminating.

Regards,

Lim

[Former Member]

Can you please check the knldiag from your database RUNDIRECTORY.

Or you can also check the logs via database manager software of your database.

[Former Member]

Hi

All the entries in the krndiag file under /sapdb/data/wrk/NS4 are dated 2006. There are no new entries in the krndiag.

Rdgs

[Former Member]

can you please try to start your database manually using command line or database manager.

dbmcli -d <DBSID> -u, <user,password>

db_enum (to get the current status)

db_start (to start your database)

[Former Member]

Problem resolved after converting the virtual host created during installation to a physical host and assign a static IP to the network interface instead of DHCP.

[Former Member]

I am having the same problem. I am at the istallation stage. I have first to start the DB to register my license. I have SLES 10.

Before installation I added line: 192.168.1.127 carlos-lap carlos-lap , as per instructions in the installation page. 192.168.1.127 is my IP address that communicates with my router.

How should I modify my host file?

I know that 192.168.155.1 doesn't exist (created at installation)

• host file **************

127.0.0.1 localhost

192.168.1.127 carlos-lap carlos-lap

1. special IPv6 addresses

::1 localhost ipv6-localhost ipv6-loopback

fe00::0 ipv6-localnet

ff00::0 ipv6-mcastprefix

ff02::1 ipv6-allnodes

ff02::2 ipv6-allrouters

ff02::3 ipv6-allhosts

127.0.0.2 linux-jltu.site linux-jltu

192.168.155.1 n4shost

**************************

Thanks in advance

Carlos Gonzalez

Edited by: Carlos Gonzalez on Dec 31, 2010 6:10 AM

Edited by: Carlos Gonzalez on Dec 31, 2010 6:11 AM

Edited by: Carlos Gonzalez on Dec 31, 2010 6:19 AM

[Former Member]

Hi,

All I did was to change the /etc/hosts file. I comment off 192.168.155.1 and insert my own IP. Below is my hosts file:

1. Do not remove the following line, or various programs

2. that require network functionality will fail.

127.0.0.1 localhost.localdomain localhost

::1 localhost6.localdomain6 localhost6

10.0.1.2 n4shost.localdomain n4shost

1. 192.168.155.1 n4shost

10.0.1.2 is my static IP.

Hope this helps.

Regards,

Lim