Gathering host name & port of oracle instance on client machine
Date: Tue, 21 May 2002 11:44:46 +0200
Message-ID: <acd4ri$nhs$1_at_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 - 11:44:46 CEST