Re: Hostname

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Tue, 05 Feb 2002 17:18:10 GMT
Message-ID: <3C6013D1.9857B9A9@ci.seattle.wa.us>

You are correct... and I could have gone further than just the literal question which I interpreted as where to find that information in a system table or view.

Thanks for going a bit further for the person with the question.

Daniel Morgan

Bricklen Anderson 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
> > > >
Received on Tue Feb 05 2002 - 11:18:10 CST