Sybase on CLUSTERPRO for Linux HowTo 1 2006 2 6-1-
... 3... 4... 5... 7 DB... 8 DB... 9... 10 DB... 11 DB... 12 CLUSTERPRO... 13... 20-2-
Sybase Adaptive Server Enterprise Red Hat Enterprise Linux AS3 Update5 CLUSTERPRO SE for Linux 3.1-5 Sybase Adaptive Server Enterprise 12.5.2 Sybase DB Sybase http://www.sybase.co.jp/ Sybase http://www.sybase.co.jp/product/manuals/index.html -3-
(1) 2 : SYB01 SYB02 : AS01 CLUSTER /dev/sdb1 /dev/sdb2 SYB01 : /mnt/sdb2 Adaptive : /dev/sdb1 AS01 DB : /dev/sdb2 SYBDB01 SYB02 AS01 Master (2) 2 : 1 SYB01 2 SYB02 AS01 AS02 : CLUSTER /dev/sdb1 SYB01 SYB02 1 /dev/sdb2 2 /dev/sdb3 : /dev/sdb1 /dev/sdb2 /mnt/sdb2 /dev/sdb3 /mnt/sdb3 /dev/sdb2 AS01 Adaptive : /dev/sdb3 Master DB 1 AS01 AS02 DB 2 AS02 Master DB : AS01 DB SYBDB01 AS02 DB SYBDB02-4-
[ ] 3-1. sybase groupadd sybase useradd -g sybase sybase passwd sybase 3-2. /opt/sybase mkdir /opt/sybase chown sybase:sybase /opt/sybase 3-3. sybase row NEC Sybase mkdir /mnt/sdb2 mount /dev/sdb2 /mnt/sdb2 chown sybase:sybase /mnt/sdb2 mkdir /mnt/sdb2 mkdir /mnt/sdb3 mount /dev/sdb2 /mnt/sdb2 mount /dev/sdb3 /mnt/sdb3 chown sybase:sybase /mnt/sdb2 chown sybase:sybase /mnt/sdb3 CLUSTERPRO -5-
3-4. /sbin/sysctl -w kernel.shmmax=67108864 64MB(=67108864) /etc/init.d/boot.local 5. 3-5. sybase sybase GUI XWindow 4. 7. SYB01: 4. 5. 6. 7. SYB02: 4. 5. 6. 7. 4. 6. -6-
================================================== CD CD-ROM $ mount /mnt/cdrom /media/cdrom CD-ROM setup $ /mnt/cdrom/setup 1 GUI Install Shield /opt/sybase Typical 1 GUI Sybase -7-
DB DB Adaptive XP 4 DB (1) (2) Adaptive Adaptive (1) Adaptive Adaptive (2) (3) DB DB Sybase ASE 12.5 AS01 /opt/sybase/interfaces /opt/sybase/ase-12_5/ AS01.cfg /opt/sybase/ase-12_5/install/run_ AS01 /opt/sybase/ase-12_5/install/run_ AS01_bak Note: DB interfaces CLUSTERPRO IP /etc/hosts interfaces -8-
DB DB isql SQL isql DB DB 8-1. $. /opt/sybase/sybase.sh $ isql -Usa -P -SAS01 1> SQL DB 1> create database SYBDB01 2> go DB 1> use SYBDB01 2> go connect -9-
================================================== CD CD-ROM $ mount /mnt/cdrom /media/cdrom CD-ROM setup $ /mnt/cdrom/setup 2 GUI Install Shield /opt/sybase Typical 2 GUI Sybase -10-
DB DB Adaptive XP 4 DB (1) (2) Adaptive (1) Adaptive DB (2) DB (3) DB DB Sybase ASE 12.5 AS02 /opt/sybase/interfaces /opt/sybase/ase-12_5/as01.cfg /opt/sybase/ase-12_5/install/run_ AS02 /opt/sybase/ase-12_5/install/run_ AS02_bak (4) DB 8-4. DB Note: DB interfaces CLUSTERPRO IP /etc/hosts interfaces -11-
DB DB isql SQL isql DB DB 8-1. $. /opt/sybase/sybase.sh $ isql -Usa -P -SAS02 1> SQL DB 3> create database SYBDB02 4> go DB 3> use SYBDB02 4> go connect DB -12-
CLUSTERPRO 7-1. Sybase Sybase exec pid 7-2. CLUSTERPRO Sybase DB -13-
(1) start.sh! /bin/sh *************************************** * start.sh * *************************************** correct the installation path of Sybase. /opt/sybase/sybase.sh if [ "$CLP_EVENT" = "START" ] if [ "$CLP_DISK" = "SUCCESS" ] echo "NORMAL1" if [ "$CLP_SERVER" = "HOME" ] echo "NORMAL2" echo "ON_OTHER1" data +"%Y/%m/%d %T" echo "Sybase ASE start" correct the sybase account and the install path of ASE su sybase c. ${SYBASE}/SYBASE.sh; startserver f \ {SYBASE}/${SYBASE_ASE}/install/RUN_ AS01 > /dev/null 2>&1 & sleep 10 echo "ERROR_DISK from START" -14-
elif [ "$CLP_EVENT" = "FAILOVER" ] if [ "$CLP_DISK" = "SUCCESS" ] echo "FAILOVER1" if [ "$CLP_SERVER" = "HOME" ] echo "FAILOVER2" echo "ON_OTHER2" data +"%Y/%m/%d %T" echo "Sybase ASE start" correct the sybase account and the install path of ASE su sybase c. ${SYBASE}/SYBASE.sh; startserver f \ {SYBASE}/${SYBASE_ASE}/install/RUN_ AS01 > /dev/null 2>&1 & sleep 10 echo "ERROR_DISK from FAILOVER" echo "NO_CLP" echo "EXIT" exit 0-15-
(2) stop.sh! /bin/sh *************************************** * stop.sh * *************************************** correct the installation path of Sybase. /opt/sybase/sybase.sh if [ "$CLP_EVENT" = "START" ] if [ "$CLP_DISK" = "SUCCESS" ] echo "NORMAL1" if [ "$CLP_SERVER" = "HOME" ] echo "NORMAL2" echo "ON_OTHER1" date +"%Y/%m/%d %T" echo "Sybase ASE stop" correct the path of shutdown script for ASE dataserver shutdown=/home/sybase/shutdown correct the server name of ASE data server su - sybase -c ". ${SYBASE}/SYBASE.sh; isql -S AS01 -U sa -P -i $shutdown" sleep 10 echo "ERROR_DISK from START" -16-
elif [ "$CLP_EVENT" = "FAILOVER" ] if [ "$CLP_DISK" = "SUCCESS" ] echo "FAILOVER1" if [ "$CLP_SERVER" = "HOME" ] echo "FAILOVER2" echo "ON_OTHER2" date +"%Y/%m/%d %T" echo "Sybase ASE stop" correct the path of shutdown script for ASE dataserver shutdown=/home/sybase/shutdown sleep 10 correct the server name of ASE data server su - sybase -c ". ${SYBASE}/SYBASE.sh; isql -S AS01 -U sa -P -i $shutdown" sleep 10 echo "ERROR_DISK from FAILOVER" echo "NO_CLP" echo "EXIT" exit 0 shutdown /home/sybase/shutdown SQL shutdown go -17-
(3) start.sh!/bin/sh *************************************** * start.sh * *************************************** correct the install path of syb and the library pass. /opt/sybase/sybase.sh export LD_LIBRARY_PATH=/opt/sybase/OCS-12_5/lib if [ "$CLP_EVENT" = "START" ] if [ "$CLP_DISK" = "SUCCESS" ] echo "NORMAL1" if [ "$CLP_SERVER" = "HOME" ] echo "NORMAL2" echo "ON_OTHER1" correct or add the prameters, server naem, databsyb name, etc... clp_sybmon sybwatch -d SYBDB01 -s AS01 -u sa -i 10 -r 10 -c 2 echo "ERROR_DISK from START" elif [ "$CLP_EVENT" = "FAILOVER" ] if [ "$CLP_DISK" = "SUCCESS" ] echo "FAILOVER1" if [ "$CLP_SERVER" = "HOME" ] echo "FAILOVER2" echo "ON_OTHER2" correct or add the prameters, server naem, databsyb name, etc... clp_sybmon sybwatch -d SYBDB01 -s AS01 -u sa -i 10 -r 10 -c 2 echo "ERROR_DISK from FAILOVER" echo "NO_CLP" echo "EXIT" exit 0-18-
(4) stop.sh! /bin/sh *************************************** * stop.sh * *************************************** correct the library pass export LD_LIBRARY_PATH=/opt/sybase/OCS-12_5/lib if [ "$CLP_EVENT" = "START" ] if [ "$CLP_DISK" = "SUCCESS" ] echo "NORMAL1" if [ "$CLP_SERVER" = "HOME" ] echo "NORMAL2" echo "ON_OTHER1" correct the watch id clp_sybmon sybwatch -stop echo "ERROR_DISK from START" elif [ "$CLP_EVENT" = "FAILOVER" ] if [ "$CLP_DISK" = "SUCCESS" ] echo "FAILOVER1" if [ "$CLP_SERVER" = "HOME" ] echo "FAILOVER2" echo "ON_OTHER2" correct the watch id clp_sybmon sybwatch -stop echo "ERROR_DISK from FAILOVER" echo "NO_CLP" echo "EXIT" exit 0-19-
8-1. DB $ /opt/sybase/ase-12_5/install/startserver f /opt/sybase/ase-12_5/install/run_as01 8-2. DB $ /opt/sybase/ase-12_5/install/showserver 8-3. DB isql 1> shutdown 2> go $ isql -Usa -P -SMyServer -i /home/sybase/shutdown /home/sybase/shutdown shutdown go 8-4. DB $ srvbuild GUI DB 1024 768 $. /opt/sybase/sybase.sh Sybsystemprocs device path DB 8-5. SA System Administrator sa Sybase sa null DB isql 1> sp_password OldPass, NewPass 2> go sa OldPass null 1> sp_password null, NewPass 2> go -20-