Re: Have host (Tnsname), need Machine:Port:Sid in PL/SQL ?

From: Douglas Hawthorne <douglashawthorne_at_yahoo.com.au>
Date: Thu, 25 Mar 2004 11:36:20 GMT
Message-ID: <Uuz8c.124258$Wa.1643@news-server.bigpond.net.au>

"Christof Kaiser" <kaiser_at_logiball.de_no_spam> wrote in message news:4062bd72$0$280$4d4ebb8e_at_read.news.de.uu.net...
> Hello,
>
> I am looking for a way to get the Machine, Port and SID in PL/SQL when I
> only have the host (as it is in the TNSNAMES).
>
> eg I have MYHOST
> and need
> MYMACHINE, MYPORT (eg 1521), MYSID
>
> I am pretty sure there is some kind if V$ view or pl/sql mechanism which
> represents the contents from the tnsnames.ora.
> But how is it named?
>
> I searched for some hours, but no luck.
>
> tia
> Christof
>

Christof,

From your post, I assume you are running a stand alone system with the server and clients on the same box. If not, there can be many TNSNAMES.ORA lurking on the network and you would need to specify which one you want to look at.

I think I will have to ask why you want to know these details. What problem are you trying to solve? Once the group has an idea of the problem, we can offer some solutions.

Douglas Hawthorne Received on Thu Mar 25 2004 - 05:36:20 CST