Enterprise Manager for DBA’s – Videos


 

The video series starts with a brand new Enterprise Manager system where everything is set to the default ‘out of box’ settings. Each video will concentrate on understanding and setting up a different area of EM (eg. adding a database; understanding the different Enterprise Manager users, setting the correct credentials; setting up notification methods; testing a host and database job; understanding database metrics and understanding incident rules. A video or set of videos are linked to each of the notes listed below. It is recommended that the note numbers should be followed in order. Some notes (or sections of notes) are marked optional and can be skipped if there is no intention to use that feature (eg. SNMP traps).

MOS Link

Title of Video

Note:1612019.1

Database Discovery in 30 Mins (Enterprise Manager Cloud Control 12c)

Note:1612010.1

Understanding Enterprise Manager Administrators and Users in 12c Cloud Control

Note:1604047.1

Setting Database Credentials in Enterprise Manager 12c Cloud Control

Note:1609677.1

Setting Host Credentials in Enterprise Manager 12c Cloud Control

Note:1612329.1

Setting up the Email Notification Method in Enterprise Manager 12c

Note:1615378.1

Setting up the SNMP Trap Method in Enterprise Manager 12c

Note:1612675.1

Testing the Job System in Enterprise Manager 12c for a Host and Database Target

Note:1615379.1

Managing Database Metrics in Enterprise Manager 12c

Note:1615380.1

Incident Rules for Oracle Database Metrics in Enterprise Manager 12c

Advertisements

Latest Oracle RAC – Important MOS IDs


RAC and Oracle Clusterware Best Practices and Starter Kit (Platform Independent)

The following document focuses on RAC and Oracle Clusterware Best Practices that are applicable to all platforms including a white paper on available RAC System Load Testing Tools and RAC System Test Plan outlines for 10gR2 & 11gR1 and 11gR2:

Document 810394.1 RAC and Oracle Clusterware Best Practices and Starter Kit (Platform Independent)



RAC Platform Specific Best Practices and Starter Kits

The following notes contain detailed platform specific best practices including Step-By-Step installation cookbooks (downloadable in PDF format):

Document 811306.1 RAC and Oracle Clusterware Best Practices and Starter Kit (Linux)
Document 811280.1 RAC and Oracle Clusterware Best Practices and Starter Kit (Solaris)
Document 811271.1 RAC and Oracle Clusterware Best Practices and Starter Kit (Windows)
Document 811293.1 RAC and Oracle Clusterware Best Practices and Starter Kit (AIX)
Document 811303.1 RAC and Oracle Clusterware Best Practices and Starter Kit (HP-UX)


 

RAC on Linux Step by Step Installation Cookbook Video

Document 1442768.1 – RACGuide: 11.2.0.3 RAC Installation on Linux [Video]
Document 1600316.1 – RACGuide: 12.1.0.1 RAC Installation on Linux [Video] *NEW*


 

RAC on Linux Step by Step Installation Instructions

Click here for a Step By Step guide for installing Oracle RAC 10gR2 on Linux.
Click here for a Step By Step guide for installing Oracle RAC 11gR1 on Linux.
Click here for a Step By Step guide for installing Oracle RAC 11gR2 (11.2.0.2) on Linux.

Have you tried using Oracle AMP for EBS Suite?


The Oracle Application Management Pack for Oracle E-Business Suite extends Oracle Enterprise Manager 12c Cloud Control to help monitor and manage Oracle E-Business Suite systems more effectively. The pack integrates Oracle Applications Manager with Cloud Control to provide a consolidated, end-to-end Oracle E-Business Suite management solution. The pack can be used to manage both Oracle E-Business Suite Release 11i systems and Release 12 systems.

This document describes the features and usage of this new pack for Cloud Control. Oracle Enterprise Manager Cloud Control provides a complete view of your enterprise so that you can manage all of your Oracle E-Business Suite systems from a single console. This pack provides new pages within Cloud Control that help you to monitor the performance, availability and configuration changes of your Oracle E-Business Suite system and also help you to provision your Oracle E-Business Suite applications. You can take advantage of advanced Cloud Control features such as the provisioning framework.

 
 


 Enterprise Manager itself allows you to monitor multiple Oracle E-Business systems (both Release 11i and Release 12) from the outside.

The Oracle Application Management Pack for Oracle E-Business Suite provides advanced features to monitor and manage Oracle E-Business Suite Release 12 systems as well as Release 11i systems that meet a standard interoperability patch level. These advanced features include Oracle E-Business Suite provisioning, Application Service Level Management, extended performance metrics, and links from Cloud Control to Oracle Applications Manager.

System Management for Oracle E-Business Suite
Oracle Application Management Pack for Oracle E-Business Suite extends Enterprise Manager Cloud Control to monitor and manage Oracle E-Business Suite systems. This new release of this management pack offers the following key capabilities:

General:

  • Oracle Enterprise Manager 12c Base Platform uptake: All components of the management suite are certified with Oracle Enterprise Manager 12c Cloud Control.

MOSC Spotlight


Welcome My Oracle Support Community!

For active My Oracle Support Community members, the new look is very apparent. What is not as obvious are the new features that will help you get answers and find solutions. 

Part of the new look is comes from sharing a new platform with Oracle Technology Network (OTN) Community. When you see the blue banner at the top of the page, or (MOSC) after a name, you can be certain that you are in My Oracle Support Community (MOSC). These pages have content that is only available for Premier Support customers, and Oracle Support engineers moderate the discussions. When you see a red banner, you are in OTN Community, which is open to the general public. Unless you own the Intellectual Property (IP), do not share information from My Oracle Support Community in the OTN Community. 

If you are new to My Oracle Support, welcome. This support channel offers a collaborative environment that we build in partnership: Oracle Premier Support customers and Oracle Support engineers. Support engineers provide their knowledge and Oracle information; you will find a trusted network of Oracle customers, who share similar goals, and who have tackled many of the real-world challenges you face. You can learn new approaches to situations and examine different perspectives to find the best answer for your environment. Together, we help you take the path to success. 

To ease your transition into the new My Oracle Support Community and to help you learn about the new features you can start with the short training videos available from the Getting Started space in the right hand column of the MOSC home. You can also register now for a live webcast session: Get Proactive Essentials: Using the new My Oracle Support Community Platform.

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)