ORA-01033: ORACLE initialization or shutdown in progress [message #479122] |
Thu, 14 October 2010 11:26 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #479359 is a reply to message #479122] |
Sat, 16 October 2010 06:17 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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
|
|
|
Re: ORA-01033: ORACLE initialization or shutdown in progress [message #479374 is a reply to message #479359] |
Sat, 16 October 2010 07:55 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 Registered: March 2007 Location: Nanterre, France, http://...
|
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
|
|
|