AIX環境下安裝sybase
軟件環境:
操作系統: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 操作系統 www.2cto.com
(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
不安裝數據庫,等會自己安裝。
提示環境變量 www.2cto.com
到這裡我門的數據庫就安裝完成了。但是實例還沒有創建。
二、打補丁
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 www.2cto.com
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中
www.2cto.com
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 www.2cto.com
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
作者 yujin2010good