开发学院数据库Sybase solaris10_x86+Sybase ASE 12.5.3安装笔记 阅读

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 GAvi /etc/ssh/sshd_config修改PermitRootLogin yes重启SSH服务#svcs |grep sshonline 15:

  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

Tags:solaris Sybase ASE

编辑录入:coldstar [复制链接] [打 印]
[]
  • 好
  • 好的评价 如果觉得好,就请您
      0%(0)
  • 差
  • 差的评价 如果觉得差,就请您
      0%(0)
赞助商链接