Apache So when you try to access by aashu4uiit


									So when you try to access login page via URL http://hostname.domainname:portnumber and if you don’t see page you need to look into log files . As you know there are two main component of Web Server Core Apache & Jserv ( for Java requests) Core Apache Log Files Core Apache log files are in directory $IAS_ORACLE_HOME/Apache/Apache/logs - error_log or error_log.$timestamp - error_log_pls or error_log_pls.$timestamp Jserv Log files Jserv log files are in directory $IAS_ORACLE_HOME/Apache/Jserv/logs and JVM ( Java Virtual Machine ) logs at $IAS_ORACLE_HOME/Apache/Jserv/logs/jvm Check if you see any error message in Jserv/logs mod_jserv.log or jserv.log. jserv.log by default is disabled so if you want to find any error message w.r.t. jserv.log then change log=false to log=true in jserv.properies and bounce webserver/apache using adapcctl.sh and check any error message. When you start Apache you should see clean start up of Web Server & no error message in this log files. Common Problems in Starting Apache Here is the list of common problems while starting web server which might be useful to you in appsdba Interview are - Could not bind port (Port already in Use) - found .pid file ( When Apache starts it creates .pid file in logs directory and when you shutdown apache it cleans this .pid file so if this file is already there then Apache will not start. Fix: Simply move this file If there is no error messages in error_log or error_log_pls then there might be issues in starting Jserv component of web server ( which caters Java requests by mod_jserv) - mobile is enabled in zone.properties disable it if you are not using it . If you mistype any directive in Apache ( httpd.conf or any conf file ) Apache will not start & it will not write even in error_log in that case it will report any error message related to mis configuration in directive in file $COMMON_TOP/admin/log/$CONTEXT_NAME/adapcctl.txt I hope once you have error message you can check related hits in metalink or oracle forums or any other Apps Forum. Most of the error message are because of changes , so check what changes you made recently. Once you are able to access http://hostname.domainname:port and if you are getting any error message that means your web server ( Core Apache ) is working but there are various component called as modules and there may be issues with those modules which we will check these modules in next post. few modules of our interest are -mod_jserv

-mod_pls -mod_oprocmgr -mod_ossl (If you have ssl enabled on web server ) -mod_osso (If single sign on server is enabled on web server) If you don’t know port number of your web server you can check it in file $IAS_ORACLE_HOME/Apache/Apache/conf/httpd.conf with directive Listen & Port 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-apachelogin-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

To top