OraFAQ Forum: Server Administration » ORA-01033: ORACLE initialization or shutdown in progress

Home » RDBMS Server » Server Administration » ORA-01033: ORACLE initialization or shutdown in progress

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

ORA-01033: ORACLE initialization or shutdown in progress [message #479122]

Thu, 14 October 2010 11:26

beginner88
Messages: 45
Registered: June 2010

Member

Hello
When I am trying to connect to sql from scott or any other user i am getting this error message ,

ORA-01033: ORACLE initialization or shutdown in progress

I have been getting this error message for 4 four days .
Butt when i am trying to connect from SYS user it connects successfully ,but when i do query it gives me following error message .

ORA-01219: database not open: queries allowed on fixed tables/views only

I shutdown Database from SYS user ,and start it again .But at startup it gives me following error message .

ORA-00204: error in reading (block 3, # blocks 8) of control file
ORA-00202: control file: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL'
ORA-27091: unable to queue I/O
ORA-27070: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 23) Data error (cyclic redundancy check).

Regards .

[Updated on: Thu, 14 October 2010 11:27]

Report message to a moderator

Re: ORA-01033: ORACLE initialization or shutdown in progress [message #479126 is a reply to message #479122]

Thu, 14 October 2010 11:34

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

Senior Member
Account Moderator

Drop the control file, copy another one into this one and restart.

Regards
Michel

[Updated on: Thu, 14 October 2010 11:34]

Report message to a moderator

Re: ORA-01033: ORACLE initialization or shutdown in progress [message #479269 is a reply to message #479122]

Fri, 15 October 2010 14:15

beginner88
Messages: 45
Registered: June 2010

Member

Thankyou so much For your reply .
I remove The Information Of Controlfile03 From initialization parameter file,but i cannot delete it , when i click , it hangs my Computer .

Regards

Report message to a moderator

Re: ORA-01033: ORACLE initialization or shutdown in progress [message #479270 is a reply to message #479269]

Fri, 15 October 2010 14:18

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

does DB start now?

Report message to a moderator

Re: ORA-01033: ORACLE initialization or shutdown in progress [message #479338 is a reply to message #479122]

Sat, 16 October 2010 02:10

beginner88
Messages: 45
Registered: June 2010

Member

Report message to a moderator

Re: ORA-01033: ORACLE initialization or shutdown in progress [message #479339 is a reply to message #479122]

Sat, 16 October 2010 02:58

Yasir Hashmi
Messages: 304
Registered: April 2006

Senior Member

What errors did you get now?
If you have removed the CF entry from spfile,the then it will not look for the corrupted one.Therefore,there should now be no problem in starting the database.

Post the contents of alert log.

Report message to a moderator

Re: ORA-01033: ORACLE initialization or shutdown in progress [message #479356 is a reply to message #479122]

Sat, 16 October 2010 05:57

beginner88
Messages: 45
Registered: June 2010

Member

Thanks Yasir For The reply Smile

I am still getting the same error message .

ORA-01033: ORACLE initialization or shutdown in progress

ALERT LOG FILE

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=2296
Sat Oct 16 12:07:59 2010
starting up 1 shared server(s) ...
Sat Oct 16 12:08:01 2010
alter database mount exclusive
Sat Oct 16 12:08:07 2010
Errors in file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_2316.trc:
ORA-00202: control file: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL'
ORA-27091: unable to queue I/O
ORA-27070: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 23) Data error (cyclic redundancy check).

Sat Oct 16 12:08:12 2010
ORA-204 signalled during: alter database mount exclusive...

Report message to a moderator

Re: ORA-01033: ORACLE initialization or shutdown in progress [message #479358 is a reply to message #479356]

Sat, 16 October 2010 06:07

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

Senior Member
Account Moderator

You are still referning the control fie 3, this proves you didn't remove it from the parameter file you are using.
Do as I said instead.

Regards
Michel

Report message to a moderator

Re: ORA-01033: ORACLE initialization or shutdown in progress [message #479359 is a reply to message #479122]

Sat, 16 October 2010 06:17

beginner88
Messages: 45
Registered: June 2010

Member

Thanks Michel For the reply

This Is My Pfile

###########################################
# File Configuration
###########################################
control_files=("D:\oracle\product\10.2.0\oradata\orcl\control01.ctl", "D:\oracle\product\10.2.0\oradata\orcl\control02.ctl")
db_recovery_file_dest=D:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size=2147483648
 
###########################################

I also Tried to open database using pfile ,but when i use Startup pfile Command , it gives me following error message

SQL> startup pfile ='D:\oracle\product\10.2.0\admin\orcl\pfile\init.ora' 
LRM-00109: could not open parameter file 'D:\oracle\product\10.2.0\admin\orcl\pfile\init.ora'
ORA-01078: failure in processing system parameters

Report message to a moderator

Re: ORA-01033: ORACLE initialization or shutdown in progress [message #479374 is a reply to message #479359]

Sat, 16 October 2010 07:55

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

Senior Member
Account Moderator

ORA-01078: failure in processing system parameters
 *Cause:  Failure during processing of INIT.ORA parameters during
            system startup.
 *Action:  Further diagnostic information should be in the error stack.

LRM-00109: could not open parameter file '%.*s'
 *Cause: The parameter file does not exist.
 *Action: Create an appropriate parameter file.

Be sure the file exists and is accessible by Oracle.

Regards
Michel

Report message to a moderator

Previous Topic:	/ORACLE FILE SYSTEM 95%
Next Topic:	Sun solaris - Oracle server Load Average is too High at specific days

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 08:32:53 CST 2024