Oracle-L: RE: get ip addr from sqlplus

From: Seefelt, Beth <Beth.Seefelt_at_TetleyUSA.com>
Date: Thu, 22 May 2003 13:08:14 -0800
Message-ID: <F001.005A0B88.20030522130814@fatcity.com>

I think there's a supplied package that will translate hostname to ip also, UTL_INADDR. Never tried it, but it looks like its just an interface to the standard socket library get_host... calls.

-----Original Message-----

Sent: Thursday, May 22, 2003 4:19 PM
To: Multiple recipients of list ORACLE-L

Extract machine name from v$session, and then a host call to 'nslookup' ? External Procedure?

Kirti

-----Original Message-----

Sent: Thursday, May 22, 2003 2:42 PM
To: Multiple recipients of list ORACLE-L

What about other sessions (not your own)?

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

-----Original Message-----

Delgado
Sent: Thursday, May 22, 2003 1:23 PM
To: Multiple recipients of list ORACLE-L

Use:

select sys_context('userenv', 'ip_address') ip_address,
sys_context('userenv', 'current_user') current_user from dual
/

(8i or above)...

HTH
JL

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Deshpande, Kirti
INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Seefelt, Beth
INET: Beth.Seefelt_at_TetleyUSA.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message