how to find host name?
708357Sep 12 2011 — edited Sep 12 2011Currently we have an oracle server and a DR oracle server, but our connections use an alias for the tnsnames entry so in case the server goes down and offline the dr server takes over but we would nto need to change the connection since the alias name would just point to the other server in the DNS server.
so we have something like this
Server A and Server B (DR server)
tnsnames entry is say oracleserver.db.com
when I run this query
select UPPER(host_name), UPPER(instance_name) from v$instance
I get back the server names (Server A or Server B) which is not what I need or like.
I would like and need to have the host name of the alias or tnsnames connection host name?
Is there away to query for that?