hp_ux11.11 下安装 sybase12.5.3

安装环境：
hp_ux
sun 218
cpu 2
memory 4G

tar xvf *.tar

1. 新建组，用户

groupadd sybase
useradd -g sybase -d /export/home/sybase -m sybase
passwd sybase

2.调整共享内存,异步

kernel configuration -- parameter -- shmmax
-- maxfiles
-- maxuser
-- drivers -- asyncdisk

3.安装数据库

./setup -console
/export/home/sybase

安 装补丁

/export/home/sybase/install_sybase

/export/home/sybase/OCS-12_5/bin/isql -Usa -PTips123 -STIPS -n -i
/export/home/sybase/ASE-12_5/scripts/installmaster
-o/export/home/sybase/install_sybase/log/installmaster.log
/export/home/sybase/ASE-12_5/scripts/installcommit
-o/export/home/sybase/install_sybase/log/installcommit.log
/export/home/sybase/ASE-12_5/scripts/installsecurity
-o/export/home/sybase/install_sybase/log/installsecurity.log
/export/home/sybase/ASE-12_5/scripts/instmsgs.ebf
-o/export/home/sybase/install_sybase/log/instmsgs.log
/export/home/sybase/ASE-12_5/scripts/installmontables
-o/export/home/sybase/install_sybase/log/installmontables.log

4. 配置数据库

sp_configure "max memory",600000
sp_configure "allocate max shared mem",1
sp_cacheconfig "default data cache","300m"
sp_configure "procedure cache size",90000
sp_configure "max online engines",2
sp_configure "number of engines at startup",2
sp_configure "allocate max shared mem",0
sp_configure "number of locks",100000
sp_configure "number of user connections",50
sp_configure "number of devices",20

5.迁 移数据库
set nocount on
use tips_dev
go
select "bcp tips_dev.." + name + " out " + name + ".bcp -Utips -Ptips123 -STIPS -c "
from sysobjects where type="U"
go

6.安装可能出现的问题

netstat -a
查 看端口是否被占用

host
IP地址解析
/etc/server