sybase 数据库for centos5.2安装

有点乱，多看几次吧
下载Click here to download ASE Express Edition for Linux (x86) 我的32位


一、在Linux下装sybase软件前一定要建立sybase帐户并用这个账户登录进来。确保安装的软件目录（比如/opt/sybase）下的全部文件的属主是sybase用户。

在CENTOS中,如果没有完全安装,有时在安装一些RPM包中出错提示,提示找不到libstdc++.so.5这个文件,解放方法在光盘中找到compat-libstdc++这个包安装就可以了,还可以用yum install libstdc++.so.5就可以了.不然会出现找不到libstdc++so.5什么的
还有个包是libaio和libaio-devel
（1）创建ASE Server前的准备工作

操作系统共享内存缺省值，对于大多数 Linux 版本为 32MB。
Adaptive Server 的最小要求为 64MB。

# ipcs -lm | grep ’max seg size’
max seg size (kbytes) = 32768

Sybase15.0.2 for linux 安装步骤
修改/etc/sysctl.conf文件，会后一行加入kernel.shmmax=400*1024*1024（400M）内存数（以字节为单位）
sysctl -p 使生效


cenost5上安装Sybase15.x（简单记录下）root
1.mkdir /opt/sybase //创建SybaseASE的安装目录
2.useradd/groupadd //添加用户/用户组sybase 要建立有sybase的环境变量（export LD_POINTER_GUARD=0 这个是重要的，不然建不了RUN_SYBASE主服务，我的uljcentos是主服务）

或(useradd -d /opt/sybase -s /bin/bash sybase 再建立mkdir /opt/sybase 更改所属chown sybase:sybase /opt/sybase)

(sybaser 的环境变量如1和 2
1文件.bash_profile内容
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin
export LD_POINTER_GUARD=0
export PATH

2文件.bashrc内容
# .bashrc

# Source global definitions
if [ -f /etc/bashrc ]; then
. /etc/bashrc
fi

# User specific aliases and functions
)

4.su - sybase //切换到sybase用户进行安装

RHEL5 （centos5)已经通过Sybase的认证，但是当前的版本不能用Sybase的setup程序配置服务器，需要用svrbuildres工具进行配置(或 svrbuild)。还有需要 export LD_POINTER_GUARD=0，最好把这一行写到sybase用户的.bash_profile里面去。

5. ./setup -console //执行Sybase字符安装程序,
安装进度如下
Installing Sybase Adaptive Server Enterprise Suite. Please wait...


|-----------|-----------|-----------|------------|
0% 25% 50% 75% 100%
||||||||||||||||||||||||||||||||||||||||||||||||||

Creating uninstaller...

Dublin, CA 94568, USA
00:00000:00000:2008/12/12 12:59:20.51 kernel Using /opt/sybase as the 'SYBASE'
environment variable, found during startup.
00:00000:00000:2008/12/12 12:59:20.51 kernel Using OCS-15_0 as the 'SYBASE_OCS'
environment variable, found during startup.
00:00000:00000:2008/12/12 12:59:20.51 kernel ASE booted on Linux release
2.6.27.4 version #6 SMP Fri Nov 14 15:43:37 CST 2008.
00:00000:00000:2008/12/12 12:59:20.51 kernel Using '/opt/sybase/uljcentos.cfg'
for configuration information.
00:00000:00000:2008/12/12 12:59:20.51 kernel Logging ASE messages in file
'/opt/sybase/ASE-15_0/install/uljcentos.log'.
00:00000:00000:2008/12/12 12:59:20.51 kernel Platform TCP network is forced to
IPv4-only.
00:00000:00000:2008/12/12 12:59:20.51 kernel ASE booted with TCP_NODELAY
enabled.
00:00000:00000:2008/12/12 12:59:20.51 kernel SSL Plus v5.0.4 security modules
loaded successfully.
Server 'uljcentos' was not created.
00:00000:00000:2008/12/12 12:59:20.51 kernel Network and device connection
limit is 1009.

Press ENTER to read the text [Type q to quit]
interface have sybase_bs sybase_xp sybase_ms service but no sybase service
提示Server 'uljcentos' was not created.建不了主服务，这时要改SYBASE.sh执行权（//设置脚本的可执行权限.该文件会设置一些必要的环境变量.这一步晕了好一阵。）

