Home » RDBMS Server » Server Administration » ORA-01507: database not mounted (merged)
ORA-01507: database not mounted (merged) [message #386098] Thu, 12 February 2009 12:06 Go to next message
piraba
Messages: 2
Registered: February 2009
Location: colombo
Junior Member

SQL> connect / as sysdba
Connected.
SQL> shutdown immediate
ORA-01507: database not mounted


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

Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 205523844 bytes
Database Buffers 398458880 bytes
Redo Buffers 7135232 bytes
ORA-00204: error in reading (block 3, # blocks Cool of control file
ORA-00202: control file:
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\EMPLOYEE\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).

how can i fix this error?
please anybody help me.

Re: ORA-01507: database not mounted [message #386099 is a reply to message #386098] Thu, 12 February 2009 12:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
shutdown the database, drop the control file, remove it from the control file list and restart.

Regards
Michel
ORA-01507: database not mounted [message #386101 is a reply to message #386098] Thu, 12 February 2009 12:25 Go to previous messageGo to next message
piraba
Messages: 2
Registered: February 2009
Location: colombo
Junior Member

SQL> connect / as sysdba
Connected.
SQL> shutdown immediate
ORA-01507: database not mounted


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

Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 205523844 bytes
Database Buffers 398458880 bytes
Redo Buffers 7135232 bytes
ORA-00204: error in reading (block 3, # blocks Cool of control file
ORA-00202: control file:
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\EMPLOYEE\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).

how can i fix this error?
please anybody help me.
Re: ORA-01507: database not mounted [message #386105 is a reply to message #386101] Thu, 12 February 2009 12:43 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Same answer as in other topic.
Do not crosspost your question but read OraFAQ Forum Guide
In particular, "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Regards
Michel
Previous Topic: Should I pass or keep this alert message?
Next Topic: DB Link
Goto Forum:
  


Current Time: Thu Dec 08 16:14:04 CST 2016

Total time taken to generate the page: 0.05803 seconds