Sybase数据启动服务之后自动关闭，点击Server Config 时报错

BoJerry 2013-03-06 08:48:34
数据库昨天能正常启动，网络IP地址改变之后无法启动服务，也无法启动Server config 进行配置。启动服务和Server config 报错分别为：“本地计算机上的Sybase SQLServer_TEST 服务启动后停止。某些服务在未由其他服务或程序使用时自动停止。 ”；“The program could not determine your release directory. Please set environment variable SYBASE to your release directory and restart the program.”
...全文
650 7 打赏 收藏 转发到动态 举报
写回复
用AI写文章
7 条回复
切换为时间正序
请发表友善的回复…
发表回复
BoJerry 2013-03-06
  • 打赏
  • 举报
 回复
确实是IP地址变了，但是为什么连Server config也无法使用呢？求解决啊 .. .
gyxing168 2013-03-06
  • 打赏
  • 举报
 回复
Cannot allocate resources for listener with protocol tcp, host 192.168.0.103, port 5000, engine 0. 我感觉就是网络环境变了，，，
BoJerry 2013-03-06
  • 打赏
  • 举报
 回复
00:00000:00001:2013/03/06 10:01:00.04 server Database 'tempdb' is now online. 00:00000:00010:2013/03/06 10:01:00.06 kernel network name 192.168.0.103, interface IPv4, address 192.168.0.103, type tcp, port 5000, filter NONE 00:00000:00010:2013/03/06 10:01:00.06 kernel NT operating system error 10049 in module 'e:\1254\porttree\svr\sql\generic\ksource\strmio\n_winsock.c' at line 1629: 在其上下文中，该请求的地址无效。 . 00:00000:00010:2013/03/06 10:01:00.08 kernel ninit: bind, Could not bind socket address. 00:00000:00010:2013/03/06 10:01:00.08 kernel Cannot allocate resources for listener with protocol tcp, host 192.168.0.103, port 5000, engine 0. 00:00000:00010:2013/03/06 10:01:00.11 kernel Cannot start any network listeners. 00:00000:00010:2013/03/06 10:01:00.11 kernel ueshutdown: exiting 00:00000:00010:2013/03/06 10:01:00.11 kernel RTDS Server is already down.
BoJerry 2013-03-06
  • 打赏
  • 举报
 回复
