8.1.6 datablock corruption

From: <Stephen.Jirik_at_txu.com.au>
Date: Thu, 25 Jan 2001 11:46:38 +1100
Message-Id: <10751.127428@fatcity.com>

<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>

---

 From: "Sanjay Kumar" <ora_user_at_hotmail.com>  Date: Wed, 24 Jan 2001 16:59:58 -0800
 Subject: ORA - 01053

This is a multi-part message in MIME format.

------=_NextPart_000_0007_01C08627.157D3EB0 Content-Type: text/plain;

        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

What needs to be done to resolve this error.

ORA-01053 user storage address cannot be read

Cause: A bind variable or other user area could not be read by Oracle.=20

Action: Check that binds are done correctly on valid user buffers, then = retry the operation.=20 Received on Wed Jan 24 2001 - 18:46:38 CST