Shulou(Shulou.com)06/01 Report--

Deployment environment:

32-bit SUSE10.2 linuex (IP address 192.168.117.120), ASE12.5.3

step

1. Create a service account

groupadd sybase

useradd -g sybase sybase

2. create the installation directory

mkdir /opt/sybase

chown sybase.sybase /opt/sybase

All the following operations are performed under the sybase user

Here we use graphical configuration, all settings under the environment variable DISPLAY

export DISPLAY=192.168.117.1:0.0 IP address of this machine

3. Start installing ASE

./ setup-options-record/tmp/silentinstall.txt (add this parameter to get the parameter file for silent installation)

Do not select any configuration items here, and manually configure them later, because there are parameters and environment variables that need to be modified.

At this point, ASE installation is complete, and we begin to create the server.

4. changing corresponding parameter

Configure shared memory size

echo "kernel.shmmax=671088640" >> /etc/sysctl.conf

Execute/sbin/sysctl -p with root to make the configuration effective

Configure the environment variable 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

Edit Server Profiles

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

sqlsrv.sa_password:

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

sqlsrv.sa_password:

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

sqlsrv.sa_password:

5. Create corresponding services by executing srvbuild program

./ srvbuild -r sqlsrv.rs

./ srvbuild -r bsrv.rs

./ srvbuild -r xp.rs

./ srvbuild -r msrv.rs

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.