sybase无法启动,跪求高手指点!!!
今天下午3点多机房停电,情急之下关了SYBASE服务器,晚上7多点来电了,sybase就无法启动了日志如下:
00:00000:00000:2008/07/04 15:56:17.64 kernelkisignal: SQL Server terminated by system shutdown.
00:00000:00000:2008/07/04 15:56:17.64 kernelueshutdown: exiting
00:00000:00000:2008/07/04 15:56:17.64 kernelshutdown waiting for engine pid 392 to exit...
00:00000:00000:2008/07/04 15:56:17.64 kernelengine pid 392 exit completed
00:00000:00000:2008/07/04 15:56:17.64 kernelshutdown waiting for engine pid 780 to exit...
00:00000:00000:2008/07/04 15:56:17.64 kernelengine pid 780 exit completed
00:00000:00000:2008/07/04 15:56:17.64 kernelshutdown waiting for engine pid 800 to exit...
00:00000:00000:2008/07/04 15:56:17.65 kernelengine pid 800 exit completed
00:00000:00000:2008/07/04 15:56:17.65 kernelshutdown waiting for engine pid 820 to exit...
00:00000:00000:2008/07/04 15:56:17.67 kernelengine pid 820 exit completed
00:00000:00000:2008/07/04 15:56:17.67 kernelshutdown waiting for engine pid 840 to exit...
00:00000:00000:2008/07/04 15:56:17.70 kernelengine pid 840 exit completed
00:00000:00000:2008/07/04 15:56:17.70 kernelshutdown waiting for engine pid 860 to exit...
00:00000:00000:2008/07/04 15:56:17.81 kernelengine pid 860 exit completed
00:00000:00000:2008/07/04 15:56:17.81 kernelshutdown waiting for engine pid 880 to exit...
00:00000:00000:2008/07/04 15:56:17.82 kernelengine pid 880 exit completed
00:00000:00000:2008/07/04 15:56:17.82 kernelAbnormal exit detected - SQL Server process level execution bindings will be cleared on startup.
sybase无法启动,跪求高手指点!!!
0:00000:00000:2008/07/04 19:48:01.73 kernelUse license file C:\sybase\SYSAM-1_0\licenses\license.dat.00:00000:00000:2008/07/04 19:48:01.73 kernelChecked out license ASE_SERVER
00:00000:00000:2008/07/04 19:48:01.73 kernelAdaptive Server Enterprise Edition
00:00000:00000:2008/07/04 19:48:01.76 kernelUsing config area from primary master device.
00:00000:00000:2008/07/04 19:48:01.78 kernelWarning: Using default file 'C:\sybase\SYBASESERVER.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/07/04 19:48:02.43 kernelUsing 100000 file descriptors.
00:00000:00000:2008/07/04 19:48:02.45 kernelAdaptive Server Enterprise/12.5.3/EBF 13061 ESD#5/P/NT (IX86)/OS 4.0/ase1253/1939/32-bit/OPT/Tue Dec 06 00:21:31 2005
00:00000:00000:2008/07/04 19:48:02.45 kernelConfidential property of Sybase, Inc.
00:00000:00000:2008/07/04 19:48:02.45 kernelCopyright 1987, 2005
00:00000:00000:2008/07/04 19:48:02.45 kernelSybase, Inc.All rights reserved.
00:00000:00000:2008/07/04 19:48:02.45 kernelUnpublished rights reserved under U.S. copyright laws.
00:00000:00000:2008/07/04 19:48:02.45 kernel
00:00000:00000:2008/07/04 19:48:02.45 kernelThis software contains confidential and trade secret information of Sybase,
00:00000:00000:2008/07/04 19:48:02.45 kernelInc. Use,duplication or disclosure of the software and documentation by
00:00000:00000:2008/07/04 19:48:02.45 kerneltheU.S.Governmentissubjecttorestrictions set forth in a license
00:00000:00000:2008/07/04 19:48:02.45 kernelagreementbetweentheGovernmentandSybase,Inc.orotherwritten
00:00000:00000:2008/07/04 19:48:02.45 kernelagreementspecifyingtheGovernment's rights to use the software and any
00:00000:00000:2008/07/04 19:48:02.45 kernelapplicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2008/07/04 19:48:02.45 kernelSybase, Inc. One Sybase Drive, Dublin, CA 94568, USA
00:00000:00000:2008/07/04 19:48:02.45 kernelASE booted on Windows 2003 build 3790 Service Pack 1.
00:00000:00000:2008/07/04 19:48:02.45 kernelUsing 'C:\sybase\SYBASESERVER.cfg' for configuration information.
00:00000:00000:2008/07/04 19:48:02.45 kernelLogging ASE messages in file 'C:\sybase\ASE-12_5\install\errorlog'.
00:00000:00000:2008/07/04 19:48:02.46 kernelInitializing MSDTC Connection
00:00000:00000:2008/07/04 19:48:07.18 kernelMSDTC Initialization succeeded
00:00000:00000:2008/07/04 19:48:07.18 kernelSQL Server booted with TCP_NODELAY enabled.
00:00000:00000:2008/07/04 19:48:07.18 kernel*** WARNING ******************
00:00000:00000:2008/07/04 19:48:07.18 kernelOperating system may favor the system cache when memory is at a premium.
To disable this warning, set the registry parameter 'LargeSystemCache' to 0 in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Memory Management.
00:00000:00000:2008/07/04 19:48:07.18 kernelSQL Server NT process id is 0x2bc.
00:00000:00000:2008/07/04 19:48:07.18 kernelSQL Server was started as a Service.
00:00000:00000:2008/07/04 19:48:07.21 kernelSSL Plus v3.1.15 security modules loaded successfully.
00:00000:00000:2008/07/04 19:48:07.21 kernelNetwork and device connection limit is 99992.
00:00000:00000:2008/07/04 19:48:09.09 serverNumber of blocks left for proc headers: 255944.
00:00000:00000:2008/07/04 19:48:09.15 serverProc header memory allocated 18281 pages for each per engine cache
00:00000:00000:2008/07/04 19:48:09.15 serverLocal cache partition number has been auto tuned to 2 for default data cache cache.
00:00000:00000:2008/07/04 19:48:13.50 serverSize of the 4K memory pool: 768000 Kb
00:00000:00000:2008/07/04 19:48:13.50 serverMemory allocated for the default data cache cachelet 1: 768000 Kb
00:00000:00000:2008/07/04 19:48:13.53 serverSize of the 4K memory pool: 4 Kb
00:00000:00000:2008/07/04 19:48:13.53 serverMemory allocated for the default data cache cachelet 2: 767996 Kb
00:00000:00000:2008/07/04 19:48:13.54 kernelInitializing virtual device 0, 'E:\sybase\data\master.dat' with dsync 'on'.
00:00000:00000:2008/07/04 19:48:13.54 kernelVirtual device 0 started using asynchronous i/o.
00:00000:00000:2008/07/04 19:48:13.54 kernelWorker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2008/07/04 19:48:13.54 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 not be initialized. No external security mechanisms will be supported.
00:00000:00000:2008/07/04 19:48:13.54 kernelengine 0, os pid 392online
00:00000:00000:2008/07/04 19:48:13.54 serverNo active traceflags
00:00000:00001:2008/07/04 19:48:13.54 kernellibomni1 - Component Integration Services loaded; version 'libomni1 - Component Integration Services/12.5.3/EBF 13061 ESD#5/P/NT (IX86)/OS 4.0/ase1253/1939/32-bit/OPT/Tue Dec 06 00:21:31 2005'.
00:00000:00001:2008/07/04 19:48:13.54 kernellibomni1 - Component Integration Services: using 'Sybase Client-Library/12.5.1/P-EBF12117 ESD #5/PC Intel/BUILD1251-038/OPT/Tue Aug 17 20:29:27 2004'
00:00000:00001:2008/07/04 19:48:13.54 serverOpening Master Database ...
00:00000:00001:2008/07/04 19:48:13.64 serverLoading SQL Server's default sort order and character set
00:00000:00001:2008/07/04 19:48:13.65 serverLoaded default Unilib conversion handle.
00:00000:00001:2008/07/04 19:48:13.65 serverRecovering database 'master'.
00:00000:00001:2008/07/04 19:48:13.65 serverStarted estimating recovery log boundaries for database 'master'.
00:00000:00001:2008/07/04 19:48:13.65 serverDatabase 'master', checkpoint=(2156, 32), first=(2156, 32), last=(2156, 44).
00:00000:00001:2008/07/04 19:48:13.65 serverCompleted estimating recovery log boundaries for database 'master'.
00:00000:00001:2008/07/04 19:48:13.65 serverStarted ANALYSIS pass for database 'master'.
00:00000:00001:2008/07/04 19:48:13.65 serverCompleted ANALYSIS pass for database 'master'.
00:00000:00001:2008/07/04 19:48:13.65 serverStarted REDO pass for database 'master'. The total number of log records to process is 13.
00:00000:00001:2008/07/04 19:48:13.67 serverRedo pass of recovery has processed 4 committed and 0 aborted transactions.
00:00000:00001:2008/07/04 19:48:13.67 serverCompleted REDO pass for database 'master'.
00:00000:00001:2008/07/04 19:48:13.67 serverRecovery of database 'master' will undo incomplete nested top actions.
00:00000:00001:2008/07/04 19:48:13.67 serverStarted recovery checkpoint for database 'master'.
00:00000:00001:2008/07/04 19:48:13.68 serverCompleted recovery checkpoint for database 'master'.
00:00000:00001:2008/07/04 19:48:13.68 serverStarted filling free space info for database 'master'.
00:00000:00001:2008/07/04 19:48:13.78 serverCompleted filling free space info for database 'master'.
00:00000:00001:2008/07/04 19:48:13.78 serverStarted cleaning up the default data cache for database 'master'.
00:00000:00001:2008/07/04 19:48:13.81 serverCompleted cleaning up the default data cache for database 'master'.
00:00000:00001:2008/07/04 19:48:13.82 serverChecking external objects.
sybase无法启动,跪求高手指点!!!
00:00000:00001:2008/07/04 19:48:13.85 serverDatabase 'master' is now online.00:00000:00001:2008/07/04 19:48:13.85 serverThe transaction log in the database 'master' will use I/O size of 4 Kb.
00:00000:00001:2008/07/04 19:48:13.89 serverWarning: ASE_HA has no valid license and therefore is not initialized.
00:00000:00001:2008/07/04 19:48:13.90 serverserver name is 'CSGSJPB6KPCUU2'
00:00000:00001:2008/07/04 19:48:13.90 serverActivating disk 'epsa' of size 1048576 KB.
00:00000:00001:2008/07/04 19:48:13.90 kernelInitializing virtual device 3, 'E:\sybase\data\epsa.dat' with dsync 'on'.
00:00000:00001:2008/07/04 19:48:13.90 kernelVirtual device 3 started using asynchronous i/o.
00:00000:00001:2008/07/04 19:48:13.90 serverActivating disk 'epsa1' of size 1048576 KB.
00:00000:00001:2008/07/04 19:48:13.90 kernelInitializing virtual device 12, 'e:\sybase\data\epsa1.dat' with dsync 'on'.
00:00000:00001:2008/07/04 19:48:13.90 kernelVirtual device 12 started using asynchronous i/o.
00:00000:00001:2008/07/04 19:48:13.90 serverActivating disk 'epsa_log' of size 1048576 KB.
00:00000:00001:2008/07/04 19:48:13.90 kernelInitializing virtual device 4, 'E:\sybase\data\epsa_log.dat' with dsync 'on'.
00:00000:00001:2008/07/04 19:48:13.90 kernelVirtual device 4 started using asynchronous i/o.
00:00000:00001:2008/07/04 19:48:13.90 serverActivating disk 'ept_log' of size 4194304 KB.
00:00000:00001:2008/07/04 19:48:13.90 kernelInitializing virtual device 7, 'E:\sybase\data\ept_log.dat' with dsync 'on'.
00:00000:00001:2008/07/04 19:48:13.90 kernelVirtual device 7 started using asynchronous i/o.
00:00000:00001:2008/07/04 19:48:13.90 serverActivating disk 'ept_log1' of size 4194304 KB.
00:00000:00001:2008/07/04 19:48:13.90 kernelInitializing virtual device 9, 'E:\sybase\data\ept_log1.dat' with dsync 'on'.
00:00000:00001:2008/07/04 19:48:13.90 kernelVirtual device 9 started using asynchronous i/o.
00:00000:00001:2008/07/04 19:48:13.90 serverActivating disk 'ept_user' of size 6291456 KB.
00:00000:00001:2008/07/04 19:48:13.90 kernelInitializing virtual device 5, 'E:\sybase\data\ept_user.dat' with dsync 'on'.
00:00000:00001:2008/07/04 19:48:13.90 kernelVirtual device 5 started using asynchronous i/o.
00:00000:00001:2008/07/04 19:48:13.90 serverActivating disk 'ept_user1' of size 6291456 KB.
00:00000:00001:2008/07/04 19:48:13.90 kernelInitializing virtual device 6, 'E:\sybase\data\ept_user1.dat' with dsync 'on'.
00:00000:00001:2008/07/04 19:48:13.90 kernelVirtual device 6 started using asynchronous i/o.
00:00000:00001:2008/07/04 19:48:13.90 serverActivating disk 'ept_user2' of size 6291456 KB.
00:00000:00001:2008/07/04 19:48:13.90 kernelInitializing virtual device 8, 'E:\sybase\data\ept_user2.dat' with dsync 'on'.
00:00000:00001:2008/07/04 19:48:13.90 kernelVirtual device 8 started using asynchronous i/o.
00:00000:00001:2008/07/04 19:48:13.90 serverActivating disk 'ept_user3' of size 6291456 KB.
00:00000:00001:2008/07/04 19:48:13.90 kernelInitializing virtual device 10, 'E:\sybase\data\ept_user3.dat' with dsync 'on'.
00:00000:00001:2008/07/04 19:48:13.90 kernelVirtual device 10 started using asynchronous i/o.
00:00000:00001:2008/07/04 19:48:13.90 serverActivating disk 'ept_user4' of size 6291456 KB.
00:00000:00001:2008/07/04 19:48:13.90 kernelInitializing virtual device 11, 'E:\sybase\data\ept_user4.dat' with dsync 'on'.
00:00000:00001:2008/07/04 19:48:13.90 kernelVirtual device 11 started using asynchronous i/o.
00:00000:00001:2008/07/04 19:48:13.90 serverActivating disk 'ept_user5' of size 10485760 KB.
00:00000:00001:2008/07/04 19:48:13.90 kernelInitializing virtual device 13, 'e:\sybase\data\ept_user5.dat' with dsync 'on'.
00:00000:00001:2008/07/04 19:48:13.90 kernelVirtual device 13 started using asynchronous i/o.
00:00000:00001:2008/07/04 19:48:13.90 serverActivating disk 'sybsystemdb' of size 51200 KB.
00:00000:00001:2008/07/04 19:48:13.90 kernelInitializing virtual device 2, 'E:\sybase\data\sybsysdb.dat' with dsync 'on'.
00:00000:00001:2008/07/04 19:48:13.90 kernelVirtual device 2 started using asynchronous i/o.
00:00000:00001:2008/07/04 19:48:13.90 serverActivating disk 'sysprocsdev' of size 204800 KB.
00:00000:00001:2008/07/04 19:48:13.90 kernelInitializing virtual device 1, 'E:\sybase\data\sybprocs.dat' with dsync 'on'.
00:00000:00001:2008/07/04 19:48:13.90 kernelVirtual device 1 started using asynchronous i/o.
00:00000:00001:2008/07/04 19:48:13.96 serverRecovering database 'sybsystemdb'.
00:00000:00001:2008/07/04 19:48:13.96 serverStarted estimating recovery log boundaries for database 'sybsystemdb'.
00:00000:00001:2008/07/04 19:48:13.96 serverDatabase 'sybsystemdb', checkpoint=(632, 20), first=(632, 20), last=(632, 22).
00:00000:00001:2008/07/04 19:48:13.96 serverCompleted estimating recovery log boundaries for database 'sybsystemdb'.
00:00000:00001:2008/07/04 19:48:13.96 serverStarted ANALYSIS pass for database 'sybsystemdb'.
00:00000:00001:2008/07/04 19:48:13.96 serverCompleted ANALYSIS pass for database 'sybsystemdb'.
00:00000:00001:2008/07/04 19:48:13.96 serverStarted REDO pass for database 'sybsystemdb'. The total number of log records to process is 3.
00:00000:00001:2008/07/04 19:48:13.98 serverRedo pass of recovery has processed 0 committed and 1 aborted transactions.
00:00000:00001:2008/07/04 19:48:13.98 serverCompleted REDO pass for database 'sybsystemdb'.
00:00000:00001:2008/07/04 19:48:13.98 serverRecovery of database 'sybsystemdb' will undo incomplete nested top actions.
00:00000:00001:2008/07/04 19:48:13.98 serverStarted recovery checkpoint for database 'sybsystemdb'.
00:00000:00001:2008/07/04 19:48:13.98 serverCompleted recovery checkpoint for database 'sybsystemdb'.
00:00000:00001:2008/07/04 19:48:13.98 serverStarted filling free space info for database 'sybsystemdb'.
00:00000:00001:2008/07/04 19:48:14.04 serverCompleted filling free space info for database 'sybsystemdb'.
00:00000:00001:2008/07/04 19:48:14.04 serverStarted cleaning up the default data cache for database 'sybsystemdb'.
00:00000:00001:2008/07/04 19:48:14.07 serverCompleted cleaning up the default data cache for database 'sybsystemdb'.
00:00000:00001:2008/07/04 19:48:14.07 serverBoot Count: 83
00:00000:00001:2008/07/04 19:48:14.07 serverChecking external objects.
00:00000:00001:2008/07/04 19:48:14.09 serverThe transaction log in the database 'sybsystemdb' will use I/O size of 4 Kb.
00:00000:00001:2008/07/04 19:48:14.14 serverDatabase 'sybsystemdb' is now online.
00:00000:00001:2008/07/04 19:48:14.17 serverRecovering database 'model'.
00:00000:00001:2008/07/04 19:48:14.17 serverStarted estimating recovery log boundaries for database 'model'.
00:00000:00001:2008/07/04 19:48:14.17 serverDatabase 'model', checkpoint=(601, 19), first=(601, 19), last=(601, 19).
00:00000:00001:2008/07/04 19:48:14.17 serverCompleted estimating recovery log boundaries for database 'model'.
00:00000:00001:2008/07/04 19:48:14.17 serverStarted ANALYSIS pass for database 'model'.
00:00000:00001:2008/07/04 19:48:14.17 serverCompleted ANALYSIS pass for database 'model'.
00:00000:00001:2008/07/04 19:48:14.17 serverStarted REDO pass for database 'model'. The total number of log records to process is 1.
00:00000:00001:2008/07/04 19:48:14.18 serverCompleted REDO pass for database 'model'.
00:00000:00001:2008/07/04 19:48:14.18 serverRecovery of database 'model' will undo incomplete nested top actions.
00:00000:00001:2008/07/04 19:48:14.18 serverStarted recovery checkpoint for database 'model'.
00:00000:00001:2008/07/04 19:48:14.18 serverCompleted recovery checkpoint for database 'model'.
00:00000:00001:2008/07/04 19:48:14.18 serverStarted filling free space info for database 'model'.
00:00000:00001:2008/07/04 19:48:14.23 serverCompleted filling free space info for database 'model'.
00:00000:00001:2008/07/04 19:48:14.23 serverStarted cleaning up the default data cache for database 'model'.
00:00000:00001:2008/07/04 19:48:14.28 serverCompleted cleaning up the default data cache for database 'model'.
00:00000:00001:2008/07/04 19:48:14.28 serverChecking external objects.
00:00000:00001:2008/07/04 19:48:14.29 serverThe transaction log in the database 'model' will use I/O size of 4 Kb.
00:00000:00001:2008/07/04 19:48:14.32 serverDatabase 'model' is now online.
00:00000:00001:2008/07/04 19:48:14.32 serverThe logical pagesize of the server is 4 Kb.
00:00000:00001:2008/07/04 19:48:14.32 server0 dump conditions detected at boot time
00:00000:00001:2008/07/04 19:48:14.32 serverResident Node id: b488eaa4e7f5
00:00000:00001:2008/07/04 19:48:14.32 serverTransaction coordinator initialized.
00:00000:00001:2008/07/04 19:48:14.32 serverClearing temp db
00:00000:00001:2008/07/04 19:48:15.25 serverThe transaction log in the database 'tempdb' will use I/O size of 4 Kb.
00:00000:00001:2008/07/04 19:48:15.28 serverDatabase 'tempdb' is now online.
00:00000:00001:2008/07/04 19:48:15.34 serverRecovering database 'sybsystemprocs'.
00:00000:00001:2008/07/04 19:48:15.34 serverStarted estimating recovery log boundaries for database 'sybsystemprocs'.
sybase无法启动,跪求高手指点!!!
0:00000:00001:2008/07/04 19:48:15.35 serverDatabase 'sybsystemprocs', checkpoint=(18157, 25), first=(18157, 25), last=(18157, 25).00:00000:00001:2008/07/04 19:48:15.35 serverCompleted estimating recovery log boundaries for database 'sybsystemprocs'.
00:00000:00001:2008/07/04 19:48:15.35 serverStarted ANALYSIS pass for database 'sybsystemprocs'.
00:00000:00001:2008/07/04 19:48:15.35 serverCompleted ANALYSIS pass for database 'sybsystemprocs'.
00:00000:00001:2008/07/04 19:48:15.35 serverStarted REDO pass for database 'sybsystemprocs'. The total number of log records to process is 1.
00:00000:00001:2008/07/04 19:48:15.35 serverCompleted REDO pass for database 'sybsystemprocs'.
00:00000:00001:2008/07/04 19:48:15.35 serverRecovery of database 'sybsystemprocs' will undo incomplete nested top actions.
00:00000:00001:2008/07/04 19:48:15.35 serverStarted recovery checkpoint for database 'sybsystemprocs'.
00:00000:00001:2008/07/04 19:48:15.35 serverCompleted recovery checkpoint for database 'sybsystemprocs'.
00:00000:00001:2008/07/04 19:48:15.35 serverStarted filling free space info for database 'sybsystemprocs'.
00:00000:00001:2008/07/04 19:48:15.48 serverCompleted filling free space info for database 'sybsystemprocs'.
00:00000:00001:2008/07/04 19:48:15.48 serverStarted cleaning up the default data cache for database 'sybsystemprocs'.
00:00000:00001:2008/07/04 19:48:15.51 serverCompleted cleaning up the default data cache for database 'sybsystemprocs'.
00:00000:00001:2008/07/04 19:48:15.51 serverChecking external objects.
00:00000:00001:2008/07/04 19:48:15.51 serverThe transaction log in the database 'sybsystemprocs' will use I/O size of 4 Kb.
00:00000:00001:2008/07/04 19:48:15.57 serverDatabase 'sybsystemprocs' is now online.
00:00000:00013:2008/07/04 19:48:15.57 kernelConnectivity Library (Directory Control Layer) Error: Error returned by service provider.
00:00000:00013:2008/07/04 19:48:15.57 kernelConnectivity Library (Directory Control Layer) Error: (InterfacesDriver): Requested server name not found.
00:00000:00013:2008/07/04 19:48:15.57 kernelServer SYBASESERVER not registered in the interfaces file or directory services.
00:00000:00013:2008/07/04 19:48:15.57 kernelCannot start any network listeners.
00:00000:00013:2008/07/04 19:48:15.57 kernelueshutdown: exiting
跪求高手指点!!!不胜感激 kernelConnectivity Library (Directory Control Layer) Error: Error returned by service provider.
00:00000:00013:2008/07/04 19:48:15.57 kernelConnectivity Library (Directory Control Layer) Error: (InterfacesDriver): Requested server name not found.
00:00000:00013:2008/07/04 19:48:15.57 kernelServer SYBASESERVER not registered in the interfaces file or directory services.
00:00000:00013:2008/07/04 19:48:15.57 kernelCannot start any network listeners.
00:00000:00013:2008/07/04 19:48:15.57 kernelueshutdown: exiting
///////////////////////////////////
从这几句里看,楼主有没有改过服务名?
有没有改过sql.ini里的内容?
有没有通过DSEDIT修改过? 原因:SYBASESERVER not registered in the interfaces file or directory services.
页:
[1]