Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle hangs on startup (9.2 on Win2000)

RE: Oracle hangs on startup (9.2 on Win2000)

From: Sinardy Xing <SinardyXing_at_bkgcomsvc.com>
Date: Tue, 2 Nov 2004 19:13:46 +0800
Message-ID: <7534CC34CD1D9F49BB05A00B9C6F20F401776A67@antares.bcsgroup.com.sg>


Hi Vincent,

Try to restart your database manually from Windows services.

What was the last error?

Sinardy

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Paul Vincent Sent: 02 November 2004 18:58
To: oracle-l_at_freelists.org
Subject: Oracle hangs on startup (9.2 on Win2000)

We're getting a very strange problem with very few symptoms to work =3D from.

It's our policy to take cold backups of our Oracle 9.2 database, which =
=3D

runs on a Win2000 server. Consequently, the Veritas backup job first =3D shuts down Agent, Listener and database, then the backup runs, then the =
=3D

job restarts the database, Listener and Agent.

All the above has worked perfectly well for several months. Until last =
=3D

night... when someone tried to connect to the database, it was apparent =
=3D

that the database was still down. I looked in the event log and found =
=3D

the following:

These were the last lines in the event log. It looks as though the =3D startup of Oracle simply "hung". No error messages, no trace files =3D generated. Nothing, just hanging there.

We tried stopping and restarting the database service, with exactly the =
=3D

same result (the above is pasted from this later attempt, in fact). We =
=3D

tried rebooting the server. Same result. The listener log indicates no =
=3D

problems. But every attempt to startup the database gives the above =3D result.

Any ideas, please?

Paul Vincent
(Desperate) DBA
University of Central England

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

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 02 2004 - 05:09:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US