大家?guī)兔�看看這段日志文件有什么問題�。�！

songwk80

00:00000:00000:2005/09/06 14:26:37.92 kernel  Warning: There is no valid license for ASE server product. Server is booting with all the option features disabled.
00:00000:00000:2005/09/06 14:26:38.18 kernel  Using config area from primary master device.
00:00000:00000:2005/09/06 14:26:38.20 kernel  Warning: Using default file 'd:\Sybase\SYBASE.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/09/06 14:26:40.79 kernel  NT operating system error 87 in module 'e:\ase1251\porttree\svr\sql\nt386\ksource\blkmem\osmntmmap.c' at line 467: 參數(shù)錯(cuò)誤。

.
00:00000:00000:2005/09/06 14:26:40.81 kernel  os_create_region: Failed to get virtual memory information.
00:00000:00000:2005/09/06 14:26:40.81 kernel  kbcreate: couldn't create server region 7.
00:00000:00000:2005/09/06 14:26:40.81 kernel  kistartup: could not create shared memory
00:00000:00000:2005/09/06 14:26:40.81 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  FATAL: NULL Pss on STACK_OVERFLOW

冷月無聲

你的共享內(nèi)存分配的有問題啊！

songwk80

00:00000:00000:2005/09/06 14:26:40.79 kernel  NT operating system error 87 in module 'e:\ase1251\porttree\svr\sql\nt386\ksource\blkmem\osmntmmap.c' at line 467: 參數(shù)錯(cuò)誤。

.
00:00000:00000:2005/09/06 14:26:40.81 kernel  os_create_region: Failed to get virtual memory information.
00:00000:00000:2005/09/06 14:26:40.81 kernel  kbcreate: couldn't create server region 7.
00:00000:00000:2005/09/06 14:26:40.81 kernel  kistartup: could not create shared memory

的確共享內(nèi)存在日志里面顯示不能分配，但是服務(wù)一直是正常使用的。只是今天才出現(xiàn)問題。

能解釋一下參數(shù)錯(cuò)誤的那個(gè)提示的含義嗎？

冷月無聲

一般來講，啟動dataserver的時(shí)候不能創(chuàng)建共享內(nèi)存 其結(jié)果應(yīng)該是不能啟動阿，但是你的服務(wù)卻是一直可以正常使用！看你是今天下午14:26啟動的，檢查一下你的配置看看！

songwk80

不知道你注意到這個(gè)提示沒有：00:00000:00000:2005/09/06 14:26:40.82 kernel  FATAL: NULL Pss on STACK_OVERFLOW
我在一篇文章里面看到這段文字：
======================================

   Following is a list of fixes which are cumulative to this release.  Each
   fix is listed along with the EBF in which it was first released and the
   description of the problem. The list is sorted by the EBFID column.

   The list of fixes represent changes included after the 12.0 ASE Release.
   For product changes up to 12.0, please refer to the CPR and SPR files
   included in the /install/SPR directory in the 12.0 release directory.
EBFID 8954
BugID 206851

ASE may exit with a 1608 error and a message in
                    the error log, "kernel FATAL: NULL Pss on
                    STACK_OVERFLOW".

1017of

從日志上看好象是啟動沒有成功，并且share memory沒有成功建立。在windows平臺上好象沒有明顯的share memory調(diào)整，但是否需要觀察一下內(nèi)存使用情況與sybase內(nèi)存配置情況。最好能貼出服務(wù)器硬件配置與sybase的memory與engine配置。至于日志中最后一句，我也不太懂，只是我覺得如果服務(wù)沒有起來，好象還到不了pss和stack這一步吧，也許首先需要看看share memory是否正常。
btw:最好能貼出OS版本與sybase具體版本，是ASE 12.5.1 for NT嗎？EBF呢？

flybean

啟動過程中出現(xiàn)不能分配shared memory，檢查配置，是否配置了啟動時(shí)申請shared memory以及分配給SYBASE的最大內(nèi)存是多少，是否低于與實(shí)際的物理內(nèi)存，當(dāng)然要為OS留點(diǎn)內(nèi)存。

Windows平臺上的確是沒有明顯的shared memory調(diào)整，但對ASE　32位而言，應(yīng)該是無限制的。另外，就我所注意到的，WINDOWS2003的共享內(nèi)存在安全策略上可能有所調(diào)整，但不會導(dǎo)致你這樣的問題。

songwk80

的確是內(nèi)存調(diào)整的問題，我將sybase.cfg所有參數(shù)全部置為default,數(shù)據(jù)庫可以成功啟動。然后重新進(jìn)行調(diào)優(yōu)，分配了比原來少的max memory.然后，就可以了。
最開始的時(shí)候是因?yàn)閿?shù)據(jù)庫日志跟操作系統(tǒng)事件日志都滿了，一般這種問題不會很嚴(yán)重的，但是最后發(fā)展到嚴(yán)重的地步，數(shù)據(jù)庫服務(wù)不能啟動。
但是的確很奇怪，原來一直能正常使用的sybase.cfg種的參數(shù)，現(xiàn)在卻不能使用。