Home » Infrastructure » Windows » Error: ORA-01033 ORACLE initialization or shutdown in progress in 9i  () 1 Vote
Error: ORA-01033 ORACLE initialization or shutdown in progress in 9i [message #403336] Thu, 14 May 2009 22:29 Go to next message
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
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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
ThomasG
Messages: 3211
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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

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 Go to previous messageGo to next message
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.....
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 Go to previous messageGo to next message
ThomasG
Messages: 3211
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 Go to previous messageGo to next message
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

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 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: MS word issue.
Next Topic: Window command line mail
Goto Forum:
  


Current Time: Thu Mar 28 17:16:14 CDT 2024