DbaNotePad

Oracle APPS DBA Blog

Archive for April, 2010

11g: Location Of Different Forms Configuration Files in Fusion Middleware Forms and Reports

Posted by dbanotepad on April 12, 2010

Unix:

ORACLE_HOME=/Oracle/Middleware/Oracle11g
ORACLE_INSTANCE=/Oracle/Middleware/instances/fr_inst
MW_HOME=/Oracle/Middleware
WL_HOME=/Oracle/Middleware/wlserver_10.3
DOMAIN_HOME=/Oracle/MiddleWare/user_projects/domains/ClassicDomain

Location of the Forms configuration files in FMW 11.1.1.1 and 11.1.1.2 and  Application Server 10gR2 installation:

Files Location in 11.1.1.2.0 Location in 11.1.1.1.0(R1) Location in 10.1.2
Jar files ORACLE_HOME/as_1/forms/java ORACLE_HOME/as_1/forms/java ORACLE_HOME/forms/java
Webutil DLLs
(d2kwutil.dll, JNIsharedstubs.dll)
ORACLE_HOME/as_1/forms/webutil ORACLE_HOME/as_1/forms/webutil ORACLE_HOME/forms/webutil
Trace Files ORACLE_INSTANCE/FormsComponent/forms/trace ORACLE_INSTANCE/FormsComponent/forms/trace ORACLE_HOME/forms/trace
frmbld, frmcmp,frmcmp_batch ORACLE_HOME/as_1/bin ORACLE_HOME/as_1/bin ORACLE_HOME/bin
webutil.cfg, ftrace.cfg ORACLE_INSTANCE/config/FormsComponent/forms/server ORACLE_INSTANCE/config/FormsComponent/forms/server ORACLE_HOME/forms/server
Registry.dat DOMAIN_HOME/config/fmwconfig/servers/WLS_FORMS/applications/formsapp_11.1.1/config/forms/registry/oracle/forms/registry ORACLE_INSTANCE/config/FormsComponent/forms/registry/oracle/forms/registry ORACLE_HOME/forms/java/oracle/forms/registry
forms.conf ORACLE_INSTANCE/config/OHS/<OHS Instance>/moduleconf ORACLE_INSTANCE/config/OHS/<OHS Instance>/moduleconf ORACLE_HOME/forms/conf
formsweb.cfg, default.env DOMAIN_HOME/config/fmwconfig/servers/WLS_FORMS/applications/formsapp_11.1.1/config/ DOMAIN_HOME/servers/WLS_FORMS/stage/formsapp/11.1.1/formsapp/config ORACLE_HOME/forms/server
basejpi.htm,base.htm, webutilbase.htm, webutiljpi.htm ORACLE_INSTANCE/config/FormsComponent/forms/server DOMAIN_HOME/servers/WLS_FORMS/stage/formsapp/11.1.1/formsapp/config
tnsnames.ora, sqlnet.ora ORACLE_INSTANCE/config ORACLE_INSTANCE/config ORACLE_HOME/network/admin
fmrweb.res (windows)fmrweb.res(Unix) ORACLE_INSTANCE\configFormsComponent\formsORACLE_INSTANCE/config/FormsComponent/forms/admin/resource/<country> ORACLE_INSTANCE\configFormsComponent\formsORACLE_INSTANCE/config/FormsComponent/forms/admin/resource/<country> ORACLE_HOME\formsORACLE_HOME/forms/admin/resource/<country>

 

Posted in Fusion Middleware | Leave a Comment »

11g: Fusion middleware 11.1.1.2.0 start/stop scripts

Posted by dbanotepad on April 12, 2010

Startup and Shutdown of Java (Admin/Managed servers) and System ( OPMNCTL  OHS etc) can be done in many different ways per documentation but here is what I have started using in our environment without node manager for shutdown/startup.

Stop Script:

#!/bin/ksh
MW_HOME=/opt/product/middleware/11.1
DOMAIN_HOME=$MW_HOME/user_projects/domains/FormsReports
INSTANCE_HOME=$MW_HOME/fr_inst
export MW_HOME DOMAIN_HOME INSTANCE_HOME
echo “Shutting down AdminServer …”
nohup $DOMAIN_HOME/stopWebLogic.sh >/dev/null 2>/dev/null &
echo “Shutting down WLS_FORMS …”
nohup $DOMAIN_HOME/bin/stopManagedWebLogic.sh WLS_FORMS “t3://localhost:7001/” >/dev/null 2>/dev/null &
echo “Shutting down WLS_REPORTS …”
nohup $DOMAIN_HOME/bin/stopManagedWebLogic.sh WLS_REPORTS “t3://localhost:7001/” >/dev/null 2>/dev/null &
echo “Shutting down OPMN managed components …”
$INSTANCE_HOME/bin/opmnctl stopall

sleep 90

echo “Killing processes forcefully after waiting for 90 secs..”
kill -9 `ps -eaf | grep -v grep | grep java | grep weblogic | egrep ‘WLS_FORMS|WLS_REPORTS|Admin’ | awk ‘{print $2}’`

Start Script:

