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

chenqian_4

有没有改过默认的设置。以前装linux3.0+sybase12.5.2遇到过，当时是default data cache配高了，会自动down的。

1017of

呵呵，表激动
用startsrv -f RUNxxx方式启动，启动完毕后，系统不会自动退回提示符状态下，如果你关闭启动窗口，会导致server也同时关闭。如果你可以使用isql登录，至少ASE server和isql所用客户端是正常的，至于sybase central不行，恐怕需要检查sybase central想对应的客户端是否配置正确或者需要明确sybase central有什么返回信息或者其状态如何。只说不能无法判断，对吗？此外，不知你在配置server过程中是否配置了XP server，把XP_server在sql.ini的端口号更改一下试试，看有没有问题。
根据sybase手册，sysservers中srvclass列值为0代表Local Server，为7代表ASEnterprise class server，我不知道具体有什么区别。我只记得一般情况下本地ASEserver的srvclass应该是0，但从你的sysservers中看不到你的本地ASE server，不知道你是否对相关部分做过直接或者间接的修改。
其实能用问题应该不大。

pandu

把XP_server在sql.ini的端口号更改一下试试

我试过了，还是不行，客户端可以连到其他机子上的sybase服务端

郁闷的不行

1017of

如果不行，请继续返回出错信息；你所说的客户端是指isql还是openclient呢？此外，你说的不行是指什么不行，最好能将相关的信息返回。
btw:出错了不可怕，有时候需要一点耐心，问题只靠发牢骚和郁闷是解决不了的。经验不就是在一点一滴中积累的吗？

pandu

1、默认安装SYBASE12.0 服务器端
2、使用\sybase_s\ASE-12_0\bin\syconfig.exe配置名称为IT的adaptive server
3、配置过程中network addresses 为 tcp winsock tcp/ip net-libray driver 192.168.11.11，5000
   configure default XP server network addresses 为 tcp winsock tcp/ip net-libray driver 192.168.11.11，5000
   然后其他的为默认
4、默认安装SYBASE12.0 客户端
5、配置dsedit 使其的配置和服务端相符
6、在win2000中的服务中设置sybase sql server为自动启动
7、重新启动计算机

sql.ini如下
[IT_BS]
$BASE$00=NLMSNMP,\pipe\sybase\backup
$BASE$01=NLWNSCK,it,5001
MASTER=$BASE$00;$BASE$01;
$BASE$02=NLMSNMP,\pipe\sybase\backup
$BASE$03=NLWNSCK,it,5001
QUERY=$BASE$02;$BASE$03;
[IT_MS]
$BASE$00=NLMSNMP,\pipe\sybase\monitor
$BASE$01=NLWNSCK,it,5002
MASTER=$BASE$00;$BASE$01;
$BASE$02=NLMSNMP,\pipe\sybase\monitor
$BASE$03=NLWNSCK,it,5002
QUERY=$BASE$02;$BASE$03;
[IT]
MASTER=NLWNSCK,it,5000
QUERY=NLWNSCK,it,5000
[IT_XP]
MASTER=NLWNSCK,it,5003
QUERY=NLWNSCK,it,5003

