Wednesday 20 September 2023

How to increase oacore/jvm processes in R12.1.3

Below are the steps to increase oacore process:

STEP1: Take a backup of context file and opmn.xml file. 
a. $INST_TOP/ora/10.1.3/opmn/conf/opmn.xml
b. $CONTEXT_FILE

STEP2: Modify $CONTEXT_FILE as follows
From
<oacore_nprocs oa_var="s_oacore_nprocs">1</oacore_nprocs>
To
<oacore_nprocs oa_var="s_oacore_nprocs">2</oacore_nprocs>

STEP3: Modify $INST_TOP/ora/10.1.3/opmn/conf/opmn.xml as follows
$INST_TOP/ora/10.1.3/opmn/conf/opmn.xml file under oacore section as follows:
<process-type id="oacore" module-id="OC4J" status="enabled" working-dir="$ORACLE_HOME/j2ee/home">
From
<process-set id="default_group" numprocs="1"/>
To
<process-set id="default_group" numprocs="2"/>

STEP4:
Bounce Apache services, no need of autoconfig.  If your application services are already running, just reload the ocaore processes using adopmnctl.sh reaload command.
                                                        OR 
Bounce the Application services for safe side.

Identify versions of components in EBS

Useful commands to find the versions of various components used in Oracle E-Business Suite

Log in to the Application server and source the environment fine and execute the below command.

Find Apache Version in R12

$IAS_ORACLE_HOME/Apache/Apache/bin/httpd -v

Find Perl Version in EBS

$IAS_ORACLE_HOME/perl/bin/perl -v|grep built

Find Java Version/JDK Version

cd $ADMIN_SCRIPTS_HOME/
sh java.sh -version

Find JRE Version

cat $FORMS_WEB_CONFIG_FILE|grep sun_plugin_version

Find Weblogic Version

cat $FMW_HOME/wlserver_10.3/.product.properties | grep WLS_PRODUCT_VERSION

Find Opatch Version

$ORACLE_HOME/OPatch/opatch lsinventory

Oracle EBS version from the backend then connect to the database as user apps,

Find Oracle EBS Version

SQL>select release_name from apps.fnd_product_groups;

Find AD & TXK version in R12

SQL>select ABBREVIATION, NAME, codelevel FROM apps.AD_TRACKABLE_ENTITIES where abbreviation in ('txk','ad');

Find Workflow Version in R12

SQL>select text ,name from wf_resources where name like '%WF_VERSION%';

Oracle has provisioned bulit in scripts to collect versions of technology stack components. Reference – 601736.1

For Application Tier

perl $FND_TOP/patch/115/bin/TXKScript.pl 
-script=$FND_TOP/patch/115/bin/txkInventory.pl 
-txktop=$APPLTMP -contextfile=$CONTEXT_FILE 
-appspass=<apps password> 
-outfile=<File_Directory>/<output_file_name>

For Database Tier

$ADPERLPRG $ORACLE_HOME/appsutil/bin/TXKScript.pl
-script=$ORACLE_HOME/appsutil/bin/txkInventory.pl 
-txktop=$ORACLE_HOME/appsutil/temp
-contextfile=$CONTEXT_FILE
-appspass=<apps password>
-outfile=<File_Directory>/<output_file_name>