Home » RDBMS Server » Server Administration » ORA-01033 ORACLE initiation or shutdown in progess (Oracle 11gr2)
ORA-01033 ORACLE initiation or shutdown in progess [message #610674] Sat, 22 March 2014 13:22 Go to next message
seure1088
Messages: 6
Registered: March 2014
Junior Member
I have been trying to log into TOAD all morning and keep getting the following error: ORA-01033 ORACLE intiation or shutdown in progress.

I've looked on this site and others for solutions and haven't been able to get any of them to work. I have a project for work due Monday and need to be able to sign in and could REALLY use some help.

I've tried going to the CMD and using:

"> sqlplus /nolog

SQL> connect / as sysdba"

However - this is giving me an error and not letting me proceed with any of the solutions I've found so far.

Any help (for someone who isn't overly technical) would be a life saver.

Thanks!
Re: ORA-01033 ORACLE initiation or shutdown in progess [message #610675 is a reply to message #610674] Sat, 22 March 2014 13:25 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>However - this is giving me an error and not letting me proceed with any of the solutions I've found so far.
ERROR?
What Error?
I don't see any error.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and please read http://www.orafaq.com/forum/t/174502/102589/
Re: ORA-01033 ORACLE initiation or shutdown in progess [message #610679 is a reply to message #610675] Sat, 22 March 2014 13:36 Go to previous messageGo to next message
seure1088
Messages: 6
Registered: March 2014
Junior Member
I can put in sqlplus/nolog.

Then I've tried "SQL> connect / as sysdba" and get

"ERROR:
ORA-12560: TNS:protocol adapter error"

I've also tried "connect sys/manager as sysdba" and get the same error.

I've never had to use this CMD before to do anything with Oracle so this really isn't one of my technical strengths.
Re: ORA-01033 ORACLE initiation or shutdown in progess [message #610680 is a reply to message #610679] Sat, 22 March 2014 13:37 Go to previous messageGo to next message
seure1088
Messages: 6
Registered: March 2014
Junior Member
I've searched the site extensively - and haven't seen anyone else get caught up at this point in the process.
Re: ORA-01033 ORACLE initiation or shutdown in progess [message #610681 is a reply to message #610680] Sat, 22 March 2014 13:40 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
when was last time Oracle DB worked without error?
what changed since then?

is this a Windows system?

are both OS Services for the database & listener started?
Re: ORA-01033 ORACLE initiation or shutdown in progess [message #610684 is a reply to message #610681] Sat, 22 March 2014 13:49 Go to previous messageGo to next message
seure1088
Messages: 6
Registered: March 2014
Junior Member
I work for a very large company where a lot of people are logging into the Oracle databases daily. I've never had this issue before - it worked fine for me last night.

This is a Windows system (Windows XP)

I'm sorry - I'm not sure I understand the last question
Re: ORA-01033 ORACLE initiation or shutdown in progess [message #610685 is a reply to message #610684] Sat, 22 March 2014 14:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Execute "Services" you should have a service named "OracleService<SID>" and it must be started.

Re: ORA-01033 ORACLE initiation or shutdown in progess [message #610687 is a reply to message #610685] Sat, 22 March 2014 14:51 Go to previous messageGo to next message
seure1088
Messages: 6
Registered: March 2014
Junior Member
I apologize for my ignorance - but I never have to run SQL through this CMD, I've always used the TOAD interface in the past so this is completely new to me. When I had the prompt "SQL>" I typed "Services" and got an error SP-0042: unknown command "Services" - rest of line ignored.

I'm sure this is a simple solution, but I have 0 experience working with Oracle in this manor.
Re: ORA-01033 ORACLE initiation or shutdown in progess [message #610688 is a reply to message #610687] Sat, 22 March 2014 14:53 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
open Command Window then type "SERVICES" in it.

Have you tried the classic universal Windows solution - Ctrl+Alt+Del & reboot?
Re: ORA-01033 ORACLE initiation or shutdown in progess [message #610689 is a reply to message #610688] Sat, 22 March 2014 15:01 Go to previous messageGo to next message
seure1088
Messages: 6
Registered: March 2014
Junior Member
I opened the Command Window and it displayed C:\Documents and Settings\e3usde\Start Menu>

I typed in SERVICES, hit enter - and the exact same line "C:\Documents and Settings\e3usde\Start Menu>"

I've tried restarting multiple times.
Re: ORA-01033 ORACLE initiation or shutdown in progess [message #610690 is a reply to message #610689] Sat, 22 March 2014 15:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
I typed in SERVICES, hit enter - and the exact same line "C:\Documents and Settings\e3usde\Start Menu>"


But a window should open similar to the following one (with your language):
/forum/fa/11784/0/
  • Attachment: OraFAQ.jpg
    (Size: 136.62KB, Downloaded 2228 times)
Re: ORA-01033 ORACLE initiation or shutdown in progess [message #610691 is a reply to message #610689] Sat, 22 March 2014 15:29 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
seure1088 wrote on Sat, 22 March 2014 15:01
I opened the Command Window and it displayed C:\Documents and Settings\e3usde\Start Menu>

I typed in SERVICES, hit enter - and the exact same line "C:\Documents and Settings\e3usde\Start Menu>"

I've tried restarting multiple times.


Instead of 'services', try 'services.msc'

This is, after all, Windows. No to configurations are exactly alike.

To paraphrase Tom Hanks, "My momma always said Windows is like a box of chocolates. You never know what you are going to get"

The usual cause for your original error (on Windows) is that you are trying to connect to a local database with a local (bequeath -- not network) connection and the Windows service for that database isn't started.
Re: ORA-01033 ORACLE initiation or shutdown in progess [message #610692 is a reply to message #610684] Sat, 22 March 2014 18:22 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
seure1088 wrote on Sat, 22 March 2014 19:49
I work for a very large company where a lot of people are logging into the Oracle databases daily. I've never had this issue before - it worked fine for me last night.


From this I assume the DB is not on your machine, but some central database somewhere administered by a DBA? Have you asked through your normal support channels in that company if the database you want to connect to is down or has per chance moved to somewhere else?
Re: ORA-01033 ORACLE initiation or shutdown in progess [message #611237 is a reply to message #610692] Mon, 31 March 2014 01:50 Go to previous messageGo to next message
arvindnegi2007
Messages: 2
Registered: March 2014
Location: Delhi
Junior Member

how to resolve error

ORA-01033: ORACLE initialization or shutdown in progress

I already use command

conn / as sysdba
Connected.
SQL>

and shutdown
and restart
but i have one more error this time
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

[Updated on: Mon, 31 March 2014 01:53]

Report message to a moderator

Re: ORA-01033 ORACLE initiation or shutdown in progess [message #611238 is a reply to message #611237] Mon, 31 March 2014 01:55 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

So try these options, the second one first.

Previous Topic: A scheduler job getting hung causing critical issues
Next Topic: Alter tablespace issue
Goto Forum:
  


Current Time: Thu Mar 28 17:41:45 CDT 2024