txkWfClone.sh Poor performance in R12

Hi, everybody should come across, while during a clone, you might have experienced very poor performance while running txkWfClone.sh profile.

Sometimes, it may end up in error

txkWfClone.sh                  INSTE8_APPLY     -1

it is time out message and could not complete the cloning.


It Runs txkWfClone.sql against apps user in the database.


During cloning, execution of txkWfClone  is required only for the first autoconfig run. For subsequent Autoconfig  runs,  it is not required



To resolve this,


Take the backup of the files described.

1). Move the phase of the script txkWfClone.sh to INSTALL_SETUP phase in $FND_TOP/admin/driver/fndtmpl.drv: 









 ###### Required for OWF ######
        fnd admin/template txkWfClone.sql INSTE8 /admin/install/ txkWfClone.sql 600


to 

       fnd admin/template txkWfClone.sh    INSTALL /admin/install/ txkWfClone.sh 600

Changing the autoconfig phase of this script from  INST8_SETUP to INSTALL_SETUP will prevent it from unwanted execution, resulting in better performance for future autoconfig runs.

The role of txkWfCLone.sh is to create workflow related references in  db tier of target system in the cloning process.

During txkWfClone.sh's execution, the comparison between source system and target system URLs is done.  Essentially, in a scenario where we are creating an additional middle tier from an existing  middle tier/(s) having one common database tier, it will result in  redundant operation of changing/creating workflow references for target  middle tier.

For comparison, txkWfClone constructs an url for target system using  the context variables as follows:

'%s_webentryurlprotocol%'||'://'||'%s_webhost%'||'.'||'%s_domainname%'||':'||'
%s_active_webport%'||'/pls/'||'%s_dbSid%'

 

Cheers!!! 

11gR2 (11.2.0.3) is certified with Oracle E Business Suite

Oracle today, announced the version of 11.2.0.3 is certified with Oracle E Business Suite.

It announces minimal requirement for to upgrade this database is:

11i: 11.5.10.2 (ATG.PF.H Rup 6 or Higher)

R12: 12.0.4 or higher (or) 12.1.1 or later.

The patchset 10404530 (5.0 GB) is the third patchset for 11gR2 family.

 

 

 

Oracle E-Business Suite Release 11i

Prerequisites

• 11.5.10.2 + ATG PF.H RUP 6 and higher

Certified Platforms

• Linux x86 (Oracle Linux 4, 5)
• Linux x86 (RHEL 4, 5)
• Linux x86 (SLES 10)
• Linux x86-64 (Oracle Linux 4, 5) -- Database-tier only
• Linux x86-64 (RHEL 4, 5) -- Database-tier only
• Linux x86-64 (SLES 10--Database-tier only)
• Oracle Solaris on SPARC (64-bit) (10)
• Oracle Solaris on x86-64 (64-bit) (10) -- Database-tier only

Pending Platform Certifications

• Microsoft Windows Server (32-bit)
• Microsoft Windows Server (64-bit)
• HP-UX PA-RISC (64-bit)
• HP-UX Itanium
• IBM: Linux on System z 
• IBM AIX on Power Systems

Oracle E-Business Suite Release 12

Prerequisites

• Oracle E-Business Suite Release 12.0.4 or later; or,
  Oracle E-Business Suite Release 12.1.1 or later

Certified Platforms

• Linux x86 (Oracle Linux 4, 5)
• Linux x86 (RHEL 4, 5)
• Linux x86 (SLES 10)
• Linux x86-64 (Oracle Linux 4, 5)
• Linux x86-64 (RHEL 4, 5)
• Linux x86-64 (SLES 10)
• Oracle Solaris on SPARC (64-bit) (10)
• Oracle Solaris on x86-64 (64-bit) (10)  -- Database-tier only

Pending Platform Certifications

• Microsoft Windows Server (32-bit)
• Microsoft Windows Server (64-bit)
• HP-UX PA-RISC (64-bit)
• IBM: Linux on System z
• IBM AIX on Power Systems
• HP-UX Itanium

Database Feature and Option Certifications
The following 11gR2 11.2.0.3 database options and features are supported for use:

• Advanced Compression
• Active Data Guard
• Advanced Security Option (ASO) / Advanced Networking Option (ANO)
• Database Vault 
• Database Partitioning
• Data Guard Redo Apply with Physical Standby Databases
• Native PL/SQL compilation
• Oracle Label Security (OLS)
• Real Application Clusters (RAC)
• Real Application Testing
• Transparent Data Encryption (TDE) Column Encryption
• Transparent Data Encryption (TDE) Tablespace Encryption
• SecureFiles
• Virtual Private Database (VPD)

Oracle 12.1 is certified on Sun Sparc 11 (64 Bit)

This is indeed a great news, that Oracle E Business Suite 12.1 is certified on Sun Sparc 11 on 15th of Nov according to the Oracle Blog.

Oracle declared, that this OS is the first cloud OS.

Oracle Solaris 11

The First Cloud OS

Brings the reliability, security and scalability of the #1 UNIX OS to the cloud. The best platform for any enterprise application, co-engineered with the Oracle stack for performance and efficiency.

• Optimized to run your applications faster—11 world records and counting
• Designed-in virtualization with zero-overhead zones, secure live migration
• 
Data at cloud scale with built-in data services, up to 10x storage savings
• Engineered cloud security with wire-speed encryption and delegated admin
• Simplified cloud deployments, dramatically faster lifecycle management.

According to the blog from John Abraham,

Oracle E-Business Suite Release 12.1 Certified on Solaris 11

By John Abraham on Nov 15, 2011

Oracle Solaris 11 was announced last week, and I'm pleased to also announce that Oracle E-Business Suite Release 12.1 is now certified on Oracle Solaris on SPARC (64-bit). This new operating system release represents a culmination of years of hard work by our Solaris engineering group. It has a number of new and advanced features including simplified deployment and lifecycle management tools, built-in certified virtualization technologies, support on the latest generation SPARC chips, and more.

New installations of the E-Business Suite R12 on this platform will require version 12.1.1 or higher and the latest Rapid Install startCD version 12.1.1.13. For existing 12.1 installations, we have also certified an "in place" OS upgrade or the use of cloning to a target Solaris 11 system. There are also specific requirements to upgrade technology components such as the Oracle Database and Fusion Middleware. These requirements are noted in the links below.

References

• Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for Oracle Solaris on SPARC (64-bit) (My Oracle Support Document 761568.1)

• Oracle Database Installation Guide 11g Release 2 (11.2) for Oracle Solaris

• Interoperability Notes Oracle E-Business Suite Release 12 with Oracle Database 11g Release 2 (11.2.0) (My Oracle Support Document 1058763.1)

• Cloning Oracle Applications Release 12 with Rapid Clone (My Oracle Support Document 406982.1)

Related Articles

• New Rapid Install StartCD (12.1.1.13) for Oracle E-Business Suite Release 12.1 Now Available
• Oracle E-Business Suite Release 12.1.3 Now Available

It requires Rapid Install version 12.1.1.13. More about Rapid Install Version 12.1.1.13 is as follows..

New Rapid Install StartCD (12.1.1.13) for Oracle E-Business Suite Release 12.1 Now Available

By Max Arderius on Aug 26, 2011

A new Rapid Install startCD (Patch 11072566) for Oracle E-Business Suite Release 12.1 is now available for download in My Oracle Support.

The startCD updates are distributed to customers via My Oracle Support Patch which can be uncompressed on top of any previous 12.1 startCD under the main staging area. This patch replaces any previous startCDs.

What's New in This Update?

This new startCD version 12.1.1.13 includes important fixes for Platform specific issues such as support for AIX 7.1, global inventory registration problems in AIX 6.1 Power 7 Systems and a reoccurring fix for a corrupted datafile included in the 12.1.1 media for Linux 64:

• 12725526 : RAPID INSTALL SUPPORT FOR AIX 7.1
• 10312267 : RAPID WIZARD DOES NOT REGISTER THE 11G ORACLE HOME IN ORAINVENTORY (AIX 6.1 POWER7)
• 11818745 : FIX FOR BUG 8625887 NOT IN STARTCD 12.1.1.11 (LINUX-64 BIT)
  

This release also contains fixes for the following issues:

• 9324196 : NEW OCM DOESN'T VALIDATE WHEN USERNAME IS BLANK AND PASSWORD IS FILLED.
• 9238157 : INCORRECT USER CAUSE ERROR STACK PRINT ON THE SERVER SCREEN
• 6857060 : RAPIDWIZ FAILS WITH DATABASE INSTALL DRIVER MISSING
• 5842386 : RAPIDWIZ FAILS TO VALIDATE UNIX USERS WHEN USING CONF FILE

References

• Oracle Applications Documentation Resources, Release 12.1 (Note 790942.1)
• Oracle E-Business Suite Release 12.1.1: Release Content Documents (Note 561580.1)
• Oracle Applications Upgrade Guide Release 11i to 12.1.1

Related Articles

• E-Business Suite Release 12.1.1 Now Available
  
• Oracle E-Business Suite Release 12.1.3 Now Available

FNDCPUCF: error while loading shared libraries: requires glibc 2.5 or later dynamic linker

This is about the error during application tier cloning.


The message i found was from adconfig.log,

ERRORCODE = 127 ERRORCODE_END
.end std out.
FNDCPUCF: error while loading shared libraries: requires glibc 2.5 or later dynamic linker
FNDCPUCF: error while loading shared libraries: requires glibc 2.5 or later dynamic linker


Cause:
Since the source system was Oracle Linux 5 update 5 and the destination is Oracle Linux 4 update 8, the executables linked using Linux 5 update 5 libraries are not compatible with the destination system.

Fix:
1. Source the application environment on each application tier.
2. using adadmin, Relink all the executables.
3. Run autoconfig on application tier. (It should complete successfully).
4. Restart the services.

Cheers!!!

Sun JRE1.6.0 update 27 has been certified for E Biz

