Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Obtaining machine name and port number using Net8 Alias

Re: Obtaining machine name and port number using Net8 Alias

From: David Fitzjarrell <oratune_at_msn.com>
Date: 2 May 2002 13:11:09 -0700
Message-ID: <32d39fb1.0205021211.4f1e1751@posting.google.com>


A query of V$INSTANCE should return the host name of the database server:

select host_name from v$instance;

however you won't obtain any port information.

Knut Talman <knut.talman_at_mytoys.de> wrote in message news:<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:11:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US