OraFAQ Forum: Server Administration » Find host name for oracle database

Home » RDBMS Server » Server Administration » Find host name for oracle database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Find host name for oracle database [message #301869]

Fri, 22 February 2008 01:40

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

Report message to a moderator

Re: Find host name for oracle database [message #301871 is a reply to message #301869]

Fri, 22 February 2008 01:45

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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

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.

Report message to a moderator