hp_ux11.11 下安装 sybase12.5.3

最新推荐文章于 2021-05-11 17:06:49 发布

原创最新推荐文章于 2021-05-11 17:06:49 发布 · 724 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sybase #hp #数据库 #cache #user

Sybase 专栏收录该内容

18 篇文章

订阅专栏

本文详细介绍在HP-UX和Sun环境下安装与配置Sybase数据库的过程，包括环境准备、共享内存调整、数据库安装步骤及参数配置等关键环节，并提供解决常见安装问题的方法。

安装环境：
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