Gathering host name & port of oracle instance on client machine

From: Manfred Teuber <manfred.teuber_at_icn.siemens.de>
Date: Tue, 21 May 2002 11:44:46 +0200
Message-ID: <acd4ri$nhs$1@news.mch.sbs.de>

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 Received on Tue May 21 2002 - 04:44:46 CDT