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
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.
Previous Topic: how do i create Heterogeneous services.
Next Topic: ORA-1115
Goto Forum:
  


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

Total time taken to generate the page: 0.11069 seconds