OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Cannot startup db

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

Cannot startup db [message #241423]

Tue, 29 May 2007 09:34

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!

Report message to a moderator

Re: Cannot startup db [message #241427 is a reply to message #241423]

Tue, 29 May 2007 09:36

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

Report message to a moderator

Re: Cannot startup db [message #241430 is a reply to message #241427]

Tue, 29 May 2007 09:40

Michel Cadot
Messages: 68686
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

Report message to a moderator

Re: Cannot startup db [message #241466 is a reply to message #241430]

Tue, 29 May 2007 13:46

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.

Report message to a moderator

Previous Topic:	Manually creating a 10g database
Next Topic:	Gather Table Stats - Partition

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 22:33:33 CDT 2024