Home » RDBMS Server » Server Administration » How to find IP address of system using SQLPLUs
How to find IP address of system using SQLPLUs [message #193929] Wed, 20 September 2006 00:26 Go to next message
saiyshnav
Messages: 15
Registered: August 2006
Location: Bangalore
Junior Member
Hi all

Some body help me

How to find IP address of system using SQLPLUs(Oracle Installed)





Thanks In advance
Saiyshnav

Report message to a moderator

Re: How to find IP address of system using SQLPLUs [message #193965 is a reply to message #193929] Wed, 20 September 2006 03:00 Go to previous message
Brayan
Messages: 315
Registered: June 2002
Senior Member
Here you go ..


select utl_inaddr.GET_HOST_ADDRESS('HOSTNAME') from dual;

You can find the terminal in V$SESSION. Via a ping you could find out the IP.

select sys_context('userenv','ip_address') from dual;

Brayan.

Report message to a moderator

Previous Topic: how do i create Heterogeneous services.
Next Topic: ORA-1115
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 08:34:06 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.