7 在root用户下把 SYBASE.sh　COPY到/etc/profile.d目录下，访问权限改为755，logout然后用Sybase用户login就可以。
chomod +x /opt/sybase/SYBASE.sh （开另一终端用root执行）
(安装了sybase ASE软件以后会在安装目录下安装SYASE.sh配置文件。根据配置文件配置相应的环境变量，加入系统.bash_profile中)
再用root执行 xhost +
然后sybase用户到安装目录bin下运行svrbuild
[sybase@uljcentos bin]$ pwd
/opt/sybase/ASE-15_0/bin
[sybase@uljcentos bin]$ svrbuild
出现图形界面（如果改动东西容易卡死X，不改注意看它的默认来建就没事）建sybase服务（可用svrbuildre -r /opt/sybase/db.rs 脚本方式（配对的话很顺利）建sybase服务，脚本有两个，一个是db.rs主服务，一个是bk.rs备份服务.脚本可放sybase目录，到时指定就可）




脚本db.rs：

sybinit.release_directory: USE_DEFAULT
sybinit.product: sqlsrv
sqlsrv.server_name:uljcentos
sqlsrv.new_config: yes
sqlsrv.do_add_server: yes
sqlsrv.network_protocol_list: tcp
sqlsrv.network_hostname_list: uljcentos
sqlsrv.network_port_list: 5000
sqlsrv.server_page_size: USE_DEFAULT
sqlsrv.force_buildmaster: no
sqlsrv.master_device_physical_name: /opt/sybase/data/master.dat
sqlsrv.master_device_size: USE_DEFAULT
sqlsrv.master_database_size: USE_DEFAULT
sqlsrv.errorlog: USE_DEFAULT
sqlsrv.do_upgrade: no
sqlsrv.sybsystemprocs_device_physical_name: /opt/sybase/data/sysprocs.dat
sqlsrv.sybsystemprocs_device_size: USE_DEFAULT
sqlsrv.sybsystemprocs_database_size: USE_DEFAULT
sqlsrv.sybsystemdb_device_physical_name: /opt/sybase/data/sybsystemdb.dat
sqlsrv.sybsystemdb_device_size: USE_DEFAULT
sqlsrv.sybsystemdb_database_size: USE_DEFAULT
sqlsrv.default_backup_server: SYB_BACKUP
sqlsrv.addl_cmdline_parameters:




脚本 bk.rs

sybinit.release_directory: USE_DEFAULT
sybinit.product: bsrv
bsrv.server_name: uljcentos_bs
bsrv.new_config: yes
bsrv.do_add_backup_server: yes
bsrv.do_upgrade: no
bsrv.network_protocol_list: tcp
bsrv.network_hostname_list: uljcentos
bsrv.network_port_list: 5001
bsrv.language: USE_DEFAULT
bsrv.character_set: USE_DEFAULT
bsrv.tape_config_file: USE_DEFAULT
bsrv.errorlog: USE_DEFAULT
sqlsrv.related_sqlsrvr: uljcentos
sqlsrv.sa_login: sa
sqlsrv.sa_password: USE_DEFAULT
bsrv.addl_cmdline_parameters:

然后
[sybase@uljcentos bin]$ srvbuildres -r db.rs
installmaster: 100% complete.
installmaster script complete.
Creating two-phase commit database...
Two phase commit database complete.
Installing common character sets (Code Page 437, Code Page 850, ISO Latin-1,
Macintosh and HP Roman-8)...
Character sets installed.
Setting server name in Adaptive Server...

[sybase@uljcentos bin]$ srvbuildres -r bk.rs
Building Backup Server 'uljcentos_bs':
Writing entry into directory services...
Directory services entry complete.
Writing RUN_uljcentos_bs file...
RUN_uljcentos_bs file complete.
Starting server...
Server started.
Server 'uljcentos_bs' was successfully created.

这样安装基本完成.后面的使用见官方手册.前三步使用root用户操作.后面的都是使用新加的sybase用户.
8 连sybase库看看，查看版本如下
sybase@CentOS ~]$ isql -Usa -Suljcentos -P
1> select @@VERSION
2> go

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Adaptive Server Enterprise/15.0.2/EBF 14331/P/Linux Intel/Linux 2.4.21-47.ELsmp
i686/ase1502/2486/32-bit/FBO/Thu May 24 08:15:50 2007

(1 row affected)
1>
9 停止数据库
停止SYB_BACKUP shutdown SYB_BACKUP
停止SYBASE shutdown 或 shutdown with nowait
10 启动数据库
启动时执行：su - sybase
cd install

startserver -f RUN_SYBASE 或RUN_SYB_BACKUP

注意一 locale ，我用的是[root@uljcentos ulj]# locale
LANG=en_US.UTF-8
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=
如果不是的话听说也可以用C的locale安装时
[sybase@CentOS ~]$ export LC_ALL=C
注意二 不知interface用不用改，改的话重要改内存最大值地方就可


[root@uljcentos]# vi /opt/sybase/ASE-15_0/uljcentos.cfg
[Physical Memory]
max memory = DEFAULT(我的用默认，我内存是1.5G，一般可改为512M #单位为2k max memory =262144）