Re: Gathering host name & port of oracle instance on client machine

On Tue, 21 May 2002 11:44:46 +0200, "Manfred Teuber" <manfred.teuber_at_icn.siemens.de> wrote:

>Hi there,
>
>I've got a problem on a running Java console application on a Windows NT
>client.
>
>The Java application can be parameterized with valid TNS-name (SID & domain)
>of an existing db instance.
>For using the Oracle.Thin driver (Java), I do need the following information
>about
>server / db-instance: host name, port number, service id.
>How can I manage to gather the valid information for host name / port to the
>provided instance name on the local Windows NT machine?
>Scanning a local tnsnames.ora file dose'nt seems to be an appropriate way
>cause
>you have to reimplement an already existing oracle mechanism - without
>actually
>knowing how it works in the details.
>A good way could be something like using an existing Oracle console tool -
>or maybe tickeling an OCI lib to do the job...
>
>Any sugestions are welcome.
>
>Thanks,
>Manfred
>
>

Just *ask* your DBA instead of *hacking* looks a very valid alternative to me.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue May 21 2002 - 09:43:45 CDT