|
|
|
|
|
|
| Author |
Message |
DA Morgan
*nix forums Guru
Joined: 06 Mar 2005
Posts: 1042
|
 Posted: Fri Feb 25, 2005 3:06 pm Post subject:
Re: Client session IP address
|
|
|
Mark Bole wrote:
| Quote: | DA Morgan wrote:
Irudaya Raj wrote:
Hello Everybody,
I have a need to know what is the source IP address of every session
that gets created on my Oracle 9i instance.
I have queried the v$session view, it does show a 'MACHINE' name for
users who have connected from apps. like SQLPLUS, but there are
connections comming in from JDBC client, Web Servlets,etc., these
connections are shown under 'MACHINE' column as the application name
itself.
But I need to know the IP address from where this application was run.
[...]
http://www.psoug.org
click on Morgan's Library
click on SYS_CONTEXT Function
Hoepfully you are not working with Windows.
What's the issue with Windows? (the PSOUG web page you reference
doesn't say).
-Mark Bole
|
Who would come to my lectures if I put everything on the web site? ;-)
There are situations, I can't find my source reference right this
minute, where with Windows NULL is returned by the function. It is
certainly the case on my stand-alone notebook.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond) |
|
| Back to top |
|
 |
IANAL_VISTA
*nix forums Guru
Joined: 23 Apr 2005
Posts: 485
|
| Posted: Fri Feb 25, 2005 2:40 pm Post subject:
Re: Client session IP address
|
|
|
"Irudaya Raj" <jirudayaraj@gmail.com> wrote in
news:1109315151.207880.213180@g14g2000cwa.googlegroups.com:
| Quote: | Hello Everybody,
I have a need to know what is the source IP address of every session
that gets created on my Oracle 9i instance.
|
DBMS_SYSTEM might help.
In a three tier architecture, more than likely all the DB will 'see'
is the middle tier server(s) and never 'see' the actual client IP#. |
|
| Back to top |
|
|
Mark Bole
*nix forums Guru Wannabe
Joined: 29 Apr 2005
Posts: 188
|
| Posted: Fri Feb 25, 2005 2:18 pm Post subject:
Re: Client session IP address
|
|
|
DA Morgan wrote:
| Quote: | Irudaya Raj wrote:
Hello Everybody,
I have a need to know what is the source IP address of every session
that gets created on my Oracle 9i instance.
I have queried the v$session view, it does show a 'MACHINE' name for
users who have connected from apps. like SQLPLUS, but there are
connections comming in from JDBC client, Web Servlets,etc., these
connections are shown under 'MACHINE' column as the application name
itself.
But I need to know the IP address from where this application was run.
[...]
http://www.psoug.org
click on Morgan's Library
click on SYS_CONTEXT Function
Hoepfully you are not working with Windows.
|
What's the issue with Windows? (the PSOUG web page you reference
doesn't say).
To the OP: the listener log file will show you the source IP address for
JDBC client connections, although it is not always possible to correlate
this to specific sessions in the database -- sometimes you can match
them up by timestamp if connections are infrequent enough.
-Mark Bole |
|
| Back to top |
|
|
DA Morgan
*nix forums Guru
Joined: 06 Mar 2005
Posts: 1042
|
| Posted: Fri Feb 25, 2005 6:36 am Post subject:
Re: Client session IP address
|
|
|
Irudaya Raj wrote:
| Quote: | Hello Everybody,
I have a need to know what is the source IP address of every session
that gets created on my Oracle 9i instance.
I have queried the v$session view, it does show a 'MACHINE' name for
users who have connected from apps. like SQLPLUS, but there are
connections comming in from JDBC client, Web Servlets,etc., these
connections are shown under 'MACHINE' column as the application name
itself.
But I need to know the IP address from where this application was run.
Is there a way to find out this.
Please let me know.
Thanks a lot for your time and valuable inputs.
Regards,
Raj.
|
http://www.psoug.org
click on Morgan's Library
click on SYS_CONTEXT Function
Hoepfully you are not working with Windows.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond) |
|
| Back to top |
|
|
Irudaya Raj
*nix forums beginner
Joined: 25 Feb 2005
Posts: 5
|
| Posted: Fri Feb 25, 2005 6:05 am Post subject:
Client session IP address
|
|
|
Hello Everybody,
I have a need to know what is the source IP address of every session
that gets created on my Oracle 9i instance.
I have queried the v$session view, it does show a 'MACHINE' name for
users who have connected from apps. like SQLPLUS, but there are
connections comming in from JDBC client, Web Servlets,etc., these
connections are shown under 'MACHINE' column as the application name
itself.
But I need to know the IP address from where this application was run.
Is there a way to find out this.
Please let me know.
Thanks a lot for your time and valuable inputs.
Regards,
Raj. |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
|
The time now is Thu Jan 08, 2009 6:11 am | All times are GMT
|
|
Cheap Magazines | Reptile Supplies | Recreation websites directory | Wide Shoes for Women & Men | Secured Loans
|
|
Copyright © 2004-2005 DeniX Solutions SRL
|
|
|
|
Other DeniX Solutions sites:
Unix/Linux blog |
electronics forum |
medicine forum |
science forum |
|
|
Privacy Policy
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
Oracle
