Saturday, December 02, 2006

Who is connected to my apps?

Who is connected to my apps?

Sometimes the apps dba needs to know who is connecting to apps right now and what responsibly are they using, user id, client ip address and other info.

We can get that up and running in simple steps.

-set the profile option (Sign-On:Audit Level) value to form. By default it is set to none.

-run the concurrent program (OAM Applications Dashboard Collection) this concurrent will fill some tables like fnd_oam_forms_rti with important data like IP address of the client, time, …etc.

-go to Oracle applications manager (OAM) and from the drop down menu choose (forms sessions) this will give you users that are connected to your apps with their responsibilities, user id, time, and which from are they using and a lot of other info.

-To get the ip address of those users you have to click on the (rti pid) filed. This will give you other screen with the information needed.

p.s kindly note that some OS like hp-ux have bug and it will show the ip address like rubbish and it need a patch to be applied in order to get the correct ip address displied.

fadi hasweh
Oracle is not Magic, it just takes years of experience

20 comments:

Atul Kumar said...

Nice one man ..

Anil Passi said...

Good job man, a small question though.

Do we have to run the process "OAM Applications Dashboard Collection" each time to see the latest Logged on people? Or is that information Auto-refreshed thereafter?

fhasweh said...

thank you anil, good qustion, you have to run this process each time but you need to know that this process is schedule to run by default every 10 minutes, techincaly you dont have to run it unless you need to know who is runing what at this specific time exactly and if you cannot wait the process to run by it self.

thank you for reading my blog
fadi

Passi said...

Hi Fadi, Please don't say thanks.
I enjoy reading Atul's and your blog.

Arunkumar said...

Nice tip Fadi.

Anonymous said...

Hi Fadi,
thanks for sharing this. i am a apps dba in leading consulting company in india. i have one qus. sometimes i observe that once you logon to the OAM fst time, "OAM Application Dashbord Collection" request is automatically schduled by default. it happens after cloning even if i have truncated fnd_concurrent_requets table. do u have any idea...
thanks
Mudit Srivastava

fhasweh said...

hi mudit,
i am not familiar with your case exactly but I think you should try to hold the request rather than truncating the table (try it on test please) maybe some user on the blog can help us out.

update fnd_concurrent_requests r
set r.hold_flag='Y'
where
concurrent_program_id=0

fadi

fhasweh said...

hi mudit,
i think it will be easier jut to disable this Concurent Request from sysadmin->Concurrent --> Program --> Define and uncheck the enable check box.

fadi

Anil Passi said...

Hi Fadi,

Well done, its hardwork I know, and you are making very good progress.

I would like to publish your blog feed on
http://oracle.anilpassi.com/news/index.php

Please grant me the permission.

Thanks,
Anil Passi

fhasweh said...

Dear Anil,
thank you, its you and all the others who read my posts who is making me keep posting, i am happy to hear that you want to publish my blog feeds, but sorry I don't know how can I grant you permission is it an sql grant statement ;-), plz inform me how and I will be more that happy to give you permission.

thank you all,
fadi

Irfan said...

Hi Fadi,

Nice post. Keep up the goodwork.

Regards,
Irfan Momin

fhasweh said...

thank you irfan and welcome

fadi

Anonymous said...

thanks Fadi. My boss asked me the same question.. who is using the system yesterday. I have no answer... If I change the audit to form, does it able to track the self-service user like CRM users who is using java to login?

fhasweh said...

dear snonymous thank you for reading my posts, but auti just tarce froms, i am not sure if there is any thing in apps that can track the self-service user as stander i think it can be managed by customization. plz if you managed to get an answer for that qustion please let us know sorry that i cannot help.

thanks
fadi

Arunkumar said...

fadi, what is the patch for hp-ux to be applied? can i use this in my 11i8 instance? what oam patchset levels?

fhasweh said...

hi arun,
i applied patch no. 3783239 for my hp-ux, i am not sure about 11i8 but you can check on metalink.

good luck
fadi

Channesh said...

Fadi,
You can as well as run the "ACTIVE USER" concurrent request fro the same right?
regards,
Channesh

fhasweh said...

Channesh ,
no "active users" is just a report of the users who are registerd (created) at your application.

Anonymous said...

Hi Fadi,

Thanks for sharing this.

I have implimented same in our local Vision instance, but data was not populated in fnd_oam_forms_rti table. Do we need to do some other setup or only changing profile to Form is enough, please advise. I have to impliment same to one of our client.
Thanks
VK Babu

fhasweh said...

you dont have to do any thing else only that. try to restart middle tire after that
fadi