Chinaunix

标题: sybase11.5建Master时故障 [打印本页]

作者: 奎目郎119 时间: 2008-10-16 15:38
标题: sybase11.5建Master时故障
环境：win2000server sybase 11.5 主机内有sqlserver2000服务
起初以为是与sqlserver冲突，停过sqlserver的服务、后来怀疑市sybase本身原因，也重新安装过sybase软件，均告失败，，故障现象如图，望高手指教

[ 本帖最后由奎目郎119 于 2008-10-16 15:42 编辑 ]

未命名4.JPG (26.72 KB, 下载次数: 86)

错误如图

作者: ziggler 时间: 2008-10-16 15:41

原帖由 奎目郎119 于 2008-10-16 15:38 发表
环境：win2000server sybase 11.5 主机内有sqlserver2000服务
起初以为是与sqlserver冲突，停过sqlserver的服务、后来怀疑市sybase本身原因，也重新安装过sybase软件，均告失败，，故障现象如图，望高手指教

换台机器试验一下？

作者: 奎目郎119 时间: 2008-10-16 15:43

原帖由 ziggler 于 2008-10-16 15:41 发表

换台机器试验一下？

谢谢，不过不适宜，求更好的方法

作者: ziggler 时间: 2008-10-16 15:44

原帖由 奎目郎119 于 2008-10-16 15:43 发表

谢谢，不过不适宜，求更好的方法

这个的目的是确认你的安装程序本身没有问题。

作者: 奎目郎119 时间: 2008-10-16 15:49

原帖由 ziggler 于 2008-10-16 15:44 发表

这个的目的是确认你的安装程序本身没有问题。

安装程序本身肯定没问题，因为同时装了十台相同环境的机器，只有这一台出现上述问题

作者: chuxu 时间: 2008-10-16 15:51
sybase的log里面有什么内容？

作者: ziggler 时间: 2008-10-16 15:52

原帖由 奎目郎119 于 2008-10-16 15:49 发表

安装程序本身肯定没问题，因为同时装了十台相同环境的机器，只有这一台出现上述问题

看来是这台机器本身的问题，可以把不相关的服务或者软件卸载掉？

作者: 奎目郎119 时间: 2008-10-16 16:04

原帖由 ziggler 于 2008-10-16 15:52 发表

看来是这台机器本身的问题，可以把不相关的服务或者软件卸载掉？

杀毒、防火、sqlserver我都停了，故障依旧，下面是错误日志的结尾部分

