OraFAQ Forum: Server Administration » ORA-01033 ORACLE initiation or shutdown in progess

Home » RDBMS Server » Server Administration » ORA-01033 ORACLE initiation or shutdown in progess (Oracle 11gr2)

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

ORA-01033 ORACLE initiation or shutdown in progess [message #610674]

Sat, 22 March 2014 13:22

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!

Report message to a moderator

Re: ORA-01033 ORACLE initiation or shutdown in progess [message #610675 is a reply to message #610674]

Sat, 22 March 2014 13:25

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/

Report message to a moderator

Re: ORA-01033 ORACLE initiation or shutdown in progess [message #610679 is a reply to message #610675]

Sat, 22 March 2014 13:36

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.

Report message to a moderator

Re: ORA-01033 ORACLE initiation or shutdown in progess [message #610680 is a reply to message #610679]

Sat, 22 March 2014 13:37

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.

Report message to a moderator

Re: ORA-01033 ORACLE initiation or shutdown in progess [message #610681 is a reply to message #610680]

Sat, 22 March 2014 13:40

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?

Report message to a moderator

Re: ORA-01033 ORACLE initiation or shutdown in progess [message #610684 is a reply to message #610681]

Sat, 22 March 2014 13:49

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

Report message to a moderator

Re: ORA-01033 ORACLE initiation or shutdown in progess [message #610685 is a reply to message #610684]

Sat, 22 March 2014 14:38

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

Senior Member
Account Moderator

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

Report message to a moderator

Re: ORA-01033 ORACLE initiation or shutdown in progess [message #610687 is a reply to message #610685]

Sat, 22 March 2014 14:51

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.

Report message to a moderator

Re: ORA-01033 ORACLE initiation or shutdown in progess [message #610688 is a reply to message #610687]

Sat, 22 March 2014 14:53

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?

Report message to a moderator

Re: ORA-01033 ORACLE initiation or shutdown in progess [message #610689 is a reply to message #610688]

Sat, 22 March 2014 15:01

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.

Report message to a moderator

Re: ORA-01033 ORACLE initiation or shutdown in progess [message #610690 is a reply to message #610689]

Sat, 22 March 2014 15:08

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

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/

/forum/fa/11784/0/

Attachment: OraFAQ.jpg
(Size: 136.62KB, Downloaded 2895 times)

Report message to a moderator

Re: ORA-01033 ORACLE initiation or shutdown in progess [message #610691 is a reply to message #610689]

Sat, 22 March 2014 15:29

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.

Report message to a moderator

Re: ORA-01033 ORACLE initiation or shutdown in progess [message #610692 is a reply to message #610684]

Sat, 22 March 2014 18:22

ThomasG
Messages: 3212
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?

Report message to a moderator

Re: ORA-01033 ORACLE initiation or shutdown in progess [message #611237 is a reply to message #610692]

Mon, 31 March 2014 01:50

arvindnegi2007
Messages: 2
Registered: March 2014
Location: Delhi

Junior Member

arvindnegi2007@gmail.com

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

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

Senior Member
Account Moderator

So try these options, the second one first.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 05:49:40 CST 2024