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: Igor Neyman <ineyman_at_perceptron.com>
Date: Tue, 2 Nov 2004 09:22:08 -0500
Message-ID: <001601c4c0e7$563b1ef0$2004a8c0@development.perceptron.com>


Paul,

Try to break "startup" (in sqlplus) into 2 steps:

Startup mount exclusive pfile=<your_init_file_full_path>; alter database open;

May be you'll get more specific error.

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Paul Vincent Sent: Tuesday, November 02, 2004 7:10 AM To: Niall Litchfield
Cc: oracle-l_at_freelists.org; Simon Baker
Subject: RE: Oracle hangs on startup (9.2 on Win2000)

Niall,

I've annotated the responses I obtained below. Not very encouraging, I'm afraid!

> On Tue, 2 Nov 2004 11:19:55 -0000, Paul Vincent=20
> <paul.vincent_at_uce.ac.uk> wrote:
> > One other piece of information: when I try using Oracle=20
> Enterprise =3D
> > Manager to connect to the database (using SYS as SYSDBA),=20
> I go to the =3D
> > "General" tab on Instance/Configuration, and this shows=20
> the database in =3D
> > a "down" state (red traffic light). I then try to open the=20
> database, =3D
> > click Apply, and the "Starting up the database" step fails=20
> with the =3D
> > error:
> >=20
> > "ORA-03113: end-of-file on communication channel"
> >=20
> > Does this shed any more light on the possible cause of the problem?
> >=20
> > Paul

> =20

> Ok in that case I think I would do the manual startup thing.=20
> =20

> at a command window on the server
> oradim -edit -sid <your sid> -startmode manual=20

OK

> -- try to avoid the service trying to start the instance.=20
> then=20
> net start oracleservice<sid>=20
> set oracle_sid=3D<your sid>
> sqlplus /nolog

> =20

> in sqlplus
> connect / as sysdba

Hit a problem here: ORA-01031: insufficient privileges. Instead, I tried CONNECT SYS/password AS SYSDBA, and this worked OK.

> startup

> =20

> you should get the underlying error.=20
> =20

This gave the "ORA-03113: end-of-file on communication channel" error.

One of our sysprogs asked if it might have something to do with the change from BST to GMT, but this seems unlikely since the problem only manifested this morning (2nd November).

Any more ideas, please, Niall? (Or anybody!). I'm feeling thoroughly brushed with the stupid-stick! If not, I can feel a TAR coming on...

Regards,

Paul

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


--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 02 2004 - 08:29:53 CST

Original text of this message

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