errorlog如下
00:00000:00000:2005/11/03 16:07:43.21 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/03 16:07:43.35 kernel  Using config area from primary master device.
00:00000:00000:2005/11/03 16:07:43.39 kernel  Warning: Using default file 'c:\sybase_s\IT.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/03 16:07:43.65 kernel  Kernel memory at 0x20000000, 313344 bytes
00:00000:00000:2005/11/03 16:07:43.65 kernel  Server part of first shared memory region at 0x2004C800, 101038080 bytes.
00:00000:00000:2005/11/03 16:07:43.67 kernel  Highest valid address is 0x2004C800
00:00000:00000:2005/11/03 16:07:43.67 kernel  Using 100000 file descriptors.
00:00000:00000:2005/11/03 16:07:43.67 kernel  Failed to load unicode conversion DLL libntlog.dll
00:00000:00000:2005/11/03 16:07:43.67 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/03 16:07:43.67 kernel  Confidential property of Sybase, Inc.
00:00000:00000:2005/11/03 16:07:43.67 kernel  Copyright 1987, 1999
00:00000:00000:2005/11/03 16:07:43.67 kernel  Sybase, Inc.  All rights reserved.
00:00000:00000:2005/11/03 16:07:43.67 kernel  Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2005/11/03 16:07:43.67 kernel  
00:00000:00000:2005/11/03 16:07:43.67 kernel  This software contains confidential and trade secret information of Sybase,
00:00000:00000:2005/11/03 16:07:43.67 kernel  Inc.   Use,  duplication or disclosure of the software and documentation by
00:00000:00000:2005/11/03 16:07:43.67 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
00:00000:00000:2005/11/03 16:07:43.67 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
00:00000:00000:2005/11/03 16:07:43.68 kernel  agreement  specifying  the  Government's rights to use the software and any
00:00000:00000:2005/11/03 16:07:43.71 kernel  applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2005/11/03 16:07:43.73 kernel  Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2005/11/03 16:07:43.76 kernel  Using 'c:\sybase_s\IT.cfg' for configuration information.
00:00000:00000:2005/11/03 16:07:43.78 kernel  Logging ASE messages in file 'c:\sybase_s\ASE-12_0\install\errorlog'.
00:00000:00000:2005/11/03 16:07:43.84 kernel  Initializing MSDTC Connection
00:00000:00000:2005/11/03 16:08:01.85 kernel  MSDTC Initialization succeeded
00:00000:00000:2005/11/03 16:08:06.73 kernel  Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2005/11/03 16:08:06.75 kernel  SQL Server NT process id is 0x62c.
00:00000:00000:2005/11/03 16:08:06.75 kernel  SQL Server was started from a console window.
00:00000:00000:2005/11/03 16:08:06.75 kernel  Network and device connection limit is 99992.
00:00000:00000:2005/11/03 16:08:06.79 server  Number of proc buffers allocated: 8735.
00:00000:00000:2005/11/03 16:08:06.96 server  Number of blocks left for proc headers: 8696.
00:00000:00000:2005/11/03 16:08:07.00 server  Proc header memory allocated 4348 pages for each per engine cache
00:00000:00000:2005/11/03 16:08:07.00 server   Memory allocated for the default data cache cachelet 1: 65534 Kb
00:00000:00000:2005/11/03 16:08:07.03 server  Size of the 2K memory pool: 65534 Kb
00:00000:00000:2005/11/03 16:08:07.04 kernel  Initializing virtual device 0, 'c:\sybase_s\data\master.dat' with dsync 'on'.
00:00000:00000:2005/11/03 16:08:07.07 kernel  Virtual device 0 started using asynchronous i/o.
00:00000:00000:2005/11/03 16:08:07.09 kernel  Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2005/11/03 16:08:07.10 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/03 16:08:07.15 kernel  engine 0, os pid 464  online
00:00000:00000:2005/11/03 16:08:07.17 server  No active traceflags
00:00000:00001:2005/11/03 16:08:07.29 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/03 16:08:07.32 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/03 16:08:07.34 server  Opening Master Database ...
00:00000:00001:2005/11/03 16:08:07.54 server  Loading SQL Server's default sort order and character set
00:00000:00001:2005/11/03 16:08:07.56 server  Loaded default Unilib conversion handle.
00:00000:00002:2005/11/03 16:08:07.57 kernel  network name it, type ether, port 5000
00:00000:00001:2005/11/03 16:08:07.62 server  Recovering database 'master'
00:00000:00001:2005/11/03 16:08:07.82 server  Checking external objects.
00:00000:00001:2005/11/03 16:08:07.92 server  Database 'master' is now online.
00:00000:00001:2005/11/03 16:08:07.93 server  The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2005/11/03 16:08:07.95 server  0 dump conditions detected at boot time
00:00000:00001:2005/11/03 16:08:08.01 server  server is unnamed
00:00000:00001:2005/11/03 16:08:08.03 server  Activating disk 'sysprocsdev'.
00:00000:00001:2005/11/03 16:08:08.03 kernel  Initializing virtual device 1, 'c:\sybase_s\data\sybprocs.dat' with dsync 'on'.
00:00000:00001:2005/11/03 16:08:08.06 kernel  Virtual device 1 started using asynchronous i/o.
00:00000:00001:2005/11/03 16:08:08.18 server  Recovering database 'sybsystemdb'.
00:00000:00001:2005/11/03 16:08:08.23 server  Boot Count: 5
00:00000:00001:2005/11/03 16:08:08.26 server  Checking external objects.
00:00000:00001:2005/11/03 16:08:08.28 server  The transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2005/11/03 16:08:08.29 server  Database 'sybsystemdb' is now online.
00:00000:00001:2005/11/03 16:08:08.34 server  Recovering database 'model'.
00:00000:00001:2005/11/03 16:08:08.37 server  Checking external objects.
00:00000:00001:2005/11/03 16:08:08.39 server  The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2005/11/03 16:08:08.40 server  Database 'model' is now online.
00:00000:00001:2005/11/03 16:08:08.40 server  Resident Node id: c6c647ba5de2
00:00000:00001:2005/11/03 16:08:08.42 server  Transaction coordinator initialized.
00:00000:00001:2005/11/03 16:08:08.43 server  Clearing temp db
00:00000:00001:2005/11/03 16:08:09.78 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2005/11/03 16:08:09.87 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2005/11/03 16:08:09.90 server  Database 'tempdb' is now online.
00:00000:00001:2005/11/03 16:08:09.90 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2005/11/03 16:08:09.98 server  Recovering database 'sybsystemprocs'.
00:00000:00001:2005/11/03 16:08:10.04 server  Checking external objects.
00:00000:00001:2005/11/03 16:08:10.07 server  The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2005/11/03 16:08:10.12 server  Database 'sybsystemprocs' is now online.
00:00000:00001:2005/11/03 16:08:10.15 server  Recovery complete.
00:00000:00001:2005/11/03 16:08:10.15 server  SQL Server's default sort order is:
00:00000:00001:2005/11/03 16:08:10.17 server          'bin_cp850' (ID = 50)
00:00000:00001:2005/11/03 16:08:10.18 server  on top of default character set:
00:00000:00001:2005/11/03 16:08:10.18 server          'cp850' (ID = 2).
00:00000:00000:2005/11/03 16:12:27.10 kernel  kisignal: SQL Server terminated by window closure.
00:00000:00000:2005/11/03 16:12:27.12 kernel  ueshutdown: exiting
00:00000:00000:2005/11/03 16:12:27.12 kernel  Abnormal exit detected - SQL Server process level execution bindings will be cleared on startup.

