Re: 8.1.6 datablock corruption

From: paquette stephane <stephane_paquette_at_yahoo.com>
Date: Thu, 25 Jan 2001 00:20:28 -0800 (PST)
Message-Id: <10752.127440@fatcity.com>

We have 816/ solaris 27, all tbs are locally managed except system. shmmax is at 4G.
We have a loading phase but I do not considered it intensive and we have no problem.

What do you call intense insert/update ?

• Stephen.Jirik_at_txu.com.au a écrit :
  <HR>
  

<br><font size=2 face="sans-serif">Hi,</font>
<br>
<br><font size=2 face="sans-serif">we are getting
oracle datablock corruption on the SYSTEM tablespace during periods of intense insert / update activity on other tablespaces.</font>
<br>
<br><font size=2 face="sans-serif">We are running
8.1.6 under Solaris 2.7.</font>
<br>
<br><font size=2 face="sans-serif">Typical errors in
the alert file are ...</font>
<br><font size=2

face="sans-serif">--------------------------------------------------------------------</font>

<br><font size=2 face="sans-serif">ORA-00602:
internalprogramming exception</font>
<br><font size=2 face="sans-serif">ORA-07445:
exception encountered: core dump
[kghsrch()+56][SIGSEGV] [Address </font>
<br><font size=2 face="sans-serif">not mapped to
object] [4294967288] [] []</font>
<br><font size=2 face="sans-serif">Fri Jan 19
21:11:212001</font>
<br><font size=2 face="sans-serif">Errors in
file/u01/app/oracle/admin/FS75TST/udump/fs75tst_ora_7899.trc:</font>
<br><font size=2 face="sans-serif">ORA-01578: ORACLE
datablock corrupted (file # 1, block # 13968)</font>
<br><font size=2 face="sans-serif">ORA-01110: data
file
1:'/u02/oradata/FS75TST/FS75TST_system01.dbf'</font>
<br><font size=2 face="sans-serif">ORA-00607: Internal
error occurred while making a change to a data block</font>
<br><font size=2

face="sans-serif">---------------------------------------------------------------------</font>

<br>
<br><font size=2 face="sans-serif">Changing the UNIX
shmmax parameter from 4GB down to 3.5GB seems to have helped.</font>
<br>
<br><font size=2 face="sans-serif">Any thoughts</font>
<br>
<br>
<CODE><FONT SIZE=3><BR>
<BR>

******************************************************************************<BR>

This email and any files transmitted with it may be confidential and <BR>
are intended solely for the use of the individual or entity to whom <BR>
they are addressed. If you have received this email in error, please <BR>
notify the sender by return email, and delete this email from your <BR>
in-box. Do not copy it to anybody else.<BR>

******************************************************************************TXU<BR>

</FONT></CODE>

-- 
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
-- 
Author: 
  INET: Stephen.Jirik_at_txu.com.au

Fat City Network Services    -- (858) 538-5051  FAX:
(858) 538-5051
San Diego, California        -- Public Internet access
/ Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an
E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of
'ListGuru') and in
the message BODY, include a line containing: UNSUB
ORACLE-L
(or the name of mailing list you want to be removed
from).  You may
also send the HELP command for other information (like
subscribing).


=====
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com

__________________________________________________
Do You Yahoo!?

Received on Thu Jan 25 2001 - 02:20:28 CST