Some questions following our last JRE certification indicated that there's still lingering confusion about which JRE releases are safe to use with E-Business Suite environments. To recap: JRE releases 1.6.0_18 through 1.6.0_22 had issues with mismanaging session cookies that affected some users in some circumstances.

The fix for those issues was first included in JRE 1.6.0_23. These fixes will carry forward and continue to be fixed in all future JRE releases. In other words, if you wish to avoid the mismanaged session cookie issue, you should apply any release after JRE 1.6.0_22: for example, JRE 1.6.0_23, 1.6.0_24, 1.6.0_25, and 1.6.0_26.

As of today, you can also apply Sun Java Runtime Environment 1.6.0_27 (a.k.a. JRE 6u27-b07). JRE 1.6.0_27 is certified with E-Business Suite Release 11i and 12.

All JRE releases are certified with EBS upon release

Our standard policy is that all E-Business Suite customers can apply all JRE updates to end-user desktops from JRE 1.6.0_03 and higher. We test all new JRE releases in parallel with the JRE development process, so all JRE releases are considered certified with the E-Business Suite on the same day that they're released by our Java team.

You do not need to wait for a certification announcement before applying new JRE releases to your EBS users' desktops. If you wish, your desktop administrators can enable the Java "Automatic updates" option on your end-users' desktops.

What's new in Java 1.6.0_27?

See the 1.6.0_27 Update Release Notes for details about what has changed in this release. This release is available for download from the usual Sun channels and through the 'Java Automatic Update' mechanism.

JRE 1.6.0_27 provides the following fixes and functionality change that may affect Oracle E-Business Suite customers:

• The browser window opening behind the Forms window issue is now fixed for Windows Vista and Windows 7 users running IE.
• Selecting the "Close Window" Link through Internet Explorer will no longer display a modal window with the prompt, "The webpage you are viewing is trying to close the tab, Do you want to close this tab?".
• Due to JRE6u27 now adhering more strictly to the IE browser settings, "File Export" and certain "Form Attachments" will now fail through IE without the correct browser setting for IE6, IE7 & IE8 users.

This JRE release has been certified with both Oracle E-Business Suite Release 11i and 12. We recommend this release for all E-Business Suite users.

IE9 is certified with Oracle E Business Suite

Internet Explorer 9 Certified with Oracle E-Business Suite

By Steven Chan (Oracle Development) on Aug 08, 2011

Microsoft Internet Explorer 9 is now certified as a desktop client browser for Oracle E-Business Suite Release 11i and 12. The certified desktop operating systems are:

• Windows Vista Service Pack 1 (SP1) or Service Pack 2 (SP2)
• Windows 7
• Windows 7 Service Pack 1 (32-bit or 64-bit)

EBS 12.1 Prerequisites

• EBS 12.1.1 or higher
• Java Plug-in JRE 1.6.0_03 or higher
  

EBS 12.0 Prerequisites

• Oracle Applications Technology R12.ATG_PF.A.DELTA.6 (patch 7237006) or higher.
  
• Oracle Forms Version 10.1.2.3 or higher.
  
• Java plug-in JRE 1.6.0_03 or higher.
  

EBS 11i Prerequisites

• Oracle Applications patch 10 (11.5.10) plus Maintenance Pack 11.5.10 CU2 or higher
  
• Oracle Applications Technology 11i.ATG_PF.H Rollup 6 (RUP 6) (patch 5903765) or higher.
  
• Oracle Developer 6i patchset 19 (6.0.8.28.x) (see Note 125767.1)
  
• Java plug-in JRE 1.6.0_03 or higher.
  
• MLR patch 8888184 or higher (AIX Users should apply MLR patch 10043867 which replaces 8888184)
  

for More information.. please visit:

http://blogs.oracle.com/stevenChan/entry/internet_explorer_9_certified_with?utm_source=feedburner&utm_medium=email&utm_campaign=Feed%3A+OracleE-BusinessSuiteTechnology+(Oracle+E-Business+Suite+Technology)

To change ORACLE logo in Forms R12 Instances

Steps to Change the ORACLE Logo in the Forms of R12 Instances:

The idea here is to replace the logo in frmall.jar. Then reload it.

cp $ORACLE_HOME/forms/java/frmall.jar $ORACLE_HOME/forms/java/frmall.jar_BAK

cp $ORACLE_HOME/forms/java/frmall.jar /tmp

cd /tmp

jar -xvf frmall.jar

rm -rf META-INF/

Rename the logo of your logo of size (125X30 pixels) to oracle_logo_light.gif

copy your own oracle_logo_light.gif to oracle/forms/icons/oracle_logo_light.gif in the /tmp folder.
cd /tmp

jar -cvf frmall.jar *

cp frmall.jar $ORACLE_HOME/forms/java/frmall.jar

adadmin (jar regenerate) and use the FORCE option

(selection option 1, regenerate Product JAR file, and

Do you wish to force regeneration of all jar files? [No] ? Yes

Retest the issue by opening the forms.

Cheers...