也谈Sybase ASE15.x在Windows下的静态安装(silent install)-程序员宅基地

技术标签: 网络  数据库  

Sybase ASE数据库的图形界面安装,虽然比较顺利,但是也让中文用户很不爽,那就是字符集的选择,似乎没有余地,只能Customize选择,还不一定一次能选对。

比如,你一路安装的时候, ASE sql server创建的时候,很难从界面里头选择语言和字符集。

还好,ASE15.x提供了silent install的方式。

1. 安装并生成silent install的配置文件

运行setupconsole.exe -options-record c:\ase1503_silentinstall.txt,这一路你只安装软件,可选择完全安装,但别装数据库服务。

这样得到了样本配置文件:ase1503_silentinstall.txt

注意一边这几项内容即可:

-P installLocation="D:\sybase" ## 你可以到时候改为你想要的目录

-W installSoftwareLicenseType.type=developer

-W sysamLicense.proceedWithoutLicense=false
-W sysamLicense.useExistingLicenseServer=false
-W sysamLicense.licenseFile=


-W askConfig.configureAse=false
-W askConfig.configureBackup=false
-W askConfig.configureMonitor=false
-W askConfig.configureXp=false
-W askConfig.configureJobScheduler=false
-W askConfig.configureSelfManagement=false
-W askConfig.configureUnifiedAgent=false


这样安装完,你会得到一套没有数据库服务的Sybase ASE15.x. 如果你将其卸载,接着,运行:
setupConsole.exe -silent -options c:\ase1503_silentinstall.txt -W SybaseLicense.agreeToLicense=true -G replaceExistingResponse="yesToALL"

即可实现silentinstall。

2. build ase server

限于篇幅,这里以ASE的主server: sybase sqlserver为例,进入目录:

%SYBASE%\%SYBASE_ASE%\bin, 有个命令sybatch.exe,这个命令长期不见之于文档,不知道什么原因,它就是windows版的sqlbuilder,用于创建各个服务的。

输入资源配置文件在哪儿呢?从%SYBASE%\%SYBASE_ASE%\samples\server里头把sybatch_ase.res文件复制到c:\sybatch_ase.res

修改一下里边的内容,不然,肯定大多会失败:

改的地方:

1). 安装目录,保持一致

sybinit.boot_directory: D:\Sybase
sybinit.release_directory: D:\Sybase

所有的C:\**什么的,都得调成你现在安装的位置,包括数据文件。

2) sysprocs.dat文件大小,132太小,改成至少136

sqlsrv.do_create_sybsystemprocs_device: yes
sqlsrv.sybsystemprocs_device_physical_name: D:\Sybase\data\sysprocs.dat
sqlsrv.sybsystemprocs_device_size: 150
sqlsrv.sybsystemprocs_db_size: 150
sqlsrv.sybsystemprocs_device_logical_name: sysprocsdev

3) 字符集,这个是大家比较关心的:

sqlsrv.sort_order: binary
sqlsrv.default_characterset: utf8
sqlsrv.default_language: us_english

默认的是iso_1, english

4)下边三个值你可以改成你想要的

sqlsrv.server_name: SYBASE
sqlsrv.sa_password:
sqlsrv.sa_login: sa

这里帖出一个由sybatch.exe创建Sybase SqlServer服务的结果:运行sybatch.exe -r c:\sybatch_ase.res

结果如下:

D:\sybase\ASE-15_0\bin>sybatch.exe -r d:\SOFT\sybatch_ase.res
CONNECTIVITY ERROR: Open Client message: 'ct_connect(): network packet layer: in
ternal net library error: Net-Lib protocol driver call to connect two endpoints
failed
Failed to connect to the server - Error is 10061 由于目标机器积极拒绝,无法连接
。

'.
CONNECTIVITY ERROR: Initialization of auditinit connectivity module failed.
Running task: update Sybase Server entry in interfaces file.
Task succeeded: update Sybase Server entry in interfaces file.
Running task: create the master device.
Building the master device
......Done
Task succeeded: create the master device.
Running task: update Sybase Server entry in registry.
Task succeeded: update Sybase Server entry in registry.
Running task: start the Sybase Server.
waiting for server 'SYBASE' to boot...
waiting for server 'SYBASE' to boot...
waiting for server 'SYBASE' to boot...
waiting for server 'SYBASE' to boot...
waiting for server 'SYBASE' to boot...
Task succeeded: start the Sybase Server.
Running task: create the sybsystemprocs database.
sybsystemprocs database created.
Task succeeded: create the sybsystemprocs database.
Running task: install system stored procedures.
Installing system stored procedures : 10% complete...
Installing system stored procedures : 20% complete...
Installing system stored procedures : 30% complete...
Installing system stored procedures : 40% complete...
Installing system stored procedures : 50% complete...
Installing system stored procedures : 60% complete...
Installing system stored procedures : 70% complete...
Installing system stored procedures : 80% complete...
Installing system stored procedures : 90% complete...
Installing system stored procedures : 100% complete...
Task succeeded: install system stored procedures.
Running task: set permissions for the 'model' database.
Task succeeded: set permissions for the 'model' database.
Running task: set local Adaptive Server name.
Task succeeded: set local Adaptive Server name.
Running task: set the XP Server for the Adaptive Server.
Task succeeded: set the XP Server for the Adaptive Server.
Running task: update XP Server entry in registry.
Task succeeded: update XP Server entry in registry.
Running task: create temporary database.
Task succeeded: create temporary database.
Running task: set the default character set and/or default sort order for the Ad
aptive Server.
Setting the default character set to utf8
Installing character set 'utf8'
.Done
Sort order 'binary' has been successfully installed.
Sort order 'binary' has been successfully set to the default.
Waiting 15 seconds for the operating system to reclaim resources before rebootin
g.
waiting for server 'SYBASE' to boot...
waiting for server 'SYBASE' to boot...
waiting for server 'SYBASE' to boot...
waiting for server 'SYBASE' to boot...
waiting for server 'SYBASE' to boot...
Task succeeded: set the default character set and/or default sort order for the
Adaptive Server.
Running task: set the default language.
Setting the default language to us_english
Language 'us_english' is already the default.
Task succeeded: set the default language.
Running task: install sybsystemdb database.
sybsystemdb database extended.
Task succeeded: install sybsystemdb database.
Running task: set the Backup Server for the Adaptive Server.
Task succeeded: set the Backup Server for the Adaptive Server.
Running task: shutdown the Sybase Server.
Waiting 15 seconds for the operating system to reclaim resources before rebootin
g.
Task succeeded: shutdown the Sybase Server.
Running task: start the Sybase Server.
waiting for server 'SYBASE' to boot...
waiting for server 'SYBASE' to boot...
waiting for server 'SYBASE' to boot...
waiting for server 'SYBASE' to boot...
waiting for server 'SYBASE' to boot...
Task succeeded: start the Sybase Server.
Configuration completed successfully.
Running task: optimize ASE.
Optimize Configuration procedures : 10% complete...
Optimize Configuration procedures : 20% complete...
Optimize Configuration procedures : 30% complete...
Optimize Configuration procedures : 40% complete...
Optimize Configuration procedures : 50% complete...
Optimize Configuration procedures : 60% complete...
Optimize Configuration procedures : 70% complete...
Optimize Configuration procedures : 80% complete...
Optimize Configuration procedures : 90% complete...
Optimize Configuration procedures : 100% complete...
Task succeeded: optimize ASE.
Running task: shutdown the Sybase Server.
Waiting 15 seconds for the operating system to reclaim resources before rebootin
g.
Task succeeded: shutdown the Sybase Server.
Running task: start the Sybase Server.
waiting for server 'SYBASE' to boot...
waiting for server 'SYBASE' to boot...
waiting for server 'SYBASE' to boot...
waiting for server 'SYBASE' to boot...
waiting for server 'SYBASE' to boot...
Task succeeded: start the Sybase Server.
Configuration completed successfully.
Exiting.
The log file for this session is 'D:\sybase\ASE-15_0\init\logs\log0418.003'.
关于c:\sybatch_ase.res, 其内容如下,仅供参考:

