Oracle EBS R12.X - cpadmin.sh Concurrent Processing Command-Line Utility

The command-line utility cpadmin consolidates various existing utilities for concurrent processing into a single menu-based utility 

This adadmin-style utility can be used for multiple tasks, including:

1.Manager Status

2.Clean CP Tables

3.Set Manager Diagnostics

4.Manager Control

5.Rebuild Manager Views

6.Move Request Files

7.Analyze Request

Running the cpadmin utility:

Complete the steps below to run the command-line utility and its maintenance tasks.

1. Set the environment.
   
   
2. From any directory, start cpadmin with this command:
   $ cpadmin.sh
   
   
3. Respond to prompts. 
4. Choose one of the tasks listed above.
5. Exit the cpadmin utility.

For more information , one can refer the MOS Doc id : 2319585.1

Oracle EBS R12.2 - Integrated with OAM and OID - Check the sequence of HTTP requests

Confirm that APPS_AUTH_AGENT is properly redirecting to WebGate

Confirm that the mod_weblogic plugin on your WebGate installation is correctly proxying to Oracle WebLogic Server

Confirm that Oracle E-Business Suite AccessGate is running, and processing the OAM headers

Oracle EBS R12.2 - Oracle E-Business Suite AccessGate Version

Change to the directory where fndauth.war exists, and run the command 

$ java -jar fndauth.war

  Ebusiness AccessGate 1.1.0.1 Fri Mar 4 16:49:04 EST 2011

Oracle EBS R12.2 - Inventory report (Technology stack) to collect a list of patches applied

Run  the below command on application tier of EBS R12.2

$ADPERLPRG $FND_TOP/patch/115/bin/TXKScript.pl -script=$FND_TOP/patch/115/bin/txkInventory.pl -txktop=$APPLTMP -contextfile=$CONTEXT_FILE -appspass=<appspassword> -outfile=$APPLTMP/Report_App_Inventory.html

Oracle EBS R12.2 - Enable debug for opmn

To enable debug for opmn, edit 

$IAS_ORACLE_HOME/instances/<instance>/config/OPMN/opmn/opmn.xml

Change the following line

        <debug comp="" rotation-size="1500000"/>
        to
        <debug comp="ons[all];pm[all]" rotation-size="1500000"/>

Oracle EBS R12.2 - 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
=========================================================================

Oracle EBS R12.2 - Collect AccessGate LogFiles

Create a file call logging.properties in 
$FMW_HOME/Oracle_EBS-app1/deployment_plans/accessgate with below information

           # Use this file as the LOG_CONFIG_FILE during deployment.

           #
           #
           #---------------------------------------------
           #  Global properties
           #---------------------------------------------
           handlers=java.util.logging.FileHandler
           #---------------------------------------------
           # Default global logging level.
           .level= ALL
           #---------------------------------------------
           # Handler specific properties.
           #---------------------------------------------
           java.util.logging.FileHandler.pattern = /tmp/fndauth%u.log
           java.util.logging.FileHandler.limit = 100000
           java.util.logging.FileHandler.count = 1
           java.util.logging.FileHandler.level = FINE
           java.util.logging.FileHandler.formatter = java.util.logging.SimpleFormatter

           #Ebusiness AccessGate modules
           oracle.apps.fnd.ext.common.level=FINE
           oracle.apps.fnd.ext.common.server.level=FINE

 Take a backup of  $INST_TOP/appl/admin/oaea_wls.properties 

 Make below change

 From

      LOG_CONFIG_FILE=
 To
      LOG_CONFIG_FILE=<Absolute path to logging.properties>

 Restart oaea_server1 manage server

        $ADMIN_SCRIPTS_HOME/admanagedsrvctl.sh stop oaea_server1
        $ADMIN_SCRIPTS_HOME/admanagedsrvctl.sh start oaea_server1

  OR

    Restart EBS Accessgate Manage server .

            Login to WLS console 

            Login as weblogic user  

                        > Environment under Domain Structure

                                 > Servers 

                                        >  control

                                                > Select EBS accessgate manage server

            shutdown and start .

Collect  Following logfiles for review:

We can collect log file from two path depend on the patch applied

----------------------------------------------------------------------------------------------------------------------

First Path

$IAS_ORACLE_HOME/instances/EBS_web_<InstanceName>_OHS1/diagnostics/logs/OHS/EBS_web_<Instance Name>/

access_log
console~OHS~1.log
oblog.log

Second Path
if Patch 27294892: CONSOLIDATED PATCH ON TOP OF TXK DELTA 10 or higher applied path will be $IAS_ORACLE_HOME/instances/EBS_web_OHS1/diagnostics/logs/OHS/EBS_web_ohs1)

access_log
console~OHS~1.log
oblog.log

----------------------------------------------------------------------------------------------------------------------

From $EBS_DOMAIN_HOME/servers/oaea_server1/logs
oaea_server1.log
oaea_server1.out
access.log
----------------------------------------------------------------------------------------------------------------------
From $EBS_DOMAIN_HOME/ or /tmp
fndauth.log