免费注册 查看新帖 |

Chinaunix

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

请高手指点:我的sybase出问题了! [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2004-05-26 16:18 |只看该作者 |倒序浏览
我装在sco unixware上的sybase数据库出状况了
所有的系统存储过程都用不了了,运行sp_help go 之类的就死在那里了!
强行退出之后,发现shutdown,dump都不行了!
请教是什么原因,该如何解决??

论坛徽章:
0
2 [报告]
发表于 2004-05-27 09:16 |只看该作者

请高手指点:我的sybase出问题了!

看看errorlog,把错误拿上来。否则怎么知道什么状况

论坛徽章:
1
操作系统版块每日发帖之星
日期:2016-06-20 06:20:00
3 [报告]
发表于 2004-05-27 09:31 |只看该作者

请高手指点:我的sybase出问题了!

怀疑是tempdb的问题

论坛徽章:
0
4 [报告]
发表于 2004-05-27 17:32 |只看该作者

请高手指点:我的sybase出问题了!

00:00000:00000:2004/05/12 10:55:03.81 kernel  Using config area from primary master device.
00:00000:00000:2004/05/12 10:55:03.81 kernel  Warning: Using default file '/home/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:2004/05/12 10:55:03.82 kernel  Using 400 file descriptors.
00:00000:00000:2004/05/12 10:55:03.82 kernel  Adaptive Server Enterprise/11.9.2/P/DG AViiON/SCO UnixWare 2.1.3/FBO/Tue Jul  6 08:52:13 1999
00:00000:00000:2004/05/12 10:55:03.82 kernel  Confidential property of Sybase, Inc.
00:00000:00000:2004/05/12 10:55:03.82 kernel  Copyright 1987, 1999
00:00000:00000:2004/05/12 10:55:03.82 kernel  Sybase, Inc.  All rights reserved.
00:00000:00000:2004/05/12 10:55:03.82 kernel  Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2004/05/12 10:55:03.82 kernel  
00:00000:00000:2004/05/12 10:55:03.82 kernel  This software contains confidential and trade secret information of Sybase,
00:00000:00000:2004/05/12 10:55:03.82 kernel  Inc.   Use,  duplication or disclosure of the software and documentation by
00:00000:00000:2004/05/12 10:55:03.82 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
00:00000:00000:2004/05/12 10:55:03.82 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
00:00000:00000:2004/05/12 10:55:03.82 kernel  agreement  specifying  the  Government's rights to use the software and any
00:00000:00000:2004/05/12 10:55:03.82 kernel  applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2004/05/12 10:55:03.82 kernel  Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2004/05/12 10:55:03.82 kernel  Using '/home/sybase/SYBASE.cfg' for configuration information.
00:00000:00000:2004/05/12 10:55:03.82 kernel  Logging SQL Server messages in file '/home/sybase/install/errorlog'.
00:00000:00000:2004/05/12 10:55:03.82 kernel  kscsinit: connectivity library error. Operation: cs_ctx_alloc().
00:00000:00000:2004/05/12 11:04:05.44 kernel  Using config area from primary master device.
00:00000:00000:2004/05/12 11:04:05.50 kernel  Warning: Using default file '/home/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:2004/05/12 11:04:05.53 kernel  Using 400 file descriptors.
00:00000:00000:2004/05/12 11:04:05.53 kernel  Adaptive Server Enterprise/11.9.2/P/DG AViiON/SCO UnixWare 2.1.3/FBO/Tue Jul  6 08:52:13 1999
00:00000:00000:2004/05/12 11:04:05.54 kernel  Confidential property of Sybase, Inc.
00:00000:00000:2004/05/12 11:04:05.54 kernel  Copyright 1987, 1999
00:00000:00000:2004/05/12 11:04:05.55 kernel  Sybase, Inc.  All rights reserved.
00:00000:00000:2004/05/12 11:04:05.55 kernel  Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2004/05/12 11:04:05.56 kernel  
00:00000:00000:2004/05/12 11:04:05.56 kernel  This software contains confidential and trade secret information of Sybase,
00:00000:00000:2004/05/12 11:04:05.57 kernel  Inc.   Use,  duplication or disclosure of the software and documentation by
00:00000:00000:2004/05/12 11:04:05.57 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
00:00000:00000:2004/05/12 11:04:05.58 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
00:00000:00000:2004/05/12 11:04:05.58 kernel  agreement  specifying  the  Government's rights to use the software and any
00:00000:00000:2004/05/12 11:04:05.59 kernel  applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2004/05/12 11:04:05.59 kernel  Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2004/05/12 11:04:05.60 kernel  Using '/home/sybase/SYBASE.cfg' for configuration information.
00:00000:00000:2004/05/12 11:04:05.60 kernel  Logging SQL Server messages in file '/home/sybase/install/errorlog'.
00:00000:00000:2004/05/12 11:04:05.75 kernel  Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2004/05/12 11:04:05.76 kernel  Network and device connection limit is 390.
00:00000:00000:2004/05/12 11:04:05.79 server  Number of proc buffers allocated: 741.
00:00000:00000:2004/05/12 11:04:05.83 kernel  dioinit: Unable to lock memory for async I/O
00:00000:00000:2004/05/12 11:04:05.84 server  Proc header memory allocated 370 pages for each per engine cache
00:00000:00000:2004/05/12 11:04:05.84 server  Number of blocks left for proc headers: 789.
00:00000:00000:2004/05/12 11:04:05.85 server  Memory allocated for the default data cache cache: 5544 Kb
00:00000:00000:2004/05/12 11:04:05.86 server  Size of the 2K memory pool: 5544 Kb
00:00000:00000:2004/05/12 11:04:05.87 kernel  Initializing virtual device 0, '/home/sybase/data/masterdev'
00:00000:00000:2004/05/12 11:04:05.88 kernel  Virtual device 0 started using standard unix i/o.
00:00000:00000:2004/05/12 11:04:05.89 kernel  Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2004/05/12 11:04:05.89 kernel  Either the config parameter 'use security services' is set to 0, or ASE does not support use of external security mechanisms on this platform. The Security Control Layer will not be initialized. No external security mechanisms will be supported.
00:00000:00000:2004/05/12 11:04:05.90 kernel  engine 0, os pid 1688  online
00:00000:00000:2004/05/12 11:04:05.91 server  No active traceflags
00:00000:00001:2004/05/12 11:04:05.92 server  Opening Master Database ...
00:00000:00001:2004/05/12 11:04:06.03 server  Loading SQL Server's default sort order and character set
tli_ninit: sninteraface: machname /dev/tcp, netname tcp
00:00000:00002:2004/05/12 11:04:06.05 kernel  ninit:0: listener type: master
00:00000:00002:2004/05/12 11:04:06.05 kernel  ninit:0: listener endpoint: /dev/tcp
00:00000:00002:2004/05/12 11:04:06.06 kernel  ninit:0: listener raw address: \x00021388c0a802fb0000000000000000
00:00000:00002:2004/05/12 11:04:06.07 kernel  ninit:0: transport provider: T_COTS_ORD
00:00000:00001:2004/05/12 11:04:06.08 server  Recovering database 'master'
00:00000:00001:2004/05/12 11:04:06.17 server  Redo pass of recovery has processed 2 committed and 0 aborted transactions.
00:00000:00001:2004/05/12 11:04:06.20 server  Database 'master' is now online.
00:00000:00001:2004/05/12 11:04:06.20 server  The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2004/05/12 11:04:06.21 server  0 dump conditions detected at boot time
00:00000:00001:2004/05/12 11:04:06.22 server  server is unnamed
00:00000:00001:2004/05/12 11:04:06.26 server  Recovering database 'model'.
00:00000:00001:2004/05/12 11:04:06.28 server  The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2004/05/12 11:04:06.29 server  Database 'model' is now online.
00:00000:00001:2004/05/12 11:04:06.29 server  Clearing temp db
00:00000:00001:2004/05/12 11:04:06.41 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2004/05/12 11:04:06.41 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2004/05/12 11:04:06.42 server  Database 'tempdb' is now online.
00:00000:00001:2004/05/12 11:04:06.42 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2004/05/12 11:04:06.43 server  Recovery complete.
00:00000:00001:2004/05/12 11:04:06.43 server  SQL Server's default sort order is:
00:00000:00001:2004/05/12 11:04:06.44 server          'bin_iso_1' (ID = 50)
00:00000:00001:2004/05/12 11:04:06.44 server  on top of default character set:
00:00000:00001:2004/05/12 11:04:06.44 server          'iso_1' (ID = 1).
00:00000:00001:2004/05/12 11:04:06.45 server  Loaded default Unilib conversion handle.
00:00000:00001:2004/05/12 11:09:08.84 server  SQL Server shutdown by request.
00:00000:00001:2004/05/12 11:09:08.84 kernel  ueshutdown: exiting

这个是errorlog的内容拉!
大家帮我看看是什么问题!为什么会是tempdb的问题啊?

论坛徽章:
1
操作系统版块每日发帖之星
日期:2016-06-20 06:20:00
5 [报告]
发表于 2004-05-28 09:11 |只看该作者

请高手指点:我的sybase出问题了!

没有sybsystemprocs这个库,系统存储过程怎么执行?

论坛徽章:
4
2015年亚洲杯之阿联酋
日期:2015-03-10 10:32:022015年亚洲杯之阿曼
日期:2015-03-10 14:53:222015亚冠之水原三星
日期:2015-07-18 15:40:262015亚冠之塔什干棉农
日期:2015-07-27 20:52:05
6 [报告]
发表于 2004-05-28 09:18 |只看该作者

请高手指点:我的sybase出问题了!

论坛徽章:
0
7 [报告]
发表于 2004-05-28 10:09 |只看该作者

请高手指点:我的sybase出问题了!

当然有sybsystemprocs这个库啦!我还特别通过master里面了sysdatabases表查到了那个库!
问题好像不是出在这里,还请高手指点究竟!

论坛徽章:
0
8 [报告]
发表于 2004-05-28 10:13 |只看该作者

请高手指点:我的sybase出问题了!

哦,对了,我还忘记说了一点很重要的:数据库除了系统存储过程出了问题,其他的好像都正常的哦!所以更搞不懂是什么原因了!

论坛徽章:
0
9 [报告]
发表于 2004-05-28 14:02 |只看该作者

请高手指点:我的sybase出问题了!

重建sybsystemprocs

论坛徽章:
0
10 [报告]
发表于 2004-05-28 14:11 |只看该作者
提示: 作者被禁止或删除 内容自动屏蔽
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

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

清除 Cookies - ChinaUnix - Archiver - WAP - TOP