【转帖】如何查找数据库启动失败原因
在实际环境中，数据库Server无法启动的原因很多，本文仅列出了几种常见的情况，供您参考。<P> 首先，应检查Server的日志文件。不同版本缺省的日志文件如下（其中<server_name>为Sybase Server的名称：</P>
<BLOCKQUOTE>
<P> UNIX:</P>
<UL>
<LI><FONT color=#006633>11.0*: $SYBASE/install/errorlog</FONT>
<LI><FONT color=#006633>11.5* 或 11.9*: $SYBASE/install/<server_name>.log</FONT>
<LI><FONT color=#006633>12.0*: $SYBASE_ASE/install/<server_name>.log</FONT> </LI></UL>
<P> NT:</P>
<UL>
<LI><FONT color=#006633>11.0* 11.5* 或 11.9*: $SYBASE\install\errorlog</FONT>
<LI><FONT color=#006633>12.0*: $SYBASE\ASE-12_0\install\errorlog</FONT> </LI></UL></BLOCKQUOTE>
<P> CASE 1:</P>
<BLOCKQUOTE>
<P><FONT color=#006633>basis_dlock: file '/sybase/master.dat' already in use by a SQL Server
kernel kdconfig: unable to read primary master device
kernel kiconfig: read of config block failed</FONT></P></BLOCKQUOTE>
<UL>
<LI>检查server是否已经启动( showserver, ps -u sybase 或NT service ) </LI></UL>
<P> CASE 2:</P>
<BLOCKQUOTE>
<P>d<FONT color=#006633>open: open '/sybase/master.dat' failed, permission denied
kernel kdconfig: unable to read primary master device
kernel kiconfig: read of config block failed</FONT></P></BLOCKQUOTE>
<UL>
<LI>检查master设备文件的所有者及权限 </LI></UL>
<P> CASE 3:</P>
<BLOCKQUOTE>
<P><FONT color=#006633>ninit: All master network listeners have failed. Shutting down</FONT></P></BLOCKQUOTE>
<UL>
<LI>检查network ip 及 port配置 ( netstat -a ) </LI></UL>
<P> CASE 4:</P>
<BLOCKQUOTE>
<P><FONT color=#006633>kernel:kscsinit: connectivity library error. Operation: cs_ctx_alloc().</FONT></P></BLOCKQUOTE>
<UL>
<LI>检查操作系统参数是否已经修改并重新启动操作系统 (参见安装手册)
<LI>若操作系统异常宕机，ASE未启动而$SYBASE/<server_name>.krg已经存在, 删除该文件 </LI></UL>
页:
[1]