一. 确认当前SYBASE ASE服务器版本：
1． 用isql登入Server，使用如下命令获知当前Server版本号：
select @@version
例：Adaptive Server Enterprise/11.9.2.5/1234/P/SWR 9676 ESD 1/RS6000/AIX 4.2.1/FBO/Tue Jul 24 04:43:25 2001
可以看到当前Server的版本号为11.9.2.5,目前补丁号为SWR后的数字 9676 ESD 1,平台为RS6000,操作系统为 AIX4.2.1。
2． 在Unix环境中可以使用如下命令:
cd $SYBASE
cd bin(如为12版本，则为cd ASE-12_0/bin)
./dataserver –v
可以得到如1同样的版本输出结果
二. 下载补丁
补丁可以从SYBASE的门户网站获得。
1. 网址为www.sybase.com
2. 点击download链接
3. 点击EBFs / Updates
4. 输入已注册的合法用户和口令，如果没有，可以点击create a new account创建一个新的下载账号后再行登录。
5. 登录后成功后，将能看见一个Product Families的产品列表，从中选择需要下载补丁的产品类型（如Adaptive Server Enterprise）
6. 选择Adaptive Server Enterprise后，会显示不同平台，不同操作系统版本的可下载补丁列表。根据实际情况选择相应的平台、操作系统版本（特别是操作系统是32位还是64位）及SYBASE数据库服务器版本，点击下载链接。如果有疑问，可以先通过察看补丁文件链接前的info链接中的说明文件了解补丁信息
7. 同意SYBASE软件下载协议的条款
8. 下载（下载过程中不要关闭网页，否则Cookie将过期，导致下在中断）
三. 补丁安装
基于不同平台不同操作系统，补丁的文件类型可能有不同，一般为ZIP(NT),TGZ(UNIX),TAR(UNIX)，安装补丁的方法也因而有所不同。
1． 全备份SYBASE数据库。包括用户数据库及master数据库。如果有条件，还可以将用户库数据使用bcp工具进行备份，以预防数据库本身已存在的故障导致load失败。
2． 关闭所有的SYBASE服务器，包括数据库服务器，备份服务器，监控服务器等，关闭所有SYBASE的应用程序，包括isql(DOS)、wisql(ver10)、SQL Advantage(ver11.5以上)、jisql(ver12)、SYBASE CENTRAL，SQLEDIT(ver10)、DSEDIT(ver11以上)，还包括等所有使用的SYBASE系统文件的应用程序，包括数据库应用系统及开发环境等。
3． 备份SYBASE原安装目录，如/usr/Sybase(UNIX)或者是c:\sybase(WINNT)。
4． 安装补丁（解包）
UNIX：
a. 将下载得到的补丁通过网络使用ftp或者其他方式拷贝到需安装补丁的主机上
b. 如果下载的补丁为tgz格式，使用操作系统下适当的命令进行解压缩得到类型为tar的打包文件，如gunzip,unzip等，具体命令格式见操作系统的管理员手册。如为WINNT环境，此步略过。
c.
UNIX平台：
将解压缩得到的tar文件拷贝到SYBASE产品的安装目录下，使用如下命令格式进行解包，对SYBASE文件进行覆盖实现文件替换，达到安装补丁的目的：
tar –xvf EBFxxxx
其中xxxx为补丁号，如9299。关于tar命令的使用请详见操作系统命令指南
WINNT平台:
将下载得到的zip文件拷贝到SYBASE产品的安装目录下，使用winzip或者其他解压缩工具解包到当前目录，对SYBASE文件进行覆盖实现文件替换，达到安装补丁的目的。解压缩过程中应该有文件覆盖的提示信息。
d. 解包成功后在SYBASE安装目录下将看到文件名如Cover.ROLL.xxxx的说明文件（xxxx为补丁号），此文件中详细的说明了补丁包含文件内容、安装的详细操作步骤以及补丁对那些BUG进行了修正等，请使用文本阅读器打开此文件仔细阅读。
e. 验证是否补丁文件正确安装：
进入SYBASE安装目录下dataserver(Unix)/sqlsrvr(Nt)所在的目录察看版本信息
cd $sybase 进入Sybase ASE 安装目录
cd ASE-12_0/bin[12版本以上](或者cd bin[1192版本以下])
./dataserver –v(Unix)
sqlsrvr –v（Nt）
在显示的版本信息中应该可以看到所安装的补丁信息，如
Adaptive Server Enterprise/11.9.2.5/1234/P/SWR 9676 ESD 1/RS6000/AIX 4.2.1/FBO/Tue Jul 24 04:43:25 2001
中的9676 ESD 1信息。如果没有看到，则说明补丁解包过程中的覆盖有问题，请检查解包路径，目录大小写等相关问题，之后重新解包，直到安装正确。
f. 启动SYBASE各服务器，注意监控启动过程中的启动信息，察看是否有警告，错误等信息，察看服务器是否能够正常启动和使用。
g. 根据不同的补丁需求，可能此后操作步骤稍有不同：
一般情况下，需要对SYBASE的系统存储过程及系统提示信息进行更新。是否需要执行更新，根据Cover.ROLL.xxxx中的说明。
cd $SYBASE/scripts(12版本为cd $SYBASE/ASE-12_0/scripts)
isql –Usa –Ppasswd -i installmaster
isql –Usa –Ppasswd -i instmsgs.ebf
如在此过程中出现意外中断（停电等），请在故障排除后保证此过程重新顺利完成，以免留下隐患。
至此。补丁安装顺利完成，对应用系统进行全面的测试。
附录
出 错 处 理
如果在安装补丁过程中出现故障，根据不同的错误程度和故障原因有不同的处理办法。在最坏情况下，可按照下面的方法进行数据库系统恢复:
1． 关闭所有数据库服务器，如果它处于运行状态
2． 关闭所有SYBASE应用程序和工具
3． 恢复原SYBASE安装文件的备份目录
4． 重新启动老版本SYBASE，并将原数据库备份进行load恢复
5． 确定出错原因，下载正确补丁或者更新补丁进行安装
jazy 回复于：2003-02-22 10:13:38
很好！
我想，这时很多人需要的，置为精华先！
rabbitdan 回复于：2003-02-24 11:20:27
请问blackrose大侠：
我在solaris下安装了ASE12。5 但是在建一个服务的时候总是
失败，我找不到问题的所在。详细的过程如下。
我的pagesize＝8k
$ srvbuildres -r sql.rs
srvbuildres: Building Adaptive Server 'jcweb':
srvbuildres: Writing entry into directory services...
srvbuildres: Directory services entry complete.
srvbuildres: Building master device...
srvbuildres: Master device complete.
srvbuildres: Writing RUN_jcweb file...
srvbuildres: RUN_jcweb file complete.
srvbuildres: Starting server...
srvbuildres: Task failed
srvbuildres: Unable to boot server 'jcweb'.
srvbuildres: Server 'jcweb' was not created.
我的日志文件有错误的记载如下：
00:00000:00001:2003/02/24 11:22:45.08 server Database 'tempdb' is now online.
00:00000:00002:2003/02/24 11:22:45.09 kernel ninit:0: listener type: master
00:00000:00002:2003/02/24 11:22:45.09 kernel ninit:0: listener endpoint: /dev/tcp
00:00000:00002:2003/02/24 11:22:45.09 kernel ninit:0: listener raw address: \x00021172c0a810050000000000000000
00:00000:00002:2003/02/24 11:22:45.09 kernel ninit:0: transport provider: T_COTS_ORD
00:00000:00002:2003/02/24 11:22:45.09 kernel ninit: t_bind, No Error
00:00000:00002:2003/02/24 11:22:45.09 kernel ninit: All master network listeners have failed. Shutting down.
00:00000:00002:2003/02/24 11:22:45.09 kernel ueshutdown: exiting
整个日志文件如下：
00:00000:00000:2003/02/24 11:19:54.06 kernel Use license file /export/home/sybase/SYSAM-1_0/licenses/license.d
at.
00:00000:00000:2003/02/24 11:19:54.06 kernel Checked out license ASE_SERVER
00:00000:00000:2003/02/24 11:19:54.11 kernel Using config area from primary master device.
00:00000:00000:2003/02/24 11:19:54.13 kernel Warning: Using default file '/export/home/sybase/jcweb.cfg' since
a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this
message.
00:00000:00000:2003/02/24 11:19:54.33 kernel Using 1024 file descriptors.
00:00000:00000:2003/02/24 11:19:54.33 kernel Adaptive Server Enterprise/12.5/SWR 9610 GA/P/Sun_svr4/OS 5.8/mai
n/1647/64-bit/FBO/Sat Jun 2 01:55:25 2001
00:00000:00000:2003/02/24 11:19:54.33 kernel Confidential property of Sybase, Inc.
00:00000:00000:2003/02/24 11:19:54.33 kernel Copyright 1987, 2001
00:00000:00000:2003/02/24 11:19:54.33 kernel Sybase, Inc. All rights reserved.
00:00000:00000:2003/02/24 11:19:54.33 kernel Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2003/02/24 11:19:54.33 kernel
00:00000:00000:2003/02/24 11:19:54.33 kernel This software contains confidential and trade secret information
of Sybase,
00:00000:00000:2003/02/24 11:19:54.33 kernel Inc. Use, duplication or disclosure of the software and docume
ntation by
00:00000:00000:2003/02/24 11:19:54.33 kernel the U.S. Government is subject to restrictions set forth in
a license
00:00000:00000:2003/02/24 11:19:54.33 kernel agreement between the Government and Sybase, Inc. or othe
r written
00:00000:00000:2003/02/24 11:19:54.33 kernel agreement specifying the Government's rights to use the softwa
re and any
00:00000:00000:2003/02/24 11:19:54.33 kernel applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2003/02/24 11:19:54.33 kernel Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2003/02/24 11:19:54.33 kernel Using '/export/home/sybase/jcweb.cfg' for configuration informati
on.
00:00000:00000:2003/02/24 11:19:54.33 kernel Logging ASE messages in file '/export/home/sybase/ASE-12_5/instal
l/jcweb.log'.
00:00000:00000:2003/02/24 11:19:54.37 kernel kdcl_sess_open: connectivity library supports master/query syntax
.
00:00000:00000:2003/02/24 11:19:54.38 kernel Directory Control Layer (DCL) using directory driver: InterfacesD
river
00:00000:00000:2003/02/24 11:19:54.38 kernel SSL Plus security modules loaded successfully.
00:00000:00000:2003/02/24 11:19:54.38 kernel Network and device connection limit is 1014.
00:00000:00000:2003/02/24 11:19:54.56 server Number of blocks left for proc headers: 3192.
00:00000:00000:2003/02/24 11:19:54.57 server Proc header memory allocated 1596 pages for each per engine cache
00:00000:00000:2003/02/24 11:19:54.60 server Memory allocated for the default data cache cachelet 1: 8192 Kb
00:00000:00000:2003/02/24 11:19:54.60 server Size of the 8K memory pool: 8192 Kb
00:00000:00000:2003/02/24 11:19:54.60 kernel Enabling Sun Kernel asynchronous disk I/O strategy
00:00000:00000:2003/02/24 11:19:54.60 kernel Initializing virtual device 0, '/databasefile/jcweb/db/master.dat
' with dsync 'on'.
00:00000:00000:2003/02/24 11:19:54.60 kernel Virtual device 0 started using asynchronous i/o.
00:00000:00000:2003/02/24 11:19:54.60 kernel Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2003/02/24 11:19:54.60 kernel Either the config parameter 'use security services' is set to 0,
or ASE does not support use of external security mechanisms on this platform. The Security Control Layer will n
ot be initialized. No external security mechanisms will be supported.
00:00000:00000:2003/02/24 11:19:54.60 kernel engine 0, os pid 550 online
00:00000:00000:2003/02/24 11:19:54.60 server No active traceflags
00:00000:00001:2003/02/24 11:19:54.61 kernel libomni1 - Component Integration Services loaded; version 'libomn
i1 - Component Integration Services/12.5/SWR 9610 GA/P/Sun_svr4/OS 5.8/main/1647/64-bit/FBO/Sat Jun 2 01:55:25
2001'.
00:00000:00001:2003/02/24 11:19:54.61 kernel libomni1 - Component Integration Services: using 'Sybase Client-L
ibrary/12.5/P/SPARC/Solaris 2.8/1/64bit/OPT/Sun Mar 25 08:30:37 2001'
00:00000:00001:2003/02/24 11:19:54.61 server The logical pagesize of the server is 8 Kb.
00:00000:00001:2003/02/24 11:19:54.61 server Database 'master' appears to be at an older revision than the pre
sent installation; SQL Server will assess it, and upgrade it as required.
00:00000:00001:2003/02/24 11:19:54.63 server Database 'master': beginning upgrade step [ID 1]: Initialize
disk and create empty allocation units on master device.
00:00000:00001:2003/02/24 11:21:09.43 server Database 'master': beginning upgrade step [ID 2]: Bootstrap b
asic system catalogs in database.
00:00000:00001:2003/02/24 11:21:09.78 server Database 'master': beginning upgrade step [ID 3]: creating in
dex (table systypes, index ncsystypes)
00:00000:00001:2003/02/24 11:21:09.90 server Database 'master': beginning upgrade step [ID 4]: creating in
dex (table sysobjects, index ncsysobjects)
00:00000:00001:2003/02/24 11:21:09.98 server Database 'master': beginning upgrade step [ID 20]: creating ta
ble (table sysusages)
00:00000:00001:2003/02/24 11:21:10.26 server Database 'master': beginning upgrade step [ID 21]: creating ta
ble (table sysdatabases)
00:00000:00001:2003/02/24 11:21:10.49 server Database 'master': beginning upgrade step [ID 22]: creating ta
ble (table sysdevices)
00:00000:00001:2003/02/24 11:21:10.75 server Database 'master': beginning upgrade step [ID 23]: creating ta
ble (table sysmessages)
00:00000:00001:2003/02/24 11:21:11.06 server Database 'master': beginning upgrade step [ID 24]: creating ta
ble (table sysconfigures)
00:00000:00001:2003/02/24 11:21:11.39 server Database 'master': beginning upgrade step [ID 25]: creating ta
ble (table syscharsets)
00:00000:00001:2003/02/24 11:21:11.61 server Database 'master': beginning upgrade step [ID 26]: creating ta
ble (table sysprocedures)
00:00000:00001:2003/02/24 11:21:11.82 server Database 'master': beginning upgrade step [ID 27]: creating ta
ble (table syscomments)
00:00000:00001:2003/02/24 11:21:11.97 server Database 'master': beginning upgrade step [ID 28]: creating ta
ble (table syssegments)
00:00000:00001:2003/02/24 11:21:12.12 server Database 'master': beginning upgrade step [ID 29]: creating ta
ble (table sysprotects)
00:00000:00001:2003/02/24 11:21:12.29 server Database 'master': beginning upgrade step [ID 30]: creating ta
ble (table sysusers)
00:00000:00001:2003/02/24 11:21:12.59 server Database 'master': beginning upgrade step [ID 31]: creating ta
ble (table sysalternates)
00:00000:00001:2003/02/24 11:21:12.71 server Database 'master': beginning upgrade step [ID 32]: creating ta
ble (table sysdepends)
00:00000:00001:2003/02/24 11:21:12.94 server Database 'master': beginning upgrade step [ID 33]: creating ta
ble (table syskeys)
00:00000:00001:2003/02/24 11:21:13.14 server Database 'master': beginning upgrade step [ID 35]: creating ta
ble (table sysprocesses)
00:00000:00001:2003/02/24 11:21:13.17 server Database 'master': beginning upgrade step [ID 36]: creating ta
ble (table syslogins)
00:00000:00001:2003/02/24 11:21:13.44 server Database 'master': beginning upgrade step [ID 37]: creating ta
ble (table syslocks)
00:00000:00001:2003/02/24 11:21:13.47 server Database 'master': beginning upgrade step [ID 38]: creating ta
ble (table syscurconfigs)
00:00000:00001:2003/02/24 11:21:13.64 server Database 'master': beginning upgrade step [ID 39]: creating ta
ble (table sysservers)
00:00000:00001:2003/02/24 11:21:13.82 server Database 'master': beginning upgrade step [ID 40]: creating ta
ble (table sysremotelogins)
00:00000:00001:2003/02/24 11:21:14.04 server Database 'master': beginning upgrade step [ID 41]: creating ta
ble (table sysmonitors)
00:00000:00001:2003/02/24 11:21:14.08 server Database 'master': beginning upgrade step [ID 42]: creating ta
ble (table sysengines)
00:00000:00001:2003/02/24 11:21:14.11 server Database 'master': beginning upgrade step [ID 43]: creating ta
ble (table syslanguages)
00:00000:00001:2003/02/24 11:21:14.40 server Database 'master': beginning upgrade step [ID 44]: creating ta
ble (table systestlog)
00:00000:00001:2003/02/24 11:21:14.44 server Database 'master': beginning upgrade step [ID 45]: creating ta
ble (table syssrvroles)
00:00000:00001:2003/02/24 11:21:14.64 server Database 'master': beginning upgrade step [ID 46]: creating ta
ble (table sysloginroles)
00:00000:00001:2003/02/24 11:21:14.82 server Database 'master': beginning upgrade step [ID 80]: creating ta
ble (table sysattributes)
00:00000:00001:2003/02/24 11:21:15.13 server Database 'master': beginning upgrade step [ID 81]: Load initia
l set of attribute-definition rows into SYSATTRIBUTES.
00:00000:00001:2003/02/24 11:21:19.38 server Warning: Using only the first 30 characters for password
00:00000:00001:2003/02/24 11:21:22.74 server Database 'master': beginning upgrade step [ID 251]: creating ta
ble (table syslogshold)
00:00000:00001:2003/02/24 11:21:22.87 server Database 'master': beginning upgrade step [ID 252]: creating ta
ble (table syslisteners)
00:00000:00001:2003/02/24 11:21:22.93 server Database 'master': beginning upgrade step [ID 253]: creating ta
ble (table syssecmechs)
00:00000:00001:2003/02/24 11:21:22.99 server Database 'master': beginning upgrade step [ID 600]: creating ta
ble (table sysreferences)
00:00000:00001:2003/02/24 11:21:23.35 server Database 'master': beginning upgrade step [ID 601]: creating ta
ble (table sysconstraints)
00:00000:00001:2003/02/24 11:21:23.66 server Database 'master': beginning upgrade step [ID 602]: creating ta
ble (table sysusermessages)
00:00000:00001:2003/02/24 11:21:23.96 server Database 'master': beginning upgrade step [ID 603]: creating ta
ble (table systhresholds)
00:00000:00001:2003/02/24 11:21:24.12 server Database 'master': beginning upgrade step [ID 604]: creating ta
ble (table sysroles)
00:00000:00001:2003/02/24 11:21:24.40 server Database 'master': beginning upgrade step [ID 605]: executing S
QL statement (declare @rid smallint delete sysro)
00:00000:00001:2003/02/24 11:21:24.55 server Database 'master': beginning upgrade step [ID 606]: executing S
QL statement (select lct_admin('lastchance', db_i)
00:00000:00001:2003/02/24 11:21:24.58 server Database 'master': beginning upgrade step [ID 1013]: creating ta
ble (table syspartitions)
00:00000:00001:2003/02/24 11:21:24.82 server Database 'master': beginning upgrade step [ID 1025]: creating ta
ble (table systimeranges)
00:00000:00001:2003/02/24 11:21:24.99 server Database 'master': beginning upgrade step [ID 1026]: executing S
QL statement (if not exists (select 1 from systim)
00:00000:00001:2003/02/24 11:21:25.03 server Database 'master': beginning upgrade step [ID 1027]: creating ta
ble (table sysresourcelimits)
00:00000:00001:2003/02/24 11:21:25.32 server Database 'master': beginning upgrade step [ID 1082]: executing S
QL statement (if not exists (select 1 from sysatt)
00:00000:00001:2003/02/24 11:21:25.37 server Database 'master': beginning upgrade step [ID 1124]: creating ta
ble (table systabstats)
00:00000:00001:2003/02/24 11:21:25.67 server Database 'master': beginning upgrade step [ID 1125]: creating ta
ble (table sysstatistics)
00:00000:00001:2003/02/24 11:21:26.03 server Database 'master': beginning upgrade step [ID 1126]: Initialize
systabstats with valid statistics
00:00000:00001:2003/02/24 11:21:26.92 server Database 'master': beginning upgrade step [ID 1131]: Creating/Up
dating the last chance threshold for logsegment.
00:00000:00001:2003/02/24 11:21:26.94 server Database 'master': beginning upgrade step [ID 1201]: creating ta
ble (table sysxtypes)
00:00000:00001:2003/02/24 11:21:27.39 server Database 'master': beginning upgrade step [ID 1205]: creating ta
ble (table sysjars)
00:00000:00001:2003/02/24 11:21:27.75 server Database 'master': beginning upgrade step [ID 1206]: executing S
QL statement (if not exists (select 1 from systyp)
00:00000:00001:2003/02/24 11:21:27.85 server Database 'master': beginning upgrade step [ID 1212]: creating ta
ble (table systransactions)
00:00000:00001:2003/02/24 11:21:27.94 server Database 'master': beginning upgrade step [ID 1213]: executing S
QL statement (update sysobjects set sysstat2 = sy)
00:00000:00001:2003/02/24 11:21:27.98 server Database 'master': beginning upgrade step [ID 1214]: executing S
QL statement (if not exists (select 1 from syssrv)
00:00000:00001:2003/02/24 11:21:28.01 server Database 'master': beginning upgrade step [ID 1226]: executing S
QL statement (insert sysattributes (class, attrib)
00:00000:00001:2003/02/24 11:21:28.05 server Database 'master': beginning upgrade step [ID 1240]: creating ta
ble (table sysqueryplans)
00:00000:00001:2003/02/24 11:21:28.42 server Database 'master': beginning upgrade step [ID 1241]: executing S
QL statement (insert into sysattributes (class, )
00:00000:00001:2003/02/24 11:21:28.52 server Database 'master': beginning upgrade step [ID 1242]: creating ta
ble (table syssessions)
00:00000:00001:2003/02/24 11:21:28.61 server Database 'master': beginning upgrade step [ID 1245]: executing S
QL statement (if not exists (select 1 from syssrv)
00:00000:00001:2003/02/24 11:21:28.65 server Database 'master': beginning upgrade step [ID 1249]: executing S
QL statement (if (select suser_id('sa')) is not n)
00:00000:00001:2003/02/24 11:21:28.69 server Database 'master': beginning upgrade step [ID 1338]: executing S
QL statement (delete from sysconfigures where con)
00:00000:00001:2003/02/24 11:21:28.71 server Database 'master': beginning upgrade step [ID 1339]: creating ta
ble (table syscertificates)
00:00000:00001:2003/02/24 11:21:28.98 server Database 'master': beginning upgrade step [ID 1340]: executing S
QL statement (update systypes set length=@@maxpag)
00:00000:00001:2003/02/24 11:21:28.99 server Database 'master': beginning upgrade step [ID 1344]: executing S
QL statement (update sysattributes set int_value=)
00:00000:00001:2003/02/24 11:21:29.03 server Database 'master': beginning upgrade step [ID 1345]: executing S
QL statement (update sysattributes set int_value=)
00:00000:00001:2003/02/24 11:21:29.06 server Database 'master': beginning upgrade step [ID 1400]: noting the
present database upgrade level
00:00000:00001:2003/02/24 11:21:29.10 server Database 'model' appears to be at an older revision than the pres
ent installation; SQL Server will assess it, and upgrade it as required.
00:00000:00001:2003/02/24 11:21:29.10 server Database 'model': beginning upgrade step [ID 1]: Initialize d
isk and create empty allocation units on master device.
00:00000:00001:2003/02/24 11:21:55.22 server Database 'model': beginning upgrade step [ID 2]: Bootstrap ba
sic system catalogs in database.
00:00000:00001:2003/02/24 11:21:55.54 server Database 'model': beginning upgrade step [ID 3]: creating ind
ex (table systypes, index ncsystypes)
00:00000:00001:2003/02/24 11:21:55.65 server Database 'model': beginning upgrade step [ID 4]: creating ind
ex (table sysobjects, index ncsysobjects)
00:00000:00001:2003/02/24 11:21:55.70 server Database 'model': beginning upgrade step [ID 26]: creating tab
le (table sysprocedures)
00:00000:00001:2003/02/24 11:21:55.89 server Database 'model': beginning upgrade step [ID 27]: creating tab
le (table syscomments)
00:00000:00001:2003/02/24 11:21:56.03 server Database 'model': beginning upgrade step [ID 28]: creating tab
le (table syssegments)
00:00000:00001:2003/02/24 11:21:56.09 server Database 'model': beginning upgrade step [ID 29]: creating tab
le (table sysprotects)
00:00000:00001:2003/02/24 11:21:56.34 server Database 'model': beginning upgrade step [ID 30]: creating tab
le (table sysusers)
00:00000:00001:2003/02/24 11:21:56.64 server Database 'model': beginning upgrade step [ID 31]: creating tab
le (table sysalternates)
00:00000:00001:2003/02/24 11:21:56.78 server Database 'model': beginning upgrade step [ID 32]: creating tab
le (table sysdepends)
00:00000:00001:2003/02/24 11:21:56.96 server Database 'model': beginning upgrade step [ID 33]: creating tab
le (table syskeys)
00:00000:00001:2003/02/24 11:21:57.17 server Database 'model': beginning upgrade step [ID 80]: creating tab
le (table sysattributes)
00:00000:00001:2003/02/24 11:21:57.51 server Database 'model': beginning upgrade step [ID 600]: creating tab
le (table sysreferences)
00:00000:00001:2003/02/24 11:21:57.88 server Database 'model': beginning upgrade step [ID 601]: creating tab
le (table sysconstraints)
00:00000:00001:2003/02/24 11:21:58.09 server Database 'model': beginning upgrade step [ID 602]: creating tab
le (table sysusermessages)
00:00000:00001:2003/02/24 11:21:58.36 server Database 'model': beginning upgrade step [ID 603]: creating tab
le (table systhresholds)
00:00000:00001:2003/02/24 11:21:58.57 server Database 'model': beginning upgrade step [ID 604]: creating tab
le (table sysroles)
00:00000:00001:2003/02/24 11:21:58.72 server Database 'model': beginning upgrade step [ID 605]: executing SQ
L statement (declare @rid smallint delete sysro)
00:00000:00001:2003/02/24 11:21:58.94 server Database 'model': beginning upgrade step [ID 606]: executing SQ
L statement (select lct_admin('lastchance', db_i)
00:00000:00001:2003/02/24 11:21:58.97 server Database 'model': beginning upgrade step [ID 1013]: creating tab
le (table syspartitions)
00:00000:00001:2003/02/24 11:21:59.09 server Database 'model': beginning upgrade step [ID 1124]: creating tab
le (table systabstats)
00:00000:00001:2003/02/24 11:21:59.34 server Database 'model': beginning upgrade step [ID 1125]: creating tab
le (table sysstatistics)
00:00000:00001:2003/02/24 11:21:59.61 server Database 'model': beginning upgrade step [ID 1126]: Initialize s
ystabstats with valid statistics
00:00000:00001:2003/02/24 11:22:00.14 server Database 'model': beginning upgrade step [ID 1131]: Creating/Upd
ating the last chance threshold for logsegment.
00:00000:00001:2003/02/24 11:22:00.17 server Database 'model': beginning upgrade step [ID 1201]: creating tab
le (table sysxtypes)
00:00000:00001:2003/02/24 11:22:00.51 server Database 'model': beginning upgrade step [ID 1205]: creating tab
le (table sysjars)
00:00000:00001:2003/02/24 11:22:00.85 server Database 'model': beginning upgrade step [ID 1206]: executing SQ
L statement (if not exists (select 1 from systyp)
00:00000:00001:2003/02/24 11:22:00.87 server Database 'model': beginning upgrade step [ID 1240]: creating tab
le (table sysqueryplans)
00:00000:00001:2003/02/24 11:22:01.21 server Database 'model': beginning upgrade step [ID 1241]: executing SQ
L statement (insert into sysattributes (class, )
00:00000:00001:2003/02/24 11:22:01.26 server Database 'model': beginning upgrade step [ID 1340]: executing SQ
L statement (update systypes set length=@@maxpag)
00:00000:00001:2003/02/24 11:22:01.28 server Database 'model': beginning upgrade step [ID 1400]: noting the p
resent database upgrade level
00:00000:00001:2003/02/24 11:22:01.36 server CREATE DATABASE: allocating 1024 logical pages (8.0 megabytes) on
disk 'master'.
00:00000:00001:2003/02/24 11:22:37.63 server Database sybsystemdb successfully created.
00:00000:00001:2003/02/24 11:22:37.70 server Recovering database 'sybsystemdb'.
00:00000:00001:2003/02/24 11:22:37.71 server Redo pass of recovery has processed 2 committed and 0 aborted tra
nsactions.
00:00000:00001:2003/02/24 11:22:37.86 server Boot Count: 1
00:00000:00001:2003/02/24 11:22:37.88 server Checking external objects.
00:00000:00001:2003/02/24 11:22:37.89 server Database 'sybsystemdb' is now online.
00:00000:00001:2003/02/24 11:22:37.90 server Now loading SQL Server's new default sort order and character set
00:00000:00001:2003/02/24 11:22:37.90 server Checking sysobjects: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.90 server Checking systypes: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.90 server Checking sysusers: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.90 server Checking sysreferences: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.90 server Checking sysreferences: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.90 server Checking sysreferences: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.90 server Checking sysattributes: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.90 server Checking sysattributes: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.90 server Checking sysxtypes: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.90 server Checking sysjars: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.91 server Checking sysobjects: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.91 server Checking systypes: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.91 server Checking sysusers: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.91 server Checking sysreferences: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.91 server Checking sysreferences: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.91 server Checking sysreferences: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.91 server Checking sysattributes: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.91 server Checking sysattributes: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.91 server Checking sysxtypes: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.91 server Checking sysjars: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.91 server Checking sysobjects: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.91 server Checking systypes: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.91 server Checking sysusers: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.91 server Checking sysreferences: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.91 server Checking sysreferences: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.91 server Checking sysreferences: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.91 server Checking sysattributes: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.92 server Checking sysattributes: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.92 server Checking sysxtypes: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.92 server Checking sysjars: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.92 server Checking sysdatabases: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.92 server Checking syslogins: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.92 server Checking sysdevices: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.92 server Checking sysconfigures: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.92 server Checking sysservers: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.92 server Checking sysremotelogins: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.92 server Checking syslanguages: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.92 server Checking syslanguages: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.93 server Checking syscharsets: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.93 server Checking sysresourcelimits: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:38.01 server Default Sort Order successfully changed.
00:00000:00001:2003/02/24 11:22:38.01 server SQL Server shutdown after verifying System Indexes.
00:00000:00001:2003/02/24 11:22:38.01 kernel ueshutdown: exiting
00:00000:00000:2003/02/24 11:22:38.18 kernel Use license file /export/home/sybase/SYSAM-1_0/licenses/license.d
at.
00:00000:00000:2003/02/24 11:22:38.18 kernel Checked out license ASE_SERVER
00:00000:00000:2003/02/24 11:22:38.19 kernel Using config area from primary master device.
00:00000:00000:2003/02/24 11:22:38.23 kernel os_find_good_keyfile: Found shared memory segment: key 0xea00eb17
, id 1201
00:00000:00000:2003/02/24 11:22:38.25 kernel os_find_good_keyfile: If SQL Server using it is not running, remo
ve it by hand
00:00000:00000:2003/02/24 11:22:38.25 kernel os_find_good_keyfile: Trying a different key
00:00000:00000:2003/02/24 11:22:38.44 kernel Using 1024 file descriptors.
00:00000:00000:2003/02/24 11:22:38.45 kernel Adaptive Server Enterprise/12.5/SWR 9610 GA/P/Sun_svr4/OS 5.8/mai
n/1647/64-bit/FBO/Sat Jun 2 01:55:25 2001
00:00000:00000:2003/02/24 11:22:38.45 kernel Confidential property of Sybase, Inc.
00:00000:00000:2003/02/24 11:22:38.45 kernel Copyright 1987, 2001
00:00000:00000:2003/02/24 11:22:38.45 kernel Sybase, Inc. All rights reserved.
00:00000:00000:2003/02/24 11:22:38.45 kernel Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2003/02/24 11:22:38.45 kernel
00:00000:00000:2003/02/24 11:22:38.45 kernel This software contains confidential and trade secret information
of Sybase,
00:00000:00000:2003/02/24 11:22:38.45 kernel Inc. Use, duplication or disclosure of the software and docume
ntation by
00:00000:00000:2003/02/24 11:22:38.45 kernel the U.S. Government is subject to restrictions set forth in
a license
00:00000:00000:2003/02/24 11:22:38.45 kernel agreement between the Government and Sybase, Inc. or othe
r written
00:00000:00000:2003/02/24 11:22:38.45 kernel agreement specifying the Government's rights to use the softwa
re and any
00:00000:00000:2003/02/24 11:22:38.45 kernel applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2003/02/24 11:22:38.45 kernel Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2003/02/24 11:22:38.45 kernel Using '/export/home/sybase/ASE-12_5/jcweb.cfg' for configuration
information.
00:00000:00000:2003/02/24 11:22:38.45 kernel Logging ASE messages in file '/export/home/sybase/ASE-12_5/instal
l/jcweb.log'.
00:00000:00000:2003/02/24 11:22:38.48 kernel kdcl_sess_open: connectivity library supports master/query syntax
.
00:00000:00000:2003/02/24 11:22:38.49 kernel Directory Control Layer (DCL) using directory driver: InterfacesD
river
00:00000:00000:2003/02/24 11:22:38.49 kernel SSL Plus security modules loaded successfully.
00:00000:00000:2003/02/24 11:22:38.49 kernel Network and device connection limit is 1014.
00:00000:00000:2003/02/24 11:22:38.68 server Number of blocks left for proc headers: 3192.
00:00000:00000:2003/02/24 11:22:38.69 server Proc header memory allocated 1596 pages for each per engine cache
00:00000:00000:2003/02/24 11:22:38.71 server Memory allocated for the default data cache cachelet 1: 8192 Kb
00:00000:00000:2003/02/24 11:22:38.71 server Size of the 8K memory pool: 8192 Kb
00:00000:00000:2003/02/24 11:22:38.71 kernel Enabling Sun Kernel asynchronous disk I/O strategy
00:00000:00000:2003/02/24 11:22:38.71 kernel Initializing virtual device 0, '/databasefile/jcweb/db/master.dat
' with dsync 'on'.
00:00000:00000:2003/02/24 11:22:38.71 kernel Virtual device 0 started using asynchronous i/o.
00:00000:00000:2003/02/24 11:22:38.71 kernel Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2003/02/24 11:22:38.72 kernel Either the config parameter 'use security services' is set to 0,
or ASE does not support use of external security mechanisms on this platform. The Security Control Layer will n
ot be initialized. No external security mechanisms will be supported.
00:00000:00000:2003/02/24 11:22:38.72 kernel engine 0, os pid 552 online
00:00000:00000:2003/02/24 11:22:38.72 server No active traceflags
00:00000:00001:2003/02/24 11:22:38.72 kernel libomni1 - Component Integration Services loaded; version 'libomn
i1 - Component Integration Services/12.5/SWR 9610 GA/P/Sun_svr4/OS 5.8/main/1647/64-bit/FBO/Sat Jun 2 01:55:25
2001'.
00:00000:00001:2003/02/24 11:22:38.72 kernel libomni1 - Component Integration Services: using 'Sybase Client-L
ibrary/12.5/P/SPARC/Solaris 2.8/1/64bit/OPT/Sun Mar 25 08:30:37 2001'
00:00000:00001:2003/02/24 11:22:38.72 server Opening Master Database ...
00:00000:00001:2003/02/24 11:22:38.80 server Loading SQL Server's default sort order and character set
00:00000:00001:2003/02/24 11:22:38.80 server Loaded default Unilib conversion handle.
00:00000:00001:2003/02/24 11:22:38.82 server Recovering database 'master'.
00:00000:00001:2003/02/24 11:22:38.82 server Redo pass of recovery has processed 3 committed and 0 aborted tra
nsactions.
00:00000:00001:2003/02/24 11:22:38.90 server Checking external objects.
00:00000:00001:2003/02/24 11:22:38.92 server Database 'master' is now online.
00:00000:00001:2003/02/24 11:22:38.92 server The transaction log in the database 'master' will use I/O size of
8 Kb.
00:00000:00001:2003/02/24 11:22:38.92 server Warning: ASE_HA has no valid license and therefore is not initial
ized.
00:00000:00001:2003/02/24 11:22:38.92 server server is unnamed
00:00000:00001:2003/02/24 11:22:39.00 server Recovering database 'sybsystemdb'.
00:00000:00001:2003/02/24 11:22:39.07 server Boot Count: 2
00:00000:00001:2003/02/24 11:22:39.09 server Checking external objects.
00:00000:00001:2003/02/24 11:22:39.09 server The transaction log in the database 'sybsystemdb' will use I/O si
ze of 8 Kb.
00:00000:00001:2003/02/24 11:22:39.10 server Database 'sybsystemdb' is now online.
00:00000:00001:2003/02/24 11:22:39.11 server Recovering database 'model'.
00:00000:00001:2003/02/24 11:22:39.19 server Checking external objects.
00:00000:00001:2003/02/24 11:22:39.20 server The transaction log in the database 'model' will use I/O size of
8 Kb.
00:00000:00001:2003/02/24 11:22:39.21 server Database 'model' is now online.
00:00000:00001:2003/02/24 11:22:39.21 server The logical pagesize of the server is 8 Kb.
00:00000:00001:2003/02/24 11:22:39.21 server 0 dump conditions detected at boot time
00:00000:00001:2003/02/24 11:22:39.22 server Resident Node id: bdc6785d508b
00:00000:00001:2003/02/24 11:22:39.22 server Transaction coordinator initialized.
00:00000:00001:2003/02/24 11:22:39.22 server Clearing temp db
00:00000:00001:2003/02/24 11:22:45.06 server The transaction log in the database 'tempdb' will use I/O size of
8 Kb.
00:00000:00001:2003/02/24 11:22:45.08 server Database 'tempdb' is now online.
00:00000:00002:2003/02/24 11:22:45.09 kernel ninit:0: listener type: master
00:00000:00002:2003/02/24 11:22:45.09 kernel ninit:0: listener endpoint: /dev/tcp
00:00000:00002:2003/02/24 11:22:45.09 kernel ninit:0: listener raw address: \x00021172c0a810050000000000000000
00:00000:00002:2003/02/24 11:22:45.09 kernel ninit:0: transport provider: T_COTS_ORD
00:00000:00002:2003/02/24 11:22:45.09 kernel ninit: t_bind, No Error
00:00000:00002:2003/02/24 11:22:45.09 kernel ninit: All master network listeners have failed. Shutting down.
00:00000:00002:2003/02/24 11:22:45.09 kernel ueshutdown: exiting
jazy 回复于：2003-02-24 13:05:42
很奇怪！
前面都没什么错误阿！怎么最后报一个All master network listeners 呢？
就只有这些日志信息吗？
察看一下你的网络配置信息，对比一下你的interfaces中文件的ip信息！看看有没有什么出入！
rabbitdan 回复于：2003-02-24 13:22:16
就这些日志阿！我的服务没有建成，所以我的interfaces是一个空文件阿！
我的*.rs文件如下
sybinit.release_directory: /export/home/sybase
sybinit.product: sqlsrv
sqlsrv.server_name: jcweb
sqlsrv.new_config: yes
sqlsrv.do_add_server: yes
sqlsrv.network_protocol_list: tcp
sqlsrv.network_hostname_list: 192.168.16.5
sqlsrv.network_port_list: 4466
sqlsrv.server_page_size: 8k
sqlsrv.force_buildmaster: yes
sqlsrv.master_device_physical_name: /databasefile/jcweb/db/master.dat
sqlsrv.master_device_size: 250
sqlsrv.master_database_size: 150
sqlsrv.errorlog: USE_DEFAULT
sqlsrv.do_upgrade: no
sqlsrv.sybsystemprocs_device_physical_name: /databasefile/jcweb/db/sybprocs.dat
sqlsrv.sybsystemprocs_device_size: 250
sqlsrv.sybsystemprocs_database_size: 200
sqlsrv.default_backup_server: jcweb_backup
我也就是找不到错误在那里阿！
eastarwang 回复于：2003-03-03 10:09:02
按照提示，系统是找不到sybase的服务，请问你在sybase用户主目录下，有没有配置sybase用户的环境变量
eastarwang 回复于：2003-03-03 10:20:46
另外，报all network。。。。。fail
一般是你的ip地址或端口地址有错误
1、先检查你的*.rs文件中的ip地址,是否在你的系统中存在
#netstat -in
2、检查你的端口是否已经被使用
shaotao27 回复于：2003-05-03 14:04:47
风格
yaoliang 回复于：2003-05-20 08:53:49
请教Blackrose:
在安装sybase12.5(NT4.0)后，我的服务器在开始启动时，能够自动启动SYBASE服务，但以后在控制面板中无法重新启动SYBASE服务，这是为何？
Blackrose 回复于：2003-05-23 18:06:32
yaoliang ：
你说的自动启动是不是指你已经把sybase服务设置为自动?
你把帖子新发一个吧！
llt 回复于：2003-05-28 18:12:37
好同志，谢谢
lljj 回复于：2003-07-14 14:05:11
恩很好啊！
不过有时候有security的存储过程可能也需要重新install一下吧！
viacocha 回复于：2003-08-03 16:00:29
如果下面有很多EBF,我是不是下那个最大号的就行了?
yeebb 回复于：2003-09-01 10:53:40
没有设置和启动SYSAM
solofeng 回复于：2003-09-24 18:26:05
好，
很好！
YT 回复于：2003-10-19 23:41:33
好帖，多谢啊~
yangblz 回复于：2003-12-10 10:25:57
很好,谢谢!
lanmp 回复于：2003-12-10 11:39:15
我昨晚上重装的系统和数据库，SYBASE升级用的是11263，系统日志如下，请各位高手给我看一下：00:00000:00000:2003/12/10 06:08:08.38 kernel Use license file /opt/sybase/SYSAM-1_0/licenses/license.dat.
00:00000:00000:2003/12/10 06:08:08.39 kernel Using config area from primary master device.
00:00000:00000:2003/12/10 06:08:08.39 kernel Configuration Error: Configuration file, '/opt/sybase/SYBASE.cfg', does not exist.
00:00000:00000:2003/12/10 06:08:08.40 kernel Warning: A configuration file was not specified and the default file '/opt/sybase/SYBASE.cfg' does not exist. SQL Server creates the default file with the default configuration.
00:00000:00000:2003/12/10 06:08:08.78 kernel Using 1024 file descriptors.
00:00000:00000:2003/12/10 06:08:08.78 kernel Adaptive Server Enterprise/12.0/P/SWR 8860 ESD 2/Sun_svr4/OS 5.7/1581/64bit/FBO/Wed Jan 26 04:43:49 2000
00:00000:00000:2003/12/10 06:08:08.78 kernel Confidential property of Sybase, Inc.
00:00000:00000:2003/12/10 06:08:08.78 kernel Copyright 1987, 2000
00:00000:00000:2003/12/10 06:08:08.78 kernel Sybase, Inc. All rights reserved.
00:00000:00000:2003/12/10 06:08:08.78 kernel Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2003/12/10 06:08:08.78 kernel
00:00000:00000:2003/12/10 06:08:08.78 kernel This software contains confidential and trade secret information of Sybase,
00:00000:00000:2003/12/10 06:08:08.78 kernel Inc. Use, duplication or disclosure of the software and documentation by
00:00000:00000:2003/12/10 06:08:08.78 kernel the U.S. Government is subject to restrictions set forth in a license
00:00000:00000:2003/12/10 06:08:08.78 kernel agreement between the Government and Sybase, Inc. or other written
00:00000:00000:2003/12/10 06:08:08.78 kernel agreement specifying the Government's rights to use the software and any
00:00000:00000:2003/12/10 06:08:08.78 kernel applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2003/12/10 06:08:08.78 kernel Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2003/12/10 06:08:08.78 kernel Using '/opt/sybase/SYBASE.cfg' for configuration information.
00:00000:00000:2003/12/10 06:08:08.78 kernel Logging ASE messages in file '/opt/sybase/ASE-12_0/install/SYBASE.log'.
00:00000:00000:2003/12/10 06:08:08.84 kernel Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2003/12/10 06:08:08.84 kernel Network and device connection limit is 1014.
00:00000:00000:2003/12/10 06:08:08.89 server Number of proc buffers allocated: 6239.
00:00000:00000:2003/12/10 06:08:09.13 server Number of blocks left for proc headers: 6168.
00:00000:00000:2003/12/10 06:08:09.15 server Proc header memory allocated 3084 pages for each per engine cache
00:00000:00000:2003/12/10 06:08:09.15 server Memory allocated for the default data cache cachelet 1: 45320 Kb
00:00000:00000:2003/12/10 06:08:09.18 server Size of the 2K memory pool: 45320 Kb
00:00000:00000:2003/12/10 06:08:09.18 kernel Initializing virtual device 0, '/dev/rdsk/c0t0d0s3' with dsync 'on'.
00:00000:00000:2003/12/10 06:08:09.19 kernel Virtual device 0 started using asynchronous i/o.
00:00000:00000:2003/12/10 06:08:09.19 kernel Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2003/12/10 06:08:09.19 kernel Either the config parameter 'use security services' is set to 0, or ASE does not support use of external security mechanisms on this platform. The Security Control Layer will not be initialized. No external security mechanisms will be supported.
00:00000:00000:2003/12/10 06:08:09.19 kernel engine 0, os pid 5868 online
00:00000:00000:2003/12/10 06:08:09.19 server No active traceflags
00:00000:00001:2003/12/10 06:08:09.20 kernel Component Integration Services loaded; version 'Component Integration Services/12.0/P/SWR 8860 ESD 2/Sun_svr4/OS 5.7/1581/64bit/FBO/Wed Jan 26 04:43:49 2000'.
00:00000:00001:2003/12/10 06:08:09.20 kernel Component Integration Services: using 'Sybase Client-Library/12.0/P/SPARC/Solaris 2.5.1/1/OPT/Mon Oct 4 12:31:04 1999'
00:00000:00001:2003/12/10 06:08:09.20 server Opening Master Database ...
00:00000:00001:2003/12/10 06:08:09.34 server Loading SQL Server's default sort order and character set
00:00000:00001:2003/12/10 06:08:09.34 server Loaded default Unilib conversion handle.
00:00000:00002:2003/12/10 06:08:09.36 kernel ninit:0: listener type: master
00:00000:00002:2003/12/10 06:08:09.36 kernel ninit:0: listener endpoint: /dev/tcp
00:00000:00002:2003/12/10 06:08:09.36 kernel ninit:0: listener raw address: \x00021388a269b5970000000000000000
00:00000:00002:2003/12/10 06:08:09.36 kernel ninit:0: transport provider: T_COTS_ORD
00:00000:00001:2003/12/10 06:08:09.38 server Recovering database 'master'
00:00000:00001:2003/12/10 06:08:09.41 server Redo pass of recovery has processed 1 committed and 0 aborted transactions.
00:00000:00001:2003/12/10 06:08:09.54 server Checking external objects.
00:00000:00001:2003/12/10 06:08:09.58 server Database 'master' is now online.
00:00000:00001:2003/12/10 06:08:09.58 server The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2003/12/10 06:08:09.58 server This installation was created using a 12.0 or later version of buildmaster.
00:00000:00001:2003/12/10 06:08:09.59 server 0 dump conditions detected at boot time
00:00000:00001:2003/12/10 06:08:09.62 server server is unnamed
00:00000:00001:2003/12/10 06:08:09.62 server Warning: The 'sysconfigures' table is not updated since the SQL Server is started with the default configuration.
00:00000:00001:2003/12/10 06:08:09.72 server Recovering database 'sybsystemdb'.
00:00000:00001:2003/12/10 06:08:09.74 server Redo pass of recovery has processed 0 committed and 1 aborted transactions.
00:00000:00001:2003/12/10 06:08:09.80 server Boot Count: 4
00:00000:00001:2003/12/10 06:08:09.85 server Checking external objects.
00:00000:00001:2003/12/10 06:08:09.87 server The transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2003/12/10 06:08:09.90 server Database 'sybsystemdb' is now online.
00:00000:00001:2003/12/10 06:08:09.94 server Recovering database 'model'.
00:00000:00001:2003/12/10 06:08:10.02 server Checking external objects.
00:00000:00001:2003/12/10 06:08:10.03 server The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2003/12/10 06:08:10.06 server Database 'model' is now online.
00:00000:00001:2003/12/10 06:08:10.08 server Resident Node id: fff2f29c24c2
00:00000:00001:2003/12/10 06:08:10.09 server Transaction coordinator initialized.
00:00000:00001:2003/12/10 06:08:10.10 server Clearing temp db
00:00000:00001:2003/12/10 06:08:11.27 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2003/12/10 06:08:11.40 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2003/12/10 06:08:11.43 server Database 'tempdb' is now online.
00:00000:00001:2003/12/10 06:08:11.43 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2003/12/10 06:08:11.44 server Recovery complete.
00:00000:00001:2003/12/10 06:08:11.45 server SQL Server's default sort order is:
00:00000:00001:2003/12/10 06:08:11.45 server 'bin_iso_1' (ID = 50)
00:00000:00001:2003/12/10 06:08:11.45 server on top of default character set:
00:00000:00001:2003/12/10 06:08:11.45 server 'iso_1' (ID = 1).
00:00000:00001:2003/12/10 06:08:17.98 kernel Initializing virtual device 1, '/dev/rdsk/c0t0d0s4' with dsync 'on'.
00:00000:00001:2003/12/10 06:08:17.98 kernel Virtual device 1 started using asynchronous i/o.
00:00000:00001:2003/12/10 06:09:45.63 server Configuration file '/opt/sybase/SYBASE.cfg' has been written and the previous version has been renamed to '/opt/sybase/SYBASE.001'.
00:00000:00001:2003/12/10 06:09:45.66 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '0' to '1'.
00:00000:00001:2003/12/10 06:09:45.70 server Configuration file '/opt/sybase/SYBASE.cfg' has been written and the previous version has been renamed to '/opt/sybase/SYBASE.002'.
00:00000:00001:2003/12/10 06:09:45.71 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '1' to '0'.
00:00000:00001:2003/12/10 06:09:45.81 server Configuration file '/opt/sybase/SYBASE.cfg' has been written and the previous version has been renamed to '/opt/sybase/SYBASE.003'.
00:00000:00001:2003/12/10 06:09:45.82 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '0' to '1'.
00:00000:00001:2003/12/10 06:15:32.17 server Configuration file '/opt/sybase/SYBASE.cfg' has been written and the previous version has been renamed to '/opt/sybase/SYBASE.004'.
00:00000:00001:2003/12/10 06:15:32.18 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '1' to '0'.
00:00000:00001:2003/12/10 06:15:32.58 server Configuration file '/opt/sybase/SYBASE.cfg' has been written and the previous version has been renamed to '/opt/sybase/SYBASE.005'.
00:00000:00001:2003/12/10 06:15:32.59 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '0' to '1'.
00:00000:00001:2003/12/10 06:15:33.31 server Configuration file '/opt/sybase/SYBASE.cfg' has been written and the previous version has been renamed to '/opt/sybase/SYBASE.006'.
00:00000:00001:2003/12/10 06:15:33.32 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '1' to '0'.
00:00000:00001:2003/12/10 06:15:33.47 server Configuration file '/opt/sybase/SYBASE.cfg' has been written and the previous version has been renamed to '/opt/sybase/SYBASE.007'.
00:00000:00001:2003/12/10 06:15:33.48 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '0' to '1'.
00:00000:00001:2003/12/10 06:16:13.74 server Configuration file '/opt/sybase/SYBASE.cfg' has been written and the previous version has been renamed to '/opt/sybase/SYBASE.008'.
00:00000:00001:2003/12/10 06:16:13.75 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '1' to '0'.
00:00000:00001:2003/12/10 06:16:13.90 kernel Initializing virtual device 2, '/dev/rdsk/c0t0d0s5' with dsync 'on'.
00:00000:00001:2003/12/10 06:16:13.90 kernel Virtual device 2 started using asynchronous i/o.
00:00000:00001:2003/12/10 06:16:35.16 server Configuration file '/opt/sybase/SYBASE.cfg' has been written and the previous version has been renamed to '/opt/sybase/SYBASE.009'.
00:00000:00001:2003/12/10 06:16:35.17 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '0' to '1'.
00:00000:00001:2003/12/10 06:16:35.24 server Configuration file '/opt/sybase/SYBASE.cfg' has been written and the previous version has been renamed to '/opt/sybase/SYBASE.010'.
00:00000:00001:2003/12/10 06:16:35.25 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '1' to '0'.
00:00000:00001:2003/12/10 06:16:35.30 server Configuration file '/opt/sybase/SYBASE.cfg' has been written and the previous version has been renamed to '/opt/sybase/SYBASE.011'.
00:00000:00001:2003/12/10 06:16:35.31 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '0' to '1'.
00:00000:00001:2003/12/10 06:16:35.36 server Configuration file '/opt/sybase/SYBASE.cfg' has been written and the previous version has been renamed to '/opt/sybase/SYBASE.012'.
00:00000:00001:2003/12/10 06:16:35.37 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '1' to '0'.
00:00000:00001:2003/12/10 06:16:35.42 server Configuration file '/opt/sybase/SYBASE.cfg' has been written and the previous version has been renamed to '/opt/sybase/SYBASE.013'.
00:00000:00001:2003/12/10 06:16:35.43 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '0' to '1'.
00:00000:00001:2003/12/10 06:16:35.48 server Configuration file '/opt/sybase/SYBASE.cfg' has been written and the previous version has been renamed to '/opt/sybase/SYBASE.014'.
00:00000:00001:2003/12/10 06:16:35.49 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '1' to '0'.
00:00000:00001:2003/12/10 06:16:35.53 server Configuration file '/opt/sybase/SYBASE.cfg' has been written and the previous version has been renamed to '/opt/sybase/SYBASE.015'.
00:00000:00001:2003/12/10 06:16:35.54 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '0' to '1'.
00:00000:00001:2003/12/10 06:16:35.59 server Configuration file '/opt/sybase/SYBASE.cfg' has been written and the previous version has been renamed to '/opt/sybase/SYBASE.016'.
00:00000:00001:2003/12/10 06:16:35.60 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '1' to '0'.
00:00000:00000:2003/12/10 06:30:36.44 kernel Use license file /opt/sybase/SYSAM-1_0/licenses/license.dat.
00:00000:00000:2003/12/10 06:30:36.45 kernel basis_dlock: file '/dev/rdsk/c0t0d0s3' already in use by a SQL Server
00:00000:00000:2003/12/10 06:30:36.45 kernel kdconfig: unable to read primary master device
00:00000:00000:2003/12/10 06:30:36.45 kernel kiconfig: read of config block failed
00:00000:00000:2003/12/10 06:40:28.24 kernel Warning: There is no valid license for ASE server product. Server is booting with all the option features disabled.
00:00000:00000:2003/12/10 06:40:28.45 kernel Using config area from primary master device.
00:00000:00000:2003/12/10 06:40:28.49 kernel Warning: Using default file '/opt/sybase/SYBASE.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2003/12/10 06:40:28.93 kernel Using 1024 file descriptors.
00:00000:00000:2003/12/10 06:40:28.93 kernel Adaptive Server Enterprise/12.0/P/SWR 8860 ESD 2/Sun_svr4/OS 5.7/1581/64bit/FBO/Wed Jan 26 04:43:49 2000
00:00000:00000:2003/12/10 06:40:28.93 kernel Confidential property of Sybase, Inc.
00:00000:00000:2003/12/10 06:40:28.93 kernel Copyright 1987, 2000
00:00000:00000:2003/12/10 06:40:28.93 kernel Sybase, Inc. All rights reserved.
00:00000:00000:2003/12/10 06:40:28.93 kernel Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2003/12/10 06:40:28.93 kernel
00:00000:00000:2003/12/10 06:40:28.93 kernel This software contains confidential and trade secret information of Sybase,
00:00000:00000:2003/12/10 06:40:28.93 kernel Inc. Use, duplication or disclosure of the software and documentation by
00:00000:00000:2003/12/10 06:40:28.93 kernel the U.S. Government is subject to restrictions set forth in a license
00:00000:00000:2003/12/10 06:40:28.93 kernel agreement between the Government and Sybase, Inc. or other written
00:00000:00000:2003/12/10 06:40:28.93 kernel agreement specifying the Government's rights to use the software and any
00:00000:00000:2003/12/10 06:40:28.93 kernel applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2003/12/10 06:40:28.93 kernel Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2003/12/10 06:40:28.93 kernel Using '/opt/sybase/SYBASE.cfg' for configuration information.
00:00000:00000:2003/12/10 06:40:28.94 kernel Logging ASE messages in file '/opt/sybase/ASE-12_0/install/SYBASE.log'.
00:00000:00000:2003/12/10 06:40:29.29 kernel Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2003/12/10 06:40:29.32 kernel Network and device connection limit is 1014.
00:00000:00000:2003/12/10 06:40:29.38 server Number of proc buffers allocated: 6239.
00:00000:00000:2003/12/10 06:40:29.66 server Number of blocks left for proc headers: 6168.
00:00000:00000:2003/12/10 06:40:29.69 server Proc header memory allocated 3084 pages for each per engine cache
00:00000:00000:2003/12/10 06:40:29.70 server Memory allocated for the default data cache cachelet 1: 45320 Kb
00:00000:00000:2003/12/10 06:40:29.72 server Size of the 2K memory pool: 45320 Kb
00:00000:00000:2003/12/10 06:40:29.73 kernel Initializing virtual device 0, '/dev/rdsk/c0t0d0s3' with dsync 'on'.
00:00000:00000:2003/12/10 06:40:29.75 kernel Virtual device 0 started using asynchronous i/o.
00:00000:00000:2003/12/10 06:40:29.76 kernel Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2003/12/10 06:40:29.76 kernel Either the config parameter 'use security services' is set to 0, or ASE does not support use of external security mechanisms on this platform. The Security Control Layer will not be initialized. No external security mechanisms will be supported.
00:00000:00000:2003/12/10 06:40:29.76 kernel engine 0, os pid 441 online
00:00000:00000:2003/12/10 06:40:29.77 server No active traceflags
00:00000:00001:2003/12/10 06:40:29.90 kernel Component Integration Services loaded; version 'Component Integration Services/12.0/P/SWR 8860 ESD 2/Sun_svr4/OS 5.7/1581/64bit/FBO/Wed Jan 26 04:43:49 2000'.
00:00000:00001:2003/12/10 06:40:29.91 kernel Component Integration Services: using 'Sybase Client-Library/12.0/P/SPARC/Solaris 2.5.1/1/OPT/Mon Oct 4 12:31:04 1999'
00:00000:00001:2003/12/10 06:40:29.92 server Opening Master Database ...
00:00000:00001:2003/12/10 06:40:30.30 server Loading SQL Server's default sort order and character set
00:00000:00001:2003/12/10 06:40:30.31 server Loaded default Unilib conversion handle.
00:00000:00002:2003/12/10 06:40:30.35 kernel ninit:0: listener type: master
00:00000:00002:2003/12/10 06:40:30.36 kernel ninit:0: listener endpoint: /dev/tcp
00:00000:00002:2003/12/10 06:40:30.36 kernel ninit:0: listener raw address: \x00021388a269b5970000000000000000
00:00000:00002:2003/12/10 06:40:30.36 kernel ninit:0: transport provider: T_COTS_ORD
00:00000:00001:2003/12/10 06:40:30.41 server Recovering database 'master'
00:00000:00001:2003/12/10 06:40:30.84 server Redo pass of recovery has processed 337 committed and 0 aborted transactions.
00:00000:00001:2003/12/10 06:40:31.85 server Checking external objects.
00:00000:00001:2003/12/10 06:40:31.97 server Database 'master' is now online.
00:00000:00001:2003/12/10 06:40:31.97 server The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2003/12/10 06:40:31.98 server This installation was created using a 12.0 or later version of buildmaster.
00:00000:00001:2003/12/10 06:40:32.00 server 0 dump conditions detected at boot time
00:00000:00001:2003/12/10 06:40:32.02 server server is unnamed
00:00000:00001:2003/12/10 06:40:32.05 server Activating disk 'sysprocsdev'.
00:00000:00001:2003/12/10 06:40:32.05 kernel Initializing virtual device 1, '/dev/rdsk/c0t0d0s4' with dsync 'on'.
00:00000:00001:2003/12/10 06:40:32.06 kernel Virtual device 1 started using asynchronous i/o.
00:00000:00001:2003/12/10 06:40:32.06 server Activating disk 'systemdbdev'.
00:00000:00001:2003/12/10 06:40:32.06 kernel Initializing virtual device 2, '/dev/rdsk/c0t0d0s5' with dsync 'on'.
00:00000:00001:2003/12/10 06:40:32.06 kernel Virtual device 2 started using asynchronous i/o.
00:00000:00001:2003/12/10 06:40:32.23 server Recovering database 'sybsystemdb'.
00:00000:00001:2003/12/10 06:40:32.29 server Redo pass of recovery has processed 5 committed and 1 aborted transactions.
00:00000:00001:2003/12/10 06:40:32.60 server Boot Count: 5
00:00000:00001:2003/12/10 06:40:32.69 server Checking external objects.
00:00000:00001:2003/12/10 06:40:32.71 server The transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2003/12/10 06:40:32.74 server Database 'sybsystemdb' is now online.
00:00000:00001:2003/12/10 06:40:32.78 server Recovering database 'model'.
00:00000:00001:2003/12/10 06:40:32.79 server Redo pass of recovery has processed 2 committed and 0 aborted transactions.
00:00000:00001:2003/12/10 06:40:32.89 server Checking external objects.
00:00000:00001:2003/12/10 06:40:32.90 server The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2003/12/10 06:40:32.92 server Database 'model' is now online.
00:00000:00001:2003/12/10 06:40:32.94 server Resident Node id: fff2f29c24c2
00:00000:00001:2003/12/10 06:40:32.94 server Transaction coordinator initialized.
00:00000:00001:2003/12/10 06:40:32.96 server Clearing temp db
00:00000:00001:2003/12/10 06:40:34.46 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2003/12/10 06:40:34.63 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2003/12/10 06:40:34.66 server Database 'tempdb' is now online.
00:00000:00001:2003/12/10 06:40:34.67 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2003/12/10 06:40:34.72 server Recovering database 'sybsystemprocs'.
00:00000:00001:2003/12/10 06:40:34.74 server Redo pass of recovery has processed 2 committed and 0 aborted transactions.
00:00000:00001:2003/12/10 06:40:35.37 server Checking external objects.
00:00000:00001:2003/12/10 06:40:35.38 server The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2003/12/10 06:40:35.43 server Database 'sybsystemprocs' is now online.
00:00000:00001:2003/12/10 06:40:35.48 server Recovery complete.
00:00000:00001:2003/12/10 06:40:35.48 server SQL Server's default sort order is:
00:00000:00001:2003/12/10 06:40:35.48 server 'bin_iso_1' (ID = 50)
00:00000:00001:2003/12/10 06:40:35.48 server on top of default character set:
00:00000:00001:2003/12/10 06:40:35.48 server 'iso_1' (ID = 1).
00:00000:00001:2003/12/10 06:40:59.34 server SQL Server shutdown by request.
00:00000:00001:2003/12/10 06:40:59.34 kernel ueshutdown: exiting
00:00000:00000:2003/12/10 06:41:52.57 kernel Use license file /opt/sybase/SYSAM-1_0/licenses/license.dat.
00:00000:00000:2003/12/10 06:41:52.59 kernel Using config area from primary master device.
00:00000:00000:2003/12/10 06:41:52.60 kernel Warning: Using default file '/opt/sybase/SYBASE.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2003/12/10 06:41:52.98 kernel Using 1024 file descriptors.
00:00000:00000:2003/12/10 06:41:52.98 kernel Adaptive Server Enterprise/12.0/P/SWR 8860 ESD 2/Sun_svr4/OS 5.7/1581/64bit/FBO/Wed Jan 26 04:43:49 2000
00:00000:00000:2003/12/10 06:41:52.98 kernel Confidential property of Sybase, Inc.
00:00000:00000:2003/12/10 06:41:52.98 kernel Copyright 1987, 2000
00:00000:00000:2003/12/10 06:41:52.98 kernel Sybase, Inc. All rights reserved.
00:00000:00000:2003/12/10 06:41:52.98 kernel Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2003/12/10 06:41:52.98 kernel
00:00000:00000:2003/12/10 06:41:52.98 kernel This software contains confidential and trade secret information of Sybase,
00:00000:00000:2003/12/10 06:41:52.98 kernel Inc. Use, duplication or disclosure of the software and documentation by
00:00000:00000:2003/12/10 06:41:52.98 kernel the U.S. Government is subject to restrictions set forth in a license
00:00000:00000:2003/12/10 06:41:52.98 kernel agreement between the Government and Sybase, Inc. or other written
00:00000:00000:2003/12/10 06:41:52.98 kernel agreement specifying the Government's rights to use the software and any
00:00000:00000:2003/12/10 06:41:52.98 kernel applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2003/12/10 06:41:52.98 kernel Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2003/12/10 06:41:52.98 kernel Using '/opt/sybase/SYBASE.cfg' for configuration information.
00:00000:00000:2003/12/10 06:41:52.98 kernel Logging ASE messages in file '/opt/sybase/ASE-12_0/install/SYBASE.log'.
00:00000:00000:2003/12/10 06:41:53.10 kernel Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2003/12/10 06:41:53.10 kernel Network and device connection limit is 1014.
00:00000:00000:2003/12/10 06:41:53.15 server Number of proc buffers allocated: 6239.
00:00000:00000:2003/12/10 06:41:53.39 server Number of blocks left for proc headers: 6168.
00:00000:00000:2003/12/10 06:41:53.42 server Proc header memory allocated 3084 pages for each per engine cache
00:00000:00000:2003/12/10 06:41:53.42 server Memory allocated for the default data cache cachelet 1: 45320 Kb
00:00000:00000:2003/12/10 06:41:53.44 server Size of the 2K memory pool: 45320 Kb
00:00000:00000:2003/12/10 06:41:53.44 kernel Initializing virtual device 0, '/dev/rdsk/c0t0d0s3' with dsync 'on'.
00:00000:00000:2003/12/10 06:41:53.44 kernel Virtual device 0 started using asynchronous i/o.
00:00000:00000:2003/12/10 06:41:53.44 kernel Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2003/12/10 06:41:53.45 kernel Either the config parameter 'use security services' is set to 0, or ASE does not support use of external security mechanisms on this platform. The Security Control Layer will not be initialized. No external security mechanisms will be supported.
00:00000:00000:2003/12/10 06:41:53.45 kernel engine 0, os pid 466 online
00:00000:00000:2003/12/10 06:41:53.45 server No active traceflags
00:00000:00001:2003/12/10 06:41:53.46 kernel Component Integration Services loaded; version 'Component Integration Services/12.0/P/SWR 8860 ESD 2/Sun_svr4/OS 5.7/1581/64bit/FBO/Wed Jan 26 04:43:49 2000'.
00:00000:00001:2003/12/10 06:41:53.46 kernel Component Integration Services: using 'Sybase Client-Library/12.0/P/SPARC/Solaris 2.5.1/1/OPT/Mon Oct 4 12:31:04 1999'
00:00000:00001:2003/12/10 06:41:53.46 server Opening Master Database ...
00:00000:00001:2003/12/10 06:41:53.56 server Loading SQL Server's default sort order and character set
00:00000:00001:2003/12/10 06:41:53.56 server Loaded default Unilib conversion handle.
00:00000:00002:2003/12/10 06:41:53.56 kernel ninit:0: listener type: master
00:00000:00002:2003/12/10 06:41:53.57 kernel ninit:0: listener endpoint: /dev/tcp
00:00000:00002:2003/12/10 06:41:53.57 kernel ninit:0: listener raw address: \x00021388a269b5970000000000000000
00:00000:00002:2003/12/10 06:41:53.57 kernel ninit:0: transport provider: T_COTS_ORD
00:00000:00001:2003/12/10 06:41:53.59 server Recovering database 'master'
00:00000:00001:2003/12/10 06:41:53.72 server Checking external objects.
00:00000:00001:2003/12/10 06:41:53.75 server Database 'master' is now online.
00:00000:00001:2003/12/10 06:41:53.76 server The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2003/12/10 06:41:53.76 server This installation was created using a 12.0 or later version of buildmaster.
00:00000:00001:2003/12/10 06:41:53.77 server 0 dump conditions detected at boot time
00:00000:00001:2003/12/10 06:41:53.79 server server is unnamed
00:00000:00001:2003/12/10 06:41:53.81 server Activating disk 'sysprocsdev'.
00:00000:00001:2003/12/10 06:41:53.81 kernel Initializing virtual device 1, '/dev/rdsk/c0t0d0s4' with dsync 'on'.
00:00000:00001:2003/12/10 06:41:53.82 kernel Virtual device 1 started using asynchronous i/o.
00:00000:00001:2003/12/10 06:41:53.82 server Activating disk 'systemdbdev'.
00:00000:00001:2003/12/10 06:41:53.82 kernel Initializing virtual device 2, '/dev/rdsk/c0t0d0s5' with dsync 'on'.
00:00000:00001:2003/12/10 06:41:53.82 kernel Virtual device 2 started using asynchronous i/o.
00:00000:00001:2003/12/10 06:41:53.97 server Recovering database 'sybsystemdb'.
00:00000:00001:2003/12/10 06:41:54.02 server Boot Count: 6
00:00000:00001:2003/12/10 06:41:54.07 server Checking external objects.
00:00000:00001:2003/12/10 06:41:54.09 server The transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2003/12/10 06:41:54.12 server Database 'sybsystemdb' is now online.
00:00000:00001:2003/12/10 06:41:54.16 server Recovering database 'model'.
00:00000:00001:2003/12/10 06:41:54.24 server Checking external objects.
00:00000:00001:2003/12/10 06:41:54.24 server The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2003/12/10 06:41:54.27 server Database 'model' is now online.
00:00000:00001:2003/12/10 06:41:54.27 server Resident Node id: fff2f29c24c2
00:00000:00001:2003/12/10 06:41:54.28 server Transaction coordinator initialized.
00:00000:00001:2003/12/10 06:41:54.28 server Clearing temp db
00:00000:00001:2003/12/10 06:41:55.43 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2003/12/10 06:41:55.58 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2003/12/10 06:41:55.60 server Database 'tempdb' is now online.
00:00000:00001:2003/12/10 06:41:55.61 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2003/12/10 06:41:55.66 server Recovering database 'sybsystemprocs'.
00:00000:00001:2003/12/10 06:41:55.74 server Checking external objects.
00:00000:00001:2003/12/10 06:41:55.76 server The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2003/12/10 06:41:55.78 server Database 'sybsystemprocs' is now online.
00:00000:00001:2003/12/10 06:41:55.80 server Recovery complete.
00:00000:00001:2003/12/10 06:41:55.80 server SQL Server's default sort order is:
00:00000:00001:2003/12/10 06:41:55.80 server 'bin_iso_1' (ID = 50)
00:00000:00001:2003/12/10 06:41:55.80 server on top of default character set:
00:00000:00001:2003/12/10 06:41:55.80 server 'iso_1' (ID = 1).
00:00000:00008:2003/12/10 06:42:32.79 kernel nconnect: t_rcvconnect, An event requires attention
00:00000:00008:2003/12/10 06:42:32.81 server Failed to connect to remote server SYBASE_back tli tcp /dev/tcp \x00021389a269b5970000000000000000 for site SYB_BACKUP. Trying the next query entry of this server, if any.
00:00000:00008:2003/12/10 06:42:32.81 server Error: 7235, Severity: 17, State: 0
00:00000:00008:2003/12/10 06:42:32.81 server No other query entry found for the remote server SYBASE_back - site SYB_BACKUP. Aborting this site handler, as no remote server responded. Please make sure the remote server is accepting connections.
00:00000:00001:2003/12/10 06:42:32.84 server Shutdown with nowait detected - SQL Server process level execution bindings will be cleared on startup.
00:00000:00001:2003/12/10 06:42:32.85 server SQL Server shutdown by request.
00:00000:00001:2003/12/10 06:42:32.85 kernel ueshutdown: exiting
00:00000:00000:2003/12/10 06:48:39.97 kernel Use license file /opt/sybase/SYSAM-1_0/licenses/license.dat.
00:00000:00000:2003/12/10 06:48:39.99 kernel Using config area from primary master device.
00:00000:00000:2003/12/10 06:48:40.01 kernel Warning: Using default file '/opt/sybase/SYBASE.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2003/12/10 06:48:40.62 kernel Using 1024 file descriptors.
00:00000:00000:2003/12/10 06:48:40.62 kernel Adaptive Server Enterprise/12.0/P/SWR 8860 ESD 2/Sun_svr4/OS 5.7/1581/64bit/FBO/Wed Jan 26 04:43:49 2000
00:00000:00000:2003/12/10 06:48:40.62 kernel Confidential property of Sybase, Inc.
00:00000:00000:2003/12/10 06:48:40.62 kernel Copyright 1987, 2000
00:00000:00000:2003/12/10 06:48:40.62 kernel Sybase, Inc. All rights reserved.
00:00000:00000:2003/12/10 06:48:40.62 kernel Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2003/12/10 06:48:40.62 kernel
00:00000:00000:2003/12/10 06:48:40.62 kernel This software contains confidential and trade secret information of Sybase,
00:00000:00000:2003/12/10 06:48:40.62 kernel Inc. Use, duplication or disclosure of the software and documentation by
00:00000:00000:2003/12/10 06:48:40.62 kernel the U.S. Government is subject to restrictions set forth in a license
00:00000:00000:2003/12/10 06:48:40.62 kernel agreement between the Government and Sybase, Inc. or other written
00:00000:00000:2003/12/10 06:48:40.62 kernel agreement specifying the Government's rights to use the software and any
00:00000:00000:2003/12/10 06:48:40.62 kernel applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2003/12/10 06:48:40.62 kernel Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2003/12/10 06:48:40.62 kernel Using '/opt/sybase/SYBASE.cfg' for configuration information.
00:00000:00000:2003/12/10 06:48:40.62 kernel Logging ASE messages in file '/opt/sybase/ASE-12_0/install/SYBASE.log'.
00:00000:00000:2003/12/10 06:48:40.97 kernel Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2003/12/10 06:48:40.99 kernel Network and device connection limit is 1014.
00:00000:00000:2003/12/10 06:48:41.06 server Number of proc buffers allocated: 6239.
00:00000:00000:2003/12/10 06:48:41.35 server Number of blocks left for proc headers: 6168.
00:00000:00000:2003/12/10 06:48:41.37 server Proc header memory allocated 3084 pages for each per engine cache
00:00000:00000:2003/12/10 06:48:41.38 server Memory allocated for the default data cache cachelet 1: 45320 Kb
00:00000:00000:2003/12/10 06:48:41.40 server Size of the 2K memory pool: 45320 Kb
00:00000:00000:2003/12/10 06:48:41.41 kernel Initializing virtual device 0, '/dev/rdsk/c0t0d0s3' with dsync 'on'.
00:00000:00000:2003/12/10 06:48:41.42 kernel Virtual device 0 started using asynchronous i/o.
00:00000:00000:2003/12/10 06:48:41.43 kernel Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2003/12/10 06:48:41.44 kernel Either the config parameter 'use security services' is set to 0, or ASE does not support use of external security mechanisms on this platform. The Security Control Layer will not be initialized. No external security mechanisms will be supported.
00:00000:00000:2003/12/10 06:48:41.44 kernel engine 0, os pid 560 online
00:00000:00000:2003/12/10 06:48:41.44 server No active traceflags
00:00000:00001:2003/12/10 06:48:41.54 kernel Component Integration Services loaded; version 'Component Integration Services/12.0/P/SWR 8860 ESD 2/Sun_svr4/OS 5.7/1581/64bit/FBO/Wed Jan 26 04:43:49 2000'.
00:00000:00001:2003/12/10 06:48:41.55 kernel Component Integration Services: using 'Sybase Client-Library/12.0/P/SPARC/Solaris 2.5.1/1/OPT/Mon Oct 4 12:31:04 1999'
00:00000:00001:2003/12/10 06:48:41.55 server Opening Master Database ...
00:00000:00001:2003/12/10 06:48:41.88 server Loading SQL Server's default sort order and character set
00:00000:00001:2003/12/10 06:48:41.89 server Loaded default Unilib conversion handle.
00:00000:00002:2003/12/10 06:48:41.91 kernel ninit:0: listener type: master
00:00000:00002:2003/12/10 06:48:41.91 kernel ninit:0: listener endpoint: /dev/tcp
00:00000:00002:2003/12/10 06:48:41.91 kernel ninit:0: listener raw address: \x00021388a269b5970000000000000000
00:00000:00002:2003/12/10 06:48:41.91 kernel ninit:0: transport provider: T_COTS_ORD
00:00000:00001:2003/12/10 06:48:41.96 server Recovering database 'master'
00:00000:00001:2003/12/10 06:48:42.09 server Redo pass of recovery has processed 1 committed and 0 aborted transactions.
00:00000:00001:2003/12/10 06:48:42.96 server Checking external objects.
00:00000:00001:2003/12/10 06:48:43.06 server Database 'master' is now online.
00:00000:00001:2003/12/10 06:48:43.07 server The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2003/12/10 06:48:43.07 server This installation was created using a 12.0 or later version of buildmaster.
00:00000:00001:2003/12/10 06:48:43.09 server 0 dump conditions detected at boot time
00:00000:00001:2003/12/10 06:48:43.11 server server is unnamed
00:00000:00001:2003/12/10 06:48:43.14 server Activating disk 'sysprocsdev'.
00:00000:00001:2003/12/10 06:48:43.14 kernel Initializing virtual device 1, '/dev/rdsk/c0t0d0s4' with dsync 'on'.
00:00000:00001:2003/12/10 06:48:43.16 kernel Virtual device 1 started using asynchronous i/o.
00:00000:00001:2003/12/10 06:48:43.16 server Activating disk 'systemdbdev'.
00:00000:00001:2003/12/10 06:48:43.16 kernel Initializing virtual device 2, '/dev/rdsk/c0t0d0s5' with dsync 'on'.
00:00000:00001:2003/12/10 06:48:43.16 kernel Virtual device 2 started using asynchronous i/o.
00:00000:00001:2003/12/10 06:48:43.36 server Recovering database 'sybsystemdb'.
00:00000:00001:2003/12/10 06:48:43.37 server Redo pass of recovery has processed 0 committed and 1 aborted transactions.
00:00000:00001:2003/12/10 06:48:43.67 server Boot Count: 7
00:00000:00001:2003/12/10 06:48:43.74 server Checking external objects.
00:00000:00001:2003/12/10 06:48:43.76 server The transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2003/12/10 06:48:43.80 server Database 'sybsystemdb' is now online.
00:00000:00001:2003/12/10 06:48:43.85 server Recovering database 'model'.
00:00000:00001:2003/12/10 06:48:43.92 server Checking external objects.
00:00000:00001:2003/12/10 06:48:43.93 server The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2003/12/10 06:48:43.95 server Database 'model' is now online.
00:00000:00001:2003/12/10 06:48:43.97 server Resident Node id: fff2f29c24c2
00:00000:00001:2003/12/10 06:48:43.97 server Transaction coordinator initialized.
00:00000:00001:2003/12/10 06:48:44.00 server Clearing temp db
00:00000:00001:2003/12/10 06:48:45.16 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2003/12/10 06:48:45.31 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2003/12/10 06:48:45.33 server Database 'tempdb' is now online.
00:00000:00001:2003/12/10 06:48:45.34 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2003/12/10 06:48:45.40 server Recovering database 'sybsystemprocs'.
00:00000:00001:2003/12/10 06:48:45.97 server Checking external objects.
00:00000:00001:2003/12/10 06:48:45.98 server The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2003/12/10 06:48:46.01 server Database 'sybsystemprocs' is now online.
00:00000:00001:2003/12/10 06:48:46.05 server Recovery complete.
00:00000:00001:2003/12/10 06:48:46.05 server SQL Server's default sort order is:
00:00000:00001:2003/12/10 06:48:46.05 server 'bin_iso_1' (ID = 50)
00:00000:00001:2003/12/10 06:48:46.05 server on top of default character set:
00:00000:00001:2003/12/10 06:48:46.05 server 'iso_1' (ID = 1).
00:00000:00001:2003/12/10 06:52:40.67 server Configuration file '/opt/sybase/SYBASE.cfg' has been written and the previous version has been renamed to '/opt/sybase/SYBASE.017'.
00:00000:00001:2003/12/10 06:52:40.69 server The configuration option 'global cache partition number ' has been changed by 'sa' from '1' to '2'.
00:00000:00001:2003/12/10 06:54:12.74 server Configuration file '/opt/sybase/SYBASE.cfg' has been written and the previous version has been renamed to '/opt/sybase/SYBASE.018'.
00:00000:00001:2003/12/10 06:54:12.75 server The configuration option 'total memory' has been changed by 'sa' from '47104' to '946176'.
00:00000:00001:2003/12/10 06:55:06.74 server Configuration file '/opt/sybase/SYBASE.cfg' has been written and the previous version has been renamed to '/opt/sybase/SYBASE.019'.
00:00000:00001:2003/12/10 06:55:06.75 server The configuration option 'number of user connections' has been changed by 'sa' from '25' to '150'.
00:00000:00001:2003/12/10 06:55:27.57 server Configuration file '/opt/sybase/SYBASE.cfg' has been written and the previous version has been renamed to '/opt/sybase/SYBASE.020'.
00:00000:00001:2003/12/10 06:55:27.58 server The configuration option 'max online engines' has been changed by 'sa' from '1' to '2'.
00:00000:00009:2003/12/10 06:55:58.76 kernel nconnect: t_rcvconnect, An event requires attention
00:00000:00009:2003/12/10 06:55:58.77 server Failed to connect to remote server SYBASE_back tli tcp /dev/tcp \x00021389a269b5970000000000000000 for site SYB_BACKUP. Trying the next query entry of this server, if any.
00:00000:00009:2003/12/10 06:55:58.77 server Error: 7235, Severity: 17, State: 0
00:00000:00009:2003/12/10 06:55:58.77 server No other query entry found for the remote server SYBASE_back - site SYB_BACKUP. Aborting this site handler, as no remote server responded. Please make sure the remote server is accepting connections.
00:00000:00008:2003/12/10 06:55:58.78 server Shutdown with nowait detected - SQL Server process level execution bindings will be cleared on startup.
00:00000:00008:2003/12/10 06:55:58.79 server SQL Server shutdown by request.
00:00000:00008:2003/12/10 06:55:58.79 kernel ueshutdown: exiting
00:00000:00000:2003/12/10 07:22:57.73 kernel Use license file /opt/sybase/SYSAM-1_0/licenses/license.dat.
00:00000:00000:2003/12/10 07:22:57.98 kernel Using config area from primary master device.
00:00000:00000:2003/12/10 07:22:58.05 kernel Warning: Using default file '/opt/sybase/SYBASE.cfg' since a configuration file was not speci |
|
