Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Could not start database server after changing the IP address

SOLVED
Go to solution
Ahmad Munawwar
Frequent Advisor

Could not start database server after changing the IP address

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
8 REPLIES
John Palmer
Honored Contributor

Re: Could not start database server after changing the IP address

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
Honored Contributor

Re: Could not start database server after changing the IP address

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

take your time and think things through
Ahmad Munawwar
Frequent Advisor

Re: Could not start database server after changing the IP address

Reattached the file.
steven Burgess_2
Honored Contributor

Re: Could not start database server after changing the IP address

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

take your time and think things through
Ahmad Munawwar
Frequent Advisor

Re: Could not start database server after changing the IP address

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
Honored Contributor

Re: Could not start database server after changing the IP address

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
take your time and think things through
Kawah Cheung
Advisor
Solution

Re: Could not start database server after changing the IP address

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
If in doubt, ask!
Ahmad Munawwar
Frequent Advisor

Re: Could not start database server after changing the IP address

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