紧急求助！！！！sybase 11.9.2数据库不能打开！！！

zhang168869

各位大侠！！！
　　　我的sybase 11.9.2 运行desdit程序ＰＩＮＧ命令服务端是成功的，sybase服务也是启动的，但在客户端运行程序报如下错误：
　　“Database "xlshop" is currently offline.Please wait and try your command again later.

求各位大侠给予支持！！！小弟谢谢了！！！

附：sybase错误日志

chuxu

online database  xlshop

zhang168869

各位大侠：
　　我的sybase 11.9.2数据库脱机了，不能使用，操作系统是sco operserver5.0.5 ,请那位帮忙给一下详细的ＯＮＬＩＮＥ方法，使数据库联机正常使用！！小弟在这儿谢了！！！！！！

REDMOB

online database dbname

zhang168869

各位大侠，我ＯＮＬＩＮＥ数据库后，报如下错误，请问如何处理？？？
00:05/07/17 17:41:10.86 kernel  SQL causing error : online database xlshop

00:05/07/17 17:41:10.86 kernel  curdb = 5 pstat = 0x10000 lasterror = 834
00:05/07/17 17:41:10.86 kernel  preverror = 0 transtate = 1
00:05/07/17 17:41:10.86 kernel  curcmd = 10 program = isql                          
00:05/07/17 17:41:10.87 kernel  pc: 0x2e4b85 ucbacktrace+0x55(0x0,0x1,0x801750f0,0x4,0x22)
00:05/07/17 17:41:10.87 kernel  pc: 0x27bf terminate_process+0x33f(0x0,0xffffffff,0x80175094,0xf0c93,0x801750f0)
00:05/07/17 17:41:10.87 kernel  pc: 0xf0d60 close_network+0x10(0x801750f0,0x0,0x801750bc,0xe261f,0x
00:05/07/17 17:41:10.87 kernel  pc: 0xf0c93 hdl_default+0x23(0x8,0x22,0x14,0x4,0x801750f0)
00:05/07/17 17:41:10.87 kernel  pc: 0xe261f s_handle+0x5af(0x8,0x22,0x14,0x4,0x801750f0)
00:05/07/17 17:41:10.87 kernel  pc: 0xf0b8d ex_raise+0x17d(0x8,0x22,0x14,0x4,0x98a7df60)
00:05/07/17 17:41:10.87 kernel  pc: 0x3cb45 cm_dbclean___1+0x12d(0x82a3a7a0,0x5,0x80170014,0x828f26e0,0x27)
00:05/07/17 17:41:10.87 kernel  pc: 0x3468e buf_online_database+0x9e(0x828f26e0,0x44cfb,0x0,0x83ed43d4,0x80170002)
00:05/07/17 17:41:10.87 kernel  pc: 0x15b597 onl_online_db___1+0x107(0x81e729e8,0x83ed43d4,0x83ed43d4,0x83ed43d4,0x83ed43d4)
00:05/07/17 17:41:10.87 kernel  pc: 0x15b09a online_database+0x17a(0x83ed43d4,0xd5645,0xffff00ff,0x81e729e8,0x1)
00:05/07/17 17:41:10.87 kernel  pc: 0xd7637 s_execute+0x2317(0x81e729e8,0x81e729e8,0x801753c4,0x0,0x2)
00:05/07/17 17:41:10.87 kernel  [Handler pc: 0xe2070 s_handle(num=0, sev=0) installed by the following function]
00:05/07/17 17:41:10.87 kernel  pc: 0xdfa70 sequencer+0xc70(0x83edc800,0x290c33,0xffffffff,0x4,0x80)
00:05/07/17 17:41:10.87 kernel  pc: 0x21ff4f tdsrecv_language+0x31f(0x0,0x1,0x0,0x0,0x0)
00:05/07/17 17:41:10.87 kernel  [Handler pc: 0xf0c50 hdl_backout(num=3600, sev=25) installed by the following function]
00:05/07/17 17:41:10.87 kernel  [Handler pc: 0x173a30 ut_handle(num=700, sev=0) installed by the following function]
00:05/07/17 17:41:10.87 kernel  pc: 0x20b3a6 conn_hdlr+0x16b6(0x1,0x801756c0,0x6a006a,0x0,0x0)
00:05/07/17 17:41:10.87 kernel  pc: 0x2f8e30 kpexit(0x0,0x0,0x5374616b,0x0,0x0)
00:05/07/17 17:41:10.88 kernel  pc: 0x6a006a frexp+0x346236(0x5374616b,0x0,0x0,0x0,0x0)
00:05/07/17 17:41:10.88 kernel  end of stack trace, spid 7, kpid 2359332, suid 0

hiaw

各位老大,他的数据库不能online是因为625错误,错误日志发在另外一篇帖子里了,这位仁兄一连发了三篇相同的帖子....


Error 625
Severity 21
Message text Could not retrieve row from logical page %ld via RID
because the entry in the offset table for that RID is
less than or equal to 0.
Note This error may be caused by a hardware problem.
Explanation Every row in a database has a unique row ID (RID). The two parts of a row ID
are a logical page number and a row number. The row number part of row IDs
are stored at the end of every data page and indicate where a certain row is
located on that page.
Commands that use row IDs include dbcc checkdb, dbcc checktable, and dbcc
checkcatalog. They verify the consistency of indexes and use the rowIDs stored
in nonclustered indexes to quickly access the data rows.
Error 625 occurs when Adaptive Server tries to retrieve a row from a data page
by specifying the row ID and it fails because the requested row ID has an illegal
value (smaller than or equal to zero).
This error can occur under the following conditions:
• The data page of a nonclustered index is corrupt.
• Hardware failure.
Errors 624 and 625 occur under similar conditions.
Action Examine your operating system error log file and the Adaptive Server error log
to determine if hardware errors may have corrupted your database devices.
Refer to Chapter 2, “How to Find an Object Name from a Page Number” for
instructions about how to use the dbcc page command to determine the table
and the index involved. Save this information and use it in the appropriate
section that follows.
CHAPTER 3 Error Message Writeups
189
The specific action you take depends on whether or not you know which index
or query caused the problem. In general, dropping and re-creating the index
will resolve the index corruption.
Index Unknown, Query Known
If you do not know which index is causing the problem, but you do know which
query encounters the problem, use this section to correct it. If you do not know
the index or query, use the next section.
1 Determine which index should be dropped by reading the showplan output
for the query that encounters the error and determining which
nonclustered index the query is using to access the table in question.
Turn on showplan and use the no execute mode:
1>; set showplan on
2>; go
1>; set noexec on
2>; go
Enter the query that was causing the problem. For example:
1>; select title from titles where title >; "Cooking"
2>; go
STEP 1
The type of query is SELECT
FROM TABLE
titles
Nested iteration
Index: titleind
Turn showplan and the no execute mode off again:
1>; set noexec off
2>; go
1>; set showplan off
2>; go
2 If the index identified in step 1 is on a system table (object ID is less than
100), refer to Chapter 2, “Howto Fix a Corrupted Index on System Tables”
for instructions on how to repair the system table index.
3 Otherwise, drop and re-create the index identified in step 1 (in this
example “titleind”).
If this did not clear the error, create a clustered index on the table or drop
and re-create the existing clustered index. Note that creating a clustered
index requires an amount of space equal to 120 percent to 150 percent of
the size of the table where you want to create the index.
Error 625
190
Both Index and Query Unknown
If you do not know either the index or the query, rebuild all nonclustered
indexes on the table using the instructions in this section.
1 Look at the dbcc page output you obtained earlier.
2 If the object is a system table (object ID is less than 100), refer to Chapter
2, “How to Fix a Corrupted Index on System Tables” for instructions on
repairing the system table index. Then go to step 4.
3 For a user table (object ID is 100 or greater), use sp_helpindex to list all
indexes on the table, and then rebuild all the nonclustered indexes using
one of two methods:
• Drop and re-create each nonclustered index on the table.
Or:
• If a clustered index also exists on the table, drop and re-create it,
which causes all nonclustered indexes to be automatically rebuilt. If
your table is large, you may not have the space to do this (a rough rule
of thumb is 120 percent to 150 percent of your table size must be
available).
If the above methods did not clear the error, create a clustered index on the
table (if space is available). You may then drop the clustered index.
4 Run dbcc checktable on the table to confirm that the problem has been
resolved.
Additional information For more information, refer to “create database” in the ASE Reference Manual.
If you need to call Technical Support for assistance, have the following
documentation ready:
• Adaptive Server version and SWR version level
• Adaptive Server error log
• Text of all error messages
• select * from master..sysusages output
Version in which this
error is raised
All versions

各位老大再替他想想解决方案吧

guest_client

解决没？？

zhang168869

谢谢各位大侠，我重启我的机器后，sybase 11.9.2发生了奇迹，现在能打开了，真的很奇怪！！！！

hiaw

很有可能是由硬件问题引起的.
还是检查一下你的硬件吧.

1017of

如果是625error，好象不是很严重吧，具体要看发生在哪一页上