另外使用 startserver －f run_xxx 启动后，从cmd下使用 isql －Usa -SIT －P 能够登录，请再帮我看看，谢谢！！！

我用同样的方法在另外的机子上安装是正常的，这台机子上我装过12。5也没有问题。
谢谢！！！

[ 本帖最后由 pandu 于 2005-11-3 18:04 编辑 ]

1017of

看不到有问题啊，除了这个00:00000:00000:2005/11/03 16:12:27.10 kernel  kisignal: SQL Server terminated by window closure.
使用的时候有什么问题呢？

flybean

从日志上看ASE是没有问题的。

pandu

sybase起不来啊，从sybase central 里面也启动不了啊
只能用执行sqlsrvr.exe，或者用startserver －f run_xxx 才能启动

变形金刚

配置过程中network addresses 为 tcp winsock tcp/ip net-libray driver 192.168.11.11，5000
   configure default XP server network addresses 为 tcp winsock tcp/ip net-libray driver 192.168.11.11，5000
   这两个端口不能都用5000,  XP SERVER 的端口地址改为其他的看看.

c001100c

配置过程中network addresses 为 tcp winsock tcp/ip net-libray driver 192.168.11.11，5000
   configure default XP server network addresses 为 tcp winsock tcp/ip net-libray driver 192.168.11.11，5000
   这两个端口不能都用5000,  XP SERVER 的端口地址改为5003或别的
也可以不加IP使用机器名。如果有可能你把你系统重做一下。我遇到过加IP配置不成功，改成机器名就没有问题了。