Blackrose 发表于 2003-02-21 12:16

SYBASE补丁安装指南

一.        确认当前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(或者cd bin)
./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

SYBASE补丁安装指南

很好!


我想,这时很多人需要的,置为精华先!

rabbitdan 发表于 2003-02-24 11:20

SYBASE补丁安装指南

请问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 serverDatabase 'tempdb' is now online.
00:00000:00002:2003/02/24 11:22:45.09 kernelninit:0: listener type: master
00:00000:00002:2003/02/24 11:22:45.09 kernelninit:0: listener endpoint: /dev/tcp
00:00000:00002:2003/02/24 11:22:45.09 kernelninit:0: listener raw address: \x00021172c0a810050000000000000000
00:00000:00002:2003/02/24 11:22:45.09 kernelninit:0: transport provider: T_COTS_ORD
00:00000:00002:2003/02/24 11:22:45.09 kernelninit: t_bind, No Error
00:00000:00002:2003/02/24 11:22:45.09 kernelninit: All master network listeners have failed.Shutting down.
00:00000:00002:2003/02/24 11:22:45.09 kernelueshutdown: exiting

整个日志文件如下:

00:00000:00000:2003/02/24 11:19:54.06 kernelUse license file /export/home/sybase/SYSAM-1_0/licenses/license.d
at.
00:00000:00000:2003/02/24 11:19:54.06 kernelChecked out license ASE_SERVER
00:00000:00000:2003/02/24 11:19:54.11 kernelUsing config area from primary master device.
00:00000:00000:2003/02/24 11:19:54.13 kernelWarning: 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 kernelUsing 1024 file descriptors.
00:00000:00000:2003/02/24 11:19:54.33 kernelAdaptive Server Enterprise/12.5/SWR 9610 GA/P/Sun_svr4/OS 5.8/mai
n/1647/64-bit/FBO/Sat Jun2 01:55:25 2001
00:00000:00000:2003/02/24 11:19:54.33 kernelConfidential property of Sybase, Inc.
00:00000:00000:2003/02/24 11:19:54.33 kernelCopyright 1987, 2001
00:00000:00000:2003/02/24 11:19:54.33 kernelSybase, Inc.All rights reserved.
00:00000:00000:2003/02/24 11:19:54.33 kernelUnpublished 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 kernelThis software contains confidential and trade secret information
of Sybase,
00:00000:00000:2003/02/24 11:19:54.33 kernelInc.   Use,duplication or disclosure of the software and docume
ntation by
00:00000:00000:2003/02/24 11:19:54.33 kerneltheU.S.Governmentissubjecttorestrictions set forth in
a license
00:00000:00000:2003/02/24 11:19:54.33 kernelagreementbetweentheGovernmentandSybase,Inc.orothe
rwritten
00:00000:00000:2003/02/24 11:19:54.33 kernelagreementspecifyingtheGovernment's rights to use the softwa
re and any
00:00000:00000:2003/02/24 11:19:54.33 kernelapplicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2003/02/24 11:19:54.33 kernelSybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2003/02/24 11:19:54.33 kernelUsing '/export/home/sybase/jcweb.cfg' for configuration informati
on.
00:00000:00000:2003/02/24 11:19:54.33 kernelLogging ASE messages in file '/export/home/sybase/ASE-12_5/instal
l/jcweb.log'.
00:00000:00000:2003/02/24 11:19:54.37 kernelkdcl_sess_open: connectivity library supports master/query syntax
.
00:00000:00000:2003/02/24 11:19:54.38 kernelDirectory Control Layer (DCL) using directory driver: InterfacesD
river
00:00000:00000:2003/02/24 11:19:54.38 kernelSSL Plus security modules loaded successfully.
00:00000:00000:2003/02/24 11:19:54.38 kernelNetwork and device connection limit is 1014.
00:00000:00000:2003/02/24 11:19:54.56 serverNumber of blocks left for proc headers: 3192.
00:00000:00000:2003/02/24 11:19:54.57 serverProc header memory allocated 1596 pages for each per engine cache
00:00000:00000:2003/02/24 11:19:54.60 serverMemory allocated for the default data cache cachelet 1: 8192 Kb
00:00000:00000:2003/02/24 11:19:54.60 serverSize of the 8K memory pool: 8192 Kb
00:00000:00000:2003/02/24 11:19:54.60 kernelEnabling Sun Kernel asynchronous disk I/O strategy
00:00000:00000:2003/02/24 11:19:54.60 kernelInitializing virtual device 0, '/databasefile/jcweb/db/master.dat
' with dsync 'on'.
00:00000:00000:2003/02/24 11:19:54.60 kernelVirtual device 0 started using asynchronous i/o.
00:00000:00000:2003/02/24 11:19:54.60 kernelWorker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2003/02/24 11:19:54.60 kernelEither 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 kernelengine 0, os pid 550online
00:00000:00000:2003/02/24 11:19:54.60 serverNo active traceflags
00:00000:00001:2003/02/24 11:19:54.61 kernellibomni1 - 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 Jun2 01:55:25
2001'.
00:00000:00001:2003/02/24 11:19:54.61 kernellibomni1 - 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 serverThe logical pagesize of the server is 8 Kb.
00:00000:00001:2003/02/24 11:19:54.61 serverDatabase '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 serverDatabase 'master': beginning upgrade step : Initialize
disk and create empty allocation units on master device.
00:00000:00001:2003/02/24 11:21:09.43 serverDatabase 'master': beginning upgrade step : Bootstrap b
asic system catalogs in database.
00:00000:00001:2003/02/24 11:21:09.78 serverDatabase 'master': beginning upgrade step : creating in
dex (table systypes, index ncsystypes)
00:00000:00001:2003/02/24 11:21:09.90 serverDatabase 'master': beginning upgrade step : creating in
dex (table sysobjects, index ncsysobjects)
00:00000:00001:2003/02/24 11:21:09.98 serverDatabase 'master': beginning upgrade step : creating ta
ble (table sysusages)
00:00000:00001:2003/02/24 11:21:10.26 serverDatabase 'master': beginning upgrade step : creating ta
ble (table sysdatabases)
00:00000:00001:2003/02/24 11:21:10.49 serverDatabase 'master': beginning upgrade step : creating ta
ble (table sysdevices)
00:00000:00001:2003/02/24 11:21:10.75 serverDatabase 'master': beginning upgrade step : creating ta
ble (table sysmessages)
00:00000:00001:2003/02/24 11:21:11.06 serverDatabase 'master': beginning upgrade step : creating ta
ble (table sysconfigures)
00:00000:00001:2003/02/24 11:21:11.39 serverDatabase 'master': beginning upgrade step : creating ta
ble (table syscharsets)
00:00000:00001:2003/02/24 11:21:11.61 serverDatabase 'master': beginning upgrade step : creating ta
ble (table sysprocedures)
00:00000:00001:2003/02/24 11:21:11.82 serverDatabase 'master': beginning upgrade step : creating ta
ble (table syscomments)
00:00000:00001:2003/02/24 11:21:11.97 serverDatabase 'master': beginning upgrade step : creating ta
ble (table syssegments)
00:00000:00001:2003/02/24 11:21:12.12 serverDatabase 'master': beginning upgrade step : creating ta
ble (table sysprotects)
00:00000:00001:2003/02/24 11:21:12.29 serverDatabase 'master': beginning upgrade step : creating ta
ble (table sysusers)
00:00000:00001:2003/02/24 11:21:12.59 serverDatabase 'master': beginning upgrade step : creating ta
ble (table sysalternates)
00:00000:00001:2003/02/24 11:21:12.71 serverDatabase 'master': beginning upgrade step : creating ta
ble (table sysdepends)
00:00000:00001:2003/02/24 11:21:12.94 serverDatabase 'master': beginning upgrade step : creating ta
ble (table syskeys)
00:00000:00001:2003/02/24 11:21:13.14 serverDatabase 'master': beginning upgrade step : creating ta
ble (table sysprocesses)
00:00000:00001:2003/02/24 11:21:13.17 serverDatabase 'master': beginning upgrade step : creating ta
ble (table syslogins)
00:00000:00001:2003/02/24 11:21:13.44 serverDatabase 'master': beginning upgrade step : creating ta
ble (table syslocks)
00:00000:00001:2003/02/24 11:21:13.47 serverDatabase 'master': beginning upgrade step : creating ta
ble (table syscurconfigs)
00:00000:00001:2003/02/24 11:21:13.64 serverDatabase 'master': beginning upgrade step : creating ta
ble (table sysservers)
00:00000:00001:2003/02/24 11:21:13.82 serverDatabase 'master': beginning upgrade step : creating ta
ble (table sysremotelogins)
00:00000:00001:2003/02/24 11:21:14.04 serverDatabase 'master': beginning upgrade step : creating ta
ble (table sysmonitors)
00:00000:00001:2003/02/24 11:21:14.08 serverDatabase 'master': beginning upgrade step : creating ta
ble (table sysengines)
00:00000:00001:2003/02/24 11:21:14.11 serverDatabase 'master': beginning upgrade step : creating ta
ble (table syslanguages)
00:00000:00001:2003/02/24 11:21:14.40 serverDatabase 'master': beginning upgrade step : creating ta
ble (table systestlog)
00:00000:00001:2003/02/24 11:21:14.44 serverDatabase 'master': beginning upgrade step : creating ta
ble (table syssrvroles)
00:00000:00001:2003/02/24 11:21:14.64 serverDatabase 'master': beginning upgrade step : creating ta
ble (table sysloginroles)
00:00000:00001:2003/02/24 11:21:14.82 serverDatabase 'master': beginning upgrade step : creating ta
ble (table sysattributes)
00:00000:00001:2003/02/24 11:21:15.13 serverDatabase 'master': beginning upgrade step : Load initia
l set of attribute-definition rows into SYSATTRIBUTES.
00:00000:00001:2003/02/24 11:21:19.38 serverWarning: Using only the first 30 characters for password
00:00000:00001:2003/02/24 11:21:22.74 serverDatabase 'master': beginning upgrade step : creating ta
ble (table syslogshold)
00:00000:00001:2003/02/24 11:21:22.87 serverDatabase 'master': beginning upgrade step : creating ta
ble (table syslisteners)
00:00000:00001:2003/02/24 11:21:22.93 serverDatabase 'master': beginning upgrade step : creating ta
ble (table syssecmechs)
00:00000:00001:2003/02/24 11:21:22.99 serverDatabase 'master': beginning upgrade step : creating ta
ble (table sysreferences)
00:00000:00001:2003/02/24 11:21:23.35 serverDatabase 'master': beginning upgrade step : creating ta
ble (table sysconstraints)
00:00000:00001:2003/02/24 11:21:23.66 serverDatabase 'master': beginning upgrade step : creating ta
ble (table sysusermessages)
00:00000:00001:2003/02/24 11:21:23.96 serverDatabase 'master': beginning upgrade step : creating ta
ble (table systhresholds)
00:00000:00001:2003/02/24 11:21:24.12 serverDatabase 'master': beginning upgrade step : creating ta
ble (table sysroles)
00:00000:00001:2003/02/24 11:21:24.40 serverDatabase 'master': beginning upgrade step : executing S
QL statement (declare @rid smallintdelete sysro)
00:00000:00001:2003/02/24 11:21:24.55 serverDatabase 'master': beginning upgrade step : executing S
QL statement (select lct_admin('lastchance', db_i)
00:00000:00001:2003/02/24 11:21:24.58 serverDatabase 'master': beginning upgrade step : creating ta
ble (table syspartitions)
00:00000:00001:2003/02/24 11:21:24.82 serverDatabase 'master': beginning upgrade step : creating ta
ble (table systimeranges)
00:00000:00001:2003/02/24 11:21:24.99 serverDatabase 'master': beginning upgrade step : executing S
QL statement (if not exists (select 1 from systim)
00:00000:00001:2003/02/24 11:21:25.03 serverDatabase 'master': beginning upgrade step : creating ta
ble (table sysresourcelimits)
00:00000:00001:2003/02/24 11:21:25.32 serverDatabase 'master': beginning upgrade step : executing S
QL statement (if not exists (select 1 from sysatt)
00:00000:00001:2003/02/24 11:21:25.37 serverDatabase 'master': beginning upgrade step : creating ta
ble (table systabstats)
00:00000:00001:2003/02/24 11:21:25.67 serverDatabase 'master': beginning upgrade step : creating ta
ble (table sysstatistics)
00:00000:00001:2003/02/24 11:21:26.03 serverDatabase 'master': beginning upgrade step : Initialize
systabstats with valid statistics
00:00000:00001:2003/02/24 11:21:26.92 serverDatabase 'master': beginning upgrade step : Creating/Up
dating the last chance threshold for logsegment.
00:00000:00001:2003/02/24 11:21:26.94 serverDatabase 'master': beginning upgrade step : creating ta
ble (table sysxtypes)
00:00000:00001:2003/02/24 11:21:27.39 serverDatabase 'master': beginning upgrade step : creating ta
ble (table sysjars)
00:00000:00001:2003/02/24 11:21:27.75 serverDatabase 'master': beginning upgrade step : executing S
QL statement (if not exists (select 1 from systyp)
00:00000:00001:2003/02/24 11:21:27.85 serverDatabase 'master': beginning upgrade step : creating ta
ble (table systransactions)
00:00000:00001:2003/02/24 11:21:27.94 serverDatabase 'master': beginning upgrade step : executing S
QL statement (update sysobjects set sysstat2 = sy)
00:00000:00001:2003/02/24 11:21:27.98 serverDatabase 'master': beginning upgrade step : executing S
QL statement (if not exists (select 1 from syssrv)
00:00000:00001:2003/02/24 11:21:28.01 serverDatabase 'master': beginning upgrade step : executing S
QL statement (insert sysattributes (class, attrib)
00:00000:00001:2003/02/24 11:21:28.05 serverDatabase 'master': beginning upgrade step : creating ta
ble (table sysqueryplans)
00:00000:00001:2003/02/24 11:21:28.42 serverDatabase 'master': beginning upgrade step : executing S
QL statement (insert into sysattributes         (class, )
00:00000:00001:2003/02/24 11:21:28.52 serverDatabase 'master': beginning upgrade step : creating ta
ble (table syssessions)
00:00000:00001:2003/02/24 11:21:28.61 serverDatabase 'master': beginning upgrade step : executing S
QL statement (if not exists (select 1 from syssrv)
00:00000:00001:2003/02/24 11:21:28.65 serverDatabase 'master': beginning upgrade step : executing S
QL statement (if (select suser_id('sa')) is not n)
00:00000:00001:2003/02/24 11:21:28.69 serverDatabase 'master': beginning upgrade step : executing S
QL statement (delete from sysconfigures where con)
00:00000:00001:2003/02/24 11:21:28.71 serverDatabase 'master': beginning upgrade step : creating ta
ble (table syscertificates)
00:00000:00001:2003/02/24 11:21:28.98 serverDatabase 'master': beginning upgrade step : executing S
QL statement (update systypes set length=@@maxpag)
00:00000:00001:2003/02/24 11:21:28.99 serverDatabase 'master': beginning upgrade step : executing S
QL statement (update sysattributes set int_value=)
00:00000:00001:2003/02/24 11:21:29.03 serverDatabase 'master': beginning upgrade step : executing S
QL statement (update sysattributes set int_value=)
00:00000:00001:2003/02/24 11:21:29.06 serverDatabase 'master': beginning upgrade step : noting the
present database upgrade level
00:00000:00001:2003/02/24 11:21:29.10 serverDatabase '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 serverDatabase 'model': beginning upgrade step : Initialize d
isk and create empty allocation units on master device.
00:00000:00001:2003/02/24 11:21:55.22 serverDatabase 'model': beginning upgrade step : Bootstrap ba
sic system catalogs in database.
00:00000:00001:2003/02/24 11:21:55.54 serverDatabase 'model': beginning upgrade step : creating ind
ex (table systypes, index ncsystypes)
00:00000:00001:2003/02/24 11:21:55.65 serverDatabase 'model': beginning upgrade step : creating ind
ex (table sysobjects, index ncsysobjects)
00:00000:00001:2003/02/24 11:21:55.70 serverDatabase 'model': beginning upgrade step : creating tab
le (table sysprocedures)
00:00000:00001:2003/02/24 11:21:55.89 serverDatabase 'model': beginning upgrade step : creating tab
le (table syscomments)
00:00000:00001:2003/02/24 11:21:56.03 serverDatabase 'model': beginning upgrade step : creating tab
le (table syssegments)
00:00000:00001:2003/02/24 11:21:56.09 serverDatabase 'model': beginning upgrade step : creating tab
le (table sysprotects)
00:00000:00001:2003/02/24 11:21:56.34 serverDatabase 'model': beginning upgrade step : creating tab
le (table sysusers)
00:00000:00001:2003/02/24 11:21:56.64 serverDatabase 'model': beginning upgrade step : creating tab
le (table sysalternates)
00:00000:00001:2003/02/24 11:21:56.78 serverDatabase 'model': beginning upgrade step : creating tab
le (table sysdepends)
00:00000:00001:2003/02/24 11:21:56.96 serverDatabase 'model': beginning upgrade step : creating tab
le (table syskeys)
00:00000:00001:2003/02/24 11:21:57.17 serverDatabase 'model': beginning upgrade step : creating tab
le (table sysattributes)
00:00000:00001:2003/02/24 11:21:57.51 serverDatabase 'model': beginning upgrade step : creating tab
le (table sysreferences)
00:00000:00001:2003/02/24 11:21:57.88 serverDatabase 'model': beginning upgrade step : creating tab
le (table sysconstraints)
00:00000:00001:2003/02/24 11:21:58.09 serverDatabase 'model': beginning upgrade step : creating tab
le (table sysusermessages)
00:00000:00001:2003/02/24 11:21:58.36 serverDatabase 'model': beginning upgrade step : creating tab
le (table systhresholds)
00:00000:00001:2003/02/24 11:21:58.57 serverDatabase 'model': beginning upgrade step : creating tab
le (table sysroles)
00:00000:00001:2003/02/24 11:21:58.72 serverDatabase 'model': beginning upgrade step : executing SQ
L statement (declare @rid smallintdelete sysro)
00:00000:00001:2003/02/24 11:21:58.94 serverDatabase 'model': beginning upgrade step : executing SQ
L statement (select lct_admin('lastchance', db_i)
00:00000:00001:2003/02/24 11:21:58.97 serverDatabase 'model': beginning upgrade step : creating tab
le (table syspartitions)
00:00000:00001:2003/02/24 11:21:59.09 serverDatabase 'model': beginning upgrade step : creating tab
le (table systabstats)
00:00000:00001:2003/02/24 11:21:59.34 serverDatabase 'model': beginning upgrade step : creating tab
le (table sysstatistics)
00:00000:00001:2003/02/24 11:21:59.61 serverDatabase 'model': beginning upgrade step : Initialize s
ystabstats with valid statistics
00:00000:00001:2003/02/24 11:22:00.14 serverDatabase 'model': beginning upgrade step : Creating/Upd
ating the last chance threshold for logsegment.
00:00000:00001:2003/02/24 11:22:00.17 serverDatabase 'model': beginning upgrade step : creating tab
le (table sysxtypes)
00:00000:00001:2003/02/24 11:22:00.51 serverDatabase 'model': beginning upgrade step : creating tab
le (table sysjars)
00:00000:00001:2003/02/24 11:22:00.85 serverDatabase 'model': beginning upgrade step : executing SQ
L statement (if not exists (select 1 from systyp)
00:00000:00001:2003/02/24 11:22:00.87 serverDatabase 'model': beginning upgrade step : creating tab
le (table sysqueryplans)
00:00000:00001:2003/02/24 11:22:01.21 serverDatabase 'model': beginning upgrade step : executing SQ
L statement (insert into sysattributes(class, )
00:00000:00001:2003/02/24 11:22:01.26 serverDatabase 'model': beginning upgrade step : executing SQ
L statement (update systypes set length=@@maxpag)
00:00000:00001:2003/02/24 11:22:01.28 serverDatabase 'model': beginning upgrade step : noting the p
resent database upgrade level
00:00000:00001:2003/02/24 11:22:01.36 serverCREATE DATABASE: allocating 1024 logical pages (8.0 megabytes) on
disk 'master'.
00:00000:00001:2003/02/24 11:22:37.63 serverDatabase sybsystemdb successfully created.
00:00000:00001:2003/02/24 11:22:37.70 serverRecovering database 'sybsystemdb'.
00:00000:00001:2003/02/24 11:22:37.71 serverRedo pass of recovery has processed 2 committed and 0 aborted tra
nsactions.
00:00000:00001:2003/02/24 11:22:37.86 serverBoot Count: 1
00:00000:00001:2003/02/24 11:22:37.88 serverChecking external objects.
00:00000:00001:2003/02/24 11:22:37.89 serverDatabase 'sybsystemdb' is now online.
00:00000:00001:2003/02/24 11:22:37.90 serverNow loading SQL Server's new default sort order and character set
00:00000:00001:2003/02/24 11:22:37.90 serverChecking sysobjects: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.90 serverChecking systypes: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.90 serverChecking sysusers: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.90 serverChecking sysreferences: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.90 serverChecking sysreferences: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.90 serverChecking sysreferences: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.90 serverChecking sysattributes: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.90 serverChecking sysattributes: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.90 serverChecking sysxtypes: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.90 serverChecking sysjars: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.91 serverChecking sysobjects: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.91 serverChecking systypes: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.91 serverChecking sysusers: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.91 serverChecking sysreferences: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.91 serverChecking sysreferences: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.91 serverChecking sysreferences: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.91 serverChecking sysattributes: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.91 serverChecking sysattributes: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.91 serverChecking sysxtypes: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.91 serverChecking sysjars: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.91 serverChecking sysobjects: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.91 serverChecking systypes: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.91 serverChecking sysusers: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.91 serverChecking sysreferences: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.91 serverChecking sysreferences: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.91 serverChecking sysreferences: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.91 serverChecking sysattributes: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.92 serverChecking sysattributes: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.92 serverChecking sysxtypes: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.92 serverChecking sysjars: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.92 serverChecking sysdatabases: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.92 serverChecking syslogins: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.92 serverChecking sysdevices: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.92 serverChecking sysconfigures: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.92 serverChecking sysservers: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.92 serverChecking sysremotelogins: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.92 serverChecking syslanguages: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.92 serverChecking syslanguages: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.93 serverChecking syscharsets: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:37.93 serverChecking sysresourcelimits: Logical pagesize is 8192 bytes
00:00000:00001:2003/02/24 11:22:38.01 serverDefault Sort Order successfully changed.
00:00000:00001:2003/02/24 11:22:38.01 serverSQL Server shutdown after verifying System Indexes.
00:00000:00001:2003/02/24 11:22:38.01 kernelueshutdown: exiting
00:00000:00000:2003/02/24 11:22:38.18 kernelUse license file /export/home/sybase/SYSAM-1_0/licenses/license.d
at.
00:00000:00000:2003/02/24 11:22:38.18 kernelChecked out license ASE_SERVER
00:00000:00000:2003/02/24 11:22:38.19 kernelUsing config area from primary master device.
00:00000:00000:2003/02/24 11:22:38.23 kernelos_find_good_keyfile: Found shared memory segment: key 0xea00eb17
, id 1201
00:00000:00000:2003/02/24 11:22:38.25 kernelos_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 kernelos_find_good_keyfile: Trying a different key
00:00000:00000:2003/02/24 11:22:38.44 kernelUsing 1024 file descriptors.
00:00000:00000:2003/02/24 11:22:38.45 kernelAdaptive Server Enterprise/12.5/SWR 9610 GA/P/Sun_svr4/OS 5.8/mai
n/1647/64-bit/FBO/Sat Jun2 01:55:25 2001
00:00000:00000:2003/02/24 11:22:38.45 kernelConfidential property of Sybase, Inc.
00:00000:00000:2003/02/24 11:22:38.45 kernelCopyright 1987, 2001
00:00000:00000:2003/02/24 11:22:38.45 kernelSybase, Inc.All rights reserved.
00:00000:00000:2003/02/24 11:22:38.45 kernelUnpublished 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 kernelThis software contains confidential and trade secret information
of Sybase,
00:00000:00000:2003/02/24 11:22:38.45 kernelInc.   Use,duplication or disclosure of the software and docume
ntation by
00:00000:00000:2003/02/24 11:22:38.45 kerneltheU.S.Governmentissubjecttorestrictions set forth in
a license
00:00000:00000:2003/02/24 11:22:38.45 kernelagreementbetweentheGovernmentandSybase,Inc.orothe
rwritten
00:00000:00000:2003/02/24 11:22:38.45 kernelagreementspecifyingtheGovernment's rights to use the softwa
re and any
00:00000:00000:2003/02/24 11:22:38.45 kernelapplicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2003/02/24 11:22:38.45 kernelSybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2003/02/24 11:22:38.45 kernelUsing '/export/home/sybase/ASE-12_5/jcweb.cfg' for configuration
information.
00:00000:00000:2003/02/24 11:22:38.45 kernelLogging ASE messages in file '/export/home/sybase/ASE-12_5/instal
l/jcweb.log'.
00:00000:00000:2003/02/24 11:22:38.48 kernelkdcl_sess_open: connectivity library supports master/query syntax
.
00:00000:00000:2003/02/24 11:22:38.49 kernelDirectory Control Layer (DCL) using directory driver: InterfacesD
river
00:00000:00000:2003/02/24 11:22:38.49 kernelSSL Plus security modules loaded successfully.
00:00000:00000:2003/02/24 11:22:38.49 kernelNetwork and device connection limit is 1014.
00:00000:00000:2003/02/24 11:22:38.68 serverNumber of blocks left for proc headers: 3192.
00:00000:00000:2003/02/24 11:22:38.69 serverProc header memory allocated 1596 pages for each per engine cache
00:00000:00000:2003/02/24 11:22:38.71 serverMemory allocated for the default data cache cachelet 1: 8192 Kb
00:00000:00000:2003/02/24 11:22:38.71 serverSize of the 8K memory pool: 8192 Kb
00:00000:00000:2003/02/24 11:22:38.71 kernelEnabling Sun Kernel asynchronous disk I/O strategy
00:00000:00000:2003/02/24 11:22:38.71 kernelInitializing virtual device 0, '/databasefile/jcweb/db/master.dat
' with dsync 'on'.
00:00000:00000:2003/02/24 11:22:38.71 kernelVirtual device 0 started using asynchronous i/o.
00:00000:00000:2003/02/24 11:22:38.71 kernelWorker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2003/02/24 11:22:38.72 kernelEither 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 kernelengine 0, os pid 552online
00:00000:00000:2003/02/24 11:22:38.72 serverNo active traceflags
00:00000:00001:2003/02/24 11:22:38.72 kernellibomni1 - 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 Jun2 01:55:25
2001'.
00:00000:00001:2003/02/24 11:22:38.72 kernellibomni1 - 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 serverOpening Master Database ...
00:00000:00001:2003/02/24 11:22:38.80 serverLoading SQL Server's default sort order and character set
00:00000:00001:2003/02/24 11:22:38.80 serverLoaded default Unilib conversion handle.
00:00000:00001:2003/02/24 11:22:38.82 serverRecovering database 'master'.
00:00000:00001:2003/02/24 11:22:38.82 serverRedo pass of recovery has processed 3 committed and 0 aborted tra
nsactions.
00:00000:00001:2003/02/24 11:22:38.90 serverChecking external objects.
00:00000:00001:2003/02/24 11:22:38.92 serverDatabase 'master' is now online.
00:00000:00001:2003/02/24 11:22:38.92 serverThe transaction log in the database 'master' will use I/O size of
8 Kb.
00:00000:00001:2003/02/24 11:22:38.92 serverWarning: ASE_HA has no valid license and therefore is not initial
ized.
00:00000:00001:2003/02/24 11:22:38.92 serverserver is unnamed
00:00000:00001:2003/02/24 11:22:39.00 serverRecovering database 'sybsystemdb'.
00:00000:00001:2003/02/24 11:22:39.07 serverBoot Count: 2
00:00000:00001:2003/02/24 11:22:39.09 serverChecking external objects.
00:00000:00001:2003/02/24 11:22:39.09 serverThe 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 serverDatabase 'sybsystemdb' is now online.
00:00000:00001:2003/02/24 11:22:39.11 serverRecovering database 'model'.
00:00000:00001:2003/02/24 11:22:39.19 serverChecking external objects.
00:00000:00001:2003/02/24 11:22:39.20 serverThe transaction log in the database 'model' will use I/O size of
8 Kb.
00:00000:00001:2003/02/24 11:22:39.21 serverDatabase 'model' is now online.
00:00000:00001:2003/02/24 11:22:39.21 serverThe logical pagesize of the server is 8 Kb.
00:00000:00001:2003/02/24 11:22:39.21 server0 dump conditions detected at boot time
00:00000:00001:2003/02/24 11:22:39.22 serverResident Node id: bdc6785d508b
00:00000:00001:2003/02/24 11:22:39.22 serverTransaction coordinator initialized.
00:00000:00001:2003/02/24 11:22:39.22 serverClearing temp db
00:00000:00001:2003/02/24 11:22:45.06 serverThe transaction log in the database 'tempdb' will use I/O size of
8 Kb.
00:00000:00001:2003/02/24 11:22:45.08 serverDatabase 'tempdb' is now online.
00:00000:00002:2003/02/24 11:22:45.09 kernelninit:0: listener type: master
00:00000:00002:2003/02/24 11:22:45.09 kernelninit:0: listener endpoint: /dev/tcp
00:00000:00002:2003/02/24 11:22:45.09 kernelninit:0: listener raw address: \x00021172c0a810050000000000000000
00:00000:00002:2003/02/24 11:22:45.09 kernelninit:0: transport provider: T_COTS_ORD
00:00000:00002:2003/02/24 11:22:45.09 kernelninit: t_bind, No Error
00:00000:00002:2003/02/24 11:22:45.09 kernelninit: All master network listeners have failed.Shutting down.
00:00000:00002:2003/02/24 11:22:45.09 kernelueshutdown: exiting

jazy 发表于 2003-02-24 13:05

SYBASE补丁安装指南

很奇怪!
前面都没什么错误阿!怎么最后报一个All master network listeners 呢?

就只有这些日志信息吗?

察看一下你的网络配置信息,对比一下你的interfaces中文件的ip信息!看看有没有什么出入!

rabbitdan 发表于 2003-02-24 13:22

SYBASE补丁安装指南

就这些日志阿!我的服务没有建成,所以我的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

SYBASE补丁安装指南

按照提示,系统是找不到sybase的服务,请问你在sybase用户主目录下,有没有配置sybase用户的环境变量

eastarwang 发表于 2003-03-03 10:20

SYBASE补丁安装指南

另外,报all network。。。。。fail

一般是你的ip地址或端口地址有错误
1、先检查你的*.rs文件中的ip地址,是否在你的系统中存在
#netstat -in
2、检查你的端口是否已经被使用

shaotao27 发表于 2003-05-03 14:04

SYBASE补丁安装指南

风格

yaoliang 发表于 2003-05-20 08:53

SYBASE补丁安装指南

请教Blackrose:
    在安装sybase12.5(NT4.0)后,我的服务器在开始启动时,能够自动启动SYBASE服务,但以后在控制面板中无法重新启动SYBASE服务,这是为何?

Blackrose 发表于 2003-05-23 18:06

SYBASE补丁安装指南

yaoliang :
你说的自动启动是不是指你已经把sybase服务设置为自动?
你把帖子新发一个吧!
页: [1] 2 3 4 5 6
查看完整版本: SYBASE补丁安装指南