Obtaining machine name and port number using Net8 Alias
From: Yash R. Ganthe <yash_ganthe_at_hotmail.com>
Date: Thu, 2 May 2002 19:01:59 +0530
Message-ID: <aare7n$cs8$1_at_news.vsnl.net.in>
Hi,
[Quoted] [Quoted] I know the user name and password of an oracle database. I also know the [Quoted] [Quoted] 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?
Date: Thu, 2 May 2002 19:01:59 +0530
Message-ID: <aare7n$cs8$1_at_news.vsnl.net.in>
Hi,
[Quoted] [Quoted] I know the user name and password of an oracle database. I also know the [Quoted] [Quoted] 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?
Thanks
Yash
Received on Thu May 02 2002 - 15:31:59 CEST