#!/bin/ksh
MW_HOME=/opt/product/middleware/11.1
DOMAIN_HOME=$MW_HOME/user_projects/domains/FormsReports
INSTANCE_HOME=$MW_HOME/fr_inst
export MW_HOME DOMAIN_HOME INSTANCE_HOME
echo “Starting up the AdminServer …”
nohup $DOMAIN_HOME/startWebLogic.sh >/dev/null 2>/dev/null &
sleep 120
echo “Starting up WLS_FORMS …”
nohup $DOMAIN_HOME/bin/startManagedWebLogic.sh WLS_FORMS “t3://localhost:7001/” >/dev/null 2>/dev/null &
echo “Starting up WLS_REPORTS …”
nohup $DOMAIN_HOME/bin/startManagedWebLogic.sh WLS_REPORTS “t3://localhost:7001/” >/dev/null 2>/dev/null &
echo “Starting up the OPMN managed components …”
$INSTANCE_HOME/bin/opmnctl startall

Posted in Fusion Middleware | 2 Comments »

11g: Fusion Middleware 11.1.1.2.0 Installation Notes

Posted by dbanotepad on April 12, 2010

Have recently installed Fusion middleware 11.1.1.2.0 with installation type as : Portal Forms Reports Discoverer

Following are installation notes:
======================
http://download.oracle.com/docs/cd/E12839_01/install.1111/e10421/overview.htm#sthref12
Oracle® Fusion Middleware Installation Guide for Oracle Portal, Forms, Reports and Discoverer
11g Release 1 (11.1.1)
Part Number E10421-01

 (*) Verify requirements from this url:

    http://www.oracle.com/technology/software/products/ias/files/fusion_requirements.htm

 rpm -qa | grep gcc-3.4
 rpm -qa | grep gcc-c++-3.4
 rpm -qa | grep openmotif21-2.1.30
 rpm -qa | grep setarch-1.6
 rpm -qa | grep pdksh-5.2.14
 rpm -qa | grep sysstat-5.0.5-
 rpm -qa | grep gnome-libs-1
 rpm -qa | grep libaio-0.3
 rpm -qa | grep libaio-devel-0.3
 rpm -qa | grep libstdc++-3.4
 rpm -qa | grep libstdc++-devel-3
 rpm -qa | grep compat-libstdc++-296
 rpm -qa | grep compat-db-4
 rpm -qa | grep control-center-
 rpm -qa | grep glibc-common-2
 rpm -qa | grep binutils-2.15.92
 rpm -qa | grep make-
 rpm -qa | grep xscreensaver-
 rpm -qa | grep openmotif-2.2.
 rpm -qa | grep openmotif22-2.2.  
 Required   openmotif22-2.2.3 (for Oracle Reports Server)
 Available openmotif21-2.1.30-11.RHEL4.6

(*) Certified Java Virtual Machines (JVMs)
    http://www.oracle.com/technology/software/products/ias/files/fusion_certification.html
    http://www.oracle.com/technology/software/products/ias/files/oracle%20fusion%20middleware%2011gR1%20(11.1.1.x)%20certification%20matrix.xls 
   
    “Minimum JDK Versions That Apply To Oracle Fusion Middleware 11gR1 (11.1.1.2+)
     Oracle Fusion Middleware 11gR1 (11.1.1.2+) requires a minimum JDK version.
     The following minimum JDK versions apply:
     Sun JDK 1.6.0_14+ (32-bit, 64-bit).
     Oracle JRockit 6 Update 14 R27.6.5+ (32-bit, 64-bit).
     HP JDK 6.0.05+ (32-bit, 64-bit).
     IBM JDK 1.6.0 SR6+ (32-bit, 64-bit).
     Note: IBM JDK 1.6.0 SR6+ can be downloaded from
     http://www.ibm.com/developerworks/java/jdk/aix/service.html”        

     To update the default JDK 1.6 that is bundled with components
     (Oracle Identity Management, Oracle Portal, Oracle Reports, Oracle Forms,
      Oracle Discoverer, and Oracle Web Tier) to the JDK 1.6 version
      that is specified in this Oracle Fusion Middleware Certification document,
      refer to Oracle Fusion Middleware Release Notes 11gR1
      http://download.oracle.com/docs/cd/E15523_01/relnotes.1111/e10132/install.htm (11gR1 11.1.1.1+)

(*)  https://www.oracle.com/technology/software/products/ias/htdocs/wls_main.html

     Choose : Oracle WebLogic Server 11gR1 (10.3.2) + OEPE – Package Installer

(*)  Download software for Forms and Reports from this page:

     http://www.oracle.com/technology/software/products/middleware/htdocs/fmw_11_download.html

Posted in Fusion Middleware | 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 »

11g ORA-15061: ASM operation not supported [41] with unpatched PSU2 ASM

Posted by dbanotepad on April 5, 2010

On our 11.1.0.7 Instance using Solaris SPARC 64 bit OS was trying to add datafiles to existing tablespace and it was erroring out:

SQLPUS> alter tablespace TSNAME add datafile ‘+SID_DG_DG’ size 32m;
alter tablespace TSNAME add datafile ‘+SID_DG_DG’ size 32m
*
ERROR at line 1:
ORA-19510: failed to set size of 4096 blocks for file “+SID_DG_DG/SIDDG/datafile/tsname.680.715525589″ (block size=8192)
ORA-17505: ksfdrsz:1 Failed to resize file to size 4096 blocks
ORA-15061: ASM operation not supported [41]

Checked view v$asm_diskgroup and there was enough free space in the DG

We have SINGLE 11.1.0.7 ASM codetree and several RDBMS codetrees.

Several RDBMS Instances make use of common ASM Instance.

One of the RDBMS codetree was recently upgraded to PSU2 (while others were at PSU1) but corresponding ASM Instance was left un patched which caused this problem.

To resolve the issue have patched the ASM Instance to PSU2.

NOTE: This worked fine with PSU1 but looks like oracle made this more strict with PSU2.

Posted in Database | 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 »