Re: Hostname

oops, didn't read the question carefully.

;-(

TurkBear wrote:
>
> That provides HIS IP address, which I expect he knows...
>
> Bricklen Anderson <bricklen_at_shaw.ca> wrote:
>
> >something like this?:
> >
> >select sys_context('userenv', 'ip_address' ) from dual;
> >
> >damorgan wrote:
> >>
> >> Not if he has been kicking around the system tables and views.
> >>
> >> More likely he is looking for v_$instance. Which is where you can find the hostname. The IP address is not a stored
> >> parameter.
> >>
> >> Daniel Morgan
> >>
> >> Johan Wegener wrote:
> >>
> >> > You are probably looking for the *FILE* called $ORACLE_HOME/network/admin/tnsnames.ora
> >> >
> >> > "Sven Schäfer" <s.schaefer_at_bmi-heidelberg.com> wrote in message news:newscache$uhe0rg$sa7$1_at_localhost.localdomain...
> >> > > Hi,
> >> > > I was looking around in the system tables and views where Oracle stores
> >> > > the servers hostname or IP-address, but I couldn't find the right one.
> >> > > Does anyone have a hint for me?
> >> > >
> >> > > TIA
> >> > >
> >> > > Sven
> >> > >
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> Check out our new Unlimited Server. No Download or Time Limits!
> -----== Over 80,000 Newsgroups - 19 Different Servers! ==-----
Received on Tue Feb 05 2002 - 13:40:02 CST