Re: Obtaining machine name and port number using Net8 Alias

From: Knut Talman <knut.talman_at_mytoys.de>
Date: Thu, 02 May 2002 15:45:48 +0200
Message-ID: <3CD1430C.5010907_at_mytoys.de>


> I know the user name and password of an oracle database. I also know the
> Net8 alias of the database. Using these 3 values, is it possible for me to
> obtain the name of the machine and the port number on which this database is
> maintained? I know this can be done using tnsping. But I want to obtain it
> programmatically, either through Pro*C or PL/SQL. I cannot parse the
> tnsnames.ora file as I do not have read permissions on that file. Is there a
> way to do it?

If you don't have read permissions on tnsnames.ora the Net8 alias is worthless. I see no way to get what you want.

Regards,

Knut

P.S. Crossposting is bad. Received on Thu May 02 2002 - 15:45:48 CEST

Original text of this message