Home » RDBMS Server » Server Administration » Find host name for oracle database
Find host name for oracle database [message #301869] Fri, 22 February 2008 01:40 Go to next message
aslamkhalife
Messages: 42
Registered: July 2007
Location: India
Member
Hi,


How can I find on which m/c my oracle database is installed.

If I login through SQL from remote m/c and I want to know on which O/S, Hostname Is my Oracle Database is installed.


Please guide for this Querry.

Thanks
Re: Find host name for oracle database [message #301871 is a reply to message #301869] Fri, 22 February 2008 01:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
v$instance.host_name

Regards
Michel

[Edit: missing _]

[Updated on: Fri, 22 February 2008 02:15]

Report message to a moderator

Re: Find host name for oracle database [message #301872 is a reply to message #301871] Fri, 22 February 2008 01:50 Go to previous messageGo to next message
aslamkhalife
Messages: 42
Registered: July 2007
Location: India
Member
Hi Michel,


When ever I post a query , I get answer very soon and you are the person who replies me

Thanks very much.

Thanks & Regards
Aslam Khalife.
Re: Find host name for oracle database [message #302019 is a reply to message #301871] Fri, 22 February 2008 13:07 Go to previous messageGo to next message
krishnakanth
Messages: 4
Registered: January 2008
Location: INDIA
Junior Member

hi michel
can you give query for this view..
Re: Find host name for oracle database [message #302023 is a reply to message #302019] Fri, 22 February 2008 13:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is the difficulty? It is like any view or table.

Regards
Michel
Re: Find host name for oracle database [message #302705 is a reply to message #302023] Tue, 26 February 2008 12:25 Go to previous message
vikramjogi
Messages: 71
Registered: June 2005
Location: Scranton
Member
SQL> select host_name from v$instance;
Previous Topic: TEMP TABLESPACE
Next Topic: how to see the list of installed patches
Goto Forum:
  


Current Time: Fri Dec 09 21:10:58 CST 2016

Total time taken to generate the page: 0.14430 seconds