- 论坛徽章:
- 1
|
solaris 安装sybase
那位老大在solaris上安装过sybase?共享一把!
作者:
xxf
发表时间:2002/09/04 06:50pm
包括修改/etc/system
.profile等。
谢谢!
xxf@unisat.com.cn
:em27:
此文章相关评论:
该文章有[color="#ff0000"]8个相关评论如下:(
[color="#ffa200"]点这儿可以发表评论
)
越野横行
[color="#000000"]发表于: 2002/09/04 09:53pm
set shmsys:shminfo_shmmax=1310720000
.profile
SYBASE=/usrlocal/vlol001/sybase
DSQUERY=e3500
export SYBASE DSQUERY
SYBASE_FTS=FTS-12_0
export SYBASE_FTS
SYBASE_REP=REP-12_0
export SYBASE_REP
PATH=/usr/bin:/usr/ucb:/etc:.
export PATH
PATH=/usrlocal/vlol001/sybase/ASE-12_0/bin:/usrlocal/vlol001/sybase/ASE-12_0/install:/usrlocal/vlol001/sybase/REP-12_0/bin:/usrlocal/vlol001/sybase/OCS-12_0/bin:$PATH
export PATH
SYBASE_OCS=OCS-12_0
export SYBASE_OCS
SYBASE_ASE=ASE-12_0
export SYBASE_ASE
LM_LICENSE_FILE=/usrlocal/vlol001/sybase/SYSAM-1_0/licenses/license.dat:$LM_LICENSE_FILE
export LM_LICENSE_FILE
LD_LIBRARY_PATH=/usrlocal/vlol001/sybase/ASE-12_0/lib:/usr/local/openwin/lib:/usrlocal/vlol001/sybase/FTS-12_0/lib:/usrlocal/vlol001/sybase/OCS-12_0/lib:/usr/local/openwin/lib:/usr/lib:/usrlocal/vlol001/sybase/SQLRemote/lib:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH
SYBASE_SYSAM=SYSAM-1_0
export SYBASE_SYSAM
stty istrip
DISPLAY=e3500:0.0
export DISPLAY
*****sybase的裸设备不能用0柱面******
安装完毕后要进行一些必要的处理工作( 给sa加密码,把磁带机加入为dumpdevice,扩大tempdb的大小,disable temp在master device上的段,)
isql -Usa -P
use master
go
sp_password null, "password"
go
sp_dropserver local
go
sp_addserver FOO, local
go
sp_dropdevice tapedump1
go
sp_dropdevice tapedump2
go
sp_addumpdevice "tape", "dds2_tape", "/dev/rmt/0cn", 7000
go
disk init
name = "tempdb_dev",
physname = "/sybase/devs/tempdb.dev",
vdevno = 4,
size = 25600
go
alter database tempdb
on tempdb_dev = 50
go
use tempdb
go
sp_dropsegment "default", tempdb, master
go
sp_dropsegment "logsegment", tempdb, master
go
sp_dropsegment "system", tempdb, master
go
本文来自ChinaUnix博客,如果查看原文请点:http://blog.chinaunix.net/u/894/showart_13982.html |
|