请帮我看看日志，sybase起来自动down

1017of

在c:sybaseASE-12_0install下用startsrv -f RUN_xxx启动ASE试试

pandu

还是不行，怎么回事啊

1017of

把RUN_xxx贴出来看看

pandu

00:00000:00000:2005/11/01 14:57:03.46 kernel  Warning: There is no valid license for ASE server product. Server is booting with all the option features disabled.
00:00000:00000:2005/11/01 14:57:03.48 kernel  Using config area from primary master device.
00:00000:00000:2005/11/01 14:57:03.48 kernel  Warning: Using default file 'c:sybase_sITDB.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2005/11/01 14:57:03.59 kernel  Kernel memory at 0x20000000, 311296 bytes
00:00000:00000:2005/11/01 14:57:03.59 kernel  Server part of first shared memory region at 0x2004C000, 42680320 bytes.
00:00000:00000:2005/11/01 14:57:03.59 kernel  Highest valid address is 0x2004C000
00:00000:00000:2005/11/01 14:57:03.59 kernel  Using 100000 file descriptors.
00:00000:00000:2005/11/01 14:57:03.60 kernel  Failed to load unicode conversion DLL libntlog.dll
00:00000:00000:2005/11/01 14:57:03.60 kernel  Adaptive Server Enterprise/12.0/P/NT (IX86)/OS 4.0/1576/32bit/OPT/Wed Nov 03 22:35:30 1999
00:00000:00000:2005/11/01 14:57:03.60 kernel  Confidential property of Sybase, Inc.
00:00000:00000:2005/11/01 14:57:03.60 kernel  Copyright 1987, 1999
00:00000:00000:2005/11/01 14:57:03.60 kernel  Sybase, Inc.  All rights reserved.
00:00000:00000:2005/11/01 14:57:03.60 kernel  Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2005/11/01 14:57:03.60 kernel  
00:00000:00000:2005/11/01 14:57:03.60 kernel  This software contains confidential and trade secret information of Sybase,
00:00000:00000:2005/11/01 14:57:03.60 kernel  Inc.   Use,  duplication or disclosure of the software and documentation by
00:00000:00000:2005/11/01 14:57:03.60 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
00:00000:00000:2005/11/01 14:57:03.60 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
00:00000:00000:2005/11/01 14:57:03.60 kernel  agreement  specifying  the  Government's rights to use the software and any
00:00000:00000:2005/11/01 14:57:03.60 kernel  applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2005/11/01 14:57:03.60 kernel  Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2005/11/01 14:57:03.60 kernel  Using 'c:sybase_sITDB.cfg' for configuration information.
00:00000:00000:2005/11/01 14:57:03.60 kernel  Logging ASE messages in file 'c:sybase_sASE-12_0installerrorlog'.
00:00000:00000:2005/11/01 14:57:03.62 kernel  Initializing MSDTC Connection
00:00000:00000:2005/11/01 14:57:21.62 kernel  MSDTC Initialization succeeded
00:00000:00000:2005/11/01 14:57:21.62 kernel  Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2005/11/01 14:57:21.62 kernel  SQL Server NT process id is 0x498.
00:00000:00000:2005/11/01 14:57:21.62 kernel  SQL Server was started from a console window.
00:00000:00000:2005/11/01 14:57:21.62 kernel  Network and device connection limit is 99992.
00:00000:00000:2005/11/01 14:57:21.64 server  Number of proc buffers allocated: 3086.
00:00000:00000:2005/11/01 14:57:21.68 server  Number of blocks left for proc headers: 3048.
00:00000:00000:2005/11/01 14:57:21.68 server  Proc header memory allocated 1524 pages for each per engine cache
00:00000:00000:2005/11/01 14:57:21.68 server   Memory allocated for the default data cache cachelet 1: 23188 Kb
00:00000:00000:2005/11/01 14:57:21.68 server  Size of the 2K memory pool: 23188 Kb
00:00000:00000:2005/11/01 14:57:21.68 kernel  Initializing virtual device 0, 'c:sybase_sdatamaster.dat' with dsync 'on'.
00:00000:00000:2005/11/01 14:57:21.68 kernel  Virtual device 0 started using asynchronous i/o.
00:00000:00000:2005/11/01 14:57:21.68 kernel  Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2005/11/01 14:57:21.68 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:2005/11/01 14:57:21.70 kernel  engine 0, os pid 584  online
00:00000:00000:2005/11/01 14:57:21.70 server  No active traceflags
00:00000:00001:2005/11/01 14:57:21.70 kernel  Component Integration Services loaded; version 'Component Integration Services/12.0/P/NT (IX86)/OS 4.0/1576/32bit/OPT/Wed Nov 03 21:14:59 1999'.
00:00000:00001:2005/11/01 14:57:21.70 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:2005/11/01 14:57:21.70 server  Opening Master Database ...
00:00000:00001:2005/11/01 14:57:21.78 server  Loading SQL Server's default sort order and character set
00:00000:00001:2005/11/01 14:57:21.78 server  Loaded default Unilib conversion handle.
00:00000:00002:2005/11/01 14:57:21.78 kernel  network name it, type ether, port 5000
00:00000:00001:2005/11/01 14:57:21.79 server  Recovering database 'master'
00:00000:00001:2005/11/01 14:57:21.82 server  Redo pass of recovery has processed 1 committed and 0 aborted transactions.
00:00000:00001:2005/11/01 14:57:21.92 server  Checking external objects.
00:00000:00001:2005/11/01 14:57:21.95 server  Database 'master' is now online.
00:00000:00001:2005/11/01 14:57:21.95 server  The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2005/11/01 14:57:21.96 server  0 dump conditions detected at boot time
00:00000:00001:2005/11/01 14:57:21.98 server  server is unnamed
00:00000:00001:2005/11/01 14:57:21.98 server  Activating disk 'sysprocsdev'.
00:00000:00001:2005/11/01 14:57:21.98 kernel  Initializing virtual device 1, 'c:sybase_sdatasybprocs.dat' with dsync 'on'.
00:00000:00001:2005/11/01 14:57:21.98 kernel  Virtual device 1 started using asynchronous i/o.
00:00000:00001:2005/11/01 14:57:22.09 server  Recovering database 'sybsystemdb'.
00:00000:00001:2005/11/01 14:57:22.10 server  Redo pass of recovery has processed 0 committed and 1 aborted transactions.
00:00000:00001:2005/11/01 14:57:22.14 server  Boot Count: 6
00:00000:00001:2005/11/01 14:57:22.17 server  Checking external objects.
00:00000:00001:2005/11/01 14:57:22.18 server  The transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2005/11/01 14:57:22.20 server  Database 'sybsystemdb' is now online.
00:00000:00001:2005/11/01 14:57:22.23 server  Recovering database 'model'.
00:00000:00001:2005/11/01 14:57:22.26 server  Checking external objects.
00:00000:00001:2005/11/01 14:57:22.29 server  The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2005/11/01 14:57:22.31 server  Database 'model' is now online.
00:00000:00001:2005/11/01 14:57:22.31 server  Resident Node id: 8db905a36aac
00:00000:00001:2005/11/01 14:57:22.31 server  Transaction coordinator initialized.
00:00000:00001:2005/11/01 14:57:22.31 server  Clearing temp db
00:00000:00001:2005/11/01 14:57:23.46 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2005/11/01 14:57:23.54 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2005/11/01 14:57:23.56 server  Database 'tempdb' is now online.
00:00000:00001:2005/11/01 14:57:23.56 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2005/11/01 14:57:23.60 server  Recovering database 'sybsystemprocs'.
00:00000:00001:2005/11/01 14:57:23.62 server  Redo pass of recovery has processed 1 committed and 0 aborted transactions.
00:00000:00001:2005/11/01 14:57:23.78 server  Checking external objects.
00:00000:00001:2005/11/01 14:57:23.81 server  The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2005/11/01 14:57:23.84 server  Database 'sybsystemprocs' is now online.
00:00000:00001:2005/11/01 14:57:23.85 server  Recovery complete.
00:00000:00001:2005/11/01 14:57:23.85 server  SQL Server's default sort order is:
00:00000:00001:2005/11/01 14:57:23.85 server          'bin_cp850' (ID = 50)
00:00000:00001:2005/11/01 14:57:23.85 server  on top of default character set:
00:00000:00001:2005/11/01 14:57:23.85 server          'cp850' (ID = 2).
00:00000:00011:2005/11/01 14:57:23.89 server  Error: 7214, Severity: 11, State: 1
00:00000:00011:2005/11/01 14:57:23.89 server  No site name received in server login packet.  Server login rejected.
00:00000:00001:2005/11/01 14:57:23.90 server  Error: 7221, Severity: 14, State: 1
00:00000:00001:2005/11/01 14:57:23.90 server  Login to site 'ITDB_XP' failed.
00:00000:00000:2005/11/01 15:05:48.26 kernel  kisignal: SQL Server terminated by window closure.
00:00000:00000:2005/11/01 15:05:48.28 kernel  ueshutdown: exiting
00:00000:00000:2005/11/01 15:05:48.28 kernel  Abnormal exit detected - SQL Server process level execution bindings will be cleared on startup.