#
# --- This is a "sybatch.exe" sample resource file. ---
#
# This sample resource file will configure a new
# 2k pagesize Adaptive Server "SYBASE".
#
sybinit.boot_directory:                         D:\Sybase
sybinit.release_directory:                      D:\Sybase
sqlsrv.do_add_server:                           yes
sqlsrv.network_hostname_list:			sql9xp
sqlsrv.network_port_list:                       5000
sqlsrv.network_protocol_list:                   tcp
sqlsrv.notes:
sqlsrv.connect_retry_delay_time:                5
sqlsrv.connect_retry_count:                     5
sqlsrv.new_config:                              yes
#
sqlsrv.server_name:                             SYBASE
sqlsrv.sa_password:                             
sqlsrv.sa_login:                                sa
sqlsrv.server_page_size:                        2k
#
# --- Set up master ----
#
sqlsrv.master_device_physical_name:             D:\Sybase\data\master.dat
sqlsrv.master_device_size:                      200
sqlsrv.master_db_size:				13
sqlsrv.disk_mirror_name:
#
# --- Set up sybsystemprocs ----
#
sqlsrv.do_create_sybsystemprocs_device:         yes
sqlsrv.sybsystemprocs_device_physical_name:     D:\Sybase\data\sysprocs.dat
sqlsrv.sybsystemprocs_device_size:              150
sqlsrv.sybsystemprocs_db_size:                  150
sqlsrv.sybsystemprocs_device_logical_name:      sysprocsdev
#
# --- Set up sybsystemdb ----
#
sqlsrv.do_create_sybsystemdb:			yes
sqlsrv.do_create_sybsystemdb_db_device:		yes
sqlsrv.sybsystemdb_db_device_physical_name:	D:\Sybase\data\sybsysdb.dat
sqlsrv.sybsystemdb_db_device_physical_size:	50
sqlsrv.sybsystemdb_db_size:			50
sqlsrv.sybsystemdb_db_device_logical_name:	systemdbdev
#
sqlsrv.errorlog:                                D:\Sybase\ASE-15_0\install\sybase.log
sqlsrv.sort_order:                              binary
sqlsrv.default_characterset:                    utf8
sqlsrv.default_language:                        us_english
#chinese
sqlsrv.preupgrade_succeeded:                    no
sqlsrv.network_name_alias_list:
sqlsrv.resword_conflict:                        0
sqlsrv.resword_done:                            no
sqlsrv.do_upgrade:                              no
sqlsrv.characterset_install_list:
sqlsrv.characterset_remove_list:
sqlsrv.language_install_list:
sqlsrv.language_remove_list:
sqlsrv.shared_memory_directory:
sqlsrv.addl_cmdline_parameters:
sqlsrv.eventlog:                                yes
sqlsrv.atr_name_shutdown_required:              yes
sqlsrv.atr_name_qinstall:                       no
#
sybinit.charset:                                utf8
sybinit.language:                               us_english
sybinit.resource_file:
sybinit.log_file:
sybinit.product:                                sqlsrv
#
sqlsrv.default_backup_server:                   SYBASE_BS
#
# optimize ASE
#
sqlsrv.do_optimize_config:			yes
sqlsrv.avail_physical_memory:			300
sqlsrv.avail_cpu_num:				1
sqlsrv.tempdb_device_physical_name:		D:\Sybase\data\tempdb.dat
sqlsrv.tempdb_device_size:			100
sqlsrv.tempdb_database_size:			100

sqlsrv.application_type:			MIXED

至于Backupserver, xp server, monitorserver在samples目录下边都能找到样例资源配置文件,不再缀述。 这个工具,现在的Sybase文档里头反而不再提及了。只要知道能用就行了。


版权声明:本文为博主原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。
本文链接:https://blog.csdn.net/jlins_you/article/details/84198428

智能推荐

Docker 快速上手学习入门教程_docker菜鸟教程-程序员宅基地

文章浏览阅读2.5w次,点赞6次,收藏50次。官方解释是,docker 容器是机器上的沙盒进程,它与主机上的所有其他进程隔离。所以容器只是操作系统中被隔离开来的一个进程,所谓的容器化,其实也只是对操作系统进行欺骗的一种语法糖。_docker菜鸟教程

电脑技巧:Windows系统原版纯净软件必备的两个网站_msdn我告诉你-程序员宅基地

文章浏览阅读5.7k次,点赞3次,收藏14次。该如何避免的,今天小编给大家推荐两个下载Windows系统官方软件的资源网站,可以杜绝软件捆绑等行为。该站提供了丰富的Windows官方技术资源,比较重要的有MSDN技术资源文档库、官方工具和资源、应用程序、开发人员工具(Visual Studio 、SQLServer等等)、系统镜像、设计人员工具等。总的来说,这两个都是非常优秀的Windows系统镜像资源站,提供了丰富的Windows系统镜像资源,并且保证了资源的纯净和安全性,有需要的朋友可以去了解一下。这个非常实用的资源网站的创建者是国内的一个网友。_msdn我告诉你

