软件环境:
操作系统:aix6.0
Sybase版本:12.5.0.0
补丁版本:12.5.0.3
实验:
一、安装sybase数据库
1、修改操作系统对文件大小、内存栈、数据段的限制(如前面已经修改过了,这部分核实一下即可):
# vi /etc/security/limits
将下面直均设置成-1
fsize = -1 (文件大小不限制)
data = -1 (数据段大小不限制)
stack = -1 (内存栈的大小不限制)
2、打开服务器的异步I/O
# smitty aio (据说6.0之后aio是动态的,不用管)
修改“STATE to be configured at system restart”值由defined 为available,然后重启AIX 操作系统
(shutdown -Fr)使之生效。
3、操作系统启动完成后,创建sybase组、用户
# smitty group
# smitty user
创建sybase 用户,指定为sybase 组,用户的主目录为/sybase
4、给sybase 用户赋予口令
# passwd Sybase
# pwdadm –c sybase
5、将ASE 原文件传到服务器上,目录为/sybase,
并用#tar –xvf ASE125_Server.tar 释放文件。
补丁包EBF11445 放在/sybase 下,试用gunzip 和tar 命令解压。
6 以客户端的图形软件(Xmanager)安装SYBASE 数据库,以root 用户登录后,执行下面的命令
./install
调出安装界面:并且选择full install
输入安装目录
一些目录空间安装信息
应该开始解包了
问你是否注册,不需要,技术上没有限制,直接选择no,no
不安装数据库,等会自己安装。
提示环境变量
到这里我门的数据库就安装完成了。但是实例还没有创建。
二、打补丁
1、将Sybase12.5.0.3的补丁打上(未打补丁前的版本是12.5.0.0,可通过将Sybase12.5.0.3的补丁打上(未打补丁前的版本是12.5.0.0,可通过dataserver–v 命令查看),方
法为:命令查看),方
法为:
# dataserver -v
ksh: dataserver: not found.
# su - sybase
$ pwd
/data
$ ls
$ ls
$ pwd
/data
$ cd ..
$ ls
TT_DB data lib pconsole sybase
admin datavg logo.gif proc tftpboot
audit db lost+found sbin tmp
bin dev lpp scsi1 unix
bosinst.data esa mailbackup smit.log usr
cdrom etc mnt smit.script var
configassist.log home opt smit.transaction websm.script
$ cd db
$ ls
ASE-12_5 Installer.log charsets jutils-2_0
ASEP-1_0 OCS-12_5 collate locales
CFG-1_0 RPL-12_5 config lost+found
CFG89163.bag SYBASE.csh docs-45_55 shared-1_0
EFTS-12_5 SYBASE.env installed studio_version.txt
Host-1_0 SYBASE.sh jConnect-4_5 sybcent32
Installer SYSAM-1_0 jConnect-5_5 textsvr.cfg
$ cd ASE-*
$ ls
ASE-12_5.csh bin diag lib sybhelp xappdefaults
ASE-12_5.sh certificates init sample symlib
META-INF debugger install scripts upgrade
$ cd bin
$ cd bin
$ ls
asecfg charset diagsmb optdiag sqlupgraderes sybmultbuf
backupserver dataserver diagxps sqldbgr srvbuild xpserver
certauth diagbs histserver sqlloc srvbuildres
certpk12 diagoptd langinstall sqllocres sybha
certreq diagserver monserver sqlupgrade sybhelp
$ ./dataserver -v
Adaptive Server Enterprise/12.5.0.1/EBF 10442 GA/P/RS6000/AIX5.1/aseaix51port/1787/64-bit/FBO/Tue Aug 6 18:04:45 2002
Confidential property of Sybase, Inc.
Copyright 1987, 2002
Sybase, Inc. All rights reserved.
Unpublished rights reserved under U.S. copyright laws.
This software contains confidential and trade secret information ofSybase,
Inc. Use, duplication or disclosure of the software anddocumentation by
the U.S. Government is subject to restrictions set forth in a license
agreement between the Government and Sybase, Inc. or other written
agreement specifying the Government's rights to use the software and any
applicable FAR provisions, for example, FAR 52.227-19.
Sybase, Inc. 5000 Hacienda Drive, Dublin, CA 94568, USA
$ pwd
/db/ASE-12_5/bin
cp -r /sybase/ebf11445/Server /db
2、最后修改/sybase 目录的属主为sybase 用户和sybase 组:
# chown –R sybase:sybase /db
3、修改sybase 用户的环境变量。
切换成sybase 用户,在根目录下修改变量
# su – sybase
$ cat SYBASE.sh >> .profile
把/db/ASE-12_5/bin加入都PATH中
4、用root用户建两个目录cwback和cwdata
# mkdir /cwdata
# chown -R sybase:sybase /cwdata
# mkdir /cwback
# chown -R sybase:sybase /cwbacek
chown: /cwbacek: A file or directory in thepath name does not exist.
# chown -R sybase:sybase /cwback
5、用sybase用户建目录
#su - sybase
$cd /cwdata
$mkdir sysdata(存放master.dat、sybsystemprocs.dat、tempdb_add.dat等设备文件)
$mkdir cwdata1(存放财务数据库的物理设备文件)
6、安装
# su - sybase
$ DISPLAY=192.168.8.254:0.0
$ export DISPLAY
$ cd /db/ASE-12.5/bin
ksh: /db/ASE-12.5/bin: not found.
$ cd /db
$ ls
ASE-12_5 OCS-12_5 config lost+found
ASEP-1_0 RPL-12_5 docs shared-1_0
CFG-1_0 SYBASE.csh docs-45_55 studio_version.txt
CFG89163.bag SYBASE.env installed sybcent32
EFTS-12_5 SYBASE.sh jConnect-4_5 textsvr.cfg
Host-1_0 SYSAM-1_0 jConnect-5_5
Installer charsets jutils-2_0
Installer.log collate locales
$ cd ASE-*
$ ls
ASE-12_5.csh certificates install sybhelp
ASE-12_5.sh debugger lib symlib
META-INF diag sample upgrade
bin init scripts xappdefaults
$ cd bin
$ ls