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/
29 Wednesday Jan 2014
Posted Uncategorized
inPart 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/
29 Wednesday Jan 2014
Posted Troubleshooting
inToday 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 |
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!
19 Sunday Jan 2014
Posted Scripts
inClick 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.
18 Saturday Jan 2014
Posted Scripts
inafcmcreq 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
17 Friday Jan 2014
Posted General
inDescription
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)
16 Thursday Jan 2014
Posted Uncategorized
inThe 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
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!
15 Wednesday Jan 2014
Posted Performance & Tuning
inTime 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
09 Thursday Jan 2014
Posted Certification
inE-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
08 Wednesday Jan 2014
Posted Certification
inSpend 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,
Hope you enjoy reading valuable MOS notes.
06 Monday Jan 2014
Posted General
inSysadmins for Oracle Solaris, Oracle Linux, or Oracle VM join us at this FREE virtual event and learn how to:
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 |
Track 2 |
Track 3 |
|
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