No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

Failure to Start the Sybase Database Because the IP Address of Sun Workstation Is Changed

Publication Date:  2012-07-25 Views:  2 Downloads:  0
Issue Description
A WDM NMS is deployed in an office and the configuration of the WDM NMS is as follows:
Sun workstation: T5220 server
Solaris OS version: 5.10
Patch version: 5.10 Generic_141414-07
U2000 version: V100R002C01SPC001
Software version of the OptiX OSN 8800: 5.51.05.35
A user mistakenly changes the system IP address as user root on a terminal. As a result, the Sybase database and U2000 fail to be started after the server is restarted. The user runs the ifconfig -a command as user root on the terminal to query the network address of the system. The returned address is 127.0.0.1. 
Alarm Information
The U2000 client displays the message "failed to connect to the server".
Handling Process
Based on the preceding analysis, log in to the OS as user root, open a CLI window, and run the sys-unconfig command. The system starts reconfiguring the network. Follow prompts to reconfigure the network and set the system network address and host name.
After configuration, run the reboot command to restart the OS. After the OS is restarted, log in to the OS as user root, open a CLI window, and run the ifconfig -a command. It is found that the displayed network address is the set IP address.
View contents in the hosts file in opt/etc/ and in the DBSVR.cfg file in /opt/sybase/ASE-*. It is found that IP addresses ahead of host names are the set IP address.
Start the U2000 client and enter the user name and password to log in to the U2000 client. The U2000 client connects to the U2000 server successfully. 
Root Cause
After confirmation with the user, the user mistakenly changes the system IP address as user root. acid results in the failure to start the system database. Some files in the system database are bound to the system network address. After the user changes the system network address, the IP addresses ahead of host names in the hosts file in opt/etc/ and in the DBSVR.cfg file in /opt/sybase/ASE-* are not changed. As a result, the system database fails to be started.
Suggestions
sys-unconfig is a reconfiguration command. The command execution process is an initialization process. The command is described as follows:
Name
sys-unconfig - undo a system's configuration
Synopsis
/usr/sbin/sys-unconfig
Description
The sys-unconfig command is used to restore a system's configuration to an "as-manufactured" state, ready to be reconfigured again. The system's configuration consists of host name, network information service (NIS) domain name, timezone, IP address, IP subnet mask, and root password.
This operation is the inverse of those performed by the sysidnet(1M), sysidns(1M), and sysidsys(1M) programs run at boot. See sysidtool(1M).
The functions of the sys-unconfig command are described in the manual.
The sys-unconfig command has the following functions:
o    Saves current /etc/inet/hosts file information in /etc/inet/hosts.saved.
o    If the current /etc/vfstab file contains NFS mount entries, saves the /etc/vfstab file to /etc/vfstab.orig.
o    Restores the default /etc/inet/hosts file.
o    Removes the default hostname in /etc/hostname.interface files for all interfaces configured when this command is run. To determine which interfaces are configured, run the command 'ifconfig-a'. The /etc/hostname.interface files corresponding to all of the interfaces listed in the resulting output, with the exception of the loopback interface (lo0), will be removed.
o    Removes the defaultdomainname in /etc/defaultdomain.
o    Restores the timezone to PST8PDT in /etc/TIMEZONE.
o    Disables the network information service (NIS) and network information service plus (NIS+) if either NIS or NIS+ was configured.
o    Removes the file /etc/inet/netmasks.
o    Removes the file /etc/defaultrouter.
o    Removes the password set for user root in /etc/shadow.
o    Removes the file /etc/.rootkey.
o    Executes all system configuration applications.
These applications are defined by prior executions of a sysidconfig -a application. (See sysidconfig(1M)). When sys-unconfig is run, all system configuration applications are passed one argument, -u.
o    Removes the file /etc/resolv.conf.
o    Removes the file /etc/sysidcfg.
o    Disables LDAP by removing /var/ldap/ldap_client_cache, /var/ldap/ldap_client_file, /var/ldap/ldap_client_cred, /var/ldap/cachemgr.log.
o    Regenerates keys for sshd(1M).
When sys-unconfig is finished, it performs a system shutdown. sys-unconfig is a potentially dangerous utility and can only be run by the super user.
The sys-unconfig command can cause severe consequences. It is not recommended that you use the command rashly. If you need to change the system network address, it is recommended that you change the system network address in the MSuite and restart the system. In this manner, relevant files in the system are changed accordingly and the normal start of the database is not affected. 

END