DbaNotePad

Oracle APPS DBA Blog

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 »

12c database rac install using virtual box

Posted by dbanotepad on July 8, 2013

Used instructions at following url to setup 12c 2 node RAC on my laptop ( windows 7 64-bit )

http://www.pythian.com/blog/oracle-12c-rac-on-your-laptop-step-by-step-guide/

Many thanks to Yury for sharing his notes.

In my laptop network setup was as below

10.0.0.3

         (IP ADDRESS GIVEN BY MY ISP)

HOST WINDOWS OS
|
|

10.154.137.1
Host-only Network
(GATEWAY) (ALSO DUAL DNS SERVER LISTENS ON THIS)

HOST WINDOWS OS

|
|

10.154.137.101(VM1) GUEST LINUX OS          10.154.137.102(VM2) GUEST LINUX OS

ON HOST OPERATING SYSTEM

VirtualBox Host-Only Ethernet Adapter #2 –> (GATEWAY) 10.154.137.1
OVB -> File Preferences -> Network -> Add host-only network Edit ipv4 address
DNS server –> 10.154.137.1 255.255.255.0 DHCPServer DISABLED

VirtualBox Host-Only Ethernet Adapter
OVB DHCP Server –> 192.168.56.1 255.255.255.0 DHCPServer : 192.168.56.100
ServerMask : 255.255.255.0
LowerAddress: 192.168.56.101
UpperAddress: 192.168.56.254

ON GUEST OPERATING SYSTEM
public ip (eth0) IPADDR  NETWORK MASK

ol6r01 –> 10.154.137.101 255.255.255.0
ol6r02 –> 10.154.137.102 255.255.255.0

private ip (eth1) IPADDR  NETWORK MASK
ol6r01-priv –> 10.154.138.101 255.255.255.0
ol6r02-priv –> 10.154.138.102 255.255.255.0

virtual ip (eth0:1) IPADDR  NETWORK MASK
ol6r01-vip –> 10.154.137.103 255.255.255.0
ol6r02-vip –> 10.154.137.104 255.255.255.0

scan ip  IPADDR  NETWORK MASK
scan-f1 –> 10.154.137.115 255.255.255.0
10.154.137.116 255.255.255.0
10.154.137.117 255.255.255.0

NAT (eth2)
ol6r01-nat –> DHCP (No Connect Automatically) –> ifup eth2 –> 10.0.4.15
ol6r02-nat –> DHCP (No Connect Automatically)

Seperate Network is necessary for host OS to access guest VMs to do that each GuestVM should have 2 network adapters

one is for GuestVM to access outbound Network namely NAT adapter another is for hostOS to access each guest VM, namely Host-Only adapter

In VirtualBox NAT is attached to each VM and is useful for guestVM to access outbound network but is treated as a seperate network

In VirtualBox Host-only network is a gateway for host(external network) to access guestVMs(internal network) to communicate with each other

 

Had following issues when doing the setup

Cloned VM network interface for public IP is not reachable from host OS using putty

To fix this have renamed file  /etc/udev/rules.d/70-persistent-net.rules to  70-persistent-net.rules.orig and made sure the mac address on the Virtualbox -> VM1 or VM2 -> Settings -> Network for each of the adapters were matching with /etc/sysconfig/network-scripts/ifcfg-ethN mac address and rebooted the VM’s

Private IP address between the nodes were not pingable

Virtualbox -> VM1 or VM2 -> Settings -> Network -> For adapter eth1 (private NIC) re-generated mac address and applied above work around to rename the rules file and rebooted VM’s. After this was done ping between private ip addresses started working.

Entries in /etc/resolv.conf on Linux VM’s were getting removed after restarting host OS(windows)

As workaround to this issue added commands(echo “search myinstall.com” > /etc/resolv.conf; echo “nameserver 10.154.137.1″ >> /etc/resolv.conf provided by Yury in his instructions to both VM’s /etc/rc.d/rc.local at the end so they get  executed during VM startup

Posted in Database | Leave a Comment »

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 »

 
Follow

Get every new post delivered to your Inbox.