Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: 10G Intance crashed

Re: 10G Intance crashed

From: Peter McLarty <peter.mclarty_at_pacificdbms.com.au>
Date: Tue, 13 Nov 2007 13:05:39 +1000
Message-Id: <1194923139.6105.11.camel@notebook5.pacificdbms.com.au>


There is patches for ORA-07445 errors on most platforms, have a look at metalink to identify your required patch

Cheers

Peter

On Mon, 2007-11-12 at 10:30 -0500, Khan, Muhammad S wrote:
> Hi DBAs.
>
>
>
>
>
> The instance with Oracle 10g DB on Windows 2003 SP1 box suddenly
> crashed last night with the following error in the alert log file.
>
>
>
> ORA-07445: exception encountered: core dump [ACCESS_VIOLATION]
> [__chkstk+23] [PC:0x1D56927] [ADDR:0x5942AD28] [UNABLE_TO_READ] []
>
>
>
>
>
> When looked into the related trace file, the error is mentioned there
> as below:
>
>
>
> *** SERVICE NAME:(SYS$USERS) 2007-11-10 02:30:14.652
>
> *** SESSION ID:(141.27363) 2007-11-10 02:30:14.652
>
> *** 2007-11-10 02:30:14.652
>
> ksedmp: internal or fatal error
>
> ORA-07445: exception encountered: core dump [ACCESS_VIOLATION]
> [__chkstk+23] [PC:0x1D56927] [ADDR:0x5942AD28] [UNABLE_TO_READ] []
>
> Current SQL statement for this session:
>
> update tsq$ set
> blocks=:3,maxblocks=:4,grantor#=:5,priv1=:6,priv2=:7,priv3=:8 where
> ts#=:1 and user#=:2
>
>
>
> There was almost no user activity at that particular time. Has anyone
> experienced a similar error before?
>
>
>
> Any expert opinion?
>
>
>
>
>
> Thanks,
>
> Khan
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Nov 12 2007 - 21:05:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US