Q

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 127.0.0.1 netmask ff000000 hme0: flags=863<UP,BROADCAST,NOTRAILERS,RUNNING,MULTICAST> mtu 1500 inet 165.47.202.245 netmask ffffff80 broadcast 165.47.202.255 hme1: flags=863<UP,BROADCAST,NOTRAILERS,RUNNING,MULTICAST> mtu 1500 inet 165.47.88.33 netmask ffffff00 broadcast 165.47.88.255

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


This was first published in February 2004

Dig deeper on Introduction to Linux system administration

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataCenter

SearchServerVirtualization

SearchCloudComputing

SearchEnterpriseDesktop

Close