Problem solve Get help with specific problems with your technologies, process and projects.

Changing the IP address

We are running Sybase 11.9 on a Sun Solaris server. We are planning to change our networking and IP address. From the Sybase and Sun end, what changes are required?

This should not be too difficult. As you know Sybase is built on client-server architecture, and in that respect, all you need to do is changing the IP address of the host (which I trust will be done by a Unix guy), and you as a Sybase DBA updating the required entry for that server in the "interfaces" files.

Before changing the IP address, I suggest that you shut down Sybase and the backup server and anything else Sybase-related on that host. After the change of the host's IP address first time, make sure that Sybase is not started automatically at the host start-up time via the entry in /ect/init.d.

Once the host is back and the new IP address is allocated, do the following on the command line:

 /usr/sbin/ifconfig -a lo0: flags=849<UP,LOOPBACK,RUNNING,MULTICAST> mtu 8232 inet netmask ff000000 hme0: flags=863<UP,BROADCAST,NOTRAILERS,RUNNING,MULTICAST> mtu 1500 inet netmask ffffff80 broadcast hme1: flags=863<UP,BROADCAST,NOTRAILERS,RUNNING,MULTICAST> mtu 1500 inet netmask ffffff00 broadcast

For example, the above host has two IP addresses. Your best bet is not to use the IP address in the interfaces file but use the logical network name of the host. Use Sybase's "dsedit" facility under $SYBASE/bin to modify the Sybase name of the ASE, the backup server and so on with the new name/IP address. Also update the same on any other interfaces file that makes a reference to this host. If you are an experienced DBA just use vi to paste the new entry in the interfaces files. PC users should update their sql.ini file etc. Note that here you are only changing the IP address. The Port No will remain the same. Once all is OK on the host, then you can start Sybase. Should be fairly straightforward. Good luck.


For More Information

Dig Deeper on Linux servers