Re: Hostname

From: Bricklen Anderson <bricklen_at_shaw.ca>
Date: Mon, 04 Feb 2002 23:16:11 GMT
Message-ID: <3C5F15BB.56636C32@shaw.ca>

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
> > >
Received on Mon Feb 04 2002 - 17:16:11 CST