Could not start database server after changing the IP address

[Ahmad Munawwar]

Hi,

I got problem to bring up database server after changing the IP address of the machine.

My system spec:
HP-UX 10.xx
Sybase 11.0

Appreciate if someone can assist me. Pleas refer to file attached.

Regards,
Munawwar

[John Palmer]

Hi,

What did you do when you 'changed the IP address'?

I don't know sybase but from your log it seems that the network listener wants to bind to the IP name 'xmmas' which appears to be the hostname.

It looks as though 'xmmas' doesn't resolve to an IP address on the server. Have you amended /etc/hosts (or DNS) to reflect the IP address change?

Regards,
John

[steven Burgess_2]

Hello

Not exactly sure, but will ask fundamental questions

Where have you changed the address ?

If you are using dns, have run the commands to update the database files

hosts_to_named -f param
sig_named restart

How is your /etc/nsswitch.conf file set to when resolving addresses to hosts

Regards

Steve

[Ahmad Munawwar]

Reattached the file.

[steven Burgess_2]

Hi

Sorry if I miss something in you second posting

If running dns, try the following command and check if the host is being resolved properly

#nslookup www.xmmas.com

Does the returned address match you new ip ?

Regards

Steve

[Ahmad Munawwar]

Hi steve,

I got the results below

munawwar

############################

root@xmmas> more /etc/hosts
# @(#)hosts $Revision: 1.9.212.1 $ $Date: 95/10/12 19:28:22 $
#
# The form for each entry is:
#
#
# For example:
# 192.1.2.34 hpfcrm loghost
#
# See the hosts(4) manual page for more information.
# Note: The entries cannot be preceded by a space.
# The format described in this file is the correct format.
# The original Berkeley manual page contains an error in
# the format description.
#
150.236.95.1 xmmas
127.0.0.1 localhost loopback
150.236.95.244 xmws01 wshost01 # 080009-9354B8
#150.236.95.244 xmws01 wshost01 # 0060B0-7F7930
#150.236.120.166 kancil wshost02 # 001083-fdff21

root@xmmas> nslookup www.xmmas.com

Default NIS Server: xmmas
Address: 150.236.95.1

*** No address information is available for "www.xmmas.com"
root@xmmas>

[steven Burgess_2]

Hi

Your xmmas is the master NIS server also

Have you updated your

hosts.byname
hosts.byaddr

Using the /var/yp/ypmake command

Regards

Steve

[Kawah Cheung · Accepted solution]

Hi,

The following is an extract from a solved sybase case similar to what you are getting:

*********************************
When trying to bring up Adaptive Server Enterprise, received the following errors in the bootup sequence:

"ninit: bind, Can't assign requested address
ninit: All master network listeners have failed. Shutting down."

Tip or Workaround:
Check the /etc/hosts file to make sure the IP address is correct.
Make sure permissions are set correctly on the /etc/hosts file.
When moving an SQL Server from one machine to another the IP address in the interfaces file needs to change to point to the new machine.

Resolution:
Permissions were found to be incorrect on the /etc/hosts file, changed
permissions and the Server booted correctly.
*********************************

Hope this helps.

Rgds,
Kawah

[Ahmad Munawwar]

Hi all,

Thank you for your help.
The problem was due to wrong ip address in /etc/hosts file. I realised this when check the lan interface with command netstat -i and ifconfig la0. So after changing the ip address and reboot the server, everything goes fine.

Best Regards,
Munawwar