Sybase数据库启动失败的原因,在实际环境中,数据库Server无法启动的原因很多,
几种常见的情况
首先,应检查Server的日志文件。
不同版本缺省的日志文件如下(其中为Sybase Server的名称:
UNIX:
$SYBASE/install/errorlog
$SYBASE/install/.log
$SYBASE_ASE/install/.log
NT:
$SYBASEinstallerrorlog
$SYBASEASE-12_0installerrorlog
CASE 1:
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
检查server是否已经启动( showserver, ps -u sybase 或NT service )
CASE 2:
dopen: open '/sybase/master.dat' failed, permission denied
kernel kdconfig: unable to read primary master device
kernel kiconfig: read of config block failed
检查master设备文件的所有者及权限
CASE 3:
ninit: All master network listeners have failed. Shutting down
检查network ip 及 port配置 ( netstat -a )
CASE 4:
kernel:kscsinit: connectivity library error. Operation: cs_ctx_alloc().
检查操作系统参数是否已经修改并重新启动操作系统 (参见安装手册)
若操作系统异常宕机,ASE未启动而$SYBASE/.krg已经存在, 删除该文件
2009/01/01 12:33:04.18 kernel kdconfig: unable to read primary master device
2009/01/01 12:33:04.18 server kiconfig: read of config block failed
Use the ONLINE DATABASE command to bring this database online; SQL Server will
not bring it online automatically.
From the errorlog, here is your problem...
basis_dlock: file 'D:sybasedatamaster.dat' already in use by an ASE
There is already a dataserver running, using this master device. Are you trying to run multiple instances of the
dataserver on one machine? If so then you MUST use different names and network port numbers for each one.
几种常见的情况
首先,应检查Server的日志文件。
不同版本缺省的日志文件如下(其中
UNIX:
$SYBASE/install/errorlog
$SYBASE/install/
$SYBASE_ASE/install/
NT:
$SYBASEinstallerrorlog
$SYBASEASE-12_0installerrorlog
CASE 1:
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
检查server是否已经启动( showserver, ps -u sybase 或NT service )
CASE 2:
dopen: open '/sybase/master.dat' failed, permission denied
kernel kdconfig: unable to read primary master device
kernel kiconfig: read of config block failed
检查master设备文件的所有者及权限
CASE 3:
ninit: All master network listeners have failed. Shutting down
检查network ip 及 port配置 ( netstat -a )
CASE 4:
kernel:kscsinit: connectivity library error. Operation: cs_ctx_alloc().
检查操作系统参数是否已经修改并重新启动操作系统 (参见安装手册)
若操作系统异常宕机,ASE未启动而$SYBASE/
2009/01/01 12:33:04.18 kernel kdconfig: unable to read primary master device
2009/01/01 12:33:04.18 server kiconfig: read of config block failed
Use the ONLINE DATABASE command to bring this database online; SQL Server will
not bring it online automatically.
From the errorlog, here is your problem...
basis_dlock: file 'D:sybasedatamaster.dat' already in use by an ASE
There is already a dataserver running, using this master device. Are you trying to run multiple instances of the
dataserver on one machine? If so then you MUST use different names and network port numbers for each one.
13朵
2个