unable to open 2nd node - error ora-01105/ora-01104 - number of control files (2) does not equal 1
Database: ORACLE11gR2NODE: 5 nodes
OS: RHEL Server release 6.3
ASM
I just restored the 10g DB to 11gR2, recovered and upgraded the database.
after I started the 1st node, i copied the init.ora to rest of the other four node, so the file would be same.
Now, I am starting up the 2nd instance using the init.ora pfile(which is identical to the 1st(master) node), i.e. startup pfile='/opt/app/oracle/product/11.2.0/db_1/dbs/initrptprod2.ora'; Reviewed ASM and both control files exist.
ORA-01105: mount is incompatible with mounts by other instances
ORA-01104: number of control files (2) does not equal 1
OS: RHEL Server release 6.3
ASM
I just restored the 10g DB to 11gR2, recovered and upgraded the database.
after I started the 1st node, i copied the init.ora to rest of the other four node, so the file would be same.
Now, I am starting up the 2nd instance using the init.ora pfile(which is identical to the 1st(master) node), i.e. startup pfile='/opt/app/oracle/product/11.2.0/db_1/dbs/initrptprod2.ora'; Reviewed ASM and both control files exist.
ORA-01105: mount is incompatible with mounts by other instances
ORA-01104: number of control files (2) does not equal 1
0