Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Obtaining machine name and port number using Net8 Alias
He means that when you do a tnsping it echoes the tnsnames.ora entry:
tnsping test_db
TNS Ping Utility for 32-bit Windows: Version 8.1.6.0.0 -Production on 03-MAY-2002 10:13:55 (c) Copyright 1997 Oracle Corporation . All rights reserved.
Attempting to contact
(ADDRESS=(COMMUNITY=testenv.world)(PROTOCOL=TCP)(Host=test_server)(Port=1521))
OK (530 msec)
Daniel Morgan <dmorgan_at_exesolutions.com> wrote in message news:<3CD18C15.7862DA6B_at_exesolutions.com>...
> "Yash R. Ganthe" wrote:
>
> > Hi,
> > 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?
> >
> > Thanks
> > Yash
>
> Not of which I am aware.
>
> But I am fascinated by the ability that you "know" can be done with TNSPING.
> How?
>
> Daniel Morgan
Received on Thu May 02 2002 - 19:47:40 CDT