Sybase on CLUSTERPRO for Linux HowTo

Size: px

Start display at page:

Download "Sybase on CLUSTERPRO for Linux HowTo"

さみらこいたばし
4 years ago
Views:

1 Sybase on CLUSTERPRO for Linux HowTo

2 DB... 8 DB DB DB CLUSTERPRO

3 Sybase Adaptive Server Enterprise Red Hat Enterprise Linux AS3 Update5 CLUSTERPRO SE for Linux Sybase Adaptive Server Enterprise Sybase DB Sybase Sybase -3-

4 (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-

5 [ ] 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-

6 3-4. /sbin/sysctl -w kernel.shmmax= MB(= ) /etc/init.d/boot.local sybase sybase GUI XWindow SYB01: SYB02:

7 ================================================== 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-

8 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-

9 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-

10 ================================================== 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-

11 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-

12 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-

13 CLUSTERPRO 7-1. Sybase Sybase exec pid 7-2. CLUSTERPRO Sybase DB -13-

14 (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-

15 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-

16 (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-

17 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-

18 (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-

19 (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-

20 8-1. DB $ /opt/sybase/ase-12_5/install/startserver f /opt/sybase/ase-12_5/install/run_as 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 $. /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-

Samba_HowTo.doc

Samba_HowTo.doc Samba 3.0.0 on CLUSTERPRO for Linux HowTo 1 Linux Samba CLUSTERPRO for Linux Samba Linux Samba Samba Samba 2 Samba Red Hat Enterprise Linux AS release 3 CLUSTERPRO SE for Linux Ver3.0 Samba 3.0.0-14.3