标题: 在WINDOWS 2003中装SYBASE 11.92后不能启动 [打印本页] 作者: 小凌子 时间: 2007-08-22 14:25 标题: 在WINDOWS 2003中装SYBASE 11.92后不能启动 各位大侠：
公司对服务器进得升级，新购服务器只支持WINDOWS 2003 ，公司数据库是SYBASE 11.92版，安装完后，启动数据库，系统报错，提示为不能正常启动，请修改配置，
提示1067错误。
求救。。。。作者: Sybase技术专家 时间: 2007-08-22 14:39
可以查errorlog文件，ASE11.92在windows 2003没有Certified作者: 小凌子 时间: 2007-08-22 14:56 标题: 大侠：我看不懂啊，请帮忙 00:00000:00000:2007/08/22 14:06:10.59 kernel Using config area from primary master device.
00:00000:00000:2007/08/22 14:06:10.60 kernel Configuration Error: Configuration file, 'C:\Sybase\JUJUMAO.cfg', does not exist.
00:00000:00000:2007/08/22 14:06:10.62 kernel Warning: A configuration file was not specified and the default file 'C:\Sybase\JUJUMAO.cfg' does not exist. SQL Server creates the default file with the default configuration.
00:00000:00000:2007/08/22 14:06:10.67 kernel Kernel memory at 0x20000000, 200704 bytes
00:00000:00000:2007/08/22 14:06:10.67 kernel Server part of first shared memory region at 0x20031000, 28119218 bytes
00:00000:00000:2007/08/22 14:06:10.67 kernel Highest valid address is 0x20031000
00:00000:00000:2007/08/22 14:06:10.67 kernel Using 100000 file descriptors.
00:00000:00000:2007/08/22 14:06:10.68 kernel Adaptive Server Enterprise/11.9.2/1031/P/NT (IX86)/OS 3.51,4.0/FBU/Fri Aug 14 01:42:41 1998
00:00000:00000:2007/08/22 14:06:10.68 kernel Confidential property of Sybase, Inc.
00:00000:00000:2007/08/22 14:06:10.68 kernel Copyright 1987, 1998
00:00000:00000:2007/08/22 14:06:10.68 kernel Sybase, Inc. All rights reserved.
00:00000:00000:2007/08/22 14:06:10.68 kernel Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2007/08/22 14:06:10.68 kernel
00:00000:00000:2007/08/22 14:06:10.68 kernel This software contains confidential and trade secret information of Sybase,
00:00000:00000:2007/08/22 14:06:10.68 kernel Inc. Use, duplication or disclosure of the software and documentation by
00:00000:00000:2007/08/22 14:06:10.68 kernel the U.S. Government is subject to restrictions set forth in a license
00:00000:00000:2007/08/22 14:06:10.68 kernel agreement between the Government and Sybase, Inc. or other written
00:00000:00000:2007/08/22 14:06:10.68 kernel agreement specifying the Government's rights to use the software and any
00:00000:00000:2007/08/22 14:06:10.68 kernel applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2007/08/22 14:06:10.68 kernel Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2007/08/22 14:06:10.68 kernel Using 'C:\Sybase\JUJUMAO.cfg' for configuration information.
00:00000:00000:2007/08/22 14:06:10.68 kernel Logging SQL Server messages in file 'C:\Sybase\install\errorlog'.
00:00000:00000:2007/08/22 14:06:10.70 kernel Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2007/08/22 14:06:10.70 kernel SQL Server NT process id is 0x310.
00:00000:00000:2007/08/22 14:06:10.70 kernel SQL Server was started as a Service.
00:00000:00000:2007/08/22 14:06:10.70 kernel Network and device connection limit is 99992.
00:00000:00000:2007/08/22 14:06:10.71 server Number of proc buffers allocated: 1945.
00:00000:00000:2007/08/22 14:06:10.75 server Proc header memory allocated 972 pages for each per engine cache
00:00000:00000:2007/08/22 14:06:10.75 server Number of blocks left for proc headers: 1991.
00:00000:00000:2007/08/22 14:06:10.75 server Memory allocated for the default data cache cache: 14660 Kb
00:00000:00000:2007/08/22 14:06:10.75 server Size of the 2K memory pool: 14660 Kb
00:00000:00000:2007/08/22 14:06:10.75 kernel Initializing virtual device 0, 'C:\Sybase\DATA\MASTER.DAT'
00:00000:00000:2007/08/22 14:06:10.75 kernel Virtual device 0 started using asynchronous i/o.
00:00000:00000:2007/08/22 14:06:10.75 kernel Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2007/08/22 14:06:10.75 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:2007/08/22 14:06:11.21 kernel engine 0, os pid 1936 online
00:00000:00000:2007/08/22 14:06:11.21 server No active traceflags
00:00000:00001:2007/08/22 14:06:11.28 server Opening Master Database ...
00:00000:00001:2007/08/22 14:06:11.40 server Loading SQL Server's default sort order and character set
00:00000:00003:2007/08/22 14:06:11.42 kernel network name JUJUMAO, type ether, port 5000
00:00000:00001:2007/08/22 14:06:11.43 server Recovering database 'master'
00:00000:00001:2007/08/22 14:06:11.46 server Redo pass of recovery has processed 1 committed and 0 aborted transactions.
00:00000:00001:2007/08/22 14:06:11.57 server Database 'master' is now online.
00:00000:00001:2007/08/22 14:06:11.59 server The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2007/08/22 14:06:11.59 server 0 dump conditions detected at boot time
00:00000:00001:2007/08/22 14:06:11.59 server server is unnamed
00:00000:00001:2007/08/22 14:06:11.59 server Warning: The 'sysconfigures' table is not updated since the SQL Server is started with the default configuration.
00:00000:00001:2007/08/22 14:06:11.60 server Recovering database 'model'.
00:00000:00001:2007/08/22 14:06:11.64 server The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2007/08/22 14:06:11.64 server Database 'model' is now online.
00:00000:00001:2007/08/22 14:06:11.64 server Clearing temp db
00:00000:00001:2007/08/22 14:06:11.73 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2007/08/22 14:06:11.78 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2007/08/22 14:06:11.78 server Database 'tempdb' is now online.
00:00000:00001:2007/08/22 14:06:11.78 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2007/08/22 14:06:11.78 server Recovery complete.
00:00000:00001:2007/08/22 14:06:11.78 server SQL Server's default sort order is:
00:00000:00001:2007/08/22 14:06:11.78 server 'bin_cp850' (ID = 50)
00:00000:00001:2007/08/22 14:06:11.78 server on top of default character set:
00:00000:00001:2007/08/22 14:06:11.78 server 'cp850' (ID = 2).
00:00000:00001:2007/08/22 14:06:11.78 server Loaded default Unilib conversion handle.
00:00000:00001:2007/08/22 14:06:40.59 kernel Initializing virtual device 1, 'C:\Sybase\DATA\SYBPROCS.DAT'
00:00000:00001:2007/08/22 14:06:40.59 kernel Virtual device 1 started using asynchronous i/o.
00:00000:00009:2007/08/22 14:06:43.40 server Configuration file 'C:\Sybase\JUJUMAO.cfg' has been written and the previous version has been renamed to 'C:\Sybase/JUJUMAO.001'.
00:00000:00009:2007/08/22 14:06:43.43 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '0' to '1'.
00:00000:00009:2007/08/22 14:06:57.31 server Configuration file 'C:\Sybase\JUJUMAO.cfg' has been written and the previous version has been renamed to 'C:\Sybase/JUJUMAO.002'.
00:00000:00009:2007/08/22 14:06:57.31 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '1' to '0'.
00:00000:00001:2007/08/22 14:06:57.43 server Configuration file 'C:\Sybase\JUJUMAO.cfg' has been written and the previous version has been renamed to 'C:\Sybase/JUJUMAO.003'.
00:00000:00001:2007/08/22 14:06:57.43 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '0' to '1'.
00:00000:00001:2007/08/22 14:06:57.48 server Configuration file 'C:\Sybase\JUJUMAO.cfg' has been written and the previous version has been renamed to 'C:\Sybase/JUJUMAO.004'.
00:00000:00001:2007/08/22 14:06:57.48 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '1' to '0'.
00:00000:00009:2007/08/22 14:06:57.56 server Configuration file 'C:\Sybase\JUJUMAO.cfg' has been written and the previous version has been renamed to 'C:\Sybase/JUJUMAO.005'.
00:00000:00009:2007/08/22 14:06:57.56 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '0' to '1'.
00:00000:00009:2007/08/22 14:06:57.60 server Configuration file 'C:\Sybase\JUJUMAO.cfg' has been written and the previous version has been renamed to 'C:\Sybase/JUJUMAO.006'.
00:00000:00009:2007/08/22 14:06:57.60 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '1' to '0'.
00:00000:00001:2007/08/22 14:06:57.71 server Configuration file 'C:\Sybase\JUJUMAO.cfg' has been written and the previous version has been renamed to 'C:\Sybase/JUJUMAO.007'.
00:00000:00001:2007/08/22 14:06:57.71 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '0' to '1'.
00:00000:00001:2007/08/22 14:06:57.76 server Configuration file 'C:\Sybase\JUJUMAO.cfg' has been written and the previous version has been renamed to 'C:\Sybase/JUJUMAO.008'.
00:00000:00001:2007/08/22 14:06:57.76 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '1' to '0'.
00:00000:00009:2007/08/22 14:06:58.54 server Configuration file 'C:\Sybase\JUJUMAO.cfg' has been written and the previous version has been renamed to 'C:\Sybase/JUJUMAO.009'.
00:00000:00009:2007/08/22 14:06:58.54 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '0' to '1'.
00:00000:00009:2007/08/22 14:06:58.60 server Configuration file 'C:\Sybase\JUJUMAO.cfg' has been written and the previous version has been renamed to 'C:\Sybase/JUJUMAO.010'.
00:00000:00009:2007/08/22 14:06:58.60 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '1' to '0'.
00:00000:00001:2007/08/22 14:06:58.65 server Configuration file 'C:\Sybase\JUJUMAO.cfg' has been written and the previous version has been renamed to 'C:\Sybase/JUJUMAO.011'.
00:00000:00001:2007/08/22 14:06:58.65 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '0' to '1'.
00:00000:00001:2007/08/22 14:06:58.70 server Configuration file 'C:\Sybase\JUJUMAO.cfg' has been written and the previous version has been renamed to 'C:\Sybase/JUJUMAO.012'.
00:00000:00001:2007/08/22 14:06:58.70 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '1' to '0'.
00:00000:00009:2007/08/22 14:06:58.89 server SQL Server shutdown by request.
00:00000:00009:2007/08/22 14:06:58.89 kernel ueshutdown: exiting
00:00000:00009:2007/08/22 14:06:58.89 kernel XP Server is not running.作者: Sybase技术专家 时间: 2007-08-22 15:05
开个CMD窗口，用C:\Sybase\install\RUN_JUJUMAO启动看看作者: 小凌子 时间: 2007-08-22 15:23 标题: 还是不行，运行结果如下，帮忙看看，谢谢 Microsoft Windows [版本 5.2.3790]
(C) 版权所有 1985-2003 Microsoft Corp.
C:\Documents and Settings\Administrator>cd..
C:\Documents and Settings>cd..
C:\>cd sybase
C:\Sybase>cd install
C:\Sybase\install>run_jujumao
C:\Sybase\install>rem
C:\Sybase\install>rem Adaptive Server Information:
C:\Sybase\install>C:\Sybase\bin\sqlsrvr.exe -dC:\Sybase\DATA\MASTER.DAT -sJUJUMA
O -eC:\Sybase\install\errorlog -iC:\Sybase\ini -MC:\Sybase
00:00000:00000:2007/08/22 15:16:46.89 kernel Using config area from primary mas
ter device.
00:00000:00000:2007/08/22 15:16:46.90 kernel Warning: Using default file 'C:\Sy
base\JUJUMAO.cfg' since a configuration file was not specified. Specify a config
uration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2007/08/22 15:16:46.96 kernel Kernel memory at 0x20000000, 20070
4 bytes
00:00000:00000:2007/08/22 15:16:46.98 kernel Server part of first shared memory
region at 0x20031000, 28119218 bytes
00:00000:00000:2007/08/22 15:16:46.98 kernel Highest valid address is 0x2003100
0
00:00000:00000:2007/08/22 15:16:46.98 kernel Using 100000 file descriptors.
00:00000:00000:2007/08/22 15:16:47.00 kernel Adaptive Server Enterprise/11.9.2/
1031/P/NT (IX86)/OS 3.51,4.0/FBU/Fri Aug 14 01:42:41 1998
00:00000:00000:2007/08/22 15:16:47.00 kernel Confidential property of Sybase, I
nc.
00:00000:00000:2007/08/22 15:16:47.00 kernel Copyright 1987, 1998
00:00000:00000:2007/08/22 15:16:47.00 kernel Sybase, Inc. All rights reserved.
00:00000:00000:2007/08/22 15:16:47.00 kernel Unpublished rights reserved under
U.S. copyright laws.
00:00000:00000:2007/08/22 15:16:47.01 kernel
00:00000:00000:2007/08/22 15:16:47.01 kernel This software contains confidentia
l and trade secret information of Sybase,
00:00000:00000:2007/08/22 15:16:47.01 kernel Inc. Use, duplication or disclo
sure of the software and documentation by
00:00000:00000:2007/08/22 15:16:47.01 kernel the U.S. Government is subject
to restrictions set forth in a license
00:00000:00000:2007/08/22 15:16:47.01 kernel agreement between the Governmen
t and Sybase, Inc. or other written
00:00000:00000:2007/08/22 15:16:47.01 kernel agreement specifying the Govern
ment's rights to use the software and any
00:00000:00000:2007/08/22 15:16:47.01 kernel applicable FAR provisions, for exa
mple, FAR 52.227-19.
00:00000:00000:2007/08/22 15:16:47.01 kernel Sybase, Inc. 6475 Christie Avenue,
Emeryville, CA 94608, USA
00:00000:00000:2007/08/22 15:16:47.03 kernel Using 'C:\Sybase\JUJUMAO.cfg' for
configuration information.
00:00000:00000:2007/08/22 15:16:47.03 kernel Logging SQL Server messages in fil
e 'C:\Sybase\install\errorlog'.
00:00000:00000:2007/08/22 15:16:47.20 kernel Directory Control Layer (DCL) usin
g directory driver: InterfacesDriver
00:00000:00000:2007/08/22 15:16:47.21 kernel SQL Server NT process id is 0x21c.
00:00000:00000:2007/08/22 15:16:47.21 kernel SQL Server was started from a cons
ole window.
00:00000:00000:2007/08/22 15:16:47.23 kernel Network and device connection limi
t is 99992.
00:00000:00000:2007/08/22 15:16:47.26 server Number of proc buffers allocated:
1945.
00:00000:00000:2007/08/22 15:16:47.29 server Proc header memory allocated 972 p
ages for each per engine cache
00:00000:00000:2007/08/22 15:16:47.29 server Number of blocks left for proc hea
ders: 1991.
00:00000:00000:2007/08/22 15:16:47.31 server Memory allocated for the default d
ata cache cache: 14660 Kb
00:00000:00000:2007/08/22 15:16:47.31 server Size of the 2K memory pool: 14660
Kb
00:00000:00000:2007/08/22 15:16:47.31 kernel Initializing virtual device 0, 'C:
\Sybase\DATA\MASTER.DAT'
00:00000:00000:2007/08/22 15:16:47.31 kernel Virtual device 0 started using asy
nchronous i/o.
00:00000:00000:2007/08/22 15:16:47.31 kernel Worker Thread Manager is not enabl
ed for use in SQL Server.
00:00000:00000:2007/08/22 15:16:47.31 kernel Either the config parameter 'use s
ecurity 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:2007/08/22 15:16:47.34 kernel engine 0, os pid 1932 online
00:00000:00000:2007/08/22 15:16:47.34 server No active traceflags
00:00000:00001:2007/08/22 15:16:47.40 server Opening Master Database ...
00:00000:00001:2007/08/22 15:16:47.48 server Loading SQL Server's default sort
order and character set
00:00000:00003:2007/08/22 15:16:47.50 kernel network name JUJUMAO, type ether,
port 5000
00:00000:00001:2007/08/22 15:16:47.51 server Recovering database 'master'
00:00000:00001:2007/08/22 15:16:47.65 server Database 'master' is now online.
00:00000:00001:2007/08/22 15:16:47.65 server The transaction log in the databas
e 'master' will use I/O size of 2 Kb.
00:00000:00001:2007/08/22 15:16:47.65 server 0 dump conditions detected at boot
time
00:00000:00001:2007/08/22 15:16:47.67 server server is unnamed
00:00000:00001:2007/08/22 15:16:47.67 server Activating disk 'sysprocsdev'.
00:00000:00001:2007/08/22 15:16:47.67 kernel Initializing virtual device 1, 'C:
\Sybase\DATA\SYBPROCS.DAT'
00:00000:00001:2007/08/22 15:16:47.68 kernel Virtual device 1 started using asy
nchronous i/o.
00:00000:00001:2007/08/22 15:16:47.78 server Recovering database 'model'.
00:00000:00001:2007/08/22 15:16:47.78 server The transaction log in the databas
e 'model' will use I/O size of 2 Kb.
00:00000:00001:2007/08/22 15:16:47.78 server Database 'model' is now online.
00:00000:00001:2007/08/22 15:16:47.79 server Clearing temp db
00:00000:00001:2007/08/22 15:16:47.85 server The transaction log in the databas
e 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2007/08/22 15:16:47.87 server The transaction log in the databas
e 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2007/08/22 15:16:47.87 server Database 'tempdb' is now online.
00:00000:00001:2007/08/22 15:16:47.87 server The transaction log in the databas
e 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2007/08/22 15:16:47.95 server Recovering database 'sybsystemproc
s'.
00:00000:00001:2007/08/22 15:16:47.98 server The transaction log in the databas
e 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2007/08/22 15:16:48.00 server Database 'sybsystemprocs' is now o
nline.
00:00000:00001:2007/08/22 15:16:48.00 server Recovery complete.
00:00000:00001:2007/08/22 15:16:48.00 server SQL Server's default sort order is
:
00:00000:00001:2007/08/22 15:16:48.00 server 'bin_cp850' (ID = 50)
00:00000:00001:2007/08/22 15:16:48.00 server on top of default character set:
00:00000:00001:2007/08/22 15:16:48.00 server 'cp850' (ID = 2).
00:00000:00001:2007/08/22 15:16:48.00 server Loaded default Unilib conversion h
andle.作者: Sybase技术专家 时间: 2007-08-22 15:30
从启动日志看，服务已经起来了，试试isql登录作者: 小凌子 时间: 2007-08-22 15:48 标题: 大侠： 不行还是报错，怎么回事？ C:\Sybase\bin>isql -Usa
Password:
CT-LIBRARY error:
ct_connect(): network packet layer: internal net library error: Net-Lib
protocol driver call to connect two endpoints failed