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
明天继续。
