RE: ORA-07445 immediately after database open

From: <Paula_Stankus_at_doh.state.fl.us>
Date: Thu, 2 Dec 2004 10:17:00 -0500
Message-ID: <E518A02B320C8D4E97D99A8C546480210251C18F@dohsmailhq01.doh.ad.state.fl.us>

Nope,

However, there is a trace file in the udump directory. =20

My guess is that it relates to the fact that we do the shutdown immediate wait a period of time then=20

$ORACLE_HOME/bin/sqlplus "/ as sysdba" << EOD alter system checkpoint;
alter system checkpoint;
shutdown abort;
exit
EOD: ...and that at the same time there is a process/session running:

=20

-----Original Message-----
From: Jared Still [mailto:jkstill_at_gmail.com]=20 Sent: Thursday, December 02, 2004 9:15 AM To: Stankus, Paula G
Cc: dgoulet_at_vicr.com; oracle-l_at_freelists.org Subject: Re: ORA-07445 immediately after database open

Is there an OS error in the alert.log?

If would in the next few lines following the ORA-7445.

Jared

On Wed, 1 Dec 2004 21:18:59 -0500, paula_stankus_at_doh.state.fl.us <paula_stankus_at_doh.state.fl.us> wrote:
> Guys,

>=20

> Periodically, I see the following type of message in the alert.log=20
> usually after a database open. We are running 9.2.0.4 and from what I

> am seeing on Metalink this may be due to a bug during shutdown/startup

> that isn't resolved until 10i. It doesn't appear to occur except=20
> during shutdown/startup so I am not sure it is a problem. As I have=20
> often found opening TAR's to be frustrating I am not too concerned. =20
> Anyone encounter this issue??

>=20

> Errors in file /opt/oracle/admin/leprod/udump/leprod_ora_25892.trc:
> ORA-07445: exception encountered: core dump [0000000100FAAFF8]=20
> [SIGSEGV] [Addres s not mapped to object] [0x000000004] [] []

>=20

> Thanks,
> Paula
> --
> http://www.freelists.org/webpage/oracle-l
>=20

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist


BEGIN-ANTISPAM-VOTING-LINKS
------------------------------------------------------
Teach CanIt if this mail (ID 17404101) is spam:
Spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D17404101&m=3Dc427=
47f32
0db
Not spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D17404101&m=3Dc427=
47f32
0db
Forget vote:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D17404101&m=3Dc427=
47f32
0db
------------------------------------------------------
END-ANTISPAM-VOTING-LINKS

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Dec 02 2004 - 09:20:33 CST