Troubleshoot Oracle Apps Web Server and Login Issues

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://onlineappsdba.com/index.php/2006/10/15/oracle-apps-web-server-apache-login-troubleshooting/

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

Share This Post with Your Friends over Social Media!

About the Author Atul Kumar

Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Oracle Gold Partner specialising in Design, Implement, and Trainings.

follow me on:

Leave a Comment:

22 comments
Anonymous says October 19, 2006

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

Reply
Atul Kumar says October 19, 2006

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

Reply
Anonymous says October 19, 2006

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

Reply
Anonymous says October 19, 2006

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

Reply
fhasweh says October 19, 2006

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

Reply
Atul Kumar says October 19, 2006

Fadi,
Thanks a lot for your inputs . I’ll cover it in my future posts.

Atul

Reply
fhasweh says October 19, 2006

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

Reply
Atul Kumar says October 19, 2006

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

Reply
Atul Kumar says October 19, 2006

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.

Reply
Mohd says September 1, 2007

Hi atul,

When we run form server on OAM, If suddenly forms strucked then what we do?

Thanks
Asif

Reply
Atul Kumar says September 1, 2007

Asif,
Do you mean during startup or accessing .

Use adfrmctl.sh command line script.

Reply
Gopi says September 7, 2007

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

Reply
murali says October 4, 2007

Dear : Mr.Atul

my Qn is ,can v do the 4 node(DB/Conc+rep+admin/Web/frm) installation by using rapid wiz? and wch would define frist in rapid wiz ?

bye 4 now

cheers:
murali

Reply
Atul says October 4, 2007

Yes Murali,
You can do this configuration

Check Install Guide at http://download.oracle.com/docs/cd/B25516_18/current/acrobat/r115102ins.pdf

under chapter 3 Page 65, first install Database and any other services on that node (like CM) and rest other servers you can install in any order

Atul

Reply
P Ahuja says December 3, 2007

Dear Atul
Except for couple of users, I want to disable access to our Apps instance. How could I achieve this objective. Thanks & regards
P Ahuja

Reply
Subhankar says December 5, 2008

I am getting the following message while navigating some of the menus in the Oracle GRC Manager

Exception
The ‘OraOLEDB.Oracle’ provider is not registered on the local machine.

Reply
Atul Kumar says December 5, 2008

Is GRC manager you are running on windows ?

Check metalink note # 215255.1 Unable to Connect to Database with Oracle Client Software for Windows

Reply
abdul says March 22, 2011

Thanks A lot men for you help to all

Reply
trmohan61 says November 30, 2012

Hi,

I was trying to log in to Oracle Apps R12. It is not able to show me the login page. Says Error 404. Could you help me out in this issue so as not to loose all the setup i had already done on ORACLE HRMS.

Reply
sdjaveedapps says January 23, 2013

System parameter file is /apps/demodb/9.2.0/network/admin/DEMO_apps11i/listener.ora
Log messages written to /apps/demodb/9.2.0/network/admin/demo.log
Trace information written to /apps/demodb/9.2.0/network/admin/demo.trc
Trace level is currently 0

Started with pid=19050
24-JAN-2013 10:56:52 * 12502
TNS-12502: TNS:listener received no CONNECT_DATA from client
Error listening on: (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCDEMO))
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
Linux Error: 98: Address already in use

Reply
sdjaveedapps says January 23, 2013

System parameter file is /apps/demodb/9.2.0/network/admin/DEMO_apps11i/listener.ora
Log messages written to /apps/demodb/9.2.0/network/admin/demo.log
Trace information written to /apps/demodb/9.2.0/network/admin/demo.trc
Trace level is currently 0

Started with pid=19050
24-JAN-2013 10:56:52 * 12502
TNS-12502: TNS:listener received no CONNECT_DATA from client
Error listening on: (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCDEMO))
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
Linux Error: 98: Address already in use

please solve my issue

Reply
    Atul Kumar says January 23, 2013

    @ sdjaveedapps,
    Check if DB listener port is already in use by other application

    Atul

    Reply
Add Your Reply

[i]
[i]