Home » RDBMS Server » Server Administration » Cannot startup db
Cannot startup db [message #241423] Tue, 29 May 2007 09:34 Go to next message
lawlade
Messages: 59
Registered: May 2007
Location: LAUREL, MARYLAND
Member
I am getting this error: Tue May 29 10:47:19 2007
alter database mount
Tue May 29 10:47:19 2007
ORA-00202: control file: '/eas/u01/app/oracle/product/admin/easp1/links/control1'
ORA-27037: unable to obtain file status
Solaris-AMD64 Error: 5: I/O error
Additional information: 3
Tue May 29 10:47:19 2007
ORA-205 signalled during: alter database mount...
Tue May 29 10:59:18 2007
Starting ORACLE instance (normal)
Tue May 29 11:01:05 2007
alter database mount
Tue May 29 11:01:05 2007
ORA-00202: control file: '/eas/u01/app/oracle/product/admin/easp1/links/control1'
ORA-27037: unable to obtain file status
Solaris-AMD64 Error: 5: I/O error
Additional information: 3
Tue May 29 11:01:05 2007

Could anyone possibly diagnose the problem? Please!
Re: Cannot startup db [message #241427 is a reply to message #241423] Tue, 29 May 2007 09:36 Go to previous messageGo to next message
lawlade
Messages: 59
Registered: May 2007
Location: LAUREL, MARYLAND
Member
Is this also what occurred earlier on the same db

Errors in file /eas/u01/app/oracle/product/admin/easp1/bdump/easp1_ckpt_22321.trc:
ORA-00206: error in writing (block 3, # blocks 1) of control file
ORA-00202: control file: '/eas/u01/app/oracle/product/admin/easp1/links/control3'
ORA-27063: number of bytes read/written is incorrect
Solaris-AMD64 Error: 5: I/O error
Additional information: -1
Additional information: 8192
ORA-00206: error in writing (block 3, # blocks 1) of control file
ORA-00202: control file: '/eas/u01/app/oracle/product/admin/easp1/links/control2'
ORA-27063: number of bytes read/written is incorrect
Solaris-AMD64 Error: 5: I/O error
Additional information: -1
Additional information: 8192
ORA-00206: error in writing (block 3, # blocks 1) of control file
ORA-00202: control file: '/eas/u01/app/oracle/product/admin/easp1/links/control1'
ORA-27063: number of bytes read/written is incorrect
Solaris-AMD64 Error: 5: I/O error
Additional information: -1
Additional information: 8192
Sun May 27 19:46:52 2007
Errors in file /eas/u01/app/oracle/product/admin/easp1/bdump/easp1_ckpt_22321.trc:
ORA-00221: error on write to control file
ORA-00206: error in writing (block 3, # blocks 1) of control file
ORA-00202: control file: '/eas/u01/app/oracle/product/admin/easp1/links/control3'
ORA-27063: number of bytes read/written is incorrect
Solaris-AMD64 Error: 5: I/O error
Re: Cannot startup db [message #241430 is a reply to message #241427] Tue, 29 May 2007 09:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It seems you have a problem with your disk.
Unfortunatly you put all your control files on the same disk and they seem all corrupted.
Hope you have a backup.

Rename the current control files.
Copy the backup onto the current ones.
Start a recovery "using backup control file".

Regards
Michel

Re: Cannot startup db [message #241466 is a reply to message #241430] Tue, 29 May 2007 13:46 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
i Had the same problem on solaris 64bit..oracle 10.2.0.3

when i upgraded oracle 10.1 to 10.2 .when i wannted to craete database it give me the same error.but after aplly patch for veritas it solve automatically.check ur patches list.
Previous Topic: Manually creating a 10g database
Next Topic: Gather Table Stats - Partition
Goto Forum:
  


Current Time: Fri Dec 09 00:25:05 CST 2016

Total time taken to generate the page: 0.08333 seconds