RE: ORA-07445 immediately after database open

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Thu, 2 Dec 2004 10:27:57 -0500
Message-ID: <AA29A27627F842409E1D18FB19CDCF275A9C1E@AABO-EXCHANGE02.bos.il.pqe>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Paula_Stankus_at_doh.state.fl.us
Sent: Thursday, December 02, 2004 10:17 AM To: jkstill_at_gmail.com
Cc: dgoulet_at_vicr.com; oracle-l_at_freelists.org 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_at_gmail.com]=3D20 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,

>=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

Received on Thu Dec 02 2004 - 09:27:50 CST