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: '/du01/imr1/control01.ctl'
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?