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

【深 度 阅 读】 相 关 文 章

·对 Sybase ASE DBA 的建议