pandu

日志执行到最后的时候，我能用isql登录，但是就是一直不动了，我关掉窗口就down了，请再帮我看看

C:sybase_sASE-12_0install>startsrv -f run_itdb.bat

C:sybase_sASE-12_0install>rem

C:sybase_sASE-12_0install>rem Adaptive Server Information:

C:sybase_sASE-12_0install>rem  name:                          ITDB

C:sybase_sASE-12_0install>rem  master device:                 c:sybase_sdat
amaster.dat

C:sybase_sASE-12_0install>rem  master device size:            51200

C:sybase_sASE-12_0install>rem  errorlog:                      c:sybase_sASE
-12_0installerrorlog

C:sybase_sASE-12_0install>rem  interfaces:                    c:sybase_sini


C:sybase_sASE-12_0install>rem

C:sybase_sASE-12_0install>c:sybase_sASE-12_0binsqlsrvr.exe -dc:sybase_s
datamaster.dat -sITDB -ec:sybase_sASE-12_0installerrorlog -ic:sybase_sini
-Mc:sybase_sASE-12_0
00:00000:00000:2005/11/02 13:54:55.79 kernel  Warning: There is no valid license
for ASE server product. Server is booting with all the option features disabled
.
00:00000:00000:2005/11/02 13:54:55.96 kernel  Using config area from primary mas
ter device.
00:00000:00000:2005/11/02 13:54:56.01 kernel  Warning: Using default file 'c:sy
base_sITDB.cfg' since a configuration file was not specified. Specify a configu
ration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2005/11/02 13:54:56.18 kernel  Kernel memory at 0x20000000, 31129
6 bytes
00:00000:00000:2005/11/02 13:54:56.20 kernel  Server part of first shared memory
region at 0x2004C000, 42680320 bytes.
00:00000:00000:2005/11/02 13:54:56.23 kernel  Highest valid address is 0x2004C00
0
00:00000:00000:2005/11/02 13:54:56.25 kernel  Using 100000 file descriptors.
00:00000:00000:2005/11/02 13:54:56.26 kernel  Failed to load unicode conversion
DLL libntlog.dll
00:00000:00000:2005/11/02 13:54:56.29 kernel  Adaptive Server Enterprise/12.0/P/
NT (IX86)/OS 4.0/1576/32bit/OPT/Wed Nov 03 22:35:30 1999
00:00000:00000:2005/11/02 13:54:56.31 kernel  Confidential property of Sybase, I
nc.
00:00000:00000:2005/11/02 13:54:56.34 kernel  Copyright 1987, 1999
00:00000:00000:2005/11/02 13:54:56.35 kernel  Sybase, Inc.  All rights reserved.

