Re: Hostname

I have done that a lot---.
..I just wish I could have added some information instead of just correcting someone's posting...

Bricklen Anderson <bricklen_at_shaw.ca> wrote:

>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! ==-----

-----= 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 - 14:02:15 CST