Hi,
we are getting oracle datablock corruption on the SYSTEM tablespace during periods of intense insert / update activity on other tablespaces.
We are running 8.1.6 under Solaris 2.7.
Typical errors in the alert file are ...
--------------------------------------------------------------------
ORA-00602: internalprogramming exception
ORA-07445: exception encountered: core dump [kghsrch()+56][SIGSEGV] [Address
not mapped to object] [4294967288] [] []
Fri Jan 19 21:11:212001
Errors in file/u01/app/oracle/admin/FS75TST/udump/fs75tst_ora_7899.trc:
ORA-01578: ORACLE datablock corrupted (file # 1, block # 13968)
ORA-01110: data file 1:'/u02/oradata/FS75TST/FS75TST_system01.dbf'
ORA-00607: Internal error occurred while making a change to a data block
---------------------------------------------------------------------
Changing the UNIX shmmax parameter from 4GB down to 3.5GB seems to have helped.
Any thoughts
******************************************************************************
This email and any files transmitted with it may be confidential and
are intended solely for the use of the individual or entity to whom
they are addressed. If you have received this email in error, please
notify the sender by return email, and delete this email from your
in-box. Do not copy it to anybody else.
******************************************************************************TXU
From: "Sanjay Kumar"
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
