Sybase数据库启动失败的原因

2013-08-22   来源:站长日记       编辑:沧海桑田   类别:数据库    转载到:    发表评论

应检查Server的日志文件。不同版本缺省的日志文件如下(其中为Sybase Server的名称:

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.

13

2
13|2 | 鲜花 VS 砸蛋 | 107阅读 0评论
 
不想登录?直接点击发布即可作为游客留言。
昵称  邮箱 网站 验证码 = 1+1