Many errors that occur using the Cluster Edition result from configuration problems in the cluster environment. Sybase recommends that before you configure your cluster:
Verify that you have set your environment variables by sourcing the SYBASE.csh or SYBASE.sh file located in $SYBASE.
Run dataserver -v from each node to verify that all required libraries are installed on the host.
If any system libraries are missing, you see an operating system error, and the data server version number does not appear. Correct this problem before proceeding. If dataserver displays the version string without error, you can assume that all required system libraries are installed.
Verify that each node in the cluster can read from and write to each database device. Use the operating system ls -l command to test whether you are able to read from and write to the devices using the dd operating system utility.
To test the readability of a device:
dd if=<device path> of=/dev/null count=x
You should get a result similar to:
%dd if=/dev/raw/raw123 of=/dev/null count=10 10+0 records in 10+0 records out
You can use the dd utility to test the writeability of your devices as well. However, you should do this only if there is no data in the devices to preserve.
Run the ping utility to verify connectivity among all nodes. From each node, attempt to ping the host name or network address of every other node. Do this for each network to be used. For example, if your configuration uses a public and two private networks, verify that ping succeeds for all combinations of node and network address.
Use the sybcluster 'show cluster config' parameter to determine the private interconnect addresses used by each instance. For example, if your cluster contains nodes node1 and node2, sybcluster displays information similar to this:
SYBCE> show cluster config ** Cluster configuration for "SYBCE" ** Interface Path "/sybce" Trace Flags: There were are no trace flags. Maximum Instances "4" Quorum "/dev/raw/raw23" Master Device "/dev/raw/ra24" logfile INSTANCE1 /sybce/ASE15_0/install/GATEST_INSTANCE1.log run_parameters INSTANCE1 logfile INSTANCE2 /sybce/ASE-15_0/install/GATEST_INSTANCE2.log run_parameters INSTANCE2 Primary Interconnect "udp" Server[1] INSTANCE1 node1_priv 49152 49171 Server[2] INSTANCE2 node2_priv 49172 4919
This cluster includes interconnect network addresses node1_priv
and node2_priv
.
From node1, execute ping node2_priv to
verify that the address of the private network on node2 is accessible
from node1. From node2, execute ping node1_priv to
verify that the private network on node1 can be reached from node2.
If the ping command fails or error messages indicate a problem with the private network, check:
The information contained in the /etc/hosts file
The condition of the network cables, routers, or switches used by the private networks
The names or IP addresses specified in the cluster configuration reported by the sybcluster “show cluster config” command