sybase ASE 12.5两个问题？（急）

yantan

免费乐捐，感谢支持

目前使用的是ASE 12.5， 有两个问题请教：
1) 数据库使用过程的安装和日常运行日志保存在哪个地方？
2) 两个Sybase服务中的BCKSERVER不能启动，提示的错误代码是Error 1067: The process terminated unexpectedly. 有没有更具体的错误日志？
多谢了。


===========================

过端午节的时候, 重新配置了一遍BCKSERVER, 就可以启动这个服务了. 感谢各位的建议.

ehxz

一、日志看\ASE-12_5\install下面的ERRORLOG文件，当然也有可能被你改过默认设置。
二、1067好像是经典错误了，一般是配置搞的有问题了没启动，先看一下上面的日志吧。
对SYBASE来说，打最新补丁有时候能解决很多问题。当然要提前做好备份与测试。{:soso_e100:}

yantan

ehxz 发表于 2011-6-1 10:56
一、日志看\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

这是我从errorlog中复制的近期的日志：其中的License问题从2月份就出现了，这次BCKSERVER不能启动和它有关系吗？

01:00000:00144:2011/05/31 05:30:18.43 server  Failed to connect to remote server CNHZNSVR00D5_BS nlwnsck ether cnhznsvr00d5 5001  for site SYB_BACKUP. Trying the next query entry of this server, if any.
01:00000:00144:2011/05/31 05:30:18.43 server  Error: 7235, Severity: 17, State: 0
01:00000:00144:2011/05/31 05:30:18.43 server  No 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 kernel  nl__connect: Could not connect to site 'CNHZNSVR00D5_BS', socket 246.
00:00000:00401:2011/05/31 05:30:32.84 kernel  nl__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 server  Failed to connect to remote server CNHZNSVR00D5_BS nlwnsck ether cnhznsvr00d5 5001  for site SYB_BACKUP. Trying the next query entry of this server, if any.
00:00000:00401:2011/05/31 05:30:32.84 server  Error: 7235, Severity: 17, State: 0
00:00000:00401:2011/05/31 05:30:32.84 server  No 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 server  WARNING: ***************************
00:00000:00400:2011/05/31 05:30:32.86 server  Attempt by user 5 to dump xact on db tms with NO_LOG
00:00000:00400:2011/05/31 05:30:33.26 server  Attempt by user 5 to dump xact on db tms with NO_LOG was successful
00:00000:00400:2011/05/31 05:30:33.26 server  WARNING: ***************************
00:00000:00400:2011/05/31 05:30:33.28 server  WARNING: ***************************
00:00000:00400:2011/05/31 05:30:33.28 server  Attempt by user 5 to dump xact on db tms_load with NO_LOG
00:00000:00400:2011/05/31 05:30:33.28 server  Attempt 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 server  WARNING: ***************************
00:00000:00200:2011/05/31 06:00:15.76 server  WARNING: ***************************
00:00000:00200:2011/05/31 06:00:15.78 server  Attempt by user 1 to dump xact on db tms with NO_LOG
00:00000:00200:2011/05/31 06:00:15.78 server  Attempt by user 1 to dump xact on db tms with NO_LOG was successful
00:00000:00200:2011/05/31 06:00:15.78 server  WARNING: ***************************
00:00000:00200:2011/05/31 06:00:15.78 server  WARNING: ***************************
00:00000:00200:2011/05/31 06:00:15.78 server  Attempt by user 1 to dump xact on db tms_load with NO_LOG
00:00000:00200:2011/05/31 06:00:15.79 server  Attempt 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 server  WARNING: ***************************
00:00000:00200:2011/05/31 06:00:15.79 server  WARNING: ***************************
00:00000:00200:2011/05/31 06:00:15.79 server  Attempt by user 1 to dump xact on db tempdb with NO_LOG
00:00000:00200:2011/05/31 06:00:15.79 server  Attempt by user 1 to dump xact on db tempdb with NO_LOG was successful
00:00000:00200:2011/05/31 06:00:15.79 server  WARNING: ***************************
00:00000:00200:2011/05/31 06:03:19.30 server  WARNING: ***************************
00:00000:00200:2011/05/31 06:03:19.30 server  Attempt by user 1 to dump xact on db tms with NO_LOG
00:00000:00200:2011/05/31 06:03:30.05 server  Attempt by user 1 to dump xact on db tms with NO_LOG was successful
00:00000:00200:2011/05/31 06:03:30.05 server  WARNING: ***************************
00:00000:00200:2011/05/31 06:03:30.05 server  WARNING: ***************************
00:00000:00200:2011/05/31 06:03:30.05 server  Attempt by user 1 to dump xact on db tms_load with NO_LOG
00:00000:00200:2011/05/31 06:03:32.32 server  Attempt 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 server  WARNING: ***************************
00:00000:00200:2011/05/31 06:03:32.32 server  WARNING: ***************************
00:00000:00200:2011/05/31 06:03:32.32 server  Attempt by user 1 to dump xact on db tempdb with NO_LOG
00:00000:00200:2011/05/31 06:03:32.32 server  Attempt by user 1 to dump xact on db tempdb with NO_LOG was successful
00:00000:00200:2011/05/31 06:03:32.32 server  WARNING: ***************************
01:00000:00076:2011/05/31 07:00:00.22 server  WARNING: ***************************
01:00000:00076:2011/05/31 07:00:00.22 server  Attempt by user 5 to dump xact on db tms_load with NO_LOG
01:00000:00076:2011/05/31 07:00:00.22 server  Attempt 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 server  WARNING: ***************************
01:00000:00011:2011/05/31 13:08:51.12 server  Exceeded license usage limit. Contact Sybase Sales for additional licenses.
00:00000:00241:2011/05/31 21:20:26.60 kernel  Cannot send, host process disconnected:  00000dfc spid: 241
00:00000:00426:2011/05/31 21:48:16.20 kernel  Cannot send, host process disconnected:  00000d7c spid: 426
00:00000:00426:2011/05/31 21:48:16.22 server  Error: 1608, Severity: 18, State: 4
00:00000:00426:2011/05/31 21:48:16.22 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.

ehxz

可以尝试把BS服务删除再建一下试试看。

yantan

ehxz 发表于 2011-6-1 12:15
可以尝试把BS服务删除再建一下试试看。

谢谢你的 建议.  我只用用 Sybase SErver Config重新配置了一遍BCKSERVER, 这个服务就可以启动了. 很奇怪. 没找到原因. 还是感谢先.

ehxz

WIN下的BS服务好像是有问题的，偶以前也经常遇到不能正常启动，删除重建一下就可以了。这个服务建的很快的。

yantan

免费乐捐，感谢支持

ehxz 发表于 2011-6-8 20:48
WIN下的BS服务好像是有问题的，偶以前也经常遇到不能正常启动，删除重建一下就可以了。这个服务建的很快的。 ...

谢谢你的帮忙. 看来你是专家了. 我只是一个偶尔做技术支持的人, 最近公司的专有技术支持出了些问题, 我只能赶鸭子上架了.

不好意思, 我刚才有提了一个问题, 参见链接, https://www.sybasebbs.com/forum.php?mod=viewthread&tid=5233&extra=page%3D1, 如果有什么好方法, 请回复.