在WINDOWS 2003中装SYBASE 11.92后不能启动

小凌子

各位大侠：
   公司对服务器进得升级，新购服务器只支持WINDOWS  2003 ，公司数据库是SYBASE  11.92版，安装完后，启动数据库，系统报错，提示为不能正常启动，请修改配置，
提示1067错误。
   求救。。。。

Sybase技术专家

可以查errorlog文件，ASE11.92在windows 2003没有Certified

小凌子

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技术专家

开个CMD窗口，用C:\Sybase\install\RUN_JUJUMAO启动看看

小凌子

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>rem  name:                          JUJUMAO

C:\Sybase\install>rem  master device:                 C:\Sybase\DATA\MASTER.DAT


C:\Sybase\install>rem  master device size:            30720

C:\Sybase\install>rem  errorlog:                      C:\Sybase\install\errorlog


C:\Sybase\install>rem  interfaces:                    C:\Sybase\ini

C:\Sybase\install>rem

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技术专家

从启动日志看，服务已经起来了，试试isql登录

小凌子

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

C:\Sybase\bin>

Sybase技术专家

试试isql -Usa -P -SJUJUMAO

小凌子

C:\>isql -Usa -P -SJUJUMAO
CT-LIBRARY error:
        ct_connect(): network packet layer: internal net library error: Net-Lib
protocol driver call to connect two endpoints failed

我打电话询问了一下SYBASE公司，说可能是微软认证的问题，2003在认证时没有考虑很久以的产品认证，这个问题怎么办呢？老大

chuxu

c:\sybase\ini\sql.ini贴出来

[ 本帖最后由 chuxu 于 2007-8-23 11:39 编辑 ]