sybase for linux下的安装

sybase 12.5.3 for RedHat9.0安装

1.      用root用户修改系统参数shmmax 和aio-max-size

直接修改/etc/sysctl.conf添加kernel.shmmax = *****（单位byte），fs.aio-max-size= *****（单位）byte.

关于shmmax是最大共享内存段，如果服务器上没有别的应用并且使用raw device可以将此参数调整到物理内存的90%，如果使用file system device
  的话相应调小，因为file system buffer需要开销内存!
    aio-max-size是一次异步IO所能够完成的大小default为128K调整到640K甚至更大（128K->640K在创建1G data,500M log的数据，时间差别是32m38s->1m2s使用page size=2k,ide hd）

2．装入ASE12.5 for linux server 盘

       cd /mnt/cdrom

     按以下顺序安装好软件包 (假定安装在 /usr/sybase目录)

        rpm –ihvf ./sybase-common-12.5*.rpm  --prefix=/usr/sybase

 

        rpm –ihvf ./sybase-ase-12.5*.rpm --prefix=/usr/sybase

 

        rpm –ihvf ./sybase-openclient-12.5*.rpm  --prefix=/usr/sybase

 

        rpm –ihvf ./sybase-esql-12.5*.rpm  --prefix=/usr/sybase

 

        rpm –ihvf ./sybase-chinese-12.5*.rpm  --prefix=/usr/sybase

 

        rpm –ihvf ./sybase-doc-12.5*.rpm  --prefix=/usr/sybase

3．入ASE12.5 for linux的补丁盘

cd /mnt/cdrom

          按以下顺序安装好补丁包

rpm –Uhvf ./sybase-comm-12.5*.rpm  --prefix=/usr/sybase

 

        rpm –Uhvf ./sybase-ase-12.5*.rpm  --prefix=/usr/sybase

 

        rpm –Uhvf ./sybase-openclient-12.5*.rpm  --prefix=/usr/sybase

 

        rpm –Uhvf ./sybase-esql-12.5*.rpm  --prefix=/usr/sybase

 

        rpm –Uhvf ./sybase-chinese-12.5*.rpm  --prefix=/usr/sybase

 

        rpm –Uhvf ./sybase-doc-12.5*.rpm  --prefix=/usr/sybase

 

4.建立sybase用户并配置环境变量

    cd /usr/sybase/install

    sh ./sybinstall.sh

5.以sybase用户登陆

     cp /usr/sybase/ASE-12_5/init/sample_resource_files/srvbuild.adaptive_server.rs  /tmp/sql.rs

      cp /usr/sybase/ASE-12_5/init/sample_resource_files/srvbuild.backup_server.rs  /tmp/backup.rs

    分别编辑/tmp/sql.rs 和 /tmp/backup.rs

/tmp/sql.rs:

 

 

sybinit.release_directory: /usr/sybase
sybinit.product: sqlsrv                                                          
sqlsrv.server_name: SYBASE                                                      
sqlsrv.new_config: yes                                                           
sqlsrv.do_add_server: yes                                                        
sqlsrv.network_protocol_list: tcp                                                
sqlsrv.network_hostname_list: 9.48.95.120                                             
sqlsrv.network_port_list: 7000                                                   
sqlsrv.server_page_size: USE_DEFAULT                                             
sqlsrv.force_buildmaster: no                                                     
sqlsrv.master_device_physical_name:/database/master.dat                               
sqlsrv.master_device_size: 60                                                  
sqlsrv.master_database_size: 30                                         
sqlsrv.errorlog: USE_DEFAULT                                                     
sqlsrv.do_upgrade: no                                                            
sqlsrv.sybsystemprocs_device_physical_name: /database/sybprocs.dat
sqlsrv.sybsystemprocs_device_size: 150                                   
sqlsrv.sybsystemprocs_database_size: 120                                 
sqlsrv.sybsystemdb_device_physical_name: /database/tempdb.dat                                sqlsrv.sybsystemdb_device_size: USE_DEFAULT                                     
sqlsrv.sybsystemdb_database_size: USE_DEFAULT                                   
sqlsrv.default_backup_server: SYB_BACKUP 

 

/tmp/backup.rs

修改以下参数：

    sybinit.release_direcroty :/usr/sybase

bsrv.server_name SYB_BACKUP

bsrv.network_hostname_list :9.48.95.120

bsrv.network_port_list:7001

sqlsrv.related_sqlsrvr:SYBASE

 

6.通过配置文件创建数据库服务器和备份服务器

 

以sybase用户登陆

  srvbuildres –r /tmp/sql.rs

 

   srvbuildres –r /tmp/backup.rs