Re: Hostname

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 - 08:44:02 CST