| Author |
Identifying clients in 3 tier architectre
|
|
|
| In a 3 tier architecture is it possible to identify which client
machine browsers are making request to the database server .I mean
suppose from 2 differnt clients ,same user is connected to the
database, how can we distinguish between them.
| |
| sybrandb@yahoo.com 2005-07-18, 3:23 am |
| Just look at the machine column in v$session.
--
Sybrand Bakker
Senior Oracle DBA
| |
|
| Actually i want to identify the client machine/ip who is connecting to
database by opening a 'form' thru his browser.
| |
| IANAL_VISTA 2005-07-18, 9:23 am |
| "anish" <anish_recd@yahoo.co.in> wrote in
news:1121679246.421076.95530@g49g2000cwa.googlegroups.com:
> Actually i want to identify the client machine/ip who is connecting to
> database by opening a 'form' thru his browser.
>
>
An Oracle database can not "opening a 'form' thru his browser.".
Try RTFM
http://download-west.oracle.com/doc...99_03/index.htm
| |
| Holger Baer 2005-07-18, 9:23 am |
| IANAL_VISTA wrote:
> "anish" <anish_recd@yahoo.co.in> wrote in
> news:1121679246.421076.95530@g49g2000cwa.googlegroups.com:
>
>
>
>
> An Oracle database can not "opening a 'form' thru his browser.".
>
Actually what Anish want's to do is the other way round:
A clients connects to a database by retrieving a http form through his
browser.
Having (hopefully) cleared that, I'm sorry to say that unless it's coded
into the application (which would be located on the app server since the
OP is talking about 3-Tier architecture) there is no way to get the
information the OP is after.
Regards,
Holger
| |
| Maxim Demenko 2005-07-18, 9:23 am |
| Holger Baer schrieb:
> Having (hopefully) cleared that, I'm sorry to say that unless it's coded
> into the application (which would be located on the app server since the
> OP is talking about 3-Tier architecture) there is no way to get the
> information the OP is after.
>
> Regards,
> Holger
Where is an approach to get that info by i3 Insight (now , i believe, is
Veritas ), they are doing it based on some statistical approach and
can correlate the relationship of ip packets, i've seen a presentation
about year ago for 3 tier with siebel and oracle, seems to work good,
is of course not that cheap...
Best regards
Maxim
| |
| Holger Baer 2005-07-18, 11:23 am |
| Maxim Demenko wrote:
> Holger Baer schrieb:
>
>
>
> Where is an approach to get that info by i3 Insight (now , i believe, is
> Veritas ), they are doing it based on some statistical approach and can
> correlate the relationship of ip packets, i've seen a presentation
> about year ago for 3 tier with siebel and oracle, seems to work good,
> is of course not that cheap...
>
> Best regards
>
> Maxim
I presumed the OP wanted the info in the database, however, on rereading
his first post I'm not so sure about that anymore, so thanks for the info.
Cheers,
Holger
| |
| anish 2005-07-18, 11:23 am |
| actually some users have locked certain resources in the database..i
want to identify their session and kill them... in this system multiple
users are getting connected to the database using the same user id thru
forms server on AS .I know which clients have made the http request
,but can't identify them in database sessions since the users are
connected using same id...so i want to know which client machine has
started what session in the database ...i think now i have made myself
clearer
| |
| DA Morgan 2005-07-18, 11:23 am |
| anish wrote:
> actually some users have locked certain resources in the database..i
> want to identify their session and kill them... in this system multiple
> users are getting connected to the database using the same user id thru
> forms server on AS .I know which clients have made the http request
> ,but can't identify them in database sessions since the users are
> connected using same id...so i want to know which client machine has
> started what session in the database ...i think now i have made myself
> clearer
And I think there is no way to accomplish this worthy goal unless the
application has been intentionally coded to make this information
visible to the database which is highly unlikely.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)
| |
| Joel Garry 2005-07-18, 8:23 pm |
|
anish wrote:
> actually some users have locked certain resources in the database..i
> want to identify their session and kill them... in this system multiple
> users are getting connected to the database using the same user id thru
> forms server on AS .I know which clients have made the http request
> ,but can't identify them in database sessions since the users are
> connected using same id...so i want to know which client machine has
> started what session in the database ...i think now i have made myself
> clearer
When you say locked, are you referring to Oracle locking or something
else? If Oracle locking, then use the lock manager of OEM or the
scripts in $ORACLE_HOME/rdbms/admin/*lock* or one of the many scripts
online that look at v$lock. If something else, desc v$session and see
what you can get, some apps are nice enough to load machine, osuser,
program or something. How do you know which clients made the request?
jg
--
@home.com is bogus.
Search for perticular on metalink.
| |
| Fabrizio 2005-07-19, 3:23 am |
| Holger Baer wrote:
> Having (hopefully) cleared that, I'm sorry to say that unless it's coded
> into the application (which would be located on the app server since the
> OP is talking about 3-Tier architecture) there is no way to get the
> information the OP is after.
>
Maybe it can be done using proxy authentication.
Only I'm not sure if the original ip is passed through the tiers... does
anybody have experience with this?
--
Fabrizio Magni
fabrizio.magni@mycontinent.com
replace mycontinent with europe
| |
| Oliver Gehlert 2005-07-31, 1:23 pm |
|
if you are running forms 10g (9.0.4) it is no problem at all. You can see
all session and the clients they are coing from using enterprise manager.
You have to change one paarameter in your default.env file to accomplish
this. It is well documented in the default.env file.
|
|
|
|