Below are the steps to increase oacore process:
<oacore_nprocs oa_var="s_oacore_nprocs">1</oacore_nprocs>
From
I’m Oracle Certified Professional with 12+ years of experience managing UNIX- based Oracle Databases. As a working IT professional, I have experience in a wide range of mission critical technologies, specializing in database administration best practices for backup and recovery. I have hands-on experience with real-world Production environments and have risen in the ranks from a developer to a managing DBA.
Below are the steps to increase oacore process:
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
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
For Database Tier