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