Re: 10G Intance crashed
- From: Peter McLarty <peter.mclarty@xxxxxxxxxxxxxxxxxx>
- To: Muhammad.Khan@xxxxxx
- Date: Tue, 13 Nov 2007 13:05:39 +1000
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
>
>
>
>
Other related posts:
