Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Obtaining machine name and port number using Net8 Alias
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