00:00000:00001:2008/10/15 13:26:48.00 server  Database 'model': beginning upgrade step [ID 603]: creating table (table systhresholds)
00:00000:00001:2008/10/15 13:26:48.01 server  Database 'model': beginning upgrade step [ID 604]: creating table (table sysroles)
00:00000:00001:2008/10/15 13:26:48.03 server  Database 'model': beginning upgrade step [ID 605]: executing SQL statement (declare @rid smallint  delete sysro)
00:00000:00001:2008/10/15 13:26:48.04 server  Database 'model': beginning upgrade step [ID 606]: executing SQL statement (select lct_admin('lastchance', db_i)
00:00000:00001:2008/10/15 13:26:48.04 server  Database 'model': beginning upgrade step [ID  1013]: creating table (table syspartitions)
00:00000:00001:2008/10/15 13:26:48.06 server  Database 'model': beginning upgrade step [ID  1124]: creating table (table systabstats)
00:00000:00001:2008/10/15 13:26:48.07 server  Database 'model': beginning upgrade step [ID  1125]: creating table (table sysstatistics)
00:00000:00001:2008/10/15 13:26:48.09 server  Database 'model': beginning upgrade step [ID  1126]: Initialize systabstats with valid statistics
00:00000:00001:2008/10/15 13:26:48.12 server  Database 'model': beginning upgrade step [ID  1131]: Creating/Updating the last chance threshold for logsegment.
00:00000:00001:2008/10/15 13:26:48.14 server  Database 'model': beginning upgrade step [ID  1201]: creating table (table sysxtypes)
00:00000:00001:2008/10/15 13:26:48.15 server  Database 'model': beginning upgrade step [ID  1205]: creating table (table sysjars)
00:00000:00001:2008/10/15 13:26:48.17 server  Database 'model': beginning upgrade step [ID  1206]: executing SQL statement (if not exists (select 1 from systyp)
00:00000:00001:2008/10/15 13:26:48.18 server  Database 'model': beginning upgrade step [ID  1240]: creating table (table sysqueryplans)
00:00000:00001:2008/10/15 13:26:48.20 server  Database 'model': beginning upgrade step [ID  1241]: executing SQL statement (insert into sysattributes (class, )
00:00000:00001:2008/10/15 13:26:48.20 server  Database 'model': beginning upgrade step [ID  1274]: executing SQL statement (declare @rid smallint  delete sysus)
00:00000:00001:2008/10/15 13:26:48.21 server  Database 'model': beginning upgrade step [ID  1340]: executing SQL statement (update systypes set length=@@maxpag)
00:00000:00001:2008/10/15 13:26:48.21 server  Database 'model': beginning upgrade step [ID  1400]: noting the present database upgrade level
00:00000:00001:2008/10/15 13:26:48.23 server  CREATE DATABASE: allocating 1024 logical pages (2.0 megabytes) on disk 'master'.
00:00000:00001:2008/10/15 13:26:48.76 server  Database sybsystemdb successfully created.
00:00000:00001:2008/10/15 13:26:48.90 server  Recovering database 'sybsystemdb'.
00:00000:00001:2008/10/15 13:26:48.95 server  Redo pass of recovery has processed 2 committed and 0 aborted transactions.
00:00000:00001:2008/10/15 13:26:49.01 server  Boot Count: 1
00:00000:00001:2008/10/15 13:26:49.01 server  Checking external objects.
00:00000:00001:2008/10/15 13:26:49.09 server  Database 'sybsystemdb' is now online.
00:00000:00001:2008/10/15 13:26:49.10 server  Now loading SQL Server's new default sort order and character set
00:00000:00001:2008/10/15 13:26:49.10 server  Checking sysobjects: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.10 server  Checking systypes: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.10 server  Checking sysusers: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.10 server  Checking sysreferences: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.10 server  Checking sysreferences: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.10 server  Checking sysreferences: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.10 server  Checking sysattributes: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.10 server  Checking sysattributes: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.10 server  Checking sysxtypes: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.12 server  Checking sysjars: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.12 server  Checking sysobjects: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.12 server  Checking systypes: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.12 server  Checking sysusers: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.14 server  Checking sysreferences: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.14 server  Checking sysreferences: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.14 server  Checking sysreferences: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.14 server  Checking sysattributes: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.15 server  Checking sysattributes: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.20 server  Checking sysxtypes: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.21 server  Checking sysjars: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.21 server  Checking sysobjects: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.21 server  Checking systypes: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.21 server  Checking sysusers: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.21 server  Checking sysreferences: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.21 server  Checking sysreferences: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.21 server  Checking sysreferences: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.21 server  Checking sysattributes: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.21 server  Checking sysattributes: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.21 server  Checking sysxtypes: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.21 server  Checking sysjars: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.21 server  Checking sysdatabases: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.21 server  Checking syslogins: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.21 server  Checking sysdevices: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.21 server  Checking sysconfigures: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.23 server  Checking sysservers: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.23 server  Checking sysremotelogins: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.23 server  Checking syslanguages: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.23 server  Checking syslanguages: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.23 server  Checking syscharsets: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.23 server  Checking sysresourcelimits: Logical pagesize is 2048 bytes
00:00000:00001:2008/10/15 13:26:49.23 server  Default Sort Order successfully changed.
00:00000:00001:2008/10/15 13:26:49.23 server  SQL Server shutdown after verifying System Indexes.
00:00000:00001:2008/10/15 13:26:49.23 kernel  ueshutdown: exiting
00:00000:00000:2008/10/15 13:27:01.67 kernel  Use license file c:\sybase\SYSAM-1_0\licenses\license.dat.
00:00000:00000:2008/10/15 13:27:01.67 kernel  Checked out license ASE_SERVER
00:00000:00000:2008/10/15 13:27:01.67 kernel  Adaptive Server Enterprise Edition
00:00000:00000:2008/10/15 13:27:01.68 kernel  Using config area from primary master device.
00:00000:00000:2008/10/15 13:27:01.70 kernel  Warning: Using default file 'c:\sybase\jhjbtx030server.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2008/10/15 13:27:01.78 kernel  Using 100000 file descriptors.
00:00000:00000:2008/10/15 13:27:01.78 kernel  Adaptive Server Enterprise/12.5.0.1/EBF 10430 ESD#2/P/NT (IX86)/OS 4.0/rel12501/1/32-bit/OPT/Tue Jul 30 23:45:57 2002
00:00000:00000:2008/10/15 13:27:01.78 kernel  Confidential property of Sybase, Inc.
00:00000:00000:2008/10/15 13:27:01.78 kernel  Copyright 1987, 2002
00:00000:00000:2008/10/15 13:27:01.78 kernel  Sybase, Inc.  All rights reserved.
00:00000:00000:2008/10/15 13:27:01.78 kernel  Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2008/10/15 13:27:01.78 kernel
00:00000:00000:2008/10/15 13:27:01.78 kernel  This software contains confidential and trade secret information of Sybase,
00:00000:00000:2008/10/15 13:27:01.78 kernel  Inc. Use,  duplication or disclosure of the software and documentation by
00:00000:00000:2008/10/15 13:27:01.78 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
00:00000:00000:2008/10/15 13:27:01.78 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
00:00000:00000:2008/10/15 13:27:01.78 kernel  agreement  specifying  the  Government's rights to use the software and any
00:00000:00000:2008/10/15 13:27:01.78 kernel  applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2008/10/15 13:27:01.78 kernel  Sybase, Inc. 5000 Hacienda Drive, Dublin, CA 94568, USA
00:00000:00000:2008/10/15 13:27:01.78 kernel  Using 'c:\sybase\jhjbtx030server.cfg' for configuration information.
00:00000:00000:2008/10/15 13:27:01.78 kernel  Logging ASE messages in file 'c:\sybase\ASE-12_5\install\errorlog'.
00:00000:00000:2008/10/15 13:27:01.79 kernel  Initializing MSDTC Connection
00:00000:00000:2008/10/15 13:27:02.81 kernel  MSDTC Initialization succeeded
00:00000:00000:2008/10/15 13:27:02.81 kernel  kdcl_sess_open: connectivity library supports master/query syntax.
00:00000:00000:2008/10/15 13:27:02.81 kernel  Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2008/10/15 13:27:02.81 kernel  SQL Server NT process id is 0x8e4.
00:00000:00000:2008/10/15 13:27:02.81 kernel  SQL Server was started as a Service.
00:00000:00000:2008/10/15 13:27:02.81 kernel  SSL Plus v3.0.9 security modules loaded successfully.
00:00000:00000:2008/10/15 13:27:02.81 kernel  Network and device connection limit is 99992.
00:00000:00000:2008/10/15 13:27:02.85 server  Number of blocks left for proc headers: 3232.
00:00000:00000:2008/10/15 13:27:02.85 server  Proc header memory allocated 1616 pages for each per engine cache
00:00000:00000:2008/10/15 13:27:02.87 server  Memory allocated for the default data cache cachelet 1: 8192 Kb
00:00000:00000:2008/10/15 13:27:02.87 server  Size of the 2K memory pool: 8192 Kb
00:00000:00000:2008/10/15 13:27:02.87 kernel  Initializing virtual device 0, 'd:\data\master.dat' with dsync 'on'.
00:00000:00000:2008/10/15 13:27:02.87 kernel  Virtual device 0 started using asynchronous i/o.
00:00000:00000:2008/10/15 13:27:02.87 kernel  Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2008/10/15 13:27:02.87 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:2008/10/15 13:27:03.57 kernel  engine 0, os pid 668  online
00:00000:00000:2008/10/15 13:27:03.59 server  No active traceflags
00:00000:00001:2008/10/15 13:27:03.59 kernel  libomni1 - Component Integration Services loaded; version 'libomni1 - Component Integration Services/12.5.0.1/EBF 10430 ESD#2/P/NT (IX86)/OS 4.0/rel12501/1794/32-bit/OPT/Tue Jul 30 17:41:42 2002'.
00:00000:00001:2008/10/15 13:27:03.59 kernel  libomni1 - Component Integration Services: using 'Sybase Client-Library/12.5/P-EBF10322/PC Intel/BUILD125-011-1/OPT/Thu May 02 15:33:17 2002'
00:00000:00001:2008/10/15 13:27:03.59 server  Opening Master Database ...
00:00000:00001:2008/10/15 13:27:03.70 server  Loading SQL Server's default sort order and character set
00:00000:00001:2008/10/15 13:27:03.78 server  Loaded default Unilib conversion handle.
00:00000:00001:2008/10/15 13:27:03.79 server  Recovering database 'master'.
00:00000:00001:2008/10/15 13:27:03.82 server  Redo pass of recovery has processed 3 committed and 0 aborted transactions.
00:00000:00001:2008/10/15 13:27:04.00 server  Checking external objects.
00:00000:00001:2008/10/15 13:27:04.01 server  Database 'master' is now online.
00:00000:00001:2008/10/15 13:27:04.01 server  The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2008/10/15 13:27:04.01 server  Warning: ASE_HA has no valid license and therefore is not initialized.
00:00000:00001:2008/10/15 13:27:04.03 server  server is unnamed
00:00000:00001:2008/10/15 13:27:04.10 server  Recovering database 'sybsystemdb'.
00:00000:00001:2008/10/15 13:27:04.17 server  Boot Count: 2
00:00000:00001:2008/10/15 13:27:04.18 server  Checking external objects.
00:00000:00001:2008/10/15 13:27:04.20 server  The transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2008/10/15 13:27:04.21 server  Database 'sybsystemdb' is now online.
00:00000:00001:2008/10/15 13:27:04.26 server  Recovering database 'model'.
00:00000:00001:2008/10/15 13:27:04.29 server  Checking external objects.
00:00000:00001:2008/10/15 13:27:04.29 server  The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2008/10/15 13:27:04.31 server  Database 'model' is now online.
00:00000:00001:2008/10/15 13:27:04.31 server  The logical pagesize of the server is 2 Kb.
00:00000:00001:2008/10/15 13:27:04.31 server  0 dump conditions detected at boot time
00:00000:00001:2008/10/15 13:27:04.31 server  Resident Node id: b8579f156285
00:00000:00001:2008/10/15 13:27:04.31 server  Transaction coordinator initialized.
00:00000:00001:2008/10/15 13:27:04.31 server  Clearing temp db
00:00000:00001:2008/10/15 13:27:04.57 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2008/10/15 13:27:04.57 server  Database 'tempdb' is now online.
00:00000:00002:2008/10/15 13:27:04.60 kernel  network name 192.168.1.1, type ether, port 5000, filter NONE
00:00000:00001:2008/10/15 13:27:04.64 server  Recovery complete.
00:00000:00001:2008/10/15 13:27:04.64 server  SQL Server's default unicode sort order is 'binary'.
00:00000:00001:2008/10/15 13:27:04.64 server  SQL Server's default sort order is:
00:00000:00001:2008/10/15 13:27:04.64 server    'bin_cp850' (ID = 50)
00:00000:00001:2008/10/15 13:27:04.64 server  on top of default character set:
00:00000:00001:2008/10/15 13:27:04.64 server    'cp850' (ID = 2).
00:00000:00001:2008/10/15 13:27:04.64 server  Master device size: 1000 megabytes, or 512000 virtual pages. (A virtual page is 2048 bytes.)

作者: ziggler 时间: 2008-10-16 16:19
这个机器的内存配置？CPU是不是差点啊？

作者: 奎目郎119 时间: 2008-10-16 16:45
机器配置还可以的，2.4G的CPU，512M内存，用来做超市的POS服务器的，业务量不大，况且256M的机器我都建成功过。刚才忘记告诉你了，我这些服务器都是用远程连接安装的，不是直接控制堆放桌面那种，用的是远程桌面工具

作者: ziggler 时间: 2008-10-16 16:49

原帖由 奎目郎119 于 2008-10-16 16:45 发表
机器配置还可以的，2.4G的CPU，512M内存，用来做超市的POS服务器的，业务量不大，况且256M的机器我都建成功过。刚才忘记告诉你了，我这些服务器都是用远程连接安装的，不是直接控制堆放桌面那种，用的是远程桌面工具

你可以不用远程控制来试验一下？

作者: 奎目郎119 时间: 2008-10-16 17:07
就在刚才我用了远程控制，Remote Administrator viewer，也不能创建master，错误提示变了，如图

zhuomian.JPG (24.83 KB, 下载次数: 56)

在桌面下错误

作者: ziggler 时间: 2008-10-16 17:12

原帖由 奎目郎119 于 2008-10-16 17:07 发表
就在刚才我用了远程控制，Remote Administrator viewer，也不能创建master，错误提示变了，如图

error.log信息看看，好像是更新注册表出错。

作者: echoaix 时间: 2008-10-16 17:36
错误日志不是清楚显示你的server已经创建好了吗？直接使用就行了。1G的master device，厉害。

作者: 奎目郎119 时间: 2008-10-17 09:40
可是只有master，没有sybprocs，怎么能算建好呢

作者: echoaix 时间: 2008-10-17 11:18
没有自己建一个
http://www.sybase.cn/cn/content/support/exp_jszc_ase_gj_00007.htm

作者: WFCJZ 时间: 2008-10-18 10:09
这个问题就是MASTER存在了,你还在建,最好的办法,删除重新安装,再重建库!安装之前把你的相关SYBASE在注册表里的值全部删除再行安装!祝你好运!

作者: 奎目郎119 时间: 2008-10-18 14:31
谢诸位帮忙，问题已经解决了，方法是重装系统，SQLSERVER，sybase

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)