Sybase ASE15.7静默安装

 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解决方法。