vue2封装对话框el-dialog组件_<el-dialog 封装成组件 vue2-程序员宅基地

文章浏览阅读1.2k次。vue2封装对话框el-dialog组件_

MFC 文本框换行_c++ mfc同一框内输入二行怎么换行-程序员宅基地

文章浏览阅读4.7k次,点赞5次,收藏6次。MFC 文本框换行 标签: it mfc 文本框1.将Multiline属性设置为True2.换行是使用"\r\n" (宽字符串为L"\r\n")3.如果需要编辑并且按Enter键换行,还要将 Want Return 设置为 True4.如果需要垂直滚动条的话将Vertical Scroll属性设置为True,需要水平滚动条的话将Horizontal Scroll属性设_c++ mfc同一框内输入二行怎么换行

redis-desktop-manager无法连接redis-server的解决方法_redis-server doesn't support auth command or ismis-程序员宅基地

文章浏览阅读832次。检查Linux是否是否开启所需端口,默认为6379,若未打开,将其开启:以root用户执行iptables -I INPUT -p tcp --dport 6379 -j ACCEPT如果还是未能解决,修改redis.conf,修改主机地址:bind 192.168.85.**;然后使用该配置文件,重新启动Redis服务./redis-server redis.conf..._redis-server doesn't support auth command or ismisconfigured. try

实验四 数据选择器及其应用-程序员宅基地

文章浏览阅读4.9k次。济大数电实验报告_数据选择器及其应用

随便推点

灰色预测模型matlab_MATLAB实战|基于灰色预测河南省社会消费品零售总额预测-程序员宅基地

文章浏览阅读236次。1研究内容消费在生产中占据十分重要的地位,是生产的最终目的和动力,是保持省内经济稳定快速发展的核心要素。预测河南省社会消费品零售总额,是进行宏观经济调控和消费体制改变创新的基础,是河南省内人民对美好的全面和谐社会的追求的要求,保持河南省经济稳定和可持续发展具有重要意义。本文建立灰色预测模型,利用MATLAB软件,预测出2019年~2023年河南省社会消费品零售总额预测值分别为21881...._灰色预测模型用什么软件

log4qt-程序员宅基地

文章浏览阅读1.2k次。12.4-在Qt中使用Log4Qt输出Log文件,看这一篇就足够了一、为啥要使用第三方Log库,而不用平台自带的Log库二、Log4j系列库的功能介绍与基本概念三、Log4Qt库的基本介绍四、将Log4qt组装成为一个单独模块五、使用配置文件的方式配置Log4Qt六、使用代码的方式配置Log4Qt七、在Qt工程中引入Log4Qt库模块的方法八、获取示例中的源代码一、为啥要使用第三方Log库,而不用平台自带的Log库首先要说明的是,在平时开发和调试中开发平台自带的“打印输出”已经足够了。但_log4qt

100种思维模型之全局观思维模型-67_计算机中对于全局观的-程序员宅基地

文章浏览阅读786次。全局观思维模型,一个教我们由点到线,由线到面,再由面到体,不断的放大格局去思考问题的思维模型。_计算机中对于全局观的

线程间控制之CountDownLatch和CyclicBarrier使用介绍_countdownluach于cyclicbarrier的用法-程序员宅基地

文章浏览阅读330次。一、CountDownLatch介绍CountDownLatch采用减法计算;是一个同步辅助工具类和CyclicBarrier类功能类似,允许一个或多个线程等待,直到在其他线程中执行的一组操作完成。二、CountDownLatch俩种应用场景: 场景一:所有线程在等待开始信号(startSignal.await()),主流程发出开始信号通知,既执行startSignal.countDown()方法后;所有线程才开始执行;每个线程执行完发出做完信号,既执行do..._countdownluach于cyclicbarrier的用法

自动化监控系统Prometheus&Grafana_-自动化监控系统prometheus&grafana实战-程序员宅基地

文章浏览阅读508次。Prometheus 算是一个全能型选手,原生支持容器监控,当然监控传统应用也不是吃干饭的,所以就是容器和非容器他都支持,所有的监控系统都具备这个流程,_-自动化监控系统prometheus&grafana实战

React 组件封装之 Search 搜索_react search-程序员宅基地

文章浏览阅读4.7k次。输入关键字,可以通过键盘的搜索按钮完成搜索功能。_react search