OTNYathra – 2014 – Across 7 Cities in India

Part of OTNYathra -2014, we are hosting RAC ‘n’ ROLL session in Mumbai, Pune and Bangalore. Please register as soon as possible, seats are very limited.

For more details http://otnyathra.com/

Advertisements

Fatal Error: TXK Install Service

Today I encounter with following error while installing Oracle EBS 12.2 on SUSE Linux Enterprise Server 11 (x86_64) (PATCHLEVEL = 3)

Error Message:

Fatal Error: TXK Install Service oracle.apps.fnd.txk.config.ProcessStateException: OPatch process failed : Exit=100 See log for details. CMD= perl /fs2/EBSapps/10.1.2/OPatch/opatch.pl apply -verbose -silent   -ocmrf /fs2/inst/apps/SID_hostname/temp/ASInstallHome/fnd/admin/template/txkForms_ocm.rsp  /fs2/inst/apps/SID_hostname/temp/patches/16271876/16271876     at oracle.apps.fnd.txk.config.OPatchActionNode.processState(OPatchActionNode.java:296)     at oracle.apps.fnd.txk.config.PatchActionNode.processState(PatchActionNode.java:187)     at oracle.apps.fnd.txk.config.PatchNode.processState(PatchNode.java:338)     at oracle.apps.fnd.txk.config.PatchesNode.processState(PatchesNode.java:79)     at oracle.apps.fnd.txk.config.InstallNode.processState(InstallNode.java:68)     at oracle.apps.fnd.txk.config.TXKTopology.traverse(TXKTopology.java:594)     at oracle.apps.fnd.txk.config.InstallService.doInvoke(InstallService.java:224)     at oracle.apps.fnd.txk.config.InstallService.invoke(InstallService.java:237)     at oracle.apps.fnd.txk.config.InstallService.main(InstallService.java:291) Cannot patch 10.1.2 Tools.     RW-50010: Error: – script has returned an error:   1 RW-50004: Error code received when running external process.  Check log file for details. Running APPL_TOP Install Driver for SID instance

 

Fix: Another ISO file system (mount) found on the server and due to that oracle home has not registered correctly to the central inventory. Please make sure that there should not be anything else mounted on the server. Unmount Other mount point. Cleanup the failed installation. Restart the R12.2 Installation.

All the best!

Concurrent Processing – Scripts

Click here to access advanced sql query statements allowing select date ranges or other sql queries for monitoring Concurrent Processing

Note: You require MOS credentials to access following scripts.

• Script Provides Daily Concurrent Request Counts Completed by Hour
  
• Script Provides the Concurrent Requests Counts, Time, and Range
  
• Script Provides the Count by Name and Date
  
• Script Provides the Count of Requests Completed and Canceled
  
• Script Provides the Count of Requests Completed with Error
  
• Script Provides the Count of Requests Pending and Scheduled
  
• Script Provides the Count of Requests Terminated by Date
  
• Script Provides the Count of Requests by Date
  
• Quick Sql Statement to check Average Monthly Requests
  
• Script Identifying Concurrent Managers Used and Compare
  
• Elapsed Time History for All Requests Run for a Given Time Period
  
• Select for Providing Frequency/Volume Analysis Program Name, Queue Name, and Count by Program Name and Date Range
  
• Request Volume Per Day Select which can be Modified with Additions to the Where Clause
  
• Select Providing the Volume of Concurrent Requests Per Node
  
• Select reflecting All Requests with Run Times > 30 Minutes During Peak Load in the Past Month by Application_Id
  
• Select Providing Request ID’s for Requests that are Currently Running
  
• Session Information Available from an Oracle Unix Process ID – SPID
  
• Tracing Concurrent Processes
  
• Recommended Concurrent Processing Resources

Seeded scripts in FND_TOP/sql as of 12.1.3