00:00000:00000:2005/11/02 13:54:56.37 kernel  Unpublished rights reserved under
U.S. copyright laws.
00:00000:00000:2005/11/02 13:54:56.40 kernel
00:00000:00000:2005/11/02 13:54:56.42 kernel  This software contains confidentia
l and trade secret information of Sybase,
00:00000:00000:2005/11/02 13:54:56.43 kernel  Inc.   Use,  duplication or disclo
sure of the software and documentation by
00:00000:00000:2005/11/02 13:54:56.46 kernel  the  U.S.  Government  is  subject
  to  restrictions set forth in a license
00:00000:00000:2005/11/02 13:54:56.50 kernel  agreement  between  the  Governmen
t  and  Sybase,  Inc.  or  other  written
00:00000:00000:2005/11/02 13:54:56.51 kernel  agreement  specifying  the  Govern
ment's rights to use the software and any
00:00000:00000:2005/11/02 13:54:56.54 kernel  applicable FAR provisions, for exa
mple, FAR 52.227-19.
00:00000:00000:2005/11/02 13:54:56.56 kernel  Sybase, Inc. 6475 Christie Avenue,
Emeryville, CA 94608, USA
00:00000:00000:2005/11/02 13:54:56.59 kernel  Using 'c:sybase_sITDB.cfg' for c
onfiguration information.
00:00000:00000:2005/11/02 13:54:56.62 kernel  Logging ASE messages in file 'c:s
ybase_sASE-12_0installerrorlog'.
00:00000:00000:2005/11/02 13:54:56.87 kernel  Initializing MSDTC Connection
00:00000:00000:2005/11/02 13:55:14.96 kernel  MSDTC Initialization succeeded
00:00000:00000:2005/11/02 13:55:14.96 kernel  Directory Control Layer (DCL) usin
g directory driver: InterfacesDriver
00:00000:00000:2005/11/02 13:55:14.98 kernel  SQL Server NT process id is 0x358.

