Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00210: cannot open the specified control file

orclrunnerOct 31 2014 — edited Nov 2 2014

Oracle 11.2.0.1

We store our data on a NAS share - Data files, log files, temp files and the control file.

Is my the setup:

Host1 has database IMR1

Data Location: /du01/imr1

Host2 has database IMR1 (empty database, no application data)

Data Location: /du01/imr1/IMR1

I want database IMR1 on Host 2 to look like the database on Host 1.

In other words, both database should use the same file location - /du01/imr1.

Here is what I did.

Shutdown the database on Host 2.

Edited the parmeter file - changed the controlfile location to /du01/imr1/control01.ctl

Ran: create spfile from pfile='/u01/app/oracle/admin/IMR1/pfile/initIMR1.ora'

Then started up the database:  startup pfile=/u01/app/oracle/admin/IMR1/pfile/initIMR1.ora

But I get this error:

ORACLE instance started.

Total System Global Area 1.3495E+10 bytes

Fixed Size                  2218032 bytes

Variable Size            6845106128 bytes

Database Buffers         6576668672 bytes

Redo Buffers               71471104 bytes

ORA-00205: error in identifying control file, check alert log for more info

Alert log:

<msg time='2014-10-31T08:12:15.331-07:00' org_id='oracle' comp_id='rdbms'

msg_id='opiexe:2994:4222364190' client_id='' type='NOTIFICATION'

group='admin_ddl' level='16' host_id='dub-ImrORA2'

host_addr='10.20.0.88' module='sqlplus@dub-ImrORA2 (TNS V1-V3)' pid='439'>

<txt>ALTER DATABASE   MOUNT

</txt>

</msg>

<msg time='2014-10-31T08:12:15.948-07:00' org_id='oracle' comp_id='rdbms'

client_id='' type='UNKNOWN' level='16'

host_id='dub-ImrORA2' host_addr='10.20.0.88' module=''

pid='425'>

<txt>ORA-00210: cannot open the specified control file

ORA-00202: control file: &apos;/du01/imr1/control01.ctl&apos;

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

</txt>

</msg>

Is there something I'm missing or is there an easier way to do this?

This post has been answered by EdStevens on Nov 2 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 30 2014
Added on Oct 31 2014
10 comments
15,989 views