Skip to Main Content

ora-00205 error in identifying control file

4055443Sep 2 2019 — edited Sep 4 2019

Hi,

When I lauched my database ORCL (alter database mount or open), the message in subject appears.

I trying recreate spfile and pfile.

The control_files are present but empty.

Some informations :

show parameters control_files;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

control_files                        string      /applications/oracle/product/d

                                                 bs/ora_control1, /applications

                                                 /oracle/product/dbs/ora_contro

                                                 l2

#files and rights

[oracle@oracle dbs]$ ll /applications/oracle/product/dbs/ora_control1

-rwxrwxr-x 1 oracle oinstall 0 21 août  11:41 /applications/oracle/product/dbs/ora_control1

[oracle@oracle dbs]$ ll /applications/oracle/product/dbs/ora_control2

-rwxrwxr-x 1 oracle oinstall 0 28 août  10:05 /applications/oracle/product/dbs/ora_control2

# files also in fast_recovery area

[oracle@oracle fast_recovery_area]$ ll

total 0

-rwxrwxr-x 1 oracle oinstall 0 21 août  11:41 ora_control1

-rwxrwxr-x 1 oracle oinstall 0 21 août  11:41 ora_control2

[oracle@oracle fast_recovery_area]$

#extract spfileORCL concerning control_files

*.control_files='/applications/oracle/product/dbs/ora_control1','/applications/oracle/product/dbs/ora_control2'

#extract initORCL concerning control_files

control_files ='/applications/oracle/product/dbs/ora_control1','/applications/oracle/product/dbs/ora_control2'

# extract of alert_log.xml

<txt>Errors in file /applications/oracle/product/diag/rdbms/orcl/ORCL/trace/ORCL_m000_16845.trc:

ORA-00202: control file: &apos;/applications/oracle/product/dbs/ora_control2&apos;

ORA-27047: unable to read the header block of file

Linux-x86_64 Error: 25: Inappropriate ioctl for device

Additional information: 1

ORA-00210: cannot open the specified control file

ORA-00202: control file: &apos;/applications/oracle/product/dbs/ora_control1&apos;

ORA-27047: unable to read the header block of file

Linux-x86_64 Error: 25: Inappropriate ioctl for device

Thanks for your help.

Comments
Post Details
Added on Sep 2 2019
5 comments
431 views