Leave a Comment:
41 comments
Hi Atul,
Would like to Thank You very much for the initiative you have taken and helping the DBA’s like me.
Thank You once Again.
Varaha
ReplyAtul,
I followed all your atricles in ” For Apps DBA beginner’s ” they are very good.
I can definetly refer your site as a good steping stone for Starter APPS DBA’s.
Once again my heartfully thanks to you for doing this kind of job for future APPS DBA’s. So, pl. keep posting.
Regard
Sashidhar
Atul great wrk – as part of these – can you shed some lite on the different and important FND tables that dba’s need to be aware of
Thanks,
Vidya
Atul great wrk – as part of these – can you shed some light on the different and important FND tables that apps dba’s need to be aware of
Thanks,
Vidya
Vidya,
Thanks a lot for your compilments. I have listed few important Apps tables at my site .
To view Click Here for Imp Tables in Apps
Sorry I suppose above link is not working here is link
Click Here for Important Tables
Replyone late qustion autl, is there any way on earth that i can know the ip address of the clinet who are currently using my froms.
fadi
ReplyFadi,
You can raise as many questions you have , thats motto of this blog & site http://teachmeoracle.com ( Discovering Oracle Apps )
You can find out user name of person initiating forms but finding IP address of that person might be tricky.
You can get list of all IP address accessing your web server via access_log under Apache/Apache/logs
ReplyHi Atul,
Can you please clarrify my doubt?
(GUEST/ORACLE have you ever noticed why this user is there , Hope you know it now it Uses Guest User to autenticate your user in database )
My DBC file contains
GUEST_USER_PWD=GUEST/ORACLE
But I could not connect to the database using this user
SQL> connect GUEST/ORACLE
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
Even I could not connect using this username and pwd in the appication.
Please let me know is this database user or application user? If it is application user then using which user it is connecting to database to verify the application user and pwd?
Seelan
ReplySeelan,
This user is application user & not database user.
You should find this user in FND_USER (S) & not in DBA_USERS
Atul
ReplyHi Atul,
I think while logging in from the initial page(single sign on),oracle use APPLSYSPUB user,otherwise w/o logging into the database how FND_USERS can be verified for username.
please ,clarify in thorough details,
regards,
Vishal
Hi Vishal,
I think you are saying right let me cross verify & I’ll update accordingly
Atul
ReplyHi Everyone,
This is my understanding about the request flow in oracle apps and i would like to share with you
1. Webserver receives the user request for the particular port number. Web server Binds the request with the port number
2.Based on the cookie webserver serves the request by sending login page
3. The application user name and password is entered by the user(operations/welcome)
4. The application user login session is validated by connecting to Applsyspub/pub. Applsyspub contains application user session ,invalid logins,security related tables. The user & security is validated here
5. The responsibility page is displayed. User selects a particular responsibility
6. The responsibility and application name is validated by connecting to Applsys schema(fnd_Responsibility, fnd_application…….)
Note: Here we should remember the difference between applsys and apps schema. Applsys schema contains ad,fnd objects whereas apps schema is a global schema contains all application objects.
7. Once the application is validated , Connecting to apps schema to get access application tables. This is the reason why we should have apps and applsys passwords should be same
8. Once a particular form is selected the .dbc file is accessed to get the information about the GUEST username/pwd
But i am not sure when the webdbsvr.app file is getting used. My assumption is between step 3 and 4 the webdbsvr.app should get accessed to obtain the apps password.
Atul and everyone, Please correct me if i am wrong in my understanding.
reg
malar
Malar,
Very well explained , Yes you are right & I need to change my bit about GUEST by your APPLSYSPUB (It uses applsyspub first time)
wdbsvr.app is used by mod_pls in Apache (apps password in this file)
mod_pls is module in Oracle-Apache for executing plsql packages from browser.
its somthing like dads.conf in standalone application server
Atul
ReplyHi Atul ,
For beginners like me you are an angel in disguise.
Thanks you very much ,
Aarif
Hi Atul,
Your practical apps notes are excellent inspiration for all oracle apps dba’s around the globe. We really appreciate your effort – Shiva Geereddy
ReplyAtul/Malar,
I didnt understand when .dbc file is going to use, either when accessing a particular form or while giving application username/pwd.
Thanks,
Sai
Sai,
I noticed that if dbs file is corrupt or not present forms connection errors out though initial login works so I suppose this is forms which is issue but you can try at your end as well by moving dbc file to other location & try at what point it errors out.
Hi Atul,
I think you should have added that the Forms Server process spawns a forms client process ( f60sebmx) which actually talks to the client. The above statement remains correct when forms listener servlet is not used.
Chandra
ReplyHi Atul,
This is Rohit, just want to correct you that initial connection to validate user is made thru applsyspub/pub, no thru guest/oracle
Keep up the good Work
-Rohit
Replyhi Atul…
Thanks for the information….
and please specify the extensions (url’s) as much s possible..
thanks
raghu
HI atul,
while logging i get the following
serveranil@192.168.1.85‘s password:
Last login: Sat Jun 2 13:04:05 2007 from 192.168.1.232
-bash: /usrxit/devenv.env: No such file or directory
[serveranil@surya ~]$
also when i run APPSORA.env
[serveranil@surya kingappl]$ . APPSORA.env
-bash: /usrxit/devenv.env: No such file or directory
[serveranil@surya kingappl]$
plz let me know the solution
rgds,
krish
Krish for any issues or problems raise them in forum at http://teachMeOracle.com/forum
ReplyThat is a wonderful document which explains the flow in brief.
Can you please elaborate on significance of 9iAS here.
Atul,
I am working as an apps dba for 3 years. I have a doubt, though very basic, still in mind. What is the difference between users APPS and APPLSYS? I tried to find it many places but did not get any good answer.
Can you please discuss on this?
Thanks,
Sayantan
I think all needs to check out the things again that, APPLSYSPUB does the validation or its GUEST user does the work.
Do a simple test:-
==================
1)
Open a Putty/Fsecure session and connect as apps user.
2)
Do not execute this query but just make it ready on the screen so that you just need to press ENTER in order to execute this query.
set linesize 100
set pagesize 100
col HOW_MANY_USER_SESSIONS for a60
select ‘Number of sessions opened by user’ ||’ ‘|| fu.user_name || ‘ is ‘ || count(distinct session_id) How_many_user_sessions
from icx_sessions icx,fnd_user fu where disabled_flag != ‘Y’ and PSEUDO_FLAG = ‘N’
and (last_connect + decode(FND_PROFILE.VALUE(‘ICX_SESSION_TIMEOUT’), NULL,limit_time, 0,limit_time,FND_PROFILE.VALUE(‘ICX_SESSION_TIMEOUT’)/60)/24) > sysdate
and icx.user_id=fu.user_id group by icx.user_id,fu.user_name;
3)
Open iExplore and put your oracle Application URL
4)
Login as SYSADMIN
Immediately press ENTER on your PUTTY/FSecure session and again press “/” and again press “/” and again press “/” and again press “/” . do this until you see output as SYSADMIN.
Important:-
===========
Before SYSADMIN comes on to your screen, query output will show you GUEST as this is the one logs into in order to authenticate uesr SYSADMIN.
Check this out and do let me know if i have showed something wrong.
neerajblr@rediffmail.com
Thanks
Neeraj Kataria
hi atul
Thanks for such a nice expalination on how request flows.
it will really help us to understand the APPS architecture
Thanks a lot.
Ash
Replyvery good explaination ,must for newcommer as apps dba,i found it best among all the various sites in net.
kns
ReplyHi,
Atul your comments on neerajblr explaination.?
That part is still confusing?
Waiting ….for your comments..
Reply