sybase12, 在windows2003上服务启动不了
我在服务里面启动以后就报1067的错误。。。。小弟我也是刚接触sybase数据库。
下面是日志信息：
00:00000:00000:2010/11/19 11:23:17.89 kernel Initializing MSDTC Connection
00:00000:00000:2010/11/19 11:23:19.01 kernel MSDTC Initialization succeeded
00:00000:00000:2010/11/19 11:23:19.01 kernel Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2010/11/19 11:23:19.01 kernel SQL Server NT process id is 0x1fa4.
00:00000:00000:2010/11/19 11:23:19.01 kernel SQL Server was started from a console window.
00:00000:00000:2010/11/19 11:23:19.01 kernel Network and device connection limit is 99992.
00:00000:00000:2010/11/19 11:23:19.01 server Number of proc buffers allocated: 3086.
00:00000:00000:2010/11/19 11:23:19.01 server Number of blocks left for proc headers: 3048.
00:00000:00000:2010/11/19 11:23:19.01 server Proc header memory allocated 1524 pages for each per engine cache
00:00000:00000:2010/11/19 11:23:19.01 server Memory allocated for the default data cache cachelet 1: 23188 Kb
00:00000:00000:2010/11/19 11:23:19.01 server Size of the 2K memory pool: 23188 Kb
00:00000:00000:2010/11/19 11:23:19.01 kernel Initializing virtual device 0, 'F:\keyi\sybase\data\master.dat' with dsync 'on'.
00:00000:00000:2010/11/19 11:23:19.01 kernel Virtual device 0 started using asynchronous i/o.
00:00000:00000:2010/11/19 11:23:19.01 kernel Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2010/11/19 11:23:19.01 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:2010/11/19 11:23:19.03 kernel engine 0, os pid 1860 online
00:00000:00000:2010/11/19 11:23:19.03 server No active traceflags
00:00000:00001:2010/11/19 11:23:19.03 kernel Component Integration Services loaded; version 'Component Integration Services/12.0/P/SWR 8776 ESD 1/NT (IX86)/OS 4.0/1580/32bit/OPT/Mon Dec 06 20:31:23 1999'.
00:00000:00001:2010/11/19 11:23:19.03 kernel Component Integration Services: using 'Sybase Client-Library/12.0/P/PC Intel/1/OPT/Mon Oct 04 15:42:12 1999'
00:00000:00001:2010/11/19 11:23:19.03 server Opening Master Database ...
00:00000:00001:2010/11/19 11:23:19.17 server Loading SQL Server's default sort order and character set
00:00000:00001:2010/11/19 11:23:19.17 server Loaded default Unilib conversion handle.
00:00000:00002:2010/11/19 11:23:19.17 kernel network name vstaroa, type ether, port 5000
00:00000:00001:2010/11/19 11:23:19.20 server Recovering database 'master'
00:00000:00001:2010/11/19 11:23:19.23 server Redo pass of recovery has processed 1 committed and 0 aborted transactions.
00:00000:00001:2010/11/19 11:23:19.34 server Checking external objects.
00:00000:00001:2010/11/19 11:23:19.35 server Database 'master' is now online.
00:00000:00001:2010/11/19 11:23:19.35 server The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2010/11/19 11:23:19.35 server This installation was created using a 12.0 or later version of bldmastr.
00:00000:00001:2010/11/19 11:23:19.35 server 0 dump conditions detected at boot time
00:00000:00001:2010/11/19 11:23:19.35 server server is unnamed
00:00000:00001:2010/11/19 11:23:19.37 server Activating disk 'sysprocsdev'.
00:00000:00001:2010/11/19 11:23:19.37 kernel Initializing virtual device 1, 'F:\keyi\sybase\data\sybprocs.dat' with dsync 'on'.
00:00000:00001:2010/11/19 11:23:19.37 kernel Virtual device 1 started using asynchronous i/o.
00:00000:00001:2010/11/19 11:23:19.46 server Recovering database 'sybsystemdb'.
00:00000:00001:2010/11/19 11:23:19.46 server Redo pass of recovery has processed 0 committed and 1 aborted transactions.
00:00000:00001:2010/11/19 11:23:19.56 server Boot Count: 11
00:00000:00001:2010/11/19 11:23:19.59 server Checking external objects.
00:00000:00001:2010/11/19 11:23:19.59 server The transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2010/11/19 11:23:19.62 server Database 'sybsystemdb' is now online.
00:00000:00001:2010/11/19 11:23:19.65 server Recovering database 'model'.
00:00000:00001:2010/11/19 11:23:19.71 server Checking external objects.
00:00000:00001:2010/11/19 11:23:19.71 server The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2010/11/19 11:23:19.75 server Database 'model' is now online.
00:00000:00001:2010/11/19 11:23:19.75 server Resident Node id: b0a0d24105cb
00:00000:00001:2010/11/19 11:23:19.75 server Transaction coordinator initialized.
00:00000:00001:2010/11/19 11:23:19.75 server Clearing temp db
00:00000:00001:2010/11/19 11:23:21.07 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2010/11/19 11:23:21.12 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2010/11/19 11:23:21.15 server Database 'tempdb' is now online.
00:00000:00001:2010/11/19 11:23:21.17 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2010/11/19 11:23:21.21 server Recovering database 'sybsystemprocs'.
00:00000:00001:2010/11/19 11:23:21.37 server Checking external objects.
00:00000:00001:2010/11/19 11:23:21.37 server The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2010/11/19 11:23:21.40 server Database 'sybsystemprocs' is now online.
00:00000:00001:2010/11/19 11:23:21.42 server Recovery complete.
00:00000:00001:2010/11/19 11:23:21.42 server SQL Server's default sort order is:
00:00000:00001:2010/11/19 11:23:21.42 server 'bin_iso_1' (ID = 50)
00:00000:00001:2010/11/19 11:23:21.42 server on top of default character set:
00:00000:00001:2010/11/19 11:23:21.42 server 'iso_1' (ID = 1).
00:00000:00000:2010/11/19 11:23:34.96 kernel kisignal: SQL Server terminated by window closure.
00:00000:00000:2010/11/19 11:23:34.96 kernel ueshutdown: exiting
00:00000:00000:2010/11/19 11:23:34.96 kernel Abnormal exit detected - SQL Server process level execution bindings will be cleared on startup.
下面是日志信息：
00:00000:00000:2010/11/19 11:23:17.89 kernel Initializing MSDTC Connection
00:00000:00000:2010/11/19 11:23:19.01 kernel MSDTC Initialization succeeded
00:00000:00000:2010/11/19 11:23:19.01 kernel Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2010/11/19 11:23:19.01 kernel SQL Server NT process id is 0x1fa4.
00:00000:00000:2010/11/19 11:23:19.01 kernel SQL Server was started from a console window.
00:00000:00000:2010/11/19 11:23:19.01 kernel Network and device connection limit is 99992.
00:00000:00000:2010/11/19 11:23:19.01 server Number of proc buffers allocated: 3086.
00:00000:00000:2010/11/19 11:23:19.01 server Number of blocks left for proc headers: 3048.
00:00000:00000:2010/11/19 11:23:19.01 server Proc header memory allocated 1524 pages for each per engine cache
00:00000:00000:2010/11/19 11:23:19.01 server Memory allocated for the default data cache cachelet 1: 23188 Kb
00:00000:00000:2010/11/19 11:23:19.01 server Size of the 2K memory pool: 23188 Kb
00:00000:00000:2010/11/19 11:23:19.01 kernel Initializing virtual device 0, 'F:\keyi\sybase\data\master.dat' with dsync 'on'.
00:00000:00000:2010/11/19 11:23:19.01 kernel Virtual device 0 started using asynchronous i/o.
00:00000:00000:2010/11/19 11:23:19.01 kernel Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2010/11/19 11:23:19.01 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:2010/11/19 11:23:19.03 kernel engine 0, os pid 1860 online
00:00000:00000:2010/11/19 11:23:19.03 server No active traceflags
00:00000:00001:2010/11/19 11:23:19.03 kernel Component Integration Services loaded; version 'Component Integration Services/12.0/P/SWR 8776 ESD 1/NT (IX86)/OS 4.0/1580/32bit/OPT/Mon Dec 06 20:31:23 1999'.
00:00000:00001:2010/11/19 11:23:19.03 kernel Component Integration Services: using 'Sybase Client-Library/12.0/P/PC Intel/1/OPT/Mon Oct 04 15:42:12 1999'
00:00000:00001:2010/11/19 11:23:19.03 server Opening Master Database ...
00:00000:00001:2010/11/19 11:23:19.17 server Loading SQL Server's default sort order and character set
00:00000:00001:2010/11/19 11:23:19.17 server Loaded default Unilib conversion handle.
00:00000:00002:2010/11/19 11:23:19.17 kernel network name vstaroa, type ether, port 5000
00:00000:00001:2010/11/19 11:23:19.20 server Recovering database 'master'
00:00000:00001:2010/11/19 11:23:19.23 server Redo pass of recovery has processed 1 committed and 0 aborted transactions.
00:00000:00001:2010/11/19 11:23:19.34 server Checking external objects.
00:00000:00001:2010/11/19 11:23:19.35 server Database 'master' is now online.
00:00000:00001:2010/11/19 11:23:19.35 server The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2010/11/19 11:23:19.35 server This installation was created using a 12.0 or later version of bldmastr.
00:00000:00001:2010/11/19 11:23:19.35 server 0 dump conditions detected at boot time
00:00000:00001:2010/11/19 11:23:19.35 server server is unnamed
00:00000:00001:2010/11/19 11:23:19.37 server Activating disk 'sysprocsdev'.
00:00000:00001:2010/11/19 11:23:19.37 kernel Initializing virtual device 1, 'F:\keyi\sybase\data\sybprocs.dat' with dsync 'on'.
00:00000:00001:2010/11/19 11:23:19.37 kernel Virtual device 1 started using asynchronous i/o.
00:00000:00001:2010/11/19 11:23:19.46 server Recovering database 'sybsystemdb'.
00:00000:00001:2010/11/19 11:23:19.46 server Redo pass of recovery has processed 0 committed and 1 aborted transactions.
00:00000:00001:2010/11/19 11:23:19.56 server Boot Count: 11
00:00000:00001:2010/11/19 11:23:19.59 server Checking external objects.
00:00000:00001:2010/11/19 11:23:19.59 server The transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2010/11/19 11:23:19.62 server Database 'sybsystemdb' is now online.
00:00000:00001:2010/11/19 11:23:19.65 server Recovering database 'model'.
00:00000:00001:2010/11/19 11:23:19.71 server Checking external objects.
00:00000:00001:2010/11/19 11:23:19.71 server The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2010/11/19 11:23:19.75 server Database 'model' is now online.
00:00000:00001:2010/11/19 11:23:19.75 server Resident Node id: b0a0d24105cb
00:00000:00001:2010/11/19 11:23:19.75 server Transaction coordinator initialized.
00:00000:00001:2010/11/19 11:23:19.75 server Clearing temp db
00:00000:00001:2010/11/19 11:23:21.07 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2010/11/19 11:23:21.12 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2010/11/19 11:23:21.15 server Database 'tempdb' is now online.
00:00000:00001:2010/11/19 11:23:21.17 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2010/11/19 11:23:21.21 server Recovering database 'sybsystemprocs'.
00:00000:00001:2010/11/19 11:23:21.37 server Checking external objects.
00:00000:00001:2010/11/19 11:23:21.37 server The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2010/11/19 11:23:21.40 server Database 'sybsystemprocs' is now online.
00:00000:00001:2010/11/19 11:23:21.42 server Recovery complete.
00:00000:00001:2010/11/19 11:23:21.42 server SQL Server's default sort order is:
00:00000:00001:2010/11/19 11:23:21.42 server 'bin_iso_1' (ID = 50)
00:00000:00001:2010/11/19 11:23:21.42 server on top of default character set:
00:00000:00001:2010/11/19 11:23:21.42 server 'iso_1' (ID = 1).
00:00000:00000:2010/11/19 11:23:34.96 kernel kisignal: SQL Server terminated by window closure.
00:00000:00000:2010/11/19 11:23:34.96 kernel ueshutdown: exiting
00:00000:00000:2010/11/19 11:23:34.96 kernel Abnormal exit detected - SQL Server process level execution bindings will be cleared on startup.
作者: teddylw1611616 发布时间: 2011-04-06
是这样的，要12.5 11449EBF以后的才可以。
如果非要这么用，可以直接运行BAT来启动服务，就是有个黑框
如果非要这么用，可以直接运行BAT来启动服务，就是有个黑框
作者: willyomg 发布时间: 2011-04-06