I've written some perl that, given a TNS alias, will get the hostname from
the effective tnsnames.ora file. My problem is I don't know how to get the
hostname if the client's using Oracle*Names. For such a configuration there
is no tnsnames.ora file to parse.
Is there something in DBI or DBD::Oracle that reveals components of the TNS
alias description? If not, is there some API that would allow someone to
retrieve the TNS alias description from 'the master' (i.e., an Oracle*Names
server)? If there is such an API and no one has written a perl wrapper for
it, I'd be willing it.
Thanks,
Jeff
Jeff Holt
Chief Scientist, Hotsos LLC
mailto:[EMAIL PROTECTED]
+1.817.821.9553 tel
+1.413.480.7346 fax
http://www.hotsos.com
Join the Oracle Performance Revolution!