afcmcreq Prints the log file name of managers that can run a given request
afcmstat Displays all defined managers and shows current status of manager processes
afimchk Checks to see if the concurrent manager monitor is actually running
afimlock Monitors locks that the ICM and CRM are waiting for.
afimpmon Sets the PMON methd based on the argument (for CONC_PMON_METHOD)
afimveri Resets the concurrent manager monitor
afrqpend Lists all the pending/normal requests
afrqrun Lists all running, terminating, and paused requests
afrqscm Prints the log file names of managers that can run a given request
afrqstat Summarizes concurrent request execution since a particular date
afrquwait Selects all the Pending request with status Q

Critical Patch Update for January 2014

Description

A Critical Patch Update (CPU) is a collection of patches for multiple security vulnerabilities. Critical Patch Update patches are usually cumulative, but each advisory describes only the security fixes added since the previous Critical Patch Update advisory. Thus, prior Critical Patch Update advisories should be reviewed for information regarding earlier published security fixes. Please refer to:

Critical Patch Updates and Security Alerts for information about Oracle Security Advisories.

Due to the threat posed by a successful attack, Oracle strongly recommends that customers apply CPU fixes as soon as possible.This Critical Patch Update contains 144 new security fixes across the product families listed below.

This Critical Patch Update advisory is also available in an XML format that conforms to the Common Vulnerability Reporting Format (CVRF) version 1.1. More information about Oracle’s use of CVRF is available at: http://www.oracle.com/technetwork/topics/security/cpufaq-098434.html#CVRF.

Affected Products and Components

Security vulnerabilities addressed by this Critical Patch Update affect the products listed in the categories below.  The product area of the patches for the listed versions is shown in the Patch Availability column corresponding to the specified Products and Versions column.   Please click on the link in the Patch Availability column below or in the Patch Availability Table to access the documentation for those patches.

Click here for more details.

This Critical Patch Update (CPU) knowledge document applies to Oracle E-Business Suite Releases 12 (12.0, 12.1 and 12.2) and 11i. Please refer MOS link for more details – Oracle E-Business Suite Releases 11i and 12 Critical Patch Update Knowledge Document (January 2014) (Doc ID 1605340.1)

 

Concurrent Processing Analyzer for E-Business Suite

The Concurrent Processing Analyzer is a Self-Service Health-Check script which reviews the overall Concurrent Processing Footprint, analyzes the current configurations and settings for the environment providing feedback and recommendations on Best Practices.

This is a non-invasive script which provides recommended actions to be performed on the instance it was run on and can be run at any time. For production instances, always apply any changes to a recent clone to ensure an expected outcome.

Benefits

• Immediate Analysis and Output of Concurrent Environment
  
• E-Business Applications Concurrent Processing Analyzer Overview
  
• Total Purge Eligible Records in FND_CONCURRENT_REQUESTS
  
• E-Business Suite Version
  
• Concurrent Processing Database Parameter Settings
  
• Applied ATG Patches
  
• Known 1-Off Patches on top of Rollups
  
• E-Business Applications Concurrent Request Analysis
  
• Long Running Reports During Business Hours
  
• Elapsed Time History of Concurrent Requests
  
• Requests Currently Running on a System
  
• FND_CONCURRENT_REQUESTS Totals
  
• Running Requests
  
• Total Pending Requests by Status Code
  
• Count Pending Regularly Scheduled/Non Regularly-Scheduled Requests
  
• Count of Pending Requests on Hold/Not on Hold
  
• Listing of Scheduled Requests
  
• Listing of Pending Requests on Hold
  
• Listing of Pending Requests Not on Hold
  
• Volume of Daily Concurrent Requests for Last Month
  
• Identify/Resolve the Pending/Standby Issue, if Caused by Run Alone Flag
  
• Tablespace Statistics for the fnd_concurrent tables
  
• E-Business Applications Concurrent Manager Analysis
  
• Concurrent Managers Active and Enabled
  
• Concurrent Manager Processes by Workshift
  
• Active Manager for Applications that are not Installed/Used
  
• Total Target Processes for Request Managers (Excluding Off-Hours)
  
• Request Managers with Incorrect Cache Size
  
• Concurrent Manager Request Summary by Manager
  
• Check Manager Queues for Pending Requests
  
• Check the Configuration of OPP
  
• Identifies Concurrent System Setup and configurations
  
