RE: ORA-07445 immediately after database open

  • From: <Paula_Stankus@xxxxxxxxxxxxxxx>
  • To: <jkstill@xxxxxxxxx>
  • Date: Thu, 2 Dec 2004 10:17:00 -0500

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@xxxxxxxxx]=20
Sent: Thursday, December 02, 2004 9:15 AM
To: Stankus, Paula G
Cc: dgoulet@xxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxxx
<paula_stankus@xxxxxxxxxxxxxxx> 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
> --
> //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

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

Other related posts: