Home » RDBMS Server » Server Administration » ORA-1033 error initialization or shutdown in progress (oracle 10g)
ORA-1033 error initialization or shutdown in progress [message #554617] Wed, 16 May 2012 00:47 Go to next message
harshitaankur
Messages: 19
Registered: April 2012
Location: Delhi
Junior Member
Hello sir

I have oracle 10g as well as oracle 8i on my server. currently we are using oracle 10g. now we get the following error when we try to connect to oracl 10g database.

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\omni>cd\
C:\>sqlplus\nolog
The system cannot find the path specified.
C:\>sqlplus/nolog
SQL*Plus: Release 8.1.5.0.0 - Production on Tue May 15 16:39:13 2012
(c) Copyright 1999 Oracle Corporation. All rights reserved.
SQL> connect sys/admin as sysdba
Connected to an idle instance.
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup nomount;
LRM-00109: could not open parameter file 'D:\oro8i\DATABASE\INIT.ORA'
ORA-01078: failure in processing system parameters

Sir ,
The location of pfile of oracle 10g database is
c:/oracle/product/10.0.0.1/admin/pfile.

Please tell me sir how to resolve this error.

Thanks in anticipation
Re: ORA-1033 error initialization or shutdown in progress [message #554621 is a reply to message #554617] Wed, 16 May 2012 00:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
startup ... pfile=...
Please read Administrator's Guide.

But what do you want to start a 10g database from a 8i client version?

Regards
Michel

[Updated on: Wed, 16 May 2012 01:01]

Report message to a moderator

Re: ORA-1033 error initialization or shutdown in progress [message #554631 is a reply to message #554621] Wed, 16 May 2012 01:16 Go to previous messageGo to next message
harshitaankur
Messages: 19
Registered: April 2012
Location: Delhi
Junior Member
NO sir,

I want to start a10g database from a 10g server version
Re: ORA-1033 error initialization or shutdown in progress [message #554633 is a reply to message #554631] Wed, 16 May 2012 01:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is not what your session shows:
Quote:
SQL*Plus: Release 8.1.5.0.0 -


Regards
Michel
ORA-1033 error initialization or shutdown in progress [message #580225 is a reply to message #554617] Thu, 21 March 2013 09:54 Go to previous messageGo to next message
tanmoypalit007
Messages: 1
Registered: March 2013
Location: Bolpur
Junior Member

Shocked This is cause of Illegal Shutdown of ORACLE Shocked
So it may help you to recover
Try out following.
Open Dos command Prompt
and move to parent directory
c:> sqlplus /nolog
sql> connect sys/manager as sysdba
sql>shutdown immediate
sql> startup
sql> exit
Please Note down the parameters and update in initSID.ora file.
Tanmoy Laughing
Re: ORA-1033 error initialization or shutdown in progress [message #580226 is a reply to message #580225] Thu, 21 March 2013 10:04 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Welcome to the forum.
Please take time to read OraFAQ Forum Guide.

Note this is a professional forum and not a social, so limit the usage of emoticon.
Also, you might answer to newer question (without mentioning that you ask OP to do almost exactly what he did).

Regards
Michel
Previous Topic: ORA-01652
Next Topic: regarding to required_mirror_free_mb
Goto Forum:
  


Current Time: Thu Mar 28 05:38:38 CDT 2024