All -
I have multiple 10g RAC (10.2.0.2) running on RH Linux ES 4. I would like to know if the following can be accomplished using TNSNAMES:
If these clusters reside on different domains (i.e. domain1 = abc.com, domain2 = xyz.com), how do you configure the sqlnet.ora and tnsnames.ora files to be able to connect to the databases on each cluster?
sqlplus system/<passwd>@db1
sqlplus system/<passwd>@db1.abc.com
sqlplus system/<passwd>@db2
sqlplus system/<passwd>@db2.xyz.com
Is this possible? Do I need to use some other connection method to accomplish what I am trying to do. Or are there work-arounds to this issue?
The documentation that I have read, specifically for Oracle 10g (10.1.0 and 10.2.0), offer information about using "names.default_domain" parameter in the sqlnet.ora file, but this assumes that these machines are in the same default domain (i.e. abc.com).
TIA,
Scott