We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
| Troubleshoot Oracle Apps Web Server and Login Issues |
| Wednesday, October 18, 2006 |
|
If you are accessing this page directly without looking at previous post on Web Server log files & basics then my suggestions are that you first go through link
http://becomeappsdba.blogspot.com/2006/10/oracle-apps-web-server-apache-login.html
Now by looking at error_log, jserv.log, mod_jserv.log you can find out error message & depending on error message you can try Metalink or Search engine for related error message encountered by others in past.
Most of the issues happen because of change so try to focus on what changed recently ( See if anything related to change is related) . Once you get first page http://hostname.domain:port
then there are few automated tool, scripts to check login issues.
If you don't get first page even i.e. http://hostname.domain:port then focus on error_log. error_log_pls in Apache/Apache/logs and jserv.log , mod_jserv.log in Apache/Jserv/logs
Once you get first page then when you try to login to application & login is not working then this can be because of number of reasons. In order to understand this you need to understand request flow in Apps . I posted about request flow in August and you can check link at
http://becomeappsdba.blogspot.com/2006/08/oracle-applications-request-flow.html
In order to authenticate your user against database in FND_USER table this request is passed from core Apache Module to mod_pls ( plsql) and it uses few files like wdbsvr.app in Apache/modplsql/conf $CONTEXT_NAME.dbc , tnsnames.ora in 806/network/admin/$CONTEXT_NAME , GUEST user & few other file so focus on these files & directories & see what changed recently. These are quite important and thats why you often these questions in apps dba interview .
Lot of you discussed about difference between GUEST & APPLSYSPUB account ( Both are Public User accounts with very basic access for authentication ). These both are defined in .dbc file under FND_SECURE one for Thin JDBC connection & another for Thick client .
If you can't login to oracle application by clicking on login link , check if
--- dbc file in FND_SECURE is correct.
--- APPL_SERVER_ID in dbc file matches with server ID in FND_NODES table against respective Server
--- GUEST/ORACLE password is correct & user is not end dated
--- APPS password is correct in wdbsvr.app file
--- Check http://hostname.domainnamel:port/pls/$SID and see if package fnd_web can ping & you get output in screen from FND_WEB.ping with correct database_id ( and check if there is correct dbc file in FND_SECURE with name $DATABASE_ID.dbc )
There is JSP tool test to find most of issues via
http://host.domain:port/OA_HTML/jsp/fnd/aoljtest.jsp
Apart from this if you have Metalink access there is very good note at metalink which you can refer
342332.1 Troubleshooting Login Problems in Oracle Applications 11i (11.5.2 Â 11.5.10+)
Tell me if you find this information Useful by leaving your comments .Labels: 11i, troubleshooting |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
 del.icio.us
¦
 Digg This
¦
 My Yahoo
¦
 Reddit
¦
 BlinkList
¦
 Furl It
¦
Email This
¦
Leave Your Comments
|
posted by Atul Kumar @ 5:13 PM
  |
|
| 15 Comments: |
-
Hi Atul,
Thanks for sharing ur knowledge.Doing a good work helping a lot.This is the first place where i can get lot of information on apps dba without searching for any topics.
Thanks & Regards,
From ALL APPS DBA's
-
Thanks a lot for your comments.
Do let me know what else you want to Hear , Few topics in pipeline (Yet to come )
- SSL Implementation
- Oracle OCT. CPU patches
- 10g AS Integration
-
Atul,
Thanks for pointing to the link for various apache related files. In one of my earlier project, I saw the following entry in one of the files (not sure if it is oprocmgr.conf or httpd_pls.conf or some other file), I want to know why it was kept so? Apologize, I dont exactly remember the entries.
One of the entry looked like the one given below. Can you please explain why it was kept so?
Allow from (ip address1)
Allow from (ip address2)
Thanks
Nagarajan
-
Atul,
Looking forward for your post on SSL implementation. Also I would like to know about the following. We have made some changes in a standard oracle package (pls file based on the suggestion from oracle). Now this pls file is compiled and working fine. Is there a way, that I can be notified if I apply a patch which could overwrite the change that I have made to this .pls file. (Like an email which says this patch has overwritten this file after I have applied the patch, so that I can reapply my customization again).
Thanks
Nagarajan
-
keep up the good work nice article i would lik hear about having more than one web/forms node how can i reach that.
fadi
-
Fadi,
Thanks a lot for your inputs . I'll cover it in my future posts.
Atul
-
thanks and keep up the good work i would like to haer about having more that one web/forms node on an apps env. have more than one access link so i can load balance my users.
fadi
-
Naga,
Tough question but good one .
You made changes in Package spec or both or both ? Is this package body wrapped or you can access it.
I think what you can do it write a Shell script & compare version
so lets say pls name is test.pls with version 115.12
variable a=adident test.pls | grep Header
if a > 115.12 send mail to your mail id .
You can run this scipt after patch or may be once a week or daily depending on how often you patch .
You need someone good in shell scripting
Atul
-
Naga Nice Question.
Some document, files, scripts are very senstive which normal user should not have access to . Like Admin related information & lot many other files related to administration & only administrator should have access. In some cases only a particular server should have access to particular module or file ( in your case mod_proc should only be accessed by core apache & not directly by users )
So the way to restrict is to use
Order allow,deny
Allow from XXXXX
Deny from XXXXX
only Allow persons from following IP's or Deny from follwoing IP's
Order clause determines preferences to given to Allow or Deny if there is overlap.
-
Hi atul,
When we run form server on OAM, If suddenly forms strucked then what we do?
Thanks
Asif
-
Asif,
Do you mean during startup or accessing .
Use adfrmctl.sh command line script.
-
Hi Atul,
Thanks for nice article.
Here i got a problem with my Apps login. I am running Apps 11.5.10 on my Laptop for the last one year it was working fine but for the last 2 days suddenly it stopped logging in. Services are working fine i can access backend everything fine. It is opening login page http://apps.test:8081/OA_HTML/AppsLocalLogin.jsp after I give UserID and Password there is noresponse even button itself is not showing any progress. Can you please advise on this issue. Really I need your help.
Thanaks in advance,
Gopi Krishna
-
Hi Atu,
I'm having the same problem as Gopi. By clicking on the 'Login' button, it does not bring me anywhere or the browser does not move at all. It was working before and not sure what's happening now. Please help!!!
Jac
-
Check Jserv logs at $IAS_ORACLE_HOME/Apache/Jserv/logs
-
I too have the same issue. I could not find any log files under $IAS_ORACLE_HOME/Apache/Jserv/logs
|
| |
| << Home |
| |
|
|
Hi Atul,
Thanks for sharing ur knowledge.Doing a good work helping a lot.This is the first place where i can get lot of information on apps dba without searching for any topics.
Thanks & Regards,
From ALL APPS DBA's