DbaNotePad

Oracle APPS DBA Blog

Archive for the ‘E-Business Suite’ Category

Copy ConcurrentQueue Definition between environments

Posted by dbanotepad on July 8, 2013

Found following command to be useful when copying new concurrent queue between source and target environments.

SOURCE:
FNDLOAD apps/appspass 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpque.lct concurrent_queue_name.ldt QUEUE APPLICATION_SHORT_NAME=XXABC CONCURRENT_QUEUE_NAME=”Custom_Manager”

TARGET:

FNDLOAD apps/appspass 0 Y UPLOAD $FND_TOP/patch/115/import/afcpque.lct concurrent_queue_name.ldt QUEUE APPLICATION_SHORT_NAME=XXABC CONCURRENT_QUEUE_NAME=”Custom_Manager”

Posted in E-Business Suite | Leave a Comment »

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: Miscellaneous

Posted by dbanotepad on April 2, 2010

Automatic Compilation of JSP pages

In Release 12 the (automatic) compilation of JSP is disabled and on runtime only the pre-compiled JSP’s are picked up. Since this requires less checks to be done the performance is improved. Therefore this is the recommended setting for a Production environment where JSP’s will only be replaced occasionally.

In cases where development activities are done and JSP pages are changing often this default setting makes things more complicated. Each time a JSP is deployed a manual compilation using the ojspCompile.pl is needed and the OC4J running the oacore needs a restart to pick up the changes. This will also affect other people working on the same environment

change the setting for main_mode from justrun to recompile in

$INST_TOP /ora/10.1.3/j2ee/oacore/application-deployments/oacore/html/orion-web.xml

This can be achieved by performing the following:

  • Login into E-Business suite and select System Administrator responsibility
  • Select function AutoConfig (under Oracle Applications Manager)
  • For each MT server perform the following:
    • Click on pencil icon under Edit Parameters
    • Select tab System
    • Expand section jtff_server
    • Change value for the entry s_jsp_main_mode from justrun to recompile
    • Confirm the change by clicking Save button
  • Run Autoconfig to propagate the changes to the configuration files
  • Verify that the $INST_TOP/ora/10.1.3/j2ee/oacore/application-deployments/oacore/html/orion-web.xml  has   
      <init-param>
         <param-name>main_mode</param-name>
         <param-value>recompile</param-value>
      </init-param>
  • Restart the Middle Tier services
  • Request a JSP in the browser which is compiled. See that a new _<jspname>.class is created in _pages
  • Make a change in the JSP file
  • Request it again in the browser. See that _<jspname>.class is ‘refreshed’ in _pages and the change is seen in the browser

 

Posted in E-Business Suite | 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 »