Sybase ASE 15.7使用响应文件静默安装
交代一下实验环境,HP DL580下安装RHEL 5.5,Sybase version:15.7
Sybase的安装目录为/opt/Sybase
Sybase的软件位置为/home/setup
Sybase属组用户都是新建sybase
下面我们开始使用响应文件来创建Sybase数据库
[root@sybase ~]# useradd sybase
[root@sybase ~]# cd /home/
[root@sybase home]# mkdir setup
[root@sybase /]# cd opt/
[root@sybase opt]# mkdir sybase
[root@sybase opt]# cd ..
[root@sybase /]# chown -R sybase:sybase opt/
[root@sybase /]# cd /home/
[root@sybase home]# chown -R sybase:sybase setup/
[root@sybase home]# chmod -R 777 setup/
[root@sybase opt]# cd /home/setup/
[root@sybase setup]# su - sybase
[sybase@sybase ~]$ cd /home/setup/
[sybase@sybase setup]$ rz
Transferring ase1570_linx8664_64.tgz...
100% 813562 KB 5572 KB/s 00:02:26 0 Errors
Transferring ase157_responsefile.txt...
100% 1 KB 1 KB/s 00:00:01 0 Errors
Transferring sybase.rs...
100% 1 KB 1 KB/s 00:00:01 0 Errors
Transferring sybase_bk.rs...
100% 543 bytes 543 bytes/s 00:00:01 0 Errors
[sybase@sybase setup]$ tar -xvf ase157*.tgz
[sybase@sybase setup]$ ll
total 54756
drwxrwxrwx 33 sybase sybase 4096 Sep 17 2011 archives
-rwxrwxrwx 1 sybase sybase 1414 Aug 8 02:34 ase157_responsefile.txt
-rwxrwxrwx 1 sybase sybase 92209 Sep 19 2011 ASE-FDT-List.pdf
-rwxrwxrwx 1 sybase sybase 17850 Sep 19 2011 sample_response.txt
-rwxrwxrwx 1 sybase sybase 54463434 Sep 19 2011 setup.bin
-rwxrwxrwx 1 sybase sybase 543 Aug 8 10:46 sybase_bk.rs
-rwxrwxrwx 1 sybase sybase 1399011 Sep 19 2011 Sybase-FDT-Master.pdf
-rwxrwxrwx 1 sybase sybase 1532 Aug 8 10:45 sybase.rs
drwxrwxrwx 3 sybase sybase 4096 Sep 17 2011 sysam_setup
drwxrwxrwx 4 sybase sybase 4096 Sep 17 2011 sysam_utilities
[sybase@sybase setup]$ ./setup.bin -f /home/setup/ase157_responsefile.txt -i silent -DAGREE_TO_SYBASE_LICENSE=true -DRUN_SILENT=true
如果此处报错:
[sybase@sybase sybase]$ ./setup.bin -f ase157_responsefile.txt -i silent
-DAGREE_TO_SYBASE_LICENSE=true -DRUN_SILENT=true
RadioButtonInputAction.install(): '$ASEP_REMEMBER_PASSWORD$' property has invalid '' value. The value must be one of the following: TRUE, FALSE,
我们以下会给出解决方法:
安装完成后我们将环境变量添加到sybase用户下
[sybase@sybase sybase]$ cat SYBASE.sh >> /home/sybase/.bash_profile
然后我们到15.7的ASE-15_0/bin目录下进行安装Adaptive Server和backup server
[sybase@sybase sybase]$ cd ASE-15_0/bin/
[sybase@sybase bin]$ ls
asecfg dataserver diagoptd diagsybtsmpasswd langinstall sqldbgr sqlupgrade srvbuildres sybhelp sybtsmpasswd
backupserver diagbs diagserver diagxps optase.sh sqlloc sqlupgraderes sybdiag sybmigrate xpserver
charset diagjsag diagsmb jsagent optdiag sqllocres srvbuild sybha sybmultbuf
[sybase@sybase bin]$ ./srvbuildres -r /home/setup/sybase.rs
Warning: You have selected '4K' as the logical page size for the Adaptive
Server. If you plan to load dump from another database, make sure this logical
page size matches the size of the source database. The default logical page
size in previous Adaptive Server versions was 2KB.
Building Adaptive Server 'sybase':
Writing entry into directory services...
Directory services entry complete.
Building master device...
Master device complete.
Writing RUN_sybase file...
RUN_sybase file complete.
Starting server...
Server started.
Building sysprocs device and sybsystemprocs database...
sysprocs device and sybsystemprocs database created.
Running installmaster script to install system stored procedures...
installmaster: 10% complete.
installmaster: 20% complete.
installmaster: 30% complete.
installmaster: 40% complete.
installmaster: 50% complete.
installmaster: 60% complete.
installmaster: 70% complete.
installmaster: 80% complete.
installmaster: 90% complete.
installmaster: 100% complete.
installmaster script complete.
Creating two-phase commit database...
Two phase commit database complete.
Installing common character sets (Code Page 437, Code Page 850, ISO Latin-1,
Macintosh and HP Roman-8)...
Character sets installed.
Setting server name in Adaptive Server...
Server name added.
Server 'sybase' was successfully created.
[sybase@sybase bin]$ ./srvbuildres -r /home/setup/sybase_bk.rs
Building Backup Server 'sybase_BK':
Writing entry into directory services...
Directory services entry complete.
Writing RUN_sybase_BK file...
RUN_sybase_BK file complete.
Starting server...
Server started.
Server 'sybase_BK' was successfully created.
提示ASE Server安装完成,那么我们来启动服务器
[sybase@sybase install]$ ./startserver -f RUN_sybase
启动完成后,我们可以查看一下我们安装的Sybase软件版本、使用isql登陆时候,尽量别使用-P参数,那样SA的密码会明文显示出来,-S就是跟服务器名
[sybase@sybase install]$ isql -Usa -Ssybase
Password:
1> select @@version
2> go
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Adaptive Server Enterprise/15.7.0/EBF 19495 SMP /P/x86_64/Enterprise Linux/ase1
57/2820/64-bit/FBO/Fri Sep 16 00:54:35 2011
(1 row affected)
响应文件、以及创建Server备注脚本:
[sybase@sybase setup]$ ls
archives ase157_responsefile.txt ASE-FDT-List.pdf sample_response.txt setup.bin sybase_bk.rs Sybase-FDT-Master.pdf sybase.rs sysam_setup sysam_utilities
[sybase@sybase setup]$ more sybase.rs
sybinit.release_directory: USE_DEFAULT
sybinit.product: sqlsrv
sqlsrv.server_name: sybase
sqlsrv.sa_password: sybase
sqlsrv.new_config: yes
sqlsrv.do_add_server: yes
sqlsrv.network_protocol_list: tcp
sqlsrv.network_hostname_list: 192.168.111.20
sqlsrv.network_port_list: 6000
sqlsrv.application_type: MIXED
sqlsrv.server_page_size: 4K
sqlsrv.force_buildmaster: yes
sqlsrv.master_device_physical_name: /opt/sybase/data/tpch/master_dev.dat
sqlsrv.master_device_size: 150
sqlsrv.master_database_size: 60
sqlsrv.errorlog: USE_DEFAULT
sqlsrv.do_upgrade: no
sqlsrv.sybsystemprocs_device_physical_name: /opt/sybase/data/tpch/systemprocs_dev.dat
sqlsrv.sybsystemprocs_device_size: 160
sqlsrv.sybsystemprocs_database_size: 160
sqlsrv.sybsystemdb_device_physical_name: /opt/sybase/data/tpch/systemdb_dev.dat
sqlsrv.sybsystemdb_device_size: USE_DEFAULT
sqlsrv.sybsystemdb_database_size: USE_DEFAULT
sqlsrv.tempdb_device_physical_name: USE_DEFAULT
sqlsrv.tempdb_device_size: 500
sqlsrv.tempdb_database_size: 500
sqlsrv.default_backup_server: sybase_BK
#sqlsrv.addl_cmdline_parameters: PUT_ANY_ADDITIONAL_COMMAND_LINE_PARAMETERS_HERE
sqlsrv.do_configure_pci: no
sqlsrv.sybpcidb_device_physical_name: PUT_THE_PATH_OF_YOUR_SYBPCIDB_DATA_DEVICE_HERE
sqlsrv.sybpcidb_device_size: USE_DEFAULT
sqlsrv.sybpcidb_database_size: USE_DEFAULT
# If sqlsrv.do_optimize_config is set to yes, both sqlsrv.avail_physical_memory and sqlsrv.avail_cpu_num need to be set.
#sqlsrv.do_optimize_config: yes
#sqlsrv.avail_physical_memory: 2048
#sqlsrv.avail_cpu_num: 4
[sybase@sybase setup]$ more sybase_bk.rs
sybinit.release_directory: USE_DEFAULT
sybinit.product: bsrv
bsrv.server_name: sybase_BK
bsrv.new_config: yes
bsrv.do_add_backup_server: yes
bsrv.do_upgrade: no
bsrv.network_protocol_list: tcp
bsrv.network_hostname_list: 192.168.111.20
bsrv.network_port_list: 6001
bsrv.language: USE_DEFAULT
bsrv.character_set: USE_DEFAULT
bsrv.tape_config_file: USE_DEFAULT
bsrv.errorlog: USE_DEFAULT
sqlsrv.related_sqlsrvr: sybase
sqlsrv.sa_login: sa
sqlsrv.sa_password: sybase
#bsrv.addl_cmdline_parameters: PUT_ANY_ADDITIONAL_COMMAND_LINE_PARAMETERS_HERE
[sybase@sybase setup]$ more ase157_responsefile.txt
# Mon Aug 06 15:04:27 CST 2012
# Replay feature output
# ---------------------
# This file was built by the Replay feature of InstallAnywhere.
# It contains variables that were set by Panels, Consoles or Custom Code.
#Validate Response File
#----------------------
RUN_SILENT=true
AGREE_TO_SYBASE_LICENSE=true
#Choose Install Folder
#---------------------
USER_INSTALL_DIR=/opt/sybase
#Install older version
#---------------------
INSTALL_OLDER_VERSION=false
#Choose Update Install Option
#----------------------------
DO_UPDATE_INSTALL=false
#Choose Install Set
#------------------
CHOSEN_INSTALL_SET=Full
#Choose Product License Type
#---------------------------
SYBASE_PRODUCT_LICENSE_TYPE=evaluate
SYSAM_LICENSE_SOURCE=proceed_without_license
SYSAM_LICENSE_FILE_PATHNAME=
SYSAM_EXISTING_LICENSE_SERVER_HOSTNAME=
SYSAM_EXISTING_LICENSE_SERVER_PORTNUMBER=
SYSAM_PRODUCT_EDITION=Enterprise Edition
SYSAM_LICENSE_TYPE=EV : Evaluation License
#Configure New Servers
#---------------------
SY_CONFIG_ASE_SERVER=false
SY_CONFIG_BS_SERVER=false
SY_CONFIG_XP_SERVER=false
SY_CONFIG_JS_SERVER=false
SY_CONFIG_SM_SERVER=false
SY_CONFIG_WS_SERVER=false
SY_CONFIG_SCC_SERVER=false
SY_CONFIG_TXT_SERVER=false
#Remember ASE Password
#---------------------
ASEP_REMEMBER_PASSWORD=FALSE
ASEP_REMEMBER_PASSWORD_1=
ASEP_REMEMBER_PASSWORD_2=Disable
ASEP_REMEMBER_PASSWORD_BOOLEAN_1=0
ASEP_REMEMBER_PASSWORD_BOOLEAN_2=1
加粗部分为RadioButtonInputAction.install(): '$ASEP_REMEMBER_PASSWORD$' property has invalid '' value. The value must be one of the following: TRUE, FALSE解决方法。