免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
12
最近访问板块 发新帖
楼主: pandu
打印 上一主题 下一主题

请帮我看看日志,sybase起来自动down [复制链接]

论坛徽章:
0
11 [报告]
发表于 2005-11-03 17:18 |显示全部楼层
把XP_server在sql.ini的端口号更改一下试试

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

郁闷的不行

论坛徽章:
0
12 [报告]
发表于 2005-11-03 18:00 |显示全部楼层
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 编辑 ]

论坛徽章:
0
13 [报告]
发表于 2005-11-04 09:38 |显示全部楼层
sybase起不来啊,从sybase central 里面也启动不了啊
只能用执行sqlsrvr.exe,或者用startserver -f run_xxx 才能启动
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP