Help - Search - Members - Calendar
Full Version: views to find connections to oracle
Oracle DBA Forums > Oracle > Oracle Forum
yudit
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

sad.gif
sudipto2579
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

sad.gif


hi,
you can use dual table to search for an ip..
yudit
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 smile.gif
burleson
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
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

sad.gif


and whats wrong with v$session - it provides eactly what you want
burleson
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
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
"Is there a way for me to know who are they?"

Only by IP address.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.