Re: Is the database server on the local machine?

Lenny Palozzi wrote:

> I'm looking for a way, via C/C++ code, to find the hostname and/or ip
> adress of the Oracle database server. I'm given a "service name"
> which, along with user/password allows me to connect to the database
> server, but the details are hidden by the Oracle client and TNS.
>
> Is there a way via OCI, or some other API, to retrieve the connection
> details based on the "service name"?.
>
> I suppose I could locate and parse the tnsnames.ora file myself, and
> though workable, is not an ideal solution.
>
> And how about if an Oracle Names Server is used?
>
> ~Lenny

http://www.psoug.org
click on Morgan's Library
click on SYS_CONTEXT function

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)