Browse oracle-l: This Month's Archive • Main Archive Page • Related posts • Previous by Date • Next by Date

RE: ORA-07445 immediately after database open

From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
To: <Paula_Stankus@xxxxxxxxxxxxxxx>, <jkstill@xxxxxxxxx>
Date: Thu, 2 Dec 2004 10:27:57 -0500

For a quick, clean shutdown, I prefer:
startup force restrict
shutdown

-Mark

Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
Paula_Stankus@xxxxxxxxxxxxxxx
Sent: Thursday, December 02, 2004 10:17 AM
To: jkstill@xxxxxxxxx
Cc: dgoulet@xxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: ORA-07445 immediately after database open


Nope,

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

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

$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:



=3D20

-----Original Message-----
From: Jared Still [mailto:jkstill@xxxxxxxxx]=3D20
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,
>=3D20
> Periodically, I see the following type of message in the =
alert.log=3D20
> 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=3D20
> during shutdown/startup so I am not sure it is a problem.  As I
have=3D20
> often found opening TAR's to be frustrating I am not too concerned.
=3D20
> Anyone encounter this issue??
>=3D20
> Errors in file /opt/oracle/admin/leprod/udump/leprod_ora_25892.trc:
> ORA-07445: exception encountered: core dump [0000000100FAAFF8]=3D20
> [SIGSEGV] [Addres s not mapped to object] [0x000000004] [] []
>=3D20
> Thanks,
> Paula
> --
> http://www.freelists.org/webpage/oracle-l
>=3D20


--
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=3D3Ds&i=3D3D17404101&m=3D=
3Dc42
7=3D
47f32
0db
Not spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3D3Dn&i=3D3D17404101&m=3D=
3Dc42
7=3D
47f32
0db
Forget vote:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3D3Df&i=3D3D17404101&m=3D=
3Dc42
7=3D
47f32
0db
------------------------------------------------------
END-ANTISPAM-VOTING-LINKS

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

RE: ORA-07445 immediately after database open

Other related posts: