Oracle DBA Forums > views to find connections to oracle

yudit

Aug 4 2008, 06:14 AM

Hi,

Is there a view in oracle (besides v$session) that can give me information of who are the machines that are connected to the DB?
information like: IP, RDP

I need to limit the machines that connect to the DB (os server2003).

Thanks
yudit

sudipto2579

Aug 4 2008, 06:17 AM

QUOTE (yudit @ Aug 4 2008, 04:45 PM)

Hi,

Is there a view in oracle (besides v$session) that can give me information of who are the machines that are connected to the DB?
information like: IP, RDP

I need to limit the machines that connect to the DB (os server2003).

Thanks
yudit

hi,
you can use dual table to search for an ip..

yudit

Aug 4 2008, 06:27 AM

QUOTE (sudipto2579 @ Aug 4 2008, 11:18 AM)

hi,
you can use dual table to search for an ip..

sorry,

maybe it's because i'm new ,

can you give me an excample?

and what do i do with teminal servers?

yudit

burleson

Aug 4 2008, 07:48 AM

Hi Yudit,

>> machines that are connected to the DB? information like: IP, RDP

See here: http://www.dba-oracle.com/t_get_ip_address...sys_context.htm

CODE

select SYS_CONTEXT('USERENV', 'IP_ADDRESS', 15) ipaddr from dual;

dave

Aug 4 2008, 08:37 AM

QUOTE (yudit @ Aug 4 2008, 12:15 PM)

Hi,

Is there a view in oracle (besides v$session) that can give me information of who are the machines that are connected to the DB?
information like: IP, RDP

I need to limit the machines that connect to the DB (os server2003).

Thanks
yudit

and whats wrong with v$session - it provides eactly what you want

burleson

Aug 4 2008, 09:31 AM

Hi Yudit,

>> I need to limit the machines that connect to the DB

Do you mean by machine name?

Oracle's Connection Manager (CMAN) does this:

http://www.dba-oracle.com/security/connection_manager.htm

yudit

Aug 5 2008, 01:59 AM

QUOTE (burleson @ Aug 4 2008, 02:32 PM)

Hi Yudit,

>> I need to limit the machines that connect to the DB

Do you mean by machine name?

Oracle's Connection Manager (CMAN) does this:

http://www.dba-oracle.com/security/connection_manager.htm

burleson,
thank you for your answers.

The machines name I can get from V$SESSION, but when users connect through terminal server client
The machine name is the same for all users.
Is there a way for me to know who are they? Or the only way is through OS?

yudit

aussie_dba

Aug 5 2008, 04:57 AM

"Is there a way for me to know who are they?"

Only by IP address.