求 sybase 数据库的cluster suite双机脚本

panhua

哪位发一个sybase 数据库的redhat cluster suite双机脚本，学习学习啊！
谢谢了

MichaelBibby

贴一个我自己写的，谨供参考：

1. #!/bin/bash
   
2. 
   
3. # Author: MichaelBibby <[email]michaelbibby@gmail.com[/email]>
   
4. # Date: 2007.06.19
   
5. 
   
6. # chkconfig: 345 78 78
   
7. # description: Normal RC script for SYBASE.
   
8. 
   
9. . /etc/init.d/functions
   
10. 
    
11. SYBASE_USERNAME="sa"
    
12. SYBASE_PASSWORD=""
    
13. 
    
14. export SYBASE_HOME='/opt/sybase-12.5'
    
15. export SYBASE_OCS='OCS-12_5'
    
16. export SYBASE_ASE='ASE-12_5'
    
17. # ************************************************
    
18. # Warnning: Modify the RUN_xxx to fit your need.
    
19. # Your startup script will be such as:
    
20. #   ${SYBASE_HOME}/${SYBASE_ASE}/install/RUN_${SERVER}
    
21. #   ${SYBASE_HOME}/${SYBASE_ASE}/install/RUN_${SERVER_BACKUP}
    
22. export SERVER='SYBASE'
    
23. export SERVER_BACKUP='SYB_BACKUP'
    
24. # For multi-server
    
25. # export SERVER='server1 server2'
    
26. # export SERVER_BACKUP='server1_backup server2_backup'
    
27. # ************************************************
    
28. 
    
29. export LIB="${SYBASE_HOME}/${SYBASE_OCS}/lib"
    
30. export PATH=$PATH:"${SYBASE_HOME}/${SYBASE_ASE}/bin:${SYBASE_HOME}/${SYBASE_ASE}/install:${SYBASE_HOME}/${SYBASE_OCS}/bin"
    
31. 
    
32. start_db()
    
33. {
    
34.     su - sybase -c "${SYBASE_HOME}/${SYBASE_ASE}/install/startserver \
    
35.     -f ${SYBASE_HOME}/${SYBASE_ASE}/install/RUN_${SERVER}"
    
36. 
    
37.     su - sybase -c "${SYBASE_HOME}/${SYBASE_ASE}/install/startserver \
    
38.     -f ${SYBASE_HOME}/${SYBASE_ASE}/install/RUN_${SERVER_BACKUP}"
    
39. }
    
40. 
    
41. stop_db()
    
42. {
    
43.     ${SYBASE_HOME}/${SYBASE_OCS}/bin/isql \
    
44.     -U${SYBASE_USERNAME} \
    
45.     -P${SYBASE_PASSWORD} \
    
46.     -S${SERVER} <<EOF
    
47. shutdown ${SERVER_BACKUP}
    
48. go
    
49. exit
    
50. EOF
    
51. 
    
52.     ${SYBASE_HOME}/${SYBASE_OCS}/bin/isql \
    
53.     -U${SYBASE_USERNAME} \
    
54.     -P${SYBASE_PASSWORD} \
    
55.     -S${SERVER} <<EOF
    
56. use master
    
57. go
    
58. checkpoint
    
59. go
    
60. shutdown  
    
61. go
    
62. exit
    
63. EOF
    
64. 
    
65. if [ X"$?" == X"0" ]; then
    
66.     exit 0
    
67. else
    
68.     exit 1
    
69. fi
    
70. }
    
71. 
    
72. status_db()
    
73. {
    
74.     chk_sybase=$(ps axw --cols 32768 | grep dataserver | grep -v grep | wc -l)
    
75.     if [ X"$chk_sybase" = X"0" ]
    
76.     then
    
77.         echo -n "Checking Master Server: ${SERVER}"
    
78.         echo_failure
    
79.         echo
    
80.     else
    
81.         echo -n "Checking Master Server: ${SERVER_BACKUP}" && echo_success
    
82.     fi
    
83. 
    
84.     chk_sybase_bs=$(ps axw --cols 32768 | grep backupserver | grep -v grep | wc -l)
    
85.     if [ X"$chk_sybase_bs" = X"0" ];then
    
86.         echo -n "Checking Backup Server: ${SERVER_BACKUP}"
    
87.         echo_failure
    
88.         echo
    
89.     else
    
90.         echo -n "Checking Backup Server: ${SERVER_BACKUP}" && echo_success
    
91.     fi
    
92. 
    
93.     exit 0
    
94. }
    
95.    
    
96. 
    
97. case $1 in
    
98.     start) start_db ;;
    
99.     stop)
    
100.         ps aux | grep -i dataserver | grep -v grep >/dev/null
     
101. 
     
102.         if [ X"$?" == X"0" ]; then
     
103.             stop_db
     
104.         else
     
105.             exit 0
     
106.         fi
     
107.         ;;
     
108.     status) status_db ;;
     
109.     *) echo "USAGE: $0 [start|stop|status]" ;;
     
110. esac

复制代码

panhua

非常感谢!!!!!!!!!!!!1