Sybase-ASE.zip_sybase

Sybase ASE 数据库实例创建手册

目 录

1. 创建 SERVER ...........................................................................................................................3

2. 创建 backup SERVER...............................................................................................................4

3. 配置 SERVER 参数 ..................................................................................................................5

4. 创建应用数据库........................................................................................................................6

5. 更改 sa 数据库用户密码 ..........................................................................................................6

以 sybase 用户登录执行

$cd /sybase

$mkdir rs

$cp $SYBASE_ASE/init/sample_resource_files/srvbuild.adaptive_server.rs $HOME/rs/sql.rs

修改资源文件

vi 编辑$HOME/rs/sql.rs 文件

sybinit.release_directory: /sybase

sybinit.product: sqlsrv

sqlsrv.server_name: servername

sqlsrv.new_config: yes

sqlsrv.master_device_physical_name: /dev/…/rlvSybMaster

sqlsrv.master_device_size: 200

sqlsrv.master_database_size: 100

sqlsrv.errorlog: /sybase/ASE-15_0/install/servername.log

sqlsrv.do_upgrade: no

sqlsrv.sybsystemprocs_device_physical_name: /dev/…/rlvSybSysprocs

sqlsrv.sybsystemprocs_device_size: 300

sqlsrv.sybsystemprocs_database_size: 200

sqlsrv.default_backup_server: servername_BS

sqlsrv.tempdb_device_physical_name: /dev/…/rlv…

$srvbuildres -r $HOME/rs/sql.rs

初始化后 SERVER 已启动。

安装字符集/排序顺序

$cd $HOME/charsets/charactername

$charset -Usa sortorder.srt charactername

password:默认空密码

变更数据库字符集