Thank you bpeasland,
i am not familiar with RAC listener setups, I will request my Sr.DBA to do this.
Thanks & Regards,
I use tns alias for my parameters. On my 2-node standby, I have the following:
I don't have IP addresses in those parameter values. These are just tnsalias. Then in my tnsnames.ora config file, I have these:
(ADDRESS = (PROTOCOL = TCP)(HOST = host01-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = host02-vip)(PORT = 1521))
The tnsnames.ora files contain the same info on both nodes, just to make my life simpler.
That's just how I do it. You can certainly use the other method too.
Thank you bpeasland