00:00000:00000:2005/11/02 13:55:14.98 kernel  SQL Server was started from a cons
ole window.
00:00000:00000:2005/11/02 13:55:14.98 kernel  Network and device connection limi
t is 99992.
00:00000:00000:2005/11/02 13:55:15.03 server  Number of proc buffers allocated:
3086.
00:00000:00000:2005/11/02 13:55:15.14 server  Number of blocks left for proc hea
ders: 3048.
00:00000:00000:2005/11/02 13:55:15.15 server  Proc header memory allocated 1524
pages for each per engine cache
00:00000:00000:2005/11/02 13:55:15.15 server   Memory allocated for the default
data cache cachelet 1: 23188 Kb
00:00000:00000:2005/11/02 13:55:15.15 server  Size of the 2K memory pool: 23188
Kb
00:00000:00000:2005/11/02 13:55:15.15 kernel  Initializing virtual device 0, 'c:
sybase_sdatamaster.dat' with dsync 'on'.
00:00000:00000:2005/11/02 13:55:15.17 kernel  Virtual device 0 started using asy
nchronous i/o.
00:00000:00000:2005/11/02 13:55:15.17 kernel  Worker Thread Manager is not enabl
ed for use in SQL Server.
00:00000:00000:2005/11/02 13:55:15.17 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:2005/11/02 13:55:15.18 kernel  engine 0, os pid 564  online
00:00000:00000:2005/11/02 13:55:15.18 server  No active traceflags
00:00000:00001:2005/11/02 13:55:15.32 kernel  Component Integration Services loa
ded; version 'Component Integration Services/12.0/P/NT (IX86)/OS 4.0/1576/32bit/
OPT/Wed Nov 03 21:14:59 1999'.
00:00000:00001:2005/11/02 13:55:15.32 kernel  Component Integration Services: us
ing 'Sybase Client-Library/12.0/P/PC Intel/1/OPT/Mon Oct 04 15:42:12 1999'
00:00000:00001:2005/11/02 13:55:15.32 server  Opening Master Database ...
00:00000:00001:2005/11/02 13:55:15.51 server  Loading SQL Server's default sort
order and character set
00:00000:00001:2005/11/02 13:55:15.51 server  Loaded default Unilib conversion h
andle.
00:00000:00002:2005/11/02 13:55:15.51 kernel  network name it, type ether, port
5000
00:00000:00001:2005/11/02 13:55:15.56 server  Recovering database 'master'
00:00000:00001:2005/11/02 13:55:15.65 server  Redo pass of recovery has processe
d 1 committed and 0 aborted transactions.
00:00000:00001:2005/11/02 13:55:15.85 server  Checking external objects.
00:00000:00001:2005/11/02 13:55:15.96 server  Database 'master' is now online.
00:00000:00001:2005/11/02 13:55:15.96 server  The transaction log in the databas
e 'master' will use I/O size of 2 Kb.
00:00000:00001:2005/11/02 13:55:15.96 server  0 dump conditions detected at boot
time
00:00000:00001:2005/11/02 13:55:16.01 server  server is unnamed
00:00000:00001:2005/11/02 13:55:16.01 server  Activating disk 'sysprocsdev'.
00:00000:00001:2005/11/02 13:55:16.01 kernel  Initializing virtual device 1, 'c:
sybase_sdatasybprocs.dat' with dsync 'on'.
00:00000:00001:2005/11/02 13:55:16.01 kernel  Virtual device 1 started using asy
nchronous i/o.
00:00000:00001:2005/11/02 13:55:16.14 server  Recovering database 'sybsystemdb'.

