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@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of
Paula_Stankus@(protected)
Sent: Thursday, December 02, 2004 10:17 AM
To: jkstill@(protected)
Cc: dgoulet@(protected); oracle-l@(protected)
Subject: RE: ORA-07445 (See ORA-07445.ora-code.com) 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@(protected)]=3D20
Sent: Thursday, December 02, 2004 9:15 AM
To: Stankus, Paula G
Cc: dgoulet@(protected); oracle-l@(protected)
Subject: Re: ORA-07445 (See ORA-07445.ora-code.com) immediately after database open
On Wed, 1 Dec 2004 21:18:59 -0500, paula_stankus@(protected)
<paula_stankus@(protected) > 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 (See ORA-07445.ora-code.com): 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
