FAQ
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

Search Discussions

  • Paquette stephane at Jan 25, 2001 at 8:20 am
    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 :

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

    face="sans-serif">--------------------------------------------------------------------

    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

    face="sans-serif">---------------------------------------------------------------------

    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

    --
    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!?
  • Yong huang at Jan 25, 2001 at 4:43 pm
    Hi, Stephen,

    This is interesting. For our information, could you tell us more about your
    system? How much memory do you have? Your shared_pool_size, db_block_size and
    db_block_buffers. Any hidden parameter in your init.ora such as _use_ism?

    I ask all these because 8.1.6 Oracle installation guide says setting shmmax to
    4G regardless of anything, while in previous versions it is more conservative
    and says setting to 2G or based on some calculation (I don't remember which).

    Yong Huang
    yong321_at_yahoo.com

    you wrote:

    we are getting oracle datablock corruption on the SYSTEM tablespace during
    perio
    ds 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

    Do You Yahoo!?
    Yahoo! Auctions - Buy the things you want at great prices.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedJan 25, '01 at 12:46a
activeJan 25, '01 at 4:43p
posts3
users3
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase