OraFAQ Forum: Windows » Error: ORA-01033 ORACLE initialization or shutdown in progress in 9i

Home » Infrastructure » Windows » Error: ORA-01033 ORACLE initialization or shutdown in progress in 9i (

) 1 Vote

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error: ORA-01033 ORACLE initialization or shutdown in progress in 9i [message #403336]

Thu, 14 May 2009 22:29

mahendra.singh
Messages: 3
Registered: May 2009
Location: Bangalore

Junior Member

Error: ORA-01033 ORACLE initialization or shutdown in progress in 9i

Hello i got the same error where can i go and check the log and what is the exact solution .
Even i have started all the services going to Control Panel >administrative tools>services.

username is scott and tiger

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress <=== what is this mean? [message #403338 is a reply to message #403336]

Thu, 14 May 2009 22:37

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

log onto OS as Oracle software owner (usually oracle).
The issue the following EXACTLY into a command window:

sqlplus
/ as sysdba
shutdown abort
startup
select * from v$version;
exit

Now CUT the whole session & PASTE results back here.

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress <=== what is this mean? [message #403342 is a reply to message #403338]

Thu, 14 May 2009 23:15

mahendra.singh
Messages: 3
Registered: May 2009
Location: Bangalore

Junior Member

but i am unable to login
once giving the username and password it throwing this error.

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress <=== what is this mean? [message #403345 is a reply to message #403342]

Thu, 14 May 2009 23:22

Michel Cadot
Messages: 68749
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What is asked to you is to copy and paste what you have.
Just do that, do not comment.

Regards
Michel

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress <=== what is this mean? [message #403346 is a reply to message #403336]

Thu, 14 May 2009 23:27

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>once giving the username and password it throwing this error.
ERROR? What Error? I do not see any error.

Do NOT use GUI interface

Go to command line then use CUT & PASTE so we can see what you see

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress <=== what is this mean? [message #403403 is a reply to message #403346]

Fri, 15 May 2009 06:18

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Note : I have split this into a new topic, and I think I will now lock the old one, since it seems to get dragged out again and again and again since 2002, despite most of what is mentioned in it being seriously outdated.

[Updated on: Fri, 15 May 2009 06:18]

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress <=== what is this mean? [message #403419 is a reply to message #403403]

Fri, 15 May 2009 08:48

mahendra.singh
Messages: 3
Registered: May 2009
Location: Bangalore

Junior Member

How can i load a .xls file to table
can anyone give me the code

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress in 9i [message #403422 is a reply to message #403336]

Fri, 15 May 2009 09:19

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.lmgtfy.com/?q=oracle+load+xls

Can we conclude you over came the login issue?

[Updated on: Fri, 15 May 2009 09:39]

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress <=== what is this mean? [message #403434 is a reply to message #403419]

Fri, 15 May 2009 10:18

Michel Cadot
Messages: 68749
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

mahendra.singh wrote on Fri, 15 May 2009 15:48

How can i load a .xls file to table
can anyone give me the code

How is this related in any point to the current topic?
A topic has a subject, don't post a question that is NOT related.

Regards
Michel

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress in 9i [message #405640 is a reply to message #403336]

Thu, 28 May 2009 15:16

ronil
Messages: 1
Registered: May 2009

Junior Member

hello i got the problem of ora 01033
i have oracle 9i
i tried following steps

i went to cmd
sqlplus/nolog
connect/as sysdba

fired
error:
ora 24314:service handle not initialized

please help me.....

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress in 9i [message #405641 is a reply to message #405640]

Thu, 28 May 2009 15:55

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Those commands are wrong. You are missing spaces in the right places

Run EXACTLY the commands in BlackSwans post and Copy/Paste the EXACT results.

And please read the forum guide first.

There are also possible bugs in relation to an ora 24314, so post you EXACT Oracle version (FOUR digits), and your EXACT OS Version.

Although the most likely cause is that ORACLE_SID is not set correctly in the environment

[Updated on: Thu, 28 May 2009 15:58]

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress in 9i [message #407192 is a reply to message #405641]

Tue, 09 June 2009 00:58

masatheesh
Messages: 1
Registered: June 2009

Junior Member

Hi,

I am using oracle 9i in windows 2003 server.When I try to login with sqlplus,I get the following error.

ERROR:ORA-01033: ORACLE initialization or shutdown in progress

I try the following steps to resolve this.please guide me.

sqlplus /nolog
connect / as sysdba
shutdown abort;
startup

Here I get the error as
ORA-00214: controlfile 'F:/ORACLE/ORADATA/ORCL/CONTROL.CTL version 1631
inconsistent with file controlfile 'F:/ORACLE/ORADATA/ORCL/CONTROL.CTL version 1633

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress in 9i [message #407197 is a reply to message #407192]

Tue, 09 June 2009 01:15

Michel Cadot
Messages: 68749
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Use SQL*Plus and copy and paste your session. There is a flaw in your post, how could a file be inconsistent with itself as you posted it?

Before please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Regards
Michel

Report message to a moderator

Previous Topic:	MS word issue.
Next Topic:	Window command line mail

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 11 14:35:24 CDT 2025