• Identifies and recommends Concurrent Best Practices
  
• Easy to add Tool for regular Concurrent Maintenance
  
• Execute Analysis anytime to compare trending from past outputs
  

Download the Concurrent Processing Analyzer Latest Version (v1.03)

Review a sample output here.

Check out a short 9 min video CP Analyzer Tutorial (09:00)

Enjoy troubleshooting! Have a great Day!

MOS Note IDs for Tuning performance on eBusiness suite

Time to work on some of the EBS performance, here is the complete reference of MOS IDs. All the best.

NOTE:38373.1 – TECH: Example TM(Table Locks) During Referential Integrity Enforcement
NOTE:384241.1 – Using Forms Socket Mode with Oracle E-Business Suite Release 12
NOTE:396009.1 – Database Initialization Parameters for Oracle E-Business Suite Release 12
NOTE:404954.1 – How to run OATM migration utility
NOTE:62143.1 – Troubleshooting: Tuning the Shared Pool and Tuning Library Cache Latch Contention
NOTE:62354.1 – Waits for ‘Enq: Tx – Row Lock Contention’ – Wait Scenario Examples
NOTE:94224.1 – FAQ- Statspack Complete Reference
NOTE:1020008.6 – SCRIPT: FULLY DECODED LOCKING
NOTE:1020012.6 – Script to Return Locking Information (Medium Detail) 
NOTE:122371.1 – How To Gather Statistics For Oracle Applications Prior to 11.5.10
NOTE:138159.1 – Canceling Long Running Queries in Oracle Applications 11i
NOTE:153507.1 – Oracle Applications and StatsPack
NOTE:163208.1 – bde_last_analyzed.sql – Verifies CBO Statistics
NOTE:163424.1 – How To Identify a Hot Block Within The Database Buffer Cache.
NOTE:169935.1 – Troubleshooting Oracle Applications Performance Issues
NOTE:174605.1 – bde_chk_cbo.sql – EBS initialization parameters – Healthcheck
NOTE:216205.1 – Database Initialization Parameters for Oracle Applications Release 11i
NOTE:228913.1 – Systemwide Tuning using STATSPACK Reports
NOTE:244040.1 – Oracle E-Business Suite Recommended Performance Patches
NOTE:276103.1 – Performance Tuning Using Advisors and Manageability Features: AWR, ASH, ADDM and Sql Tuning Advisor
NOTE:33453.1 – Locking and Referential Integrity
NOTE:33567.1 – TECH: ORA-1575 Timeout waiting for Space Management Enqueue
NOTE:34566.1 – WAITEVENT: “enqueue” Reference Note
NOTE:362851.1 – JVM: Guidelines to setup the Java Virtual Machine in Apps Ebusiness Suite 11i and R12

MOS note IDs related to Concurrent Processing tuning:

NOTE:1389261.1 – PCP Concurrent Manager Failover/Failback Does Not Work When Application Listener is Down On Primary Node
NOTE:1060736.1 – Deadlock Error During Concurrent Request Termination
NOTE:466752.1 – Concurrent Processing – What is FNDREVIVER and How Is It Set?
NOTE:551895.1 – Concurrent Processing – Failover Of Concurrent Manager Processes Takes More than 30 Minutes
NOTE:1360118.1 – Performance: Concurrent Requests Hang in Pending Status For Long Time
NOTE:866298.1 – Concurrent Processing – ORA-00060: Deadlock Detected – UPDATE FND_CONCURRENT_QUEUES
NOTE:1075684.1 – Concurrent Managers are consuming high CPU and memory
NOTE:1399454.1 – Tuning Output Post Processor (OPP) to Improve Performance
NOTE:844976.1 – Concurrent Processing – Concurrent Reports Failing With Errors REP-0004,REP-0082 and REP-0104
NOTE:1492893.1 – R12: Performance Issue When Standard Managers Waiting for “enq: TX – row lock contention” Held By ICM
NOTE:822368.1 – Concurrent Processing – How To Run the Purge Concurrent Request FNDCPPUR, Which Tables Are Purged, And Known Issues Like Files Are Not Deleted From File System or Slow Performance
NOTE:104452.1 – Concurrent Processing – Troubleshooting Concurrent Manager Issues (Unix specific)
NOTE:1060707.1 – Purge Concurrent Requests/Manager Data, FNDCPPUR, Not Removing Files From Filesystem

