|
sybase数据库的安装分为两种方式:文件系统方式和原始设备方式。文件系统方式即将sybase数据库建立在 ?qCLAy}zv 文件系统( File System)的基础上,以文件的形式存放,优点是读写的速度快,据sybase公司工程师称,其 ]p?b u@f_ 读写速度是原始设备方式的5倍,并且备份可以采用保存转移文件的形式进行,较为灵活;而原始设备方式将 :;B?Nh 4O 数据库系统直接建立在原始设备(Raw device)的基础上,最大的优点是安全性较高。 T;9/]hK~$ 以HP 11.0上安装sybase Adeptive Server 11.9.3为例,说明数据库的安装过程,笔者刚装过,在RS6000上参数 ={DLp UY 设置更简单,以字符终端为例,图形方式更简单! &#NvD7 1、 用SAM修改异步IO的参数asycdsk,OUT->IN;(AIX 为aio available) 2dZ5<tBu 2、 用SAM修改共享内存最大值参数shmmax为1.5G(可以为物理内存大小或更大,但是HP Unix11上设置共享内 KF/ }, 存的值最大为1.75G,大于此值需要打补丁); aX t` 3、 Sybase系统将安装在9.98和9.99的内置硬盘上的mount在/home上的文件系统/dev/vg00/lvol5下,该文件 NPp>w R 系统扩到2G; 8X|!o "Lb 4、 用SAM建立新组:sybase; <6#QMX+I 5、 用SAM建立新用户:sybase,属于sybase组; pM5o X uy 7、#mknod /dev/async C 101 5 k1a'} #chmod 0660 /dev/async WHI}+_C| #chown sybase::sybase /dev/async qzGPnE1Y 8、#mkdir mnt kxzHNG:< #mount –F cdfs –o –ro /dev/cdrom /mnt {o#]`NG 9、#su – sybase Li'A!Q0= $cat /mnt/install/CAS(显示序列号,抄下做备用); d r3F^6W 10、$/mnt/sybload –D,做缺省选择最后输入序列号; SFM):gx_ 11、修改.profile文件,全文如下: .f'DbZ R]|!tnn ry # @(#) $Revision: 72.2 $ cK-$Se|=]c hoL OBt* # Default user .profile file (/usr/bin/sh initialization). 52#)~$ 0#p[.l # Set up the terminal: P !b 7v if [ "$TERM" = "" ] ^i0\gw| then E&pDg9sOd eval ` tset -s -Q -m ':?hp' ` *W@"F^VB else )g[rP4S<Z eval ` tset -s -Q ` c.}<CEM(*q fi MMK`QJOS stty erase "^H" kill "^U" intr "^C" eof "^D" !'B Z stty hupcl ixon ixoff ^V}!C8Os tabs EL$<t}KJ 6dx*+M7$> # Set up the search paths: \>B}<#M^B PATH=$PATH:. &Y>|goRI+ X{cO.O_ # Set up the shell environment: I*"q'HFFQ7 set -u W[=^Qqn trap "echo 'logout'" 0 bu|@eR r% _*A~92 # Set up the shell variables: |n}^Z%x EDITOR=vi wy6&}~ H export EDITOR WqWBAfm SYBASE=/home/sybase;export SYBASE r. '-'5V PATH=$SYBASE/bin:$PATH:.;export PATH ],'\kU{Gr SHLIB_PATH=$SYBASE/lib;export SHLIB_PATH smDbSmTPg ;##Oj@h G\ 12、cp ./init/sample_resource_files/srvbuild/srvbuild.ada*.rs $SYBASE/bin/ase1.rs ]m5lNYi cp ./init/sample_resource_files/srvbuild/srvbuild.bac*.rs $SYBASE/bin/back1.rs sdp^{QT2 (源文件在./init/sample_resource_files/srvbuild下) daK wEXy$ =?pW 3 13、vi ase1.rs k(rstQ~\? ase1.rs全文如下: y[ C/\W*- sybinit.release_directory:/home/sybase p'M+LW^ sybinit.product: sqlsrv > ,F<^I sqlsrv.server_name: HPWG i%Cg{yl' sqlsrv.new_config: yes 6|F _V0 sqlsrv.do_add_server: yes r8K,9MJs sqlsrv.network_protocol_list: tcp yV{{Hjsu' sqlsrv.network_hostname_list: hpwg2 >1$X/z sqlsrv.network_port_list: 4100 p1O2]J{ sqlsrv.master_device_physical_name:/sybase/sybdev/master.dat zrRuw sqlsrv.master_device_size: 60 o&k\P2nC sqlsrv.master_database_size: 15 !i_ sqlsrv.errorlog: /sybase/errorlog e*s#s}tP sqlsrv.do_upgrade: no o;5qK@B;]Z sqlsrv.sybsystemprocs_device_physical_name:/sybase/sybdev/sybprocs.dat =TqYmQXPo sqlsrv.sybsystemprocs_device_size: 80 KcXPhpV sqlsrv.sybsystemprocs_database_size:60 H:Y WWwo sqlsrv.default_backup_server: SYB_BACKUP 6>\R3# 14、$srvbuildres –r ase1.rs 4DhC5k 15、拷贝 sqlloc.rs 至 ./bin/locl.rs fcE}dK!yK 修改字符集为iso_1,排序字符集为bin_iso_1。locl.rs 修改后如下: =3[ dy ;P sybinit.release_directory:/home/sybase U'BCQI"T sqlsrv.server_name: HPWG hYb}4~T sqlsrv.sa_login: sa ozm PqB sqlsrv.sa_password: b"XVlURC sqlsrv.default_language: USE_DEFAULT W0v4xfBp~ sqlsrv.language_install_list: USE_DEFAULT tRV_<nz sqlsrv.language_remove_list: USE_DEFAULT uczC h~, sqlsrv.default_characterset: iso_1 swc(XO/J sqlsrv.characterset_install_list: USE_DEFAULT 'Ln0bk]FE sqlsrv.characterset_remove_list: USE_DEFAULT lr<K}wg sqlsrv.sort_order: bin_iso_1 3]\Kof4= .^b09{z # An example sqlloc resource file... s0 B 2E q # sybinit.release_directory: USE_DEFAULT 5gM0-N # sqlsrv.server_name: PUT_YOUR_SERVER_NAME_HERE ;jcBos:O. # sqlsrv.sa_login: sa ?6-x2U(s # sqlsrv.sa_password: 8<S^11| # sqlsrv.default_language: french (>Q_Pg2] # sqlsrv.language_install_list: spanish,german bv}HV # sqlsrv.language_remove_list: USE_DEFAULT 5Di v$K^kR # sqlsrv.default_characterset: cp437 ._hxd\1 # sqlsrv.characterset_install_list: mac,cp850 +izkV_ # sqlsrv.characterset_remove_list: USE_DEFAULT LU7bqh; # sqlsrv.sort_order: dictionary h5ZC/K=9O [N55b2y\ 16、修改back1.rs. =_x<Jfq& back1.rs全文如下: jLGI@. sybinit.release_directory:/home/sybase i^fsExu4 sybinit.product: bsrv >1[3j-) bsrv.server_name:SYB_BACKUP K42S&c%J: bsrv.do_add_backup_server: yes QI~~5&+<>Y bsrv.network_protocol_list: tcp _;BsHkE bsrv.network_hostname_list: hpwg2 uhdW:b bsrv.network_port_list: 4200 ,Y{ r> bsrv.language: USE_DEFAULT ^So8~_rN7 bsrv.character_set: USE_DEFAULT ' \[:Bn bsrv.tape_config_file: USE_DEFAULT T[{ p44k bsrv.errorlog: USE_DEFAULT kd,(*J*c /7f yku\ 17、$svrbuildres –r back1.rs .xY2t4 18、至此可以尝试运行isql: nuMz?ef isql –Usa –P –S HPWG 测试服务器是否成功安装 iE6] | 19、dump database master to “/dev/rmt/0mn” capacity=12000000 wPDa:30g$ 测试BACKUP服务器是否成功安装.
|