OraFAQ Forum: Windows » Error: ORA-01033 ORACLE initialization or shutdown in progress <=== what is this mean?

Home » Infrastructure » Windows » Error: ORA-01033 ORACLE initialization or shutdown in progress <=== what is this mean? (

) 2 Votes

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

Error: ORA-01033 ORACLE initialization or shutdown in progress <=== what is this mean? [message #100344]

Sun, 27 October 2002 09:17

SOS
Messages: 3
Registered: February 2001

Junior Member

i have some login problem with oracle 8i, the following error:

Error: ORA-01033 ORACLE initialization or shutdown in progress

Can anyone help to solve it for me, thanks~

Report message to a moderator

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

Fri, 08 November 2002 06:23

Sanjeev Sapre
Messages: 3
Registered: November 2002

Junior Member

wait for some time and try
you will log in
please let me know it worked.

Report message to a moderator

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

Fri, 09 April 2004 06:26

Manoj Gandhi
Messages: 1
Registered: April 2004

Junior Member

Please send me solution on this

Report message to a moderator

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

Fri, 18 June 2004 06:27

badercheema
Messages: 2
Registered: November 1999

Junior Member

I had the problem............I waited till oracle started up properly and after that no error.

Report message to a moderator

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

Tue, 27 July 2004 05:43

Mobeen qureshi
Messages: 1
Registered: July 2004

Junior Member

This means that your database is either starting or closing. Its better to wait untill this process get completed.

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress <=== what [message #101386 is a reply to message #101060]

Wed, 08 September 2004 02:44

David Andrews
Messages: 1
Registered: September 2004

Junior Member

It may be worth checking that the user you are logged in to the operating system as is a member of the ORA_DBA group. This worked for me.

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress <=== what [message #101431 is a reply to message #101060]

Wed, 29 September 2004 04:02

rachel green
Messages: 2
Registered: September 2004

Junior Member

I had the same error and waited along time but the error still persist...any more suggestion?

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress <=== what [message #101488 is a reply to message #101431]

Sun, 31 October 2004 20:49

Richard
Messages: 44
Registered: May 2000

Member

i had problem too
was caused by the file system that /u02 (the database data) was on was not mounted after a reboot ('cos of disk failure)

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress <=== what [message #101538 is a reply to message #100344]

Sat, 27 November 2004 07:56

nassiri
Messages: 4
Registered: November 2004

Junior Member

i have the same Error: ORA-01033 ORACLE initialization or shutdown in progress (version Oracle 8i 8.1.7.0.0
I have lanch Compasant Instance manager ,i have give him the file init.ora ,and i OPEN my data base,OK
now i have no probl�me.

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress <=== what [message #101597 is a reply to message #101488]

Thu, 30 December 2004 00:08

arun gupta
Messages: 2
Registered: September 2002

Junior Member

When trying to connect got the error

ORA-01033: ORACLE initialization or shutdown in progress

went to prompt and typed

sqlplus /nolog

tried to connect using sys, got the same error

fired

connect / as sysdba

fired

shutdown

got

ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.

fired

startup

got

ORACLE instance started.
Total System Global Area 276371980 bytes
Fixed Size 453132 bytes
Variable Size 117440512 bytes
Database Buffers 157286400 bytes
Redo Buffers 1191936 bytes
Database mounted.
ORA-01113: file 30 needs media recovery
ORA-01110: data file 30: 'E:ORACLEORADATAINDEX5_1T.ORA'

fired

alter database recover datafile 30;

got

ERROR at line 1:
ORA-00283: recovery session canceled due to errors
ORA-01114: IO error writing block to file 30 (block # 1)
ORA-01110: data file 30: 'E:ORACLEORADATAINDEX5_1T.ORA'
ORA-27091: skgfqio: unable to queue I/O
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.

E:ORACLEORADATAINDEX5_1T.ORA file was readonly. Unchecked it.

fired

alter database recover datafile 30;

shutdown

startup

Database mounted and opened successfully!

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress <=== what [message #101602 is a reply to message #101597]

Tue, 04 January 2005 07:07

syed
Messages: 8
Registered: October 1999

Junior Member

Can u kindly explain the following more crystal clear, as I have the same problem:

When trying to connect got the error

ORA-01033: ORACLE initialization or shutdown in progress

went to prompt and typed

sqlplus /nolog

tried to connect using sys, got the same error-->

a) what was the user name you have supplied?
b) what is the password you have supplied?

fired --> a) where did u try to connect whether in sqlplus or form

connect / as sysdba--->
a) what was the user name you have supplied?
b) what is the password you have supplied?

fired

shutdown

got

ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.

fired

startup

got

ORACLE instance started.
Total System Global Area 276371980 bytes
Fixed Size 453132 bytes
Variable Size 117440512 bytes
Database Buffers 157286400 bytes
Redo Buffers 1191936 bytes
Database mounted.
ORA-01113: file 30 needs media recovery
ORA-01110: data file 30: 'E:ORACLEORADATAINDEX5_1T.ORA'

fired

alter database recover datafile 30;

got

ERROR at line 1:
ORA-00283: recovery session canceled due to errors
ORA-01114: IO error writing block to file 30 (block # 1)
ORA-01110: data file 30: 'E:ORACLEORADATAINDEX5_1T.ORA'
ORA-27091: skgfqio: unable to queue I/O
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.

E:ORACLEORADATAINDEX5_1T.ORA file was readonly. Unchecked it.

fired

alter database recover datafile 30;

shutdown

startup

Database mounted and opened successfully!

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress <=== what [message #101603 is a reply to message #101538]

Tue, 04 January 2005 07:46

syed
Messages: 8
Registered: October 1999

Junior Member

I have the same Error: ORA-01033 ORACLE initialization or shutdown in progress in 9i

I have the same problem with oracle 9i-Error: ORA-01033 ORACLE initialization or shutdown in progress
Can you let me know what is the equivalent of
Compasant Instance manager in oracle 9i?
And what change do I have to do in it.?

----------------------
I have lanch Compasant Instance manager ,i have give him the file init.ora ,and i OPEN my data base,OK
now i have no probl�me.

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress <=== what [message #101633 is a reply to message #101538]

Sun, 23 January 2005 20:53

sabir
Messages: 18
Registered: April 2003

Junior Member

ORA-01109: database not open

This was the error which i can find out from ORADIM.ORA file under which the entry comes where some error comes in the database.

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress <=== what [message #101644 is a reply to message #100344]

Sun, 30 January 2005 14:30

Gerson Morales
Messages: 1
Registered: January 2005

Junior Member

I get ora-01033 error and have waited for a long time and nogo. I have shutdown my pc, the oracle services, and nothing. Same issue. This started when I installed 9i developer.

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress <=== what [message #109484 is a reply to message #101431]

Thu, 24 February 2005 18:29

Munish
Messages: 21
Registered: November 2001

Junior Member

pl. send me urgent help on this error

Thanks

Munish

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress <=== what [message #109574 is a reply to message #101431]

Sat, 26 February 2005 01:01

mfoggiat
Messages: 6
Registered: February 2005

Junior Member

hello,

Strange situation:

I had ORA-01033 Error code and under sqlplus sys as sysdba i shutdown the database and started again and all was ok with sql> connect ....

BUT: the Web ENTERPRISE MANAGER 10G
http://localhost:5500/em

STILL CONTINUE TO SAY: THE DATABASE IS NOT AVAILABLE TRY TO RECOVERY...

VERSION: ORACLE DB 10.1.0.2

HELP ... THANK

Report message to a moderator

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

Tue, 07 June 2005 10:28

mmmmm
Messages: 1
Registered: June 2005

Junior Member

ERROR ORA-01033
I have recived this error can you help me

Report message to a moderator

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

Thu, 09 June 2005 05:31

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

check the alert log for oracle and see waht exactly is causing this issue.
Esp. DO observe the last few entries in the alert log.

Report message to a moderator

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

Wed, 03 August 2005 07:33

cowa
Messages: 3
Registered: August 2005

Junior Member

I am running Oracle 9i under Windows XP Pro and my database hung during a long "select" request...
Now, everytime I try to login I have an ORA-01033 error. And I cannot even login as sys...
How would I resolve that problem ?

Report message to a moderator

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

Wed, 03 August 2005 15:33

Barbara Boehmer
Messages: 9102
Registered: November 2002
Location: California, USA

Senior Member

Have you tried restarting your computer, then waiting several minutes for Oracle to complete the startup process? It takes several minutes after your computer restarts before Oracle is ready for you to login.

Report message to a moderator

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

Thu, 04 August 2005 02:11

cowa
Messages: 3
Registered: August 2005

Junior Member

OK here is the solution I found with the help of a DBA here :

Actually, the database was not shutted down properly the last time (it hung), so the solution is to shutdown explicitely by using SQL Plus.

- I was not able to log in so I used :
> sqlplus /nolog

And after that, I used these commands :

SQL> connect / as sysdba
ConnectÚ.
SQL> shutdown abort
Instance ORACLE arrÛtÚe.
SQL> startup nomount
Instance ORACLE lancÚe.
SQL> alter database mount;
SQL> alter database open;

And all works !!

Report message to a moderator

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

Wed, 02 November 2005 10:07

manipradeep
Messages: 1
Registered: November 2005

Junior Member

i too have the same problem
ora -01033 oracle in initialization or shutdown in progress

i waited for some time but still i am facing the same problem.

even asp code stopped executing since then

plz provide a solution

Report message to a moderator

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

Wed, 02 November 2005 14:58

cowa
Messages: 3
Registered: August 2005

Junior Member

The error occurred when I killed the oracle process because I thought it hung out.

So my Oracle instance was corrupted. Try what I was telling previously. Otherwise : restore previous state of the database with to the .log files. And redo the steps to unmount, remount the DB.
I hope this help.

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress <=== what [message #154736 is a reply to message #101538]

Tue, 10 January 2006 06:36

PTT001
Messages: 1
Registered: January 2006
Location: INDIA

Junior Member

HI

I too got the same message have tried to SHUTDOWN ABORT
When tried to ALTER DATABASE I AM GETTING

:
ERROR AT LINE :1
ORA-0032:LOG 1 OF THREAD 1 IS NOT CURRENT COPY
ORA-0032;ONLINE LOG 1 THREAD 1:'D:\ORACLE \ORADATA\ADMIN\REDO01.LOG'

Please help me for the same.

Prashant

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress <=== what [message #158836 is a reply to message #154736]

Tue, 14 February 2006 11:44

elrushbo
Messages: 1
Registered: February 2006

Junior Member

Alternativley, for windows use the Database admin assistant that comes with oracle. Click Oracle Managed Objects -->Computers --> databases --> <your database name>

Right click and click 'stop service'. And then again right click and 'start service'. Presto, you are done !

-ER

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress <=== what [message #161267 is a reply to message #101597]

Thu, 02 March 2006 23:08

naga_faq
Messages: 17
Registered: April 2005
Location: Pondy

Junior Member

Hello Friends,

Am facing the problem like Oracle Initialization or Shutdown in Progres. But as per our logic i went to command prompt and typed
sqlplus /nolog
it enter into the SQl prompt,
after,
SQL> connect / as sysdba
for this command, it shows insufficent privileges.

What is the solution for me?? pls let me known as soon as possible. it's very urgent for me.

With rgds
Naga

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress <=== what [message #197037 is a reply to message #161267]

Mon, 09 October 2006 12:10

superoscarin@hotmail.com
Messages: 101
Registered: July 2006
Location: Mexico

Senior Member

forget the last error I have many oracle homes for different products... In windows seems that the last product installation get the control for the oracle_sid... i change it and works

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress <=== what [message #208355 is a reply to message #197037]

Sat, 09 December 2006 16:25

assoora28
Messages: 18
Registered: December 2006
Location: Jordan

Junior Member

Hi all,
i had this problem, and i solved it (Thanks God).

Open Dos command Prompt
c:> sqlplus /nolog
SQL> connect sys/manager as sysdba
Connected.
SQL> shutdown immediate;
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.

Total System Global Area 161966464 bytes
Fixed Size 887988 bytes
Variable Size 135750508 bytes
Database Buffers 25165824 bytes
Redo Buffers 262144 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: 'E:\oracle\product\10.2.0\oradata\orcl\UNDOTBS01.DBF'

I realized what happened and how this happened. It's all my fault. During a clean-up effort this file was accidentally deleted.
so i did the folowing:
Mount the database and drop the datafile using
alter database datafile '<<file_name>>' offline drop;

and then open the database

alter database open;

Thnx

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress <=== what [message #208356 is a reply to message #158836]

Sat, 09 December 2006 16:28

assoora28
Messages: 18
Registered: December 2006
Location: Jordan

Junior Member

Hi
i had this problem, and i solved it (Thanks God).

Open Dos command Prompt
c:> sqlplus /nolog
SQL> connect sys/manager as sysdba
Connected.
SQL> shutdown immediate;
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.

Total System Global Area 161966464 bytes
Fixed Size 887988 bytes
Variable Size 135750508 bytes
Database Buffers 25165824 bytes
Redo Buffers 262144 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: 'E:\oracle\product\10.2.0\oradata\orcl\UNDOTBS01.DBF'

I realized what happened and how this happened. It's all my fault. During a clean-up effort this file was accidentally deleted.
so i did the folowing:
Mount the database and drop the datafile using
alter database datafile '<<file_name>>' offline drop;

and then open the database

alter database open;

Thnx

Report message to a moderator

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

Wed, 28 March 2007 23:57

bhojwanimukesh
Messages: 1
Registered: March 2007

Junior Member

Restart the oracle database service :

Go to

Control Panel > Administrative Tools > Services

Select the service pointing to the your particular database

E.g. It was OracleCORE in my system as the database name is CORE

Restart the service ...

it worked for me, I am sure it will work for you also

Good luck,

Regards,
Mukesh Bhojwani,
MSU-BCA.

Report message to a moderator

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

Sun, 09 September 2007 10:20

syednaveed
Messages: 1
Registered: September 2007
Location: Pakistan

Junior Member

SQL*Plus: Release 9.2.0.1.0 - Production on Sun Sep 9 19:30:56 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter user-name: scott/tiger
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress

--------------------------------------------------------------------------------

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

F:\oracle\ora92\bin>sqlplus/nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Sun Sep 9 19:37:13 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> connect / as sysdba
Connected.
------------------------------------------------------------
SQL> shutdown
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-00368: checksum error in redo log block
ORA-00353: log corruption near block 1999 change 6624338 time 09/07/2007
18:45:15
ORA-00312: online log 2 thread 1: 'F:\ORACLE\ORADATA\ORACLE\REDO02.LOG'

Please Chkout this Error. N lEt me Know Wat should i Do? plzz

SQL> alter database recover redo02;
alter database recover redo02
*
ERROR at line 1:
ORA-00905: missing keyword

Report message to a moderator

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

Thu, 13 March 2008 11:07

aditya007
Messages: 1
Registered: March 2008

Junior Member

Hi, friends
Thank you for your suggestions...
But when i was doin the same process that is
In command promt
c:>sqlplus /nolog

SQL> connect sys/manager as sysdba
Connected.
SQL> shutdown immediate;

At this time i'm getting an error ie

SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00058: DB_BLOCK_SIZE must be 4096 to mount this database (not 6144)

Please solve this problem...

Report message to a moderator

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

Thu, 13 March 2008 11:50

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

Senior Member
Account Moderator

So fix the parameter value.

Regards
Michel

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress <=== what [message #311617 is a reply to message #101597]

Sat, 05 April 2008 02:11

irsathahamed
Messages: 12
Registered: April 2008
Location: UAE

Junior Member

Hi,

I have the same problem and I followed the instruction mentioned above.... But no use.... Still I have the same prolem. Can anybody help to solve this problem...

Here I posted what I had tried.

SQL> shutdown
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 145488364 bytes
Database Buffers 25165824 bytes
Redo Buffers 524288 bytes
Database mounted.
ORA-00314: log 1 of thread 1, expected sequence# 179 doesn't match 176
ORA-00312: online log 1 thread 1:
'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\REDO01.LOG'

Thanks in advance.

Report message to a moderator

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

Sat, 05 April 2008 08:44

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Can anybody help to solve this problem...
restore from backups or use dbca to drop & recreate database.

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress <=== what [message #311657 is a reply to message #208356]

Sat, 05 April 2008 09:15

assoora
Messages: 3
Registered: April 2007
Location: Jordan

Junior Member

Hi
Have u tried to log in as a DBA using the DOS command??

Open Dos command Prompt
c:> sqlplus /nolog
SQL> connect sys/manager as sysdba
Connected.
SQL> shutdown immediate;

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress <=== what [message #311663 is a reply to message #311657]

Sat, 05 April 2008 10:27

irsathahamed
Messages: 12
Registered: April 2008
Location: UAE

Junior Member

Yes, I logged as sysdba and I have done the same....

But still the same problem..

Report message to a moderator

Re: Error: ORA-01033 ORACLE initialization or shutdown in progress <=== what [message #311688 is a reply to message #311663]

Sat, 05 April 2008 13:17

assoora
Messages: 3
Registered: April 2007
Location: Jordan

Junior Member

Hi,
Your problem is in the following file: (('D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\REDO01.LOG')) according to what you have got…
--------------------------------------------------
….
ORA-00314: log 1 of thread 1, expected sequence# 179 doesn't match 176
ORA-00312: online log 1 thread 1:
'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\REDO01.LOG'
---------------------------------------------------

I can't exactly remember what I did. I do remember that, what happened to me was; during a clean-up effort (computer scan) a similar file to what you have got was accidentally deleted. I had no backups too.I was willing to lose the data in this datafile. There was something I couldn't do so that the startup does not try to open this file?

-------
Actually I had a different error, my error was:
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: 'E:\oracle\product\10.2.0\oradata\orcl\UNDOTBS01.DBF'
So I created the corrupted file again, as follows:

First, I saw what tablespace I have in my database:
select segment_name, tablespace_name, initial_extent,status
from dba_rollback_segs;

Second, I created the corrupted file:
create undo tablespace UNDO1 datafile 'E:\oracle\product\10.2.0\oradata\orcl/undo01.dbf' size 1
0M;

Third, I alter the systems tablespace, as follows:
ALTER SYSTEM SET UNDO_TABLESPACE = undotbs_02;

And then everything was ok

Best wishes

[Updated on: Sat, 05 April 2008 13:25]

Report message to a moderator