ANNOUNCEMENTS: E-Business Suite 12.1

E-Business Suite 12.1 Premier Support Now Through Dec. 2016 and 11.5.10 Sustaining Support Exception Updates.

Please refer MOS (Doc ID 1495337.1) for more details.

Useful MOS Notes:

NOTE:1494891.1 – E-Business Suite Releases – Support Policy FAQ

NOTE:1195034.1 – Oracle E-Business Suite Error Correction Support Policy (V.4)

NOTE:883202.1 – Patch Requirements for Extended Support of Oracle E-Business Suite Release 11.5.10

Good MOS notes to understand on E-Business Suite Releases – Support Policy FAQ

Spend some time to understand E-Business Suite Releases – Support Policies. I am referring to (Doc ID 1494891.1). In this most of your questions are answered. Like E-Business Suite General Support Policy Information,

• Why is Oracle providing Sustaining Support Exception for EBS 11.5.10?
• Will customers need to purchase an additional contract for the 11.5.10 Exception to Sustaining Support?
• What defines Severity 1 Production Support in the 11.5.10 Exception to Sustaining Support?
  
• What are the terms and conditions for the Critical Patch Updates (CPUs) during the exception period for 11i?
  
• What are the differences in the Lifetime Support Policy feature benefits from Extended Support to the Severity 1 Production Support in the 11.5.10 Exception to Sustaining Support?
  
• What happens to open non-severity 1 bugs once 11.5.10 enters Sustaining Support?
  
• Which EBS release version does Oracle recommend customers upgrade to from 11.5.10?
  

Hope you enjoy reading valuable MOS notes.

 

Register today for Virtual Sysadmin Day: 2014!

Sysadmins for Oracle Solaris, Oracle Linux, or Oracle VM join us at this FREE virtual event and learn how to:

• Learn tips and best practices for deploying Oracle Solaris 11 in the cloud
• Get a better understanding of how to take advantage of Oracle Solaris 11 unique features in software lifecycle, virtualization and data management
• Keep Oracle Linux up to date by accessing updates and errata with yum, apply kernel updates with Ksplice, and use btrfs to allow rolling back of updates
• Run multiple, isolated instances of Oracle Linux with extremely low overhead using Linux Containers
• Deploy and manage a private cloud with Oracle VM and Enterprise Manager 12c
• Virtualize and deploy Oracle Database in minutes using Oracle VM Templates

Americas – Tuesday January 28th, 2014 9am to 1pm PST / 12pm to 4pm EST / 3pm to 5pm BRST

Agenda:

08:45 AM	Platform Opening
9:00 am	Keynote – Make Your Sysadmin Life Easier with Oracle Operating Systems and Virtualization Solutions!
	Track 1  Oracle Solaris	Track 2  Oracle Linux	Track 3  Oracle VM
9:15 AM	Oracle Solaris 11 and Sysadmin’s Daily Life	Oracle Linux Overview	Rapid Deployment with Oracle VM
9:45 AM	Part 1. Software Lifecycle	Oracle Linux Package and Patch Management Solutions (2 hours)	Migrate to Oracle VM and Oracle Linux from VMware and Redhat with Oracle best practices
10:45 AM	Part 2. Virtualization	Oracle Linux Package and Patch Management Solutions (2 hours) continued	Deploy 4 nodes Oracle RAC 12c in minutes from Oracle VM Templates
11:45 AM	Part 3. Data Management	Getting Started with Linux Containers on Oracle Linux	Deploy and manage a private cloud with Oracle VM and Enterprise Manager 12c
1:00 PM	Event Close

 

Hands on Lab Set Up Instructions:

Page: Hands on Lab Instructions – Oracle
VMPage: Oracle Linux Hands-on
LabsPage: Oracle Linux Hands On Lab VM Set Up
Page: Oracle Solaris Hands On Lab and VM Set Up