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
