Currently we are running several 7.3.4 databases (and a few 8.1x) and
up to this point have been using local tnsnames. Due to growth we are
wanting to move to a global tnsnames for administrative / update
purposes, but have a major concern. If the master tnsnames server goes
down (or is inaccessible to a particular network segment) then the
users won't be able to access Oracle.
I haven't had too much luck finding information on setting up
redundant tnsnames for 7.3.4 other than a few references to the
sql*net.ora configuration (no examples though).
Is there a way to have multiple global tnsnames that would be accessed
sequentially if the previous file was not accessible? What is the best
way to do this in a mixed 7.3.4 - 8.1.x environment? Would this change
at all if it was a purely 8.1.x environment (eventually we'll have to
either upgrade or retire the 7.3.4 databases).
Appreciate any pointers, or suggestions on where to find this
information.
Thanks,
Brad
(email responses remove leading b)