00:00000:00001:2005/11/02 13:55:16.14 server  Redo pass of recovery has processe
d 0 committed and 1 aborted transactions.
00:00000:00001:2005/11/02 13:55:16.18 server  Boot Count: 7
00:00000:00001:2005/11/02 13:55:16.25 server  Checking external objects.
00:00000:00001:2005/11/02 13:55:16.25 server  The transaction log in the databas
e 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2005/11/02 13:55:16.28 server  Database 'sybsystemdb' is now onli
ne.
00:00000:00001:2005/11/02 13:55:16.29 server  Recovering database 'model'.
00:00000:00001:2005/11/02 13:55:16.34 server  Checking external objects.
00:00000:00001:2005/11/02 13:55:16.35 server  The transaction log in the databas
e 'model' will use I/O size of 2 Kb.
00:00000:00001:2005/11/02 13:55:16.37 server  Database 'model' is now online.
00:00000:00001:2005/11/02 13:55:16.37 server  Resident Node id: 8db905a36aac
00:00000:00001:2005/11/02 13:55:16.37 server  Transaction coordinator initialize
d.
00:00000:00001:2005/11/02 13:55:16.39 server  Clearing temp db
00:00000:00001:2005/11/02 13:55:17.84 server  The transaction log in the databas
e 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2005/11/02 13:55:17.92 server  The transaction log in the databas
e 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2005/11/02 13:55:17.93 server  Database 'tempdb' is now online.
00:00000:00001:2005/11/02 13:55:17.93 server  The transaction log in the databas
e 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2005/11/02 13:55:17.98 server  Recovering database 'sybsystemproc
s'.
00:00000:00001:2005/11/02 13:55:18.12 server  Checking external objects.
00:00000:00001:2005/11/02 13:55:18.15 server  The transaction log in the databas
e 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2005/11/02 13:55:18.18 server  Database 'sybsystemprocs' is now o
nline.
00:00000:00001:2005/11/02 13:55:18.18 server  Recovery complete.
00:00000:00001:2005/11/02 13:55:18.18 server  SQL Server's default sort order is
:
00:00000:00001:2005/11/02 13:55:18.18 server    'bin_cp850' (ID = 50)
00:00000:00001:2005/11/02 13:55:18.18 server  on top of default character set:
00:00000:00001:2005/11/02 13:55:18.18 server    'cp850' (ID = 2).
00:00000:00011:2005/11/02 13:55:18.34 server  Error: 7214, Severity: 11, State:
1
00:00000:00011:2005/11/02 13:55:18.34 server  No site name received in server lo
gin packet.  Server login rejected.
00:00000:00001:2005/11/02 13:55:18.35 server  Error: 7221, Severity: 14, State:
1
00:00000:00001:2005/11/02 13:55:18.35 server  Login to site 'ITDB_XP' failed.

1017of

把sql.ini中的[IT]改为[ITDB]试试

杀无赦

Error 7214
Severity 11
Message text No site name received in server login packet. Server
login rejected.
Explanation This error occurs when executing a remote procedure call (RPC) from an
Adaptive Server which has not been given a name via the sp_addserver system
procedure. The Adaptive Server name referred to here is stored in the
sysservers system table as well as in the @@servername global variable.
Action 1 Use sp_addserver to assign a name to the Adaptive Server initiating the
RPC, while using that server:
1> sp_addserver sql_server_name, local
2> go
Refer to “sp_addserver” in the Reference Manual for information about
valid Adaptive Server names.
2 Restart Adaptive Server to make the change take effect.
3 Verify that the server initiating the RPC has been given a name:
1> select @@servername
2> go

You can also check the Adaptive Server start message. The output will
show the (local) Adaptive Server initiating the RPC. If the output is
NULL, then the local server has not yet been assigned a name.
Additional information For more information, refer to:
• Server Is Unnamed.
• “Identifiers” in the Reference Manual
Version in which this
error is raised
All versions

pandu

我的sql.ini里面就时ITDB，我用select * from sysservers查询执行的结果如下，
srvid  srvstatus srvname                        srvnetname                       srvclass srvsecmech                     
------ --------- ------------------------------ -------------------------------- -------- ------------------------------
1      8         SYB_BACKUP                     ITDB_BS                          7        (null)                        
2      8         ITDB_XP                        ITDB_XP                          0        (null)                        

ITDB_XP的srvclass怎么是0 啊，我看我得另外一台服务器显示是7

还有就是我的这台机子装12。5就没有问题，装12。0就老是起不来，不知道怎么回事，请大家帮帮我了，谢谢！！！

1017of

哦，你贴出来的sql.ini好象没有ITDB啊，你的ASE server现在能起来吗？修改过系统表或者删除过server吗？
至于12.0起不来一样需要日志。
btw:问题一个一个问，一个一个解决，都缠在一起，很容易产生误会的

pandu

1、现在说的就是一个问题（我得机子上安装了12。0后，sybase启动不了）
2、至于原来的IT变成后来的ITDB是因为我又重新安装了一次试试看的
3、你告诉我的使用starserver －f run_xxx ，我试过了，启动到00:00000:00001:2005/11/02 13:55:18.35 server  Login to site 'ITDB_XP' failed. 就不动了，但是我用 isql能登录，用sybase central不能登录啊
4、我的机子以前安装过12。5是没有问题能起来的
5、我在isql里面执行select * from sysservers
结果中的ITDB_XP srvclass 的值是0
6、我现在很想知道是什么原因

谢谢！！！