Identifying clients in 3 tier architectre

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

anish - 18 Jul 2005 08:08 GMT

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.

Reply to this Message

sybrandb@yahoo.com - 18 Jul 2005 09:13 GMT

Just look at the machine column in v$session.

Signature

Sybrand Bakker
Senior Oracle DBA

Reply to this Message

anish - 18 Jul 2005 10:34 GMT

Actually i want to identify the client machine/ip who is connecting to
database by opening a 'form' thru his browser.

Reply to this Message

IANAL_VISTA - 18 Jul 2005 14:30 GMT

> 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/docs/cd/B14099_03/index.htm

Reply to this Message

Holger Baer - 18 Jul 2005 14:50 GMT

>>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.".

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

Reply to this Message

Maxim Demenko - 18 Jul 2005 15:12 GMT

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
[quoted text clipped - 3 lines]
> 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

Reply to this Message

Holger Baer - 18 Jul 2005 16:35 GMT

> Holger Baer schrieb:
>
[quoted text clipped - 15 lines]
>
> 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

Reply to this Message

Fabrizio - 19 Jul 2005 05:55 GMT

> 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?

Signature

Fabrizio Magni

fabrizio.magni@mycontinent.com

replace mycontinent with europe

Reply to this Message

anish - 18 Jul 2005 17:14 GMT

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

Reply to this Message

DA Morgan - 18 Jul 2005 17:46 GMT

> actually some users have locked certain resources in the database..i
> want to identify their session and kill them... in this system multiple
[quoted text clipped - 4 lines]
> 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.

Signature

Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

Reply to this Message

Oliver Gehlert - 31 Jul 2005 18:26 GMT

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.

Reply to this Message

Joel Garry - 18 Jul 2005 22:04 GMT

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

Signature

@home.com is bogus.
Search for perticular on metalink.

Reply to this Message