免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 1692 | 回复: 3
打印 上一主题 下一主题

sybase的启动问题,急,在线等 [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2003-12-04 23:14 |只看该作者 |倒序浏览
sybase启动时不断翻滚着出现下列提示:
here are fewer active users, or ask your System Administrator to reconfigure SQL Server with more user connections.
00:00000:00002:2003/12/04 22:48:49.76 server  Error: 1601, Severity: 21, State: 3
00:00000:00002:2003/12/04 22:48:49.76 server  There are not enough 'user connections' available to start a new process. Retry when there are fewer active users, or ask your System Administrator to reconfigure SQL Server with more user connections.
不能正常启动,这是什么原因?请指出如何解决

论坛徽章:
0
2 [报告]
发表于 2003-12-05 00:27 |只看该作者

sybase的启动问题,急,在线等

把使用数据库的程序关掉后,sybase可以起来了,但有如下提示
0:00000:00001:2003/12/04 23:31:23.24 server  Error: 926, Severity: 14, State: 1
00:00000:00001:2003/12/04 23:31:23.24 server  Database 'sybsystemprocs' cannot be opened. An earlier attempt at recovery marked it 'suspect'. Check the SQL Server errorlog for information as to the cause.
00:00000:00001:2003/12/04 23:31:23.61 server  Unable to proceed with the recovery of dbid <4>; because of previous errors.  Continuing with the next database.
00:00000:00001:2003/12/04 23:31:23.61 server  System stored procedures are not currently accessible due to a recovery error. Please consult the errorlog. You may need to drop and re-create the sybsystemprocs database and re-run the installmaster SQL script if the error is unrecoverable.
00:00000:00001:2003/12/04 23:31:23.61 server  Error: 926, Severity: 14, State: 1
00:00000:00001:2003/12/04 23:31:23.61 server  Database 'media' cannot be opened. An earlier attempt at recovery marked it 'suspect'. Check the SQL Server errorlog for information as to the cause.
00:00000:00001:2003/12/04 23:31:24.01 server  Unable to proceed with the recovery of dbid <6>; because of previous errors.  Continuing with the next database.
00:00000:00001:2003/12/04 23:31:24.01 server  Recovery complete.

论坛徽章:
0
3 [报告]
发表于 2003-12-05 00:29 |只看该作者

sybase的启动问题,急,在线等

日志提示如下:
00:00000:00002:2003/12/04 17:19:54.48 kernel  b_stliopt_generic: t_alloc failed: Protocol error.
00:00000:00002:2003/12/04 17:19:54.50 kernel  fd = 40
03:00000:00056:2003/12/04 18:57:26.70 server  Space available in the log segment has fallen critically low in database 'media'
.  All future modifications to this database will be suspended until the log is successfully dumped and space becomes available.
03:00000:00105:2003/12/04 18:57:26.82 server  Error: 2812, Severity: 16, State: 5
03:00000:00105:2003/12/04 18:57:26.82 server  Stored procedure 'sp_thresholdaction' not found. Specify owner.objectname or use sp_he
lp to check whether the object exists (sp_help may produce lots of output).
00:00000:00063:2003/12/04 19:04:54.90 server  Error: 1608, Severity: 18, State: 4
00:00000:00063:2003/12/04 19:04:54.90 server  A client process exited abnormally, or a network error was encountered. Unless other e
rrors occurred, continue processing normally.
00:00000:00156:2003/12/04 19:09:10.54 server  Error: 1608, Severity: 18, State: 4
00:00000:00156:2003/12/04 19:09:10.54 server  A client process exited abnormally, or a network error was encountered. Unless other e
rrors occurred, continue processing normally.
00:00000:00142:2003/12/04 19:12:25.49 server  Error: 1608, Severity: 18, State: 4
00:00000:00142:2003/12/04 19:12:25.49 server  A client process exited abnormally, or a network error was encountered. Unless other e
rrors occurred, continue processing normally.
00:00000:00035:2003/12/04 19:13:08.93 server  Error: 1608, Severity: 18, State: 4
00:00000:00035:2003/12/04 19:13:08.93 server  A client process exited abnormally, or a network error was encountered. Unless other e
rrors occurred, continue processing normally.
00:00000:00002:2003/12/04 19:14:45.72 server  Error: 1601, Severity: 21, State: 3
00:00000:00002:2003/12/04 19:14:45.72 server  There are not enough 'user connections' available to start a new process. Retry when t
here are fewer active users, or ask your System Administrator to reconfigure SQL Server with more user connections.

该怎么解决?

论坛徽章:
0
4 [报告]
发表于 2003-12-05 00:58 |只看该作者

sybase的启动问题,急,在线等

配置更多的用户连接数,注意你的操作系统中对用户的可用文件句柄的限制 。
消除数据库挂起问题:
使用update sysdatabases  set status = -32768 Where name="databasename"  然后,shutdown Server ,Restart Server,
接着,update sysdatabases set status=0 Where name="databasename',最后,checkpoint数据库的option!

   
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP