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数据库用户管理基本概念 [办公软件]关于SYBASE的自动启动 [办公软件]SYBASE事务 [办公软件]SYBASE dbcc [C语言系列]SQL Server到SYBASE连接服务器的实现 [其他]SQLServer到SYBASE连接服务器的实现 [SyBase]四川移动BOSS系统Sybase解决方案 [SyBase]中国联通CDMA计费系统工程的Sybase解决方案 [SyBase]Sybase ASE12.5智能管理《北京青年报》新闻采编系… [SyBase]Sybase EA Server 在网上税务系统中的应用
|