sybase部署

部署环境：
32位SUSE10.2 linuex（IP地址192.168.117.120），ASE12.5.3步骤1.创建服务账户groupadd sybaseuseradd -g sybase sybase
2.创建安装目录mkdir /opt/sybasechown sybase.sybase /opt/sybase接下来所有的操作都是在sybase用户下进行这里我们用图形化方式做配置，所有设置下环境变量DISPLAYexport 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_GUARDecho “LD_POINTER_GUARD=1” >> /home/sybase/.bashrccat /opt/sybase/SYBASE.sh >> /home/sybase/.bashrcecho “DSQUERY=SYBASE” >>/home/sybase/.bashrcecho “DSLISTEN=SYBASE” >>/home/sybase/.bashrcsource/home/sybase/.bashrcexport LANG=C
编辑服务器配置文件vi sqlsrv.rs
sybinit.release_directory: /opt/sybasesybinit.product: sqlsrvsqlsrv.server_name: SYBASEsqlsrv.new_config: yessqlsrv.do_add_server: yessqlsrv.sa_login: sasqlsrv.sa_password:sqlsrv.default_language: us_englishsqlsrv.default_characterset: utf8sqlsrv.sort_order: binarysqlsrv.network_protocol_list: tcpsqlsrv.network_hostname_list: sybasesqlsrv.network_port_list: 5000sqlsrv.server_page_size: 2ksqlsrv.force_buildmaster: yessqlsrv.master_device_physical_name: /opt/sybase/data/master.datsqlsrv.master_device_size: 500sqlsrv.master_database_size: 120sqlsrv.errorlog: /opt/sybase/ASE-12_5/install/SYBASE.logsqlsrv.do_upgrade: nosqlsrv.sybsystemprocs_device_physical_name: /opt/sybase/data/sybsystemprocs.datsqlsrv.sybsystemprocs_device_size: 500sqlsrv.sybsystemprocs_database_size: 120sqlsrv.sybsystemdb_device_physical_name: /opt/sybase/data/sybsystemdb.datsqlsrv.sybsystemdb_device_size: 500 sqlsrv.sybsystemdb_database_size: 200sqlsrv.default_backup_server: SYBASE_BS
vi bsrv.rssybinit.boot_directory: /opt/sybasesybinit.release_directory: /opt/sybasesybinit.product: bsrvbsrv.do_add_backup_server: yesbsrv.server_name: SYBASE_BSbsrv.errorlog: /opt/sybase/ASE-12_5/install/SYBASE_BS.logbsrv.network_port_list: 5001bsrv.network_hostname_list: sybasebsrv.network_protocol_list: tcpbsrv.character_set: utf8bsrv.language: us_englishbsrv.tape_config_file: USE_DEFAULTbsrv.network_name_alias_list:bsrv.notes:bsrv.connect_retry_delay_time: 5bsrv.connect_retry_count: 5bsrv.addl_cmdline_parameters:bsrv.new_config: yesbsrv.do_upgrade: nosqlsrv.sa_login: sasqlsrv.sa_password:
vi xp.rssybinit.release_directory: /opt/sybasesybinit.product: xpxp.server_name: SYBASE_XPxp.new_config: yesxp.do_add_xp_server: yesxp.do_upgrade: noxp.network_protocol_list: tcpxp.network_hostname_list: sybasexp.network_port_list: 免费云主机域名 5002xp.related_sqlsrvr: SYBASEsqlsrv.sa_login: sasqlsrv.sa_password:
vi msrv.rssybinit.release_directory: /opt/sybasesybinit.product: msrvmsrv.server_name: SYBASE_MSmsrv.new_config: yesmsrv.do_add_monitor_server: yesmsrv.do_upgrade: nomsrv.network_protocol_list: tcpmsrv.network_hostname_list: sybasemsrv.network_port_list: 5003msrv.errorlog: /opt/sybase/ASE-12_5/install/SYBASE_MS.logsqlsrv.related_sqlsrvr: SYBASEsqlsrv.sa_login: sasqlsrv.sa_password:
5.通过执行程序srvbuild创建相应服务./srvbuild -rsqlsrv.rs./srvbuild -rbsrv.rs./srvbuild -rxp.rs./srvbuild -rmsrv.rs

相关推荐: 如何为oracle添加重做日志组及重做日志成员

本篇内容主要讲解“如何为oracle添加重做日志组及重做日志成员”，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习“如何为oracle添加重做日志组及重做日志成员”吧! 添加重做日志组：SYS@orcl 08-SEP-1…