也谈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

智能推荐

稀疏编码的数学基础与理论分析-程序员宅基地

文章浏览阅读290次,点赞8次,收藏10次。1.背景介绍稀疏编码是一种用于处理稀疏数据的编码技术,其主要应用于信息传输、存储和处理等领域。稀疏数据是指数据中大部分元素为零或近似于零的数据,例如文本、图像、音频、视频等。稀疏编码的核心思想是将稀疏数据表示为非零元素和它们对应的位置信息,从而减少存储空间和计算复杂度。稀疏编码的研究起源于1990年代,随着大数据时代的到来,稀疏编码技术的应用范围和影响力不断扩大。目前,稀疏编码已经成为计算...

EasyGBS国标流媒体服务器GB28181国标方案安装使用文档-程序员宅基地

文章浏览阅读217次。EasyGBS - GB28181 国标方案安装使用文档下载安装包下载,正式使用需商业授权, 功能一致在线演示在线API架构图EasySIPCMSSIP 中心信令服务, 单节点, 自带一个 Redis Server, 随 EasySIPCMS 自启动, 不需要手动运行EasySIPSMSSIP 流媒体服务, 根..._easygbs-windows-2.6.0-23042316使用文档

【Web】记录巅峰极客2023 BabyURL题目复现——Jackson原生链_原生jackson 反序列化链子-程序员宅基地

文章浏览阅读1.2k次,点赞27次,收藏7次。2023巅峰极客 BabyURL之前AliyunCTF Bypassit I这题考查了这样一条链子:其实就是Jackson的原生反序列化利用今天复现的这题也是大同小异,一起来整一下。_原生jackson 反序列化链子

一文搞懂SpringCloud,详解干货,做好笔记_spring cloud-程序员宅基地

文章浏览阅读734次,点赞9次,收藏7次。微服务架构简单的说就是将单体应用进一步拆分,拆分成更小的服务,每个服务都是一个可以独立运行的项目。这么多小服务,如何管理他们?(服务治理 注册中心[服务注册 发现 剔除])这么多小服务,他们之间如何通讯?这么多小服务,客户端怎么访问他们?(网关)这么多小服务,一旦出现问题了,应该如何自处理?(容错)这么多小服务,一旦出现问题了,应该如何排错?(链路追踪)对于上面的问题,是任何一个微服务设计者都不能绕过去的,因此大部分的微服务产品都针对每一个问题提供了相应的组件来解决它们。_spring cloud

Js实现图片点击切换与轮播-程序员宅基地

文章浏览阅读5.9k次,点赞6次,收藏20次。Js实现图片点击切换与轮播图片点击切换<!DOCTYPE html><html> <head> <meta charset="UTF-8"> <title></title> <script type="text/ja..._点击图片进行轮播图切换

tensorflow-gpu版本安装教程(过程详细)_tensorflow gpu版本安装-程序员宅基地

文章浏览阅读10w+次,点赞245次,收藏1.5k次。在开始安装前,如果你的电脑装过tensorflow,请先把他们卸载干净,包括依赖的包(tensorflow-estimator、tensorboard、tensorflow、keras-applications、keras-preprocessing),不然后续安装了tensorflow-gpu可能会出现找不到cuda的问题。cuda、cudnn。..._tensorflow gpu版本安装

随便推点

物联网时代 权限滥用漏洞的攻击及防御-程序员宅基地

文章浏览阅读243次。0x00 简介权限滥用漏洞一般归类于逻辑问题,是指服务端功能开放过多或权限限制不严格,导致攻击者可以通过直接或间接调用的方式达到攻击效果。随着物联网时代的到来,这种漏洞已经屡见不鲜,各种漏洞组合利用也是千奇百怪、五花八门,这里总结漏洞是为了更好地应对和预防,如有不妥之处还请业内人士多多指教。0x01 背景2014年4月,在比特币飞涨的时代某网站曾经..._使用物联网漏洞的使用者

Visual Odometry and Depth Calculation--Epipolar Geometry--Direct Method--PnP_normalized plane coordinates-程序员宅基地

文章浏览阅读786次。A. Epipolar geometry and triangulationThe epipolar geometry mainly adopts the feature point method, such as SIFT, SURF and ORB, etc. to obtain the feature points corresponding to two frames of images. As shown in Figure 1, let the first image be ​ and th_normalized plane coordinates

开放信息抽取(OIE)系统(三)-- 第二代开放信息抽取系统(人工规则, rule-based, 先抽取关系)_语义角色增强的关系抽取-程序员宅基地

文章浏览阅读708次,点赞2次,收藏3次。开放信息抽取(OIE)系统(三)-- 第二代开放信息抽取系统(人工规则, rule-based, 先关系再实体)一.第二代开放信息抽取系统背景​ 第一代开放信息抽取系统(Open Information Extraction, OIE, learning-based, 自学习, 先抽取实体)通常抽取大量冗余信息,为了消除这些冗余信息,诞生了第二代开放信息抽取系统。二.第二代开放信息抽取系统历史第二代开放信息抽取系统着眼于解决第一代系统的三大问题: 大量非信息性提取(即省略关键信息的提取)、_语义角色增强的关系抽取

10个顶尖响应式HTML5网页_html欢迎页面-程序员宅基地

文章浏览阅读1.1w次,点赞6次,收藏51次。快速完成网页设计,10个顶尖响应式HTML5网页模板助你一臂之力为了寻找一个优质的网页模板,网页设计师和开发者往往可能会花上大半天的时间。不过幸运的是,现在的网页设计师和开发人员已经开始共享HTML5,Bootstrap和CSS3中的免费网页模板资源。鉴于网站模板的灵活性和强大的功能,现在广大设计师和开发者对html5网站的实际需求日益增长。为了造福大众,Mockplus的小伙伴整理了2018年最..._html欢迎页面

计算机二级 考试科目,2018全国计算机等级考试调整,一、二级都增加了考试科目...-程序员宅基地

文章浏览阅读282次。原标题:2018全国计算机等级考试调整,一、二级都增加了考试科目全国计算机等级考试将于9月15-17日举行。在备考的最后冲刺阶段,小编为大家整理了今年新公布的全国计算机等级考试调整方案,希望对备考的小伙伴有所帮助,快随小编往下看吧!从2018年3月开始,全国计算机等级考试实施2018版考试大纲,并按新体系开考各个考试级别。具体调整内容如下:一、考试级别及科目1.一级新增“网络安全素质教育”科目(代..._计算机二级增报科目什么意思

conan简单使用_apt install conan-程序员宅基地

文章浏览阅读240次。conan简单使用。_apt install conan