00:00000:00001:2013/03/06 10:00:56.22 server Opening Master Database ... 00:00000:00001:2013/03/06 10:00:56.57 server Loading SQL Server's default sort order and character set 00:00000:00001:2013/03/06 10:00:56.74 server Loaded default Unilib conversion handle. 00:00000:00001:2013/03/06 10:00:56.83 server Recovering database 'master'. 00:00000:00001:2013/03/06 10:00:56.88 server Started estimating recovery log boundaries for database 'master'. 00:00000:00001:2013/03/06 10:00:56.91 server Database 'master', checkpoint=(1256, 185), first=(1256, 185), last=(1257, 2). 00:00000:00001:2013/03/06 10:00:56.91 server Completed estimating recovery log boundaries for database 'master'. 00:00000:00001:2013/03/06 10:00:56.91 server Started ANALYSIS pass for database 'master'. 00:00000:00001:2013/03/06 10:00:56.92 server Completed ANALYSIS pass for database 'master'. 00:00000:00001:2013/03/06 10:00:56.92 server Started REDO pass for database 'master'. The total number of log records to process is 11. 00:00000:00001:2013/03/06 10:00:56.99 server Redo pass of recovery has processed 1 committed and 0 aborted transactions. 00:00000:00001:2013/03/06 10:00:56.99 server Completed REDO pass for database 'master'. 00:00000:00001:2013/03/06 10:00:57.00 server Recovery of database 'master' will undo incomplete nested top actions. 00:00000:00001:2013/03/06 10:00:57.00 server Started recovery checkpoint for database 'master'. 00:00000:00001:2013/03/06 10:00:57.05 server Completed recovery checkpoint for database 'master'. 00:00000:00001:2013/03/06 10:00:57.05 server Started filling free space info for database 'master'. 00:00000:00001:2013/03/06 10:00:57.11 server Completed filling free space info for database 'master'. 00:00000:00001:2013/03/06 10:00:57.11 server Started cleaning up the default data cache for database 'master'. 00:00000:00001:2013/03/06 10:00:57.11 server Completed cleaning up the default data cache for database 'master'. 00:00000:00001:2013/03/06 10:00:57.17 server Checking external objects. 00:00000:00001:2013/03/06 10:00:57.21 server Database 'master' is now online. 00:00000:00001:2013/03/06 10:00:57.21 server The transaction log in the database 'master' will use I/O size of 16 Kb. 00:00000:00001:2013/03/06 10:00:57.28 server Warning: ASE_HA has no valid license and therefore is not initialized. 00:00000:00001:2013/03/06 10:00:57.31 server server name is 'TEST' 00:00000:00001:2013/03/06 10:00:57.35 server Activating disk 'sysprocsdev' of size 135168 KB. 00:00000:00001:2013/03/06 10:00:57.35 kernel Initializing virtual device 1, 'D:\Sybase\sybprocs.dat' with dsync 'on'. 00:00000:00001:2013/03/06 10:00:57.36 kernel Virtual device 1 started using asynchronous i/o. 00:00000:00001:2013/03/06 10:00:57.36 server Activating disk 'systemdbdev' of size 4096 KB. 00:00000:00001:2013/03/06 10:00:57.36 kernel Initializing virtual device 2, 'D:\Sybase\sybsysdb.dat' with dsync 'on'. 00:00000:00001:2013/03/06 10:00:57.36 kernel Virtual device 2 started using asynchronous i/o. 00:00000:00001:2013/03/06 10:00:57.55 server Recovering database 'sybsystemdb'. 00:00000:00001:2013/03/06 10:00:57.55 server Started estimating recovery log boundaries for database 'sybsystemdb'. 00:00000:00001:2013/03/06 10:00:57.55 server Database 'sybsystemdb', checkpoint=(468, 35), first=(468, 35), last=(468, 35). 00:00000:00001:2013/03/06 10:00:57.55 server Completed estimating recovery log boundaries for database 'sybsystemdb'. 00:00000:00001:2013/03/06 10:00:57.55 server Started ANALYSIS pass for database 'sybsystemdb'. 00:00000:00001:2013/03/06 10:00:57.55 server Completed ANALYSIS pass for database 'sybsystemdb'. 00:00000:00001:2013/03/06 10:00:57.56 server Started REDO pass for database 'sybsystemdb'. The total number of log records to process is 1. 00:00000:00001:2013/03/06 10:00:57.56 server Completed REDO pass for database 'sybsystemdb'. 00:00000:00001:2013/03/06 10:00:57.56 server Recovery of database 'sybsystemdb' will undo incomplete nested top actions. 00:00000:00001:2013/03/06 10:00:57.56 server Started recovery checkpoint for database 'sybsystemdb'. 00:00000:00001:2013/03/06 10:00:57.56 server Completed recovery checkpoint for database 'sybsystemdb'. 00:00000:00001:2013/03/06 10:00:57.58 server Started filling free space info for database 'sybsystemdb'. 00:00000:00001:2013/03/06 10:00:57.61 server Completed filling free space info for database 'sybsystemdb'. 00:00000:00001:2013/03/06 10:00:57.61 server Started cleaning up the default data cache for database 'sybsystemdb'. 00:00000:00001:2013/03/06 10:00:57.61 server Completed cleaning up the default data cache for database 'sybsystemdb'. 00:00000:00001:2013/03/06 10:00:57.61 server Boot Count: 13 00:00000:00001:2013/03/06 10:00:57.67 server Checking external objects. 00:00000:00001:2013/03/06 10:00:57.69 server The transaction log in the database 'sybsystemdb' will use I/O size of 16 Kb. 00:00000:00001:2013/03/06 10:00:57.70 server Database 'sybsystemdb' is now online. 00:00000:00001:2013/03/06 10:00:57.77 server Recovering database 'model'. 00:00000:00001:2013/03/06 10:00:57.77 server Started estimating recovery log boundaries for database 'model'. 00:00000:00001:2013/03/06 10:00:57.77 server Database 'model', checkpoint=(467, 101), first=(467, 101), last=(467, 101). 00:00000:00001:2013/03/06 10:00:57.77 server Completed estimating recovery log boundaries for database 'model'. 00:00000:00001:2013/03/06 10:00:57.77 server Started ANALYSIS pass for database 'model'. 00:00000:00001:2013/03/06 10:00:57.77 server Completed ANALYSIS pass for database 'model'. 00:00000:00001:2013/03/06 10:00:57.77 server Started REDO pass for database 'model'. The total number of log records to process is 1. 00:00000:00001:2013/03/06 10:00:57.78 server Completed REDO pass for database 'model'. 00:00000:00001:2013/03/06 10:00:57.78 server Recovery of database 'model' will undo incomplete nested top actions. 00:00000:00001:2013/03/06 10:00:57.78 server Started recovery checkpoint for database 'model'. 00:00000:00001:2013/03/06 10:00:57.78 server Completed recovery checkpoint for database 'model'. 00:00000:00001:2013/03/06 10:00:57.78 server Started filling free space info for database 'model'. 00:00000:00001:2013/03/06 10:00:57.83 server Completed filling free space info for database 'model'. 00:00000:00001:2013/03/06 10:00:57.83 server Started cleaning up the default data cache for database 'model'. 00:00000:00001:2013/03/06 10:00:57.83 server Completed cleaning up the default data cache for database 'model'. 00:00000:00001:2013/03/06 10:00:57.83 server Checking external objects. 00:00000:00001:2013/03/06 10:00:57.83 server The transaction log in the database 'model' will use I/O size of 16 Kb. 00:00000:00001:2013/03/06 10:00:57.83 server Database 'model' is now online. 00:00000:00001:2013/03/06 10:00:57.83 server The logical pagesize of the server is 16 Kb. 00:00000:00001:2013/03/06 10:00:57.84 server 0 dump conditions detected at boot time 00:00000:00001:2013/03/06 10:00:57.88 server Resident Node id: c005a8502f1b 00:00000:00001:2013/03/06 10:00:57.94 server Transaction coordinator initialized. 00:00000:00001:2013/03/06 10:00:57.95 server Clearing temp db 00:00000:00001:2013/03/06 10:00:59.14 server The transaction log in the database 'tempdb' will use I/O size of 16 Kb. 00:00000:00001:2013/03/06 10:00:59.20 server The transaction log in the database 'tempdb' will use I/O size of 16 Kb. 00:00000:00001:2013/03/06 10:00:59.25 server Database 'tempdb' is now online. 00:00000:00001:2013/03/06 10:00:59.33 server Recovering database 'sybsystemprocs'. 00:00000:00001:2013/03/06 10:00:59.33 server Started estimating recovery log boundaries for database 'sybsystemprocs'. 00:00000:00001:2013/03/06 10:00:59.33 server Database 'sybsystemprocs', checkpoint=(5275, 29), first=(5275, 29), last=(5275, 29). 00:00000:00001:2013/03/06 10:00:59.33 server Completed estimating recovery log boundaries for database 'sybsystemprocs'. 00:00000:00001:2013/03/06 10:00:59.33 server Started ANALYSIS pass for database 'sybsystemprocs'. 00:00000:00001:2013/03/06 10:00:59.33 server Completed ANALYSIS pass for database 'sybsystemprocs'. 00:00000:00001:2013/03/06 10:00:59.33 server Started REDO pass for database 'sybsystemprocs'. The total number of log records to process is 1. 00:00000:00001:2013/03/06 10:00:59.34 server Completed REDO pass for database 'sybsystemprocs'. 00:00000:00001:2013/03/06 10:00:59.34 server Recovery of database 'sybsystemprocs' will undo incomplete nested top actions. 00:00000:00001:2013/03/06 10:00:59.34 server Started recovery checkpoint for database 'sybsystemprocs'. 00:00000:00001:2013/03/06 10:00:59.34 server Completed recovery checkpoint for database 'sybsystemprocs'. 00:00000:00001:2013/03/06 10:00:59.34 server Started filling free space info for database 'sybsystemprocs'. 00:00000:00001:2013/03/06 10:00:59.50 server Completed filling free space info for database 'sybsystemprocs'. 00:00000:00001:2013/03/06 10:00:59.50 server Started cleaning up the default data cache for database 'sybsystemprocs'. 00:00000:00001:2013/03/06 10:00:59.50 server Completed cleaning up the default data cache for database 'sybsystemprocs'. 00:00000:00001:2013/03/06 10:00:59.50 server Checking external objects. 00:00000:00001:2013/03/06 10:00:59.51 server The transaction log in the database 'sybsystemprocs' will use I/O size of 16 Kb. 00:00000:00001:2013/03/06 10:00:59.58 server Th log in the database 'sybsystemprocs' will use I/O size of 16 Kb. 00:00000:00001:2013/03/06 10:00:59.61 server Database 'sybsystemprocs' is now online. 00:00000:00001:2013/03/06 10:00:59.75 server Database 'master' is now online. 00:00000:00001:2013/03/06 10:00:59.84 server Database 'model' is now online. 00:00000:00001:2013/03/06 10:00:59.92 server Database 'sybsystemdb' is now online. 00:00000:00001:2013/03/06 10:01:00.04 server Database 'tempdb' is now online.
BoJerry 2013-03-06
  • 打赏
  • 举报
 回复
00:00000:00000:2013/03/06 10:00:54.16 kernel Use license file D:\Sybase\SYSAM-1_0\licenses\license.dat. 00:00000:00000:2013/03/06 10:00:54.24 kernel Checked out license ASE_SERVER 00:00000:00000:2013/03/06 10:00:54.26 kernel Adaptive Server Enterprise Edition 00:00000:00000:2013/03/06 10:00:54.87 kernel Using config area from primary master device. 00:00000:00000:2013/03/06 10:00:54.93 kernel Warning: Using default file 'D:\Sybase\TEST.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message. 00:00000:00000:2013/03/06 10:00:55.02 kernel Using 100000 file descriptors. 00:00000:00000:2013/03/06 10:00:55.13 kernel Adaptive Server Enterprise/12.5.4/EBF 15438 ESD#8/P/NT (IX86)/OS 4.0/ase1254/2105/32-bit/OPT/Sat Mar 22 04:44:15 2008 00:00000:00000:2013/03/06 10:00:55.13 kernel Confidential property of Sybase, Inc. 00:00000:00000:2013/03/06 10:00:55.13 kernel Copyright 1987, 2008 00:00000:00000:2013/03/06 10:00:55.13 kernel Sybase, Inc. All rights reserved. 00:00000:00000:2013/03/06 10:00:55.13 kernel Unpublished rights reserved under U.S. copyright laws. 00:00000:00000:2013/03/06 10:00:55.13 kernel 00:00000:00000:2013/03/06 10:00:55.13 kernel This software contains confidential and trade secret information of Sybase, 00:00000:00000:2013/03/06 10:00:55.13 kernel Inc. Use, duplication or disclosure of the software and documentation by 00:00000:00000:2013/03/06 10:00:55.13 kernel the U.S. Government is subject to restrictions set forth in a license 00:00000:00000:2013/03/06 10:00:55.13 kernel agreement between the Government and Sybase, Inc. or other written 00:00000:00000:2013/03/06 10:00:55.13 kernel agreement specifying the Government's rights to use the software and any 00:00000:00000:2013/03/06 10:00:55.13 kernel applicable FAR provisions, for example, FAR 52.227-19. 00:00000:00000:2013/03/06 10:00:55.13 kernel Sybase, Inc. One Sybase Drive, Dublin, CA 94568, USA 00:00000:00000:2013/03/06 10:00:55.13 kernel Using D:\Sybase\ as the SYBASE environment variable, found during start-up 00:00000:00000:2013/03/06 10:00:55.15 kernel ASE booted on Windows (unrecognized or unsupported version) build 7601 Service Pack 1. 00:00000:00000:2013/03/06 10:00:55.15 kernel Using 'D:\Sybase\TEST.cfg' for configuration information. 00:00000:00000:2013/03/06 10:00:55.15 kernel Logging ASE messages in file 'D:\Sybase\ASE-12_5\install\errorlog'. 00:00000:00000:2013/03/06 10:00:55.43 kernel Initializing MSDTC Connection 00:00000:00000:2013/03/06 10:00:55.55 kernel The DTC Operation DtcGetTransactionManagerC failed with error DTC Services not available (0x8004d01b) 00:00000:00000:2013/03/06 10:00:55.55 kernel MSDTC Initialization failed 00:00000:00000:2013/03/06 10:00:55.55 kernel Platform TCP network is forced to IPv4-only. 00:00000:00000:2013/03/06 10:00:55.58 kernel SQL Server booted with TCP_NODELAY enabled. 00:00000:00000:2013/03/06 10:00:55.58 kernel *** WARNING ****************** 00:00000:00000:2013/03/06 10:00:55.58 kernel Operating system may favor the system cache when memory is at a premium. To disable this warning, set the registry parameter 'LargeSystemCache' to 0 in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Memory Management. 00:00000:00000:2013/03/06 10:00:55.58 kernel SQL Server NT process id is 0x45c. 00:00000:00000:2013/03/06 10:00:55.58 kernel SQL Server was started as a Service. 00:00000:00000:2013/03/06 10:00:55.66 kernel SSL Plus security module EZ_SECURITY_BUILDER_DSA_MODULE load failed (2030). 00:00000:00000:2013/03/06 10:00:55.66 kernel SSL Plus security module EZ_SECURITY_BUILDER_RSA_MODULE load failed (2031). 00:00000:00000:2013/03/06 10:00:55.66 kernel SSL Plus security module EZ_SECURITY_BUILDER_DES_MODULE load failed (2031). 00:00000:00000:2013/03/06 10:00:55.66 kernel SSL Plus security module EZ_SECURITY_BUILDER_AES_MODULE load failed (2031). 00:00000:00000:2013/03/06 10:00:55.66 kernel SSL Plus security module EZ_SECURITY_BUILDER_3DES_MODULE load failed (2031). 00:00000:00000:2013/03/06 10:00:55.66 kernel SSL Plus security module EZ_SECURITY_BUILDER_AES_MODULE load failed (2031). 00:00000:00000:2013/03/06 10:00:55.66 kernel SSL Plus security module EZ_SECURITY_BUILDER_ECC_MODULE load failed (2031). 00:00000:00000:2013/03/06 10:00:55.66 kernel SSL Plus security module EZ_SECURITY_BUILDER_ECDH_MODULE load failed (2031). 00:00000:00000:2013/03/06 10:00:55.66 kernel SSL Plus security module EZ_SECURITY_BUILDER_PRNG_MODULE load failed (2031). 00:00000:00000:2013/03/06 10:00:55.66 kernel SSL Plus security module EZ_SECURITY_BUILDER_SHA1_MODULE load failed (2031). 00:00000:00000:2013/03/06 10:00:55.66 kernel SSL Plus security module EZ_SECURITY_BUILDER_MD5_MODULE load failed (2031). 00:00000:00000:2013/03/06 10:00:55.66 kernel SSL Plus security module EZ_SECURITY_BUILDER_ARC4_MODULE load failed (2031). 00:00000:00000:2013/03/06 10:00:55.66 kernel SSL Plus security module EZ_SECURITY_BUILDER_MD2_MODULE load failed (2031). 00:00000:00000:2013/03/06 10:00:55.66 kernel SSL Plus security module EZ_SECURITY_BUILDER_DH_MODULE load failed (2031). 00:00000:00000:2013/03/06 10:00:55.66 kernel SSL Plus v5.0.4 security modules loaded, 14 errors. Continuing startup without listed modules. 00:00000:00000:2013/03/06 10:00:55.66 kernel Network and device connection limit is 99987. 00:00000:00000:2013/03/06 10:00:55.77 server Number of blocks left for proc headers: 3232. 00:00000:00000:2013/03/06 10:00:55.77 server Proc header memory allocated 1616 pages for each per engine cache 00:00000:00000:2013/03/06 10:00:55.77 server Size of the 16K memory pool: 8192 Kb 00:00000:00000:2013/03/06 10:00:55.79 server Memory allocated for the default data cache cachelet 1: 8192 Kb 00:00000:00000:2013/03/06 10:00:55.80 kernel Initializing virtual device 0, 'D:\Sybase\master.dat' with dsync 'on'. 00:00000:00000:2013/03/06 10:00:55.80 kernel Virtual device 0 started using asynchronous i/o. 00:00000:00000:2013/03/06 10:00:55.80 kernel Worker Thread Manager is not enabled for use in SQL Server. 00:00000:00000:2013/03/06 10:00:55.80 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:2013/03/06 10:00:55.97 kernel engine 0, os pid 316 online 00:00000:00000:2013/03/06 10:00:56.04 server No active traceflags 00:00000:00001:2013/03/06 10:00:56.21 kernel libomni1 - Component Integration Services loaded; version 'libomni1 - Component Integration Services/12.5.4/EBF 15438 ESD#8/P/NT (IX86)/OS 4.0/ase1254/2105/32-bit/OPT/Sat Mar 22 04:44:15 2008'. 00:00000:00001:2013/03/06 10:00:56.21 kernel libomni1 - Component Integration Services: using 'Sybase Client-Library/12.5.1/P-EBF14745 ESD #19/PC Intel/BUILD1251-050/OPT/Thu Jun 21 01:34:01 2007'
gyxing168 2013-03-06
  • 打赏
  • 举报
 回复
Sybase 服务正常修改IP 地址的话 重启下电脑服务应该能起来的；你看下dsedit里面的IP地址改了没，还是就是指向的 计算机名称； 再有就是查看一下启动日志去。
wwwwb 2013-03-06
  • 打赏
  • 举报
 回复
错误日志中有无信息
SYBASE 12.5 维护手册 5. 灾难恢复篇
5. 灾难恢复篇    5.1 数据库服务不能启动        5.1.1 如何查找数据库启动失败原因 在实际环境中，数据库Server无法启动的原因很多，本文仅列出了几种常见的情况，供您参考。 首先，应检查Server的日志文件。不同版本缺省的日志文件如下（其中为Sybase Server的名称： UNIX: 11.0*: $SYBASE/install/errorlog 11
Sybase 还原过程中遇到的问题 20141219
1、新建备份服务器： 点击 开始---->sybase------>sybase config ------- >创建BackupServer     1.1点击  创建BackupServer 之后，给备份服务器命名，点击下一步 点击 “网络地址” 进去之后点击增加，添加应用服务器名称和端口号，中间用逗号隔开，(端口号是未使用的)。点击继续。     1.2配置好备份服务器之
Sybase数据库备份报错
问题描述： Can't open a connection to site 'SYB_BACKUP',see the errorlog file in the ASE directory。现在想备份数据库但是提示这个错误。 参考网络资料大概是由于 ASE 安装／服务初始化程序的 BUG 导致的。在创建服务时，ASE 会创建一个名为类似 XXXX_BS 的备份服务，同时会在 master.sys
Sybase概念篇
1. 基本概念篇1.1 什么是Sybase Adaptive Server Enterprise （ASE）?Sybase Adaptive Enterprise Server （ASE）是由Sybase公司提供的具有高性能、高可靠性和易维护性的一个关系数据库管理系统。1.2 Sybase 具有哪些Server以及这些Server的用途？Adaptive ServerAdaptive Server...
SYBASE 使用技巧集锦(zt)
SYBASE 使用技巧集锦Q.如何解决数据库被标记为"suspect"的问题之一（ 一般解决方案）？ A.现象：Error 926 　Severity Level 14 　Error Message Text 　Data...
Sybase

2,596

社区成员

25,614

社区内容

发帖
与我相关
我的任务
社区描述
Sybase相关技术讨论区
社区管理员
  • Sybase社区
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章