Re: Migrate EBS on a Single DB Instance to a RAC DB

Posted by ErmanArslansOracleBlog on Feb 18, 2017; 7:56am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Migrate-EBS-on-a-Single-DB-Instance-to-a-RAC-DB-tp2165p2181.html

No need for them to have connect_data..

Here:
Reference: Troubleshooting Autoconfig Issues With Oracle Applications RAC Databases (Doc ID 756050.1)


The tnsnames.ora on database tier must have following three entries for local and remote listeners on all RAC nodes.  The following example assumes, a two node RAC having virtual host names icmtest8-vip,  icmtest4-vip and SIDs PROD1, PROD2 :


PROD1_LOCAL=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=icmtest8-vip.idc.oracle.com)(PORT=1521))
)


PROD2_LOCAL=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=icmtest4-vip.idc.oracle.com)(PORT=1521))
)


PROD_REMOTE=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=icmtest8-vip.idc.oracle.com)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=icmtest4-vip.idc.oracle.com)(PORT=1521))
)
)