DbaNotePad

Oracle APPS DBA Blog

Archive for the ‘Release12’ Category

R12: What Is the OAFM JVM Process

Posted by dbanotepad on April 9, 2010

R12: What Is the OAFM JVM Process Used For?

When running adopmnctl.sh status you notice a java process-type named “OC4J-oafm”. When running adstrtal.sh you may observe that file adoafmctl.sh is called to What is this OAFM Java Virtual Machine? What is it used for, can it be turned off, and how is it scaled.

Solution

OAFM is short for “Oracle Applications Fusion Middleware”, however this doesn’t best describe what the JVM is currently used for.

More specifically the OAFM JVM is used for Map Viewer applications, Oracle Transport Agent XML transactions, and Web Services.

There are 2 applications in Release 12 that use Map Viewer, these are:

Field Service and Transportation Planning

You may be wasting resources on your server by starting the OAFM JVM’s if your not using Field Service, Transportation Planning, XML Gateway or Web services. If you are not using these products (see SQL query below) you may be able to safely disable the OAFM JVM. You can follow the steps below to stop the JVM from starting when running adstrtal.sh

1. Stop the OAFM JVM via adoafmctl.sh stop

2. Edit context via the context editor and change s_oafmstatus  to disabled

3. Run Autoconfig

Now when adstrtal.sh is run the adoafmctl.sh script will not be called and thus OAFM processes will not start. If you have more than one application tier please perform the actions above on all application tiers.

If you are using Field Service and/or Transportation Planning a good rule of thumb would be to have 1 OAFM jvm per 80-100 active Map Viewer users. Map data generally is quite large in size so stick to the lower end of the scale….80 users per JVM.

To adjust the number of OAFM JVMs edit context via the context editor and change s_oafm_nprocs to the number of JVMs required per node. Now run Autoconfig to propagate the change. Repeat the steps for each application tier.

Script to check if OAFM apps are being used (not a complete list, doesn’t include web services)

select fa.APPLICATION_SHORT_NAME, fpi.PATCH_LEVEL, DECODE(fpi.STATUS, ‘I’,’Installed’,
‘S’,’Shared’, ‘N’, ‘Inactive’, fpi.STATUS) Status , fpi.DB_STATUS
from fnd_product_installations fpi,FND_APPLICATION fa
where fpi.APPLICATION_ID in (
select APPLICATION_ID from FND_APPLICATION where APPLICATION_SHORT_NAME in (‘CSKF’,’MST’,’ECX’))
and fa.APPLICATION_ID=fpi.APPLICATION_ID;
where the status is like:
I= ‘Installed’
N=’Inactive’ – product is not fully implemented and not used.
S=’Shared’ are not fully implemented and patching these products isn’t required.

 

Posted in E-Business Suite, Release12 | Leave a Comment »

R12 File system changes

Posted by dbanotepad on April 2, 2010

File System

File Oracle Applications 11i Release 12
Environment Source file APPSORA.env APPS<SID>_<hostname>.env
Context File (middle tier) $APPL_TOP/admin/$TWO_TASK.xml $INST_TOP/appl/admin/$TWO_TASK_<hostname>.xml
tnsnames.ora (OH) $ORACLE_HOME/network/admin/<CONTEXT> $INST_TOP/ora/10.1.2/network/admin
listener.ora $ORACLE_HOME/network/admin/<CONTEXT> $INST_TOP/ora/10.1.2/network/admin
appsweb.cfg $OA_HTML/bin $INST_TOP/ora/10.1.2/forms/server
tnsnames.ora (Apache) $IAS_ORACLE_HOME/network/admin/<CONTEXT> $INST_TOP/ora/10.1.3/network/admin
zone.properties $IAS_ORACLE_HOME/Apache/Jserv/etc $ORA_CONFIG_HOME/10.1.3/j2ee/oacore/application-deployments/oacore/oa_servlets/orion-web.xml  and …/oacore/html/orion-web.xml
(Same file located in both directories)
jsev.properties $IAS_ORACLE_HOME/Apache/Jserv/etc $INST_TOP/ora/10.1.3/opmn/conf/opmn.xml
httpd.conf $IAS_ORACLE_HOME/Apache/Apache/conf $ORA_CONFIG_HOME/10.1.3/Apache/Apache/conf
apps.conf $IAS_ORACLE_HOME/Apache/Apache/conf $ORA_CONFIG_HOME/10.1.3/Apache/Apache/conf
formservlet.ini $IAS_ORACLE_HOME/Apache/Jserv/etc $ORACLE_HOME/forms/server/default.env
topfile.txt $APPL_TOP/admin $APPL_CONFIG_HOME/admin
adovars.env $APPL_TOP/admin $APPL_CONFIG_HOME/admin
adjborg2.txt $APPL_TOP/admin $APPL_CONFIG_HOME/admin
SSL Certificates $COMMON_TOP/admin/certs $INST_TOP/certs
AD scripts logs $COMMON_TOP/admin/log/<SID_hostname> $LOG_HOME/appl/admin/log
Concurrent Request logs $APPLCSF $APPLCSF
Apache logs $IAS_ORACLE_HOME/Apache/Apache/logs $LOG_HOME/ora/10.1.3/Apache
Jserv logs $IAS_ORACLE_HOME/Apache/Jserv/logs $LOG_HOME/ora/10.1.3/j2ee
javacache.log $COMMON_TOP/rgf/<SID_Hostname> $LOG_HOME/appl/rgf

Environment variables

Variable Oracle Applications 11i Release 12
APPL_TOP $HOME/<SID>appl $HOME/apps/apps_st/appl
COMMON_TOP $HOME/<SID>comn $HOME/apps/apps_st/comn
ORACLE_HOME (applmgr) $HOME/<SID>ora/8.0.6 $HOME/apps/tech_st/10.1.2
IAS_ORACLE_HOME $HOME/<SID>ora/iAS $HOME/apps/tech_st/10.1.3
ORACLE_HOME (oracle) $HOME/<SID>db/10.2.0 $HOME/db/tech_st/10.2.0
ORADATA $HOME/<SID>data $HOME/db/apps_st/data
JAVA_TOP, OA_JAVA $COMMON_TOP/java $COMMON_TOP/java/classes
OA_HTML $COMMON_TOP/html $COMMON_TOP/webapps/oacore/html
FND_SECURE $FND_TOP/secure/<SID> $INST_TOP/appl/fnd/12.0.0/secure
ADMIN_SCRIPTS_HOME $COMMON_TOP/admin/scripts/<SID> $INST_TOP/admin/scripts
LOG_HOME $INST_TOP/logs
FORMS_WEB_CONFIG_FILE $INST_TOP/ora/10.1.2/forms/server/appsweb.cfg
AF_JLIB $COMMON_TOP/java/lib
JAVA_BASE $COMMON_TOP/java
INST_TOP $HOME/inst/apps/<CONTEXT>
ORA_CONFIG_HOME $INST_TOP/ora
APPLCSF $COMMON_TOP/admin $LOG_HOME/appl/conc

Posted in Release12 | Leave a Comment »