Analysing EBS Login Issue

Analysing EBS Login Issue

E-Business Suite Applications Login Analyzer( Doc ID 2319360.1 )

E-Business Suite: WLS (WebLogic Server) Utility (Doc ID 2230225.1)

12.2 E-Business Suite - Collecting Fusion Middleware Log Files (Doc ID 1362900.1)

a) OPMN and OHS log files

Run this script as the owner of the applications file system to gather the log files for OPMN and OHS services:

zip -r /tmp/`uname -n`_`date +%m%d%y.%H%M`_OPMN_OHS.zip $IAS_ORACLE_HOME/instances/*/diagnostics/logs/OHS/*/*log* $IAS_ORACLE_HOME/instances/*/diagnostics/logs/OPMN/opmn/*

b) WebLogic Server

Run this script as the owner of the applications file system to gather the log files for Fusion Middleware components such as NodeManager, AdminServer, forms, oacore and oafm services:

zip -r /tmp/`uname -n`_`date +%m%d%y.%H%M`_FMW.zip $IAS_ORACLE_HOME/../wlserver_10.3/common/nodemanager $EBS_DOMAIN_HOME/servers/oa*/logs/*out* $EBS_DOMAIN_HOME/servers/oa*/logs/*log* $EBS_DOMAIN_HOME/servers/forms*/logs/*out* $EBS_DOMAIN_HOME/servers/forms*/logs/*log* $EBS_DOMAIN_HOME/servers/AdminServer/logs/*out* $EBS_DOMAIN_HOME/servers/AdminServer/logs/*log* $EBS_DOMAIN_HOME/sysman/log/* $EBS_DOMAIN_HOME/servers/oac*/adr/diag/ofm/EBS_domain_*/oac*/incident/* $EBS_DOMAIN_HOME/servers/forms_s*/adr/diag/ofm/EBS_domain_*/forms_s*/incident/*

These 2 commands will create zip files in the /tmp directory with names including server name and date. e.g. server.customer.com_092811.2005_OPMN_OHS.zip.  Please collect these files from the /tmp directory and upload them to your service request.

Alternative...

Use the following script to gather the Apache, WLS and Apps log files which have been modified in the last 1 day

#####################################################################################
####     Start of script
#####################################################################################
(
# pick up files which have been modified in the last 1 day only
HowManyDaysOld=1
echo "Picking up files which have been modified in the last ${HowManyDaysOld} days"
set -x
find $LOG_HOME -type f -mtime -${HowManyDaysOld} > m.tmp
find $FMW_HOME/webtier/instances/*/diagnostics/logs -type f -mtime -${HowManyDaysOld} >> m.tmp
find $FMW_HOME/wlserver_10.3/common/nodemanager/nmHome*/*.log -type f -mtime -${HowManyDaysOld} >> m.tmp
##  Get log files for only the WLS servers needed.   Valid server names are one or more of:
##      AdminServer forms-c4ws_server  forms_server  oacore_server  oaea_server  oafm_server
for SERVERNAME in AdminServer oacore_server forms_server oafm_server
do
   find $EBS_DOMAIN_HOME/servers/${SERVERNAME}*/logs -type f -mtime -${HowManyDaysOld} >> m.tmp
   find $EBS_DOMAIN_HOME/servers/${SERVERNAME}*/adr/diag/ofm/EBS_domain_*/${SERVERNAME}*/incident -type f -mtime -${HowManyDaysOld} >> m.tmp
done
zip -r mzAppsLogFiles_`hostname`_`date '+%m%d%y'`.zip -@ < m.tmp
rm m.tmp
) 2>&1 | tee mzLogZip.out
#####################################################################################
####     End of script
#####################################################################################

###################################################################################

OBJECTS MODIFIED BETWEEN TIME 

select owner,object_type,object_name,to_char(created,'MM-DD-YY HH24:MI:SS'),to_char(LAST_DDL_TIME,'MM-DD-YY HH24:MI:SS') from dba_objects

where to_char(LAST_DDL_TIME,'MM-DD-YY HH24:MI:SS') between '10-11-18 16:00:00' and '10-11-18 17:04:59'

 ###################################################################################

 

 

Below Command will Zip all logs and creates file zip file under /tmp

zip -r /tmp/`uname -n`_`date +%m%d%y.%H%M`_OPMN_OHS.zip $IAS_ORACLE_HOME/instances/*/diagnostics/logs/OHS/*/*log* $IAS_ORACLE_HOME/instances/*/diagnostics/logs/OPMN/opmn/* 

zip -r /tmp/`uname -n`_`date +%m%d%y.%H%M`_FMW.zip $IAS_ORACLE_HOME/../wlserver_10.3/common/nodemanager $EBS_DOMAIN_HOME/servers/oa*/logs/*out* $EBS_DOMAIN_HOME/servers/oa*/logs/*log* $EBS_DOMAIN_HOME/servers/AdminServer/logs/*out* $EBS_DOMAIN_HOME/servers/AdminServer/logs/*log* $EBS_DOMAIN_HOME/sysman/log/* $EBS_DOMAIN_HOME/servers/oac*/adr/diag/ofm/EBS_domain_*/oac*/incident/*

ENABLE AFL LOGGING

1/ Source the run file system environment file

2/ Backup file:

$INST_TOP/appl/admin/oacore_wls.properties

3/ Edit $INST_TOP/appl/admin/oacore_wls.properties and add the following lines. (adjust the variables accordingly)

AFLOG_ENABLED=true

AFLOG_LEVEL=statement

AFLOG_MODULE=%

AFLOG_FILENAME=/tmp/aflog.txt

4/ Re-start Middle tier services

5/ Reproduce the issue

6/ Collect the log file

7/ Disable logging by removing the lines which were addded to oacore_wls.properties and re-start services