sybase11.5建Master时故障

奎目郎119

环境：win2000server  sybase 11.5 主机内有sqlserver2000服务
起初以为是与sqlserver冲突，停过sqlserver的服务、后来怀疑市sybase本身原因，也重新安装过sybase软件，均告失败，，故障现象如图，望高手指教

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

ziggler

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

换台机器试验一下？

奎目郎119

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

换台机器试验一下？

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

ziggler

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

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

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

奎目郎119

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

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

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

chuxu

sybase的log里面有什么内容？

ziggler

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


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

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

奎目郎119

原帖由 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

这个机器的内存配置？CPU是不是差点啊？

奎目郎119

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