sybase ASE 12.5两个问题？（急）
本帖最后由 yantan 于 2011-6-8 20:46 编辑目前使用的是ASE 12.5， 有两个问题请教：
1) 数据库使用过程的安装和日常运行日志保存在哪个地方？
2) 两个Sybase服务中的BCKSERVER不能启动，提示的错误代码是Error 1067: The process terminated unexpectedly. 有没有更具体的错误日志？
多谢了。
===========================
过端午节的时候, 重新配置了一遍BCKSERVER, 就可以启动这个服务了. 感谢各位的建议.
一、日志看\ASE-12_5\install下面的ERRORLOG文件，当然也有可能被你改过默认设置。
二、1067好像是经典错误了，一般是配置搞的有问题了没启动，先看一下上面的日志吧。
对SYBASE来说，打最新补丁有时候能解决很多问题。当然要提前做好备份与测试。{:soso_e100:}
本帖最后由 yantan 于 2011-6-1 11:16 编辑
ehxz 发表于 2011-6-1 10:56 static/image/common/back.gif
一、日志看\ASE-12_5\install下面的ERRORLOG文件，当然也有可能被你改过默认设置。
二、1067好像是经典错误 ...
好的，我先试试。多谢了。
补充：
刚才看了一次backup.log, 最后一次成功备份的日期是4月22日，之后就不能启动了，下面是错误提示，但是很简单，哪里有更详细的？ 以便于判断问题.
Apr 22 05:48:24 2011: Backup Server: 4.58.1.1: Database tms_load: 3860656 kilobytes DUMPed.
Apr 22 05:48:25 2011: Backup Server: 3.42.1.1: DUMP is complete (database tms_load).
Apr 22 05:48:25 2011: Open Server Error: 16144.10.0: Server process '36' is not allocated in 'srv__prepare_for_suspend'
.
Apr 22 05:48:25 2011: Open Server Error: 16144.10.0: Server process '36' is not allocated in 'srv__prepare_for_resume'
.
Apr 22 05:48:25 2011: Open Server Error: 16144.10.0: Server process '37' is not allocated in 'srv__prepare_for_suspend'
.
Apr 22 05:48:25 2011: Open Server Error: 16144.10.0: Server process '37' is not allocated in 'srv__prepare_for_resume'
.
Apr 22 12:30:00 2011: Backup Server: 3.48.1.1: The Backup Server will go down immediately.Terminating sessions.
本帖最后由 yantan 于 2011-6-1 11:29 编辑
这是我从errorlog中复制的近期的日志：其中的License问题从2月份就出现了，这次BCKSERVER不能启动和它有关系吗？
01:00000:00144:2011/05/31 05:30:18.43 serverFailed to connect to remote server CNHZNSVR00D5_BS nlwnsck ether cnhznsvr00d5 5001for site SYB_BACKUP. Trying the next query entry of this server, if any.
01:00000:00144:2011/05/31 05:30:18.43 serverError: 7235, Severity: 17, State: 0
01:00000:00144:2011/05/31 05:30:18.43 serverNo other query entry found for the remote server CNHZNSVR00D5_BS - site SYB_BACKUP. Aborting this site handler, as no remote server responded. Please make sure the remote server is accepting connections.
00:00000:00401:2011/05/31 05:30:32.84 kernelnl__connect: Could not connect to site 'CNHZNSVR00D5_BS', socket 246.
00:00000:00401:2011/05/31 05:30:32.84 kernelnl__connect: net_connect failed to connect to site 'CNHZNSVR00D5_BS'.
: No connection could be made because the target machine actively refused it.
.
00:00000:00401:2011/05/31 05:30:32.84 serverFailed to connect to remote server CNHZNSVR00D5_BS nlwnsck ether cnhznsvr00d5 5001for site SYB_BACKUP. Trying the next query entry of this server, if any.
00:00000:00401:2011/05/31 05:30:32.84 serverError: 7235, Severity: 17, State: 0
00:00000:00401:2011/05/31 05:30:32.84 serverNo other query entry found for the remote server CNHZNSVR00D5_BS - site SYB_BACKUP. Aborting this site handler, as no remote server responded. Please make sure the remote server is accepting connections.
00:00000:00400:2011/05/31 05:30:32.86 serverWARNING: ***************************
00:00000:00400:2011/05/31 05:30:32.86 serverAttempt by user 5 to dump xact on db tms with NO_LOG
00:00000:00400:2011/05/31 05:30:33.26 serverAttempt by user 5 to dump xact on db tms with NO_LOG was successful
00:00000:00400:2011/05/31 05:30:33.26 serverWARNING: ***************************
00:00000:00400:2011/05/31 05:30:33.28 serverWARNING: ***************************
00:00000:00400:2011/05/31 05:30:33.28 serverAttempt by user 5 to dump xact on db tms_load with NO_LOG
00:00000:00400:2011/05/31 05:30:33.28 serverAttempt by user 5 to dump xact on db tms_load with NO_LOG was successful
00:00000:00400:2011/05/31 05:30:33.28 serverWARNING: ***************************
00:00000:00200:2011/05/31 06:00:15.76 serverWARNING: ***************************
00:00000:00200:2011/05/31 06:00:15.78 serverAttempt by user 1 to dump xact on db tms with NO_LOG
00:00000:00200:2011/05/31 06:00:15.78 serverAttempt by user 1 to dump xact on db tms with NO_LOG was successful
00:00000:00200:2011/05/31 06:00:15.78 serverWARNING: ***************************
00:00000:00200:2011/05/31 06:00:15.78 serverWARNING: ***************************
00:00000:00200:2011/05/31 06:00:15.78 serverAttempt by user 1 to dump xact on db tms_load with NO_LOG
00:00000:00200:2011/05/31 06:00:15.79 serverAttempt by user 1 to dump xact on db tms_load with NO_LOG was successful
00:00000:00200:2011/05/31 06:00:15.79 serverWARNING: ***************************
00:00000:00200:2011/05/31 06:00:15.79 serverWARNING: ***************************
00:00000:00200:2011/05/31 06:00:15.79 serverAttempt by user 1 to dump xact on db tempdb with NO_LOG
00:00000:00200:2011/05/31 06:00:15.79 serverAttempt by user 1 to dump xact on db tempdb with NO_LOG was successful
00:00000:00200:2011/05/31 06:00:15.79 serverWARNING: ***************************
00:00000:00200:2011/05/31 06:03:19.30 serverWARNING: ***************************
00:00000:00200:2011/05/31 06:03:19.30 serverAttempt by user 1 to dump xact on db tms with NO_LOG
00:00000:00200:2011/05/31 06:03:30.05 serverAttempt by user 1 to dump xact on db tms with NO_LOG was successful
00:00000:00200:2011/05/31 06:03:30.05 serverWARNING: ***************************
00:00000:00200:2011/05/31 06:03:30.05 serverWARNING: ***************************
00:00000:00200:2011/05/31 06:03:30.05 serverAttempt by user 1 to dump xact on db tms_load with NO_LOG
00:00000:00200:2011/05/31 06:03:32.32 serverAttempt by user 1 to dump xact on db tms_load with NO_LOG was successful
00:00000:00200:2011/05/31 06:03:32.32 serverWARNING: ***************************
00:00000:00200:2011/05/31 06:03:32.32 serverWARNING: ***************************
00:00000:00200:2011/05/31 06:03:32.32 serverAttempt by user 1 to dump xact on db tempdb with NO_LOG
00:00000:00200:2011/05/31 06:03:32.32 serverAttempt by user 1 to dump xact on db tempdb with NO_LOG was successful
00:00000:00200:2011/05/31 06:03:32.32 serverWARNING: ***************************
01:00000:00076:2011/05/31 07:00:00.22 serverWARNING: ***************************
01:00000:00076:2011/05/31 07:00:00.22 serverAttempt by user 5 to dump xact on db tms_load with NO_LOG
01:00000:00076:2011/05/31 07:00:00.22 serverAttempt by user 5 to dump xact on db tms_load with NO_LOG was successful
01:00000:00076:2011/05/31 07:00:00.22 serverWARNING: ***************************
01:00000:00011:2011/05/31 13:08:51.12 serverExceeded license usage limit. Contact Sybase Sales for additional licenses.
00:00000:00241:2011/05/31 21:20:26.60 kernelCannot send, host process disconnected:00000dfc spid: 241
00:00000:00426:2011/05/31 21:48:16.20 kernelCannot send, host process disconnected:00000d7c spid: 426
00:00000:00426:2011/05/31 21:48:16.22 serverError: 1608, Severity: 18, State: 4
00:00000:00426:2011/05/31 21:48:16.22 serverA client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
可以尝试把BS服务删除再建一下试试看。 ehxz 发表于 2011-6-1 12:15 static/image/common/back.gif
可以尝试把BS服务删除再建一下试试看。
谢谢你的 建议.我只用用 Sybase SErver Config重新配置了一遍BCKSERVER, 这个服务就可以启动了. 很奇怪. 没找到原因. 还是感谢先. WIN下的BS服务好像是有问题的，偶以前也经常遇到不能正常启动，删除重建一下就可以了。这个服务建的很快的。 ehxz 发表于 2011-6-8 20:48 static/image/common/back.gif
WIN下的BS服务好像是有问题的，偶以前也经常遇到不能正常启动，删除重建一下就可以了。这个服务建的很快的。 ...
谢谢你的帮忙. 看来你是专家了. 我只是一个偶尔做技术支持的人, 最近公司的专有技术支持出了些问题, 我只能赶鸭子上架了.
不好意思, 我刚才有提了一个问题, 参见链接, https://www.sybasebbs.com/forum.php?mod=viewthread&tid=5233&extra=page%3D1, 如果有什么好方法, 请回复.
页:
[1]