RE: get ip addr from sqlplus

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Thu, 22 May 2003 11:42:18 -0800
Message-ID: <F001.005A07CF.20030522114218@fatcity.com>

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

• "Leyden, Joseph" <LeydenJ_at_MTA.NET> wrote:
  > Now that I've been shown how to get the
  > MACHINE name from either V$SESSION or V$INSTANCE,
  > where do I get the IP address of this MACHINE in
  > sqlplus
  > (if it's possible)?
  >
  > Joe
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.net
  > --
  > Author: Leyden, Joseph
  > INET: LeydenJ_at_MTA.NET
  >
  > 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).
  >
  

  ---

Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo. http://search.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jose Luis Delgado
  INET: joseluis_delgado_at_yahoo.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: Igor Neyman
  INET: ineyman_at_perceptron.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).

Received on Thu May 22 2003 - 14:42:18 CDT