solaris10_x86+Sybase ASE 12.5.3安装笔记
2006-03-12 21:47:36 来源:WEB开发网solaris10_x86+Sybase ASE 12.5.3安装笔记
solaris10_x86+Sybase ASE 12.5.3安装笔记
安装solaris10 GA
vi /etc/ssh/sshd_config修改
PermitRootLogin yes
重启SSH服务
#svcs |grep ssh
online 15:53:37 svc:/network/ssh:default
#svcadm restart svc:/network/ssh
新增sybase12账号:
groupadd dba
useradd -d /opt/sybase12/ -m -s /usr/bin/csh -g dba sybase12
passwd sybase12
建数据库设备目录:
mkdir /sybdata
chown -R sybase12 /sybdata
chgrp -R dba /sybdata
我的VM是160M Memory.
prtconf|grep Mem
Memory size: 160 Megabytes
修改/etc/system:
set shmsys:shminfo_shmmax=83886080 #80M
set sys:maxasynchio=500
以sybase12账号上传 ase1252_de_solx86.tgz和EBF12468.tgz到VM。
下载地址:
http://download.sybase.com/eval/ASE_1252_DE/ase1252_de_solx86.tgz
http://origin1.sybase.com/swx/7109/EBF12468.tgz
以sybase12 ssh到VM。开始安装sybase.
vsol10:sybase12 ~ 1 > gunzip -d ase1252_de_solx86.tgz
vsol10:sybase12 ~ 2 > tar xvf ase1252_de_solx86.tar
vsol10:sybase12 ~ 3 > ./setup -console
-------------------------------------------------------------------------------
Sybase Adaptive Server Enterprise Suite will be installed in the following
location:
/opt/sybase12
with the following features:
Sybase Servers
Adaptive Server Enterprise
ASE Diagnostic Server
Connectivity
Open Client
Common ctlib files
Common dblib files
Embedded SQL/C
Language Modules
Chinese Language Module
German Language Module
French Language Module
Japanese Language Module
The installer will now configure new servers with the following values. Please
click Next to proceed with the server configurations.
Adaptive Server
Adaptive Server Name VSOL10
Port Number 5000
Page Size 2k
Error Log /opt/sybase12/ASE-12_5/install/VSOL10.log
Master Device /sybdata/master.dat
Master Device Size (MB) 60
Master Database Size (MB) 20
System Procedure Device /sybdata/sysprocs.dat
System Procedure Device Size (MB) 120
System Procedure Database Size (MB) 120
Backup Server
Backup Server Name VSOL10_BACKUP
Port Number 5001
Error Log /opt/sybase12/ASE-12_5/install/VSOL10_BACKUP.log
然后安装EBF补丁
gzip -d EBF12468.tgz
tar -xvf EBF12468.tar
cd EBF12468
./setup -console
在.cshrc里加入一条:
source /opt/sybase12/SYBASE.csh
然后source ~/.cshrc
isql到数据库检查一下。
isql -SVSOL10 -Usa -P
1> select @@version
2> go
-----------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------
----------------------------------------------------------------
Adaptive Server Enterprise/12.5.3/EBF 12468 ESD#2/P/Solaris Intel/OS 5.9/ase125
3/1904/32-bit/OPT/Wed Mar 23 08:53:45 2005
安装数据库设备。
1> disk init name='datadev1',
2> physname='/sybdata/datadev1.dat',
3> vdevno=2,size='100M'
4> go
1> disk init name='logdev1',
2> physname='/sybdata/logdev1.dat',
3> vdevno=3,size='100M'
4> go
1> sp_diskdefault master,defaultoff
2> go
(return status = 0)
1> sp_diskdefault datadev1,defaulton
2> go
(return status = 0)
1> sp_diskdefault logdev1,defaulton
2> go
(return status = 0)
安装语法数据库
isql -Usa -P -SVSOL10 < /opt/sybase12/ASE-12_5/scripts/ins_syn_sql
1>sp_syntax "select"
2>go
1>sp_password NULL, <password>
2>go
1>shutdown
2>go
- ››solaris系统用ps命令查看进程占用的CPU、内存等情...
- ››Sybase ASE15.7静默安装教程
- ››Sybase发布iOS 4的移动设备管理和安全解决方案
- ››Sybase案例分析之旅游管理系统导游IC卡
- ››Sybase案例解剖之法院信息系统应用分析
- ››SYBASE连锁经营分布式解决方案
- ››Sybase SQL Server日志问题普及
- ››Sybase数据复制与热切换的实现
- ››Sybase-Oracle异构数据库互联与数据库复制
- ››Sybase数据备份之BCP用法简介
- ››Sybase存储过程的建立和使用
- ››Sybase加快BP Exploration的应用开发案例
更多精彩
赞助商链接