部署環境:
32位SUSE10.2 linuex(IP位址192.168.117.120),ASE12.5.3
步驟
1.建立服務賬戶
groupadd sybase
useradd -g sybase sybase
2.建立安裝目錄
mkdir /opt/sybase
chown sybase.sybase /opt/sybase
接下來所有的操作都是在sybase使用者下進行
這裡我們用圖形化方式做配置,所有設定下環境變量DISPLAY
export DISPLAY=192.168.117.1:0.0 本機的IP位址
3.開始安裝ASE
./setup -options-record /tmp/silentinstall.txt (加上這個參數可以得到靜默安裝的參數檔案)
這裡先不選任何配置項,後面手動配置,因為有參數和環境變量需要修改
至此,ASE的安裝完成,接下來我們開始建立server
4.修改相應參數
配置共享記憶體大小
echo "kernel.shmmax=671088640" >> /etc/sysctl.conf
用root執行/sbin/sysctl -p使配置生效
配置環境變量LD_POINTER_GUARD
echo "LD_POINTER_GUARD=1" >> /home/sybase/.bashrc
cat /opt/sybase/SYBASE.sh >> /home/sybase/.bashrc
echo "DSQUERY=SYBASE" >> /home/sybase/.bashrc
echo "DSLISTEN=SYBASE" >> /home/sybase/.bashrc
source /home/sybase/.bashrc
export LANG=C
編輯伺服器配置檔案
vi sqlsrv.rs
sybinit.release_directory: /opt/sybase
sybinit.product: sqlsrv
sqlsrv.server_name: SYBASE
sqlsrv.new_config: yes
sqlsrv.do_add_server: yes
sqlsrv.sa_login: sa
sqlsrv.sa_password:
sqlsrv.default_language: us_english
sqlsrv.default_characterset: utf8
sqlsrv.sort_order: binary
sqlsrv.network_protocol_list: tcp
sqlsrv.network_hostname_list: sybase
sqlsrv.network_port_list: 5000
sqlsrv.server_page_size: 2k
sqlsrv.force_buildmaster: yes
sqlsrv.master_device_physical_name: /opt/sybase/data/master.dat
sqlsrv.master_device_size: 500
sqlsrv.master_database_size: 120
sqlsrv.errorlog: /opt/sybase/ASE-12_5/install/SYBASE.log
sqlsrv.do_upgrade: no
sqlsrv.sybsystemprocs_device_physical_name: /opt/sybase/data/sybsystemprocs.dat
sqlsrv.sybsystemprocs_device_size: 500
sqlsrv.sybsystemprocs_database_size: 120
sqlsrv.sybsystemdb_device_physical_name: /opt/sybase/data/sybsystemdb.dat
sqlsrv.sybsystemdb_device_size: 500
sqlsrv.sybsystemdb_database_size: 200
sqlsrv.default_backup_server: SYBASE_BS
vi bsrv.rs
sybinit.boot_directory: /opt/sybase
sybinit.release_directory: /opt/sybase
sybinit.product: bsrv
bsrv.do_add_backup_server: yes
bsrv.server_name: SYBASE_BS
bsrv.errorlog: /opt/sybase/ASE-12_5/install/SYBASE_BS.log
bsrv.network_port_list: 5001
bsrv.network_hostname_list: sybase
bsrv.network_protocol_list: tcp
bsrv.character_set: utf8
bsrv.language: us_english
bsrv.tape_config_file: USE_DEFAULT
bsrv.network_name_alias_list:
bsrv.notes:
bsrv.connect_retry_delay_time: 5
bsrv.connect_retry_count: 5
bsrv.addl_cmdline_parameters:
bsrv.new_config: yes
bsrv.do_upgrade: no
sqlsrv.sa_login: sa
vi xp.rs
sybinit.release_directory: /opt/sybase
sybinit.product: xp
xp.server_name: SYBASE_XP
xp.new_config: yes
xp.do_add_xp_server: yes
xp.do_upgrade: no
xp.network_protocol_list: tcp
xp.network_hostname_list: sybase
xp.network_port_list: 5002
xp.related_sqlsrvr: SYBASE
sqlsrv.sa_login: sa
vi msrv.rs
sybinit.release_directory: /opt/sybase
sybinit.product: msrv
msrv.server_name: SYBASE_MS
msrv.new_config: yes
msrv.do_add_monitor_server: yes
msrv.do_upgrade: no
msrv.network_protocol_list: tcp
msrv.network_hostname_list: sybase
msrv.network_port_list: 5003
msrv.errorlog: /opt/sybase/ASE-12_5/install/SYBASE_MS.log
sqlsrv.related_sqlsrvr: SYBASE
sqlsrv.sa_login: sa
5.通過執行程式srvbuild建立相應服務
./srvbuild -r sqlsrv.rs
./srvbuild -r bsrv.rs
./srvbuild -r xp.rs
./srvbuild -r msrv.rs