How to troubleshoot Login issues of Apps Applications

How to troubleshoot Login issues of Apps Applications

Action Plan:


1. Please do the following:

- stop all middle tier services

- make sure to delete the states and persistence files:
rm -fr $INST_TOP/ora/10.1.3/j2ee/oacore/persistence/*
rm -fr $INST_TOP/ora/10.1.3/j2ee/oafm/persistence/*
rm -fr $INST_TOP/ora/10.1.3/j2ee/forms/persistence/*

rm $ORA_CONFIG_HOME/10.1.3/opmn/logs/states/*

- Clear the TLD cache. Delete/backup the file:

$COMMON_TOP/_TldCache

- start all middle tier services

- Retest

2. If the issue still exist, please perform the following in order to obtain more information:

- Shutdown the http server, oc4j and opmn services
adapcctl.sh stop adoacorectl.sh stop adformsctl.sh stop adoafmctl.sh stop adopmnctl.sh stop

- Backup and then delete existing log files in (THIS IS IMPORTANT STEP TO GET FRESH LOG FILES):
$LOG_HOME/ora/10.1.3/Apache
$LOG_HOME/ora/10.1.3/j2ee
$LOG_HOME/ora/10.1.3/opmn
$APPLRGF/javacache.log

- Enable HTTP/OC4J/OPMN debug logging

Enable http ODL logging
-----------------------------
Edit httpd.conf file, add the following to the end of file
$ORA_CONFIG_HOME/10.1.3/Apache/Apache/conf/httpd.conf

OraLogMode oracle
OraLogSeverity TRACE:32

- Make the following directories which will be where the log files are created
mkdir $LOG_HOME/ora/10.1.3/Apache/oracle
mkdir $INST_TOP/pids/10.1.3/Apache/logs/oracle

- Increase OACore OC4J logging
----------------------------
edit j2ee-logging.xml adjust the following in file:
$ORA_CONFIG_HOME/10.1.3/j2ee/oacore/config/j2ee-logging.xml

<logger name='oracle' level='TRACE:32' useParentHandlers='false'>

edit orion-web.xml adjust the following in file:
$ORA_CONFIG_HOME/10.1.3/j2ee/oacore/application-deployments/oacore/html/orion-web.xml

param-name>debug_mode</param-name>
<param-value>true</param-value>

- Increase OPMN Logging
-------------------------------
edit opmn.xml adjust the following in file:
$ORA_CONFIG_HOME/10.1.3/opmn/conf/opmn.xml

<debug path="/u01/inst/apps/JB_atg/logs/ora/10.1.3/opmn/opmn.dbg" comp="
internal;ons;pm" rotation-size="1500000" rotation-hour="0" />

- Enable AFLogging
Open the file $ORA_CONFIG_HOME/10.1.3/j2ee/oacore/config/oc4j.properties in a text editor

Add:the following values:
AFLOG_ENABLED=true
AFLOG_LEVEL=statement
AFLOG_MODULE=%
AFLOG_FILENAME=/tmp/debug.log

- Startup the http server, oacore oc4j, forms oc4j, oafm oc4j and opmn

- Check the services status
$ADMIN_SCRIPTS_HOME/adopmnctl.sh status

- Try to login

- Review all the files from:
$LOG_HOME/ora/10.1.3/Apache
$LOG_HOME/ora/10.1.3/j2ee
$LOG_HOME/ora/10.1.3/opmn
$APPLRGF/javacache.log
$INST_TOP/appl/admin/<instance>.xml
$ORA_CONFIG_HOME/10.1.3/opmn/conf/opmn.xml
/tmp/debug.log