Re: Hostname

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Mon, 04 Feb 2002 18:01:46 GMT
Message-ID: <3C5ECC89.6F71F40C@ci.seattle.wa.us>

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 - 12:01:46 CST