Friday, December 02, 2011
Useful Articles for Apps DBAs Oracle noteID ID 828157.1
note 1207184.1 Enhanced Signing of Oracle E-Business Suite JAR FilesOracleAS----------------------------------------------------------------------------------------------------note 454811.1 Upgrading to the Latest OracleAS 10g 10.1.3.x Patch Set in Oracle E-Business Suite Release 12note 743518.1 Starting up AS10g services in an EBusiness Suite Release 12 environmentJDBC----------------------------------------------------------------------------------------------------note 557194.1 monitor_jdbc_conn.sql - Script to monitor JDBC connections in Apps eBusiness Suite
note 427759.1 How To Prevent Inactive JDBC Connections In Oracle ApplicationsJVM----------------------------------------------------------------------------------------------------note 362851.1 Guidelines to setup the JVM in Apps Ebusiness Suite 11i and R12note 567551.1 Configuring various JVM tuning parameters for Oracle E-Business suite 11i and R12note 370583.1 Basic troubleshooting of JVM consuming cpu or too many JDBC connections in Apps 11iApache/mod_jserv----------------------------------------------------------------------------------------------------note 230688.1 11i Basic Apache/mod_jserv Troubleshooting with Hello.classDebug/Trace----------------------------------------------------------------------------------------------------note 422419.1 R12 - How To Enable and Collect Debug for HTTP, OC4J and OPMNNote 443671.1 R12 - Collecting Configuration Information for HTTP, OC4J and OPMNnote 427848.1 How to Enable Execution Context ID (ECID) in the R12 access_lognote 455154.1 R12: How To Obtain A Thread Dump When OC4J is shutdownnote 603390.1 How To Create a User Event Trace in R11i / R12OA Framework----------------------------------------------------------------------------------------------------note 391554.1 Oracle Application Framework Documentation Resources, Release 12note 275880.1 Oracle Application Framework Release 11i Documentation Road Mapnote 275875.1 Oracle Application Framework Troubleshooting Release 11i (11.5.10)note 357597.1 How To Generate A SQL Trace In OA Framework For Oracle ApplicationsWebCache----------------------------------------------------------------------------------------------------note 380486.1 Installing and Configuring Web Cache 10g and Oracle E-Business Suite 12note 306653.1 Installing and Configuring Web Cache 10.1.2 and Oracle E-Business Suite 11iJDeveloper----------------------------------------------------------------------------------------------------note 330236.1 Configuring JDeveloper For Use With Oracle Applications 11i and R12note 357218.1 Troubleshooting JDeveloper setup for Oracle Applicationsnote 416708.1 How to find the correct version of JDeveloper to use with eBusiness Suite 11i or Release 12.xPerformance----------------------------------------------------------------------------------------------------note 163208.1 bde_last_analyzed.sql - Verifies CBO Statisticsnote 174605.1 bde_chk_cbo.sql - Reports Database Initialization Parameters related to an Apps 12 or 11i instancenote 396009.1 Database Initialization Parameters for Oracle Applications Release 12note 216205.1 Database Initialization Parameters for Oracle Applications 11inote 744143.1 Tuning performance on eBusiness suitenote 169935.1 Troubleshooting Oracle Applications Performance Issuesnote 244040.1 Oracle E-Business Suite Recommended Performance PatchesSecurity----------------------------------------------------------------------------------------------------note 738923.1 Oracle E-Business Suite Releases 11i and 12 Critical Patch Update note (January 2009)note 403537.1 Best Practices for Securing Oracle E-Business Suite Release 12note 189367.1 Best Practices for Securing the E-Business Suite Release 11iIhelp----------------------------------------------------------------------------------------------------Note 740834.1 R12: Troubleshooting iHelpAdvanced Configurations----------------------------------------------------------------------------------------------------note 380483.1 Oracle E-Business Suite Release 12 Additional Configuration and Deployment Optionsnote 384248.1 Sharing The Application Tier File System in Oracle E-Business Suite Release 12note 217368.1 Advanced Configurations and Topologies for Enterprise Deployments of E-Business Suite 11inote 233428.1 Sharing the Application Tier File System in Oracle Applications 11inote 233436.1 Installing Oracle Application Server 10g with Oracle E-Business Suite Release 11inote 364439.1 Tips and Queries for Troubleshooting Advanced TopologiesDMZ----------------------------------------------------------------------------------------------------note 380490.1 Oracle E-Business Suite R12 Configuration in a DMZnote 726953.1 Case History: Implementing a Reverse Proxy Alone in the DMZ Configuration - R12note 287176.1 DMZ Configuration with Oracle E-Business Suite 11inote 438744.1 Case History: Implementing a Reverse Proxy Alone in a DMZ Configuration - 11inote 460564.1 Hints and Tips for Troubleshooting the URL FirewalLoadbalancer----------------------------------------------------------------------------------------------------note 380489.1 Using Load-Balancers with Oracle E-Business Suite Release 12note 727171.1 Implementing Load Balancing On Oracle E-Business Suite - Documentation For Specific Load Balancer Hardwarenote 601694.1 How To Check Session Persistence On BigIP F5 And Cisco Ace Load Balancer Appliancesnote 603325.1 Using Cisco ACE Series Application Control Engine with Oracle E-Business Suite Release 12SSL----------------------------------------------------------------------------------------------------note 376700.1 Using SSL with Oracle E-Business Suite Release 12
Note 1330799.1 Login Page Fails To Render On SSL Terminated Application Tiers
note 123718.1 11i A Guide to Understanding and Implementing SSL for Oracle Applications
Portal----------------------------------------------------------------------------------------------------note 380484.1 Using Oracle Portal 10g with Oracle E-Business Suite Release 12
note 305918.1 Using Oracle Portal 10g with Oracle E-Business Suite Release 11iSSO/OID----------------------------------------------------------------------------------------------------note 876539.1 Using the Latest Oracle Internet Directory 11gR1 Patchset with Oracle Single Sign-on and Oracle E-Business Suite
note 376811.1 Integrating Oracle E-Business Suite Release 12 with 10g AS Oracle Internet Directory and Oracle Single Sign-Onnote 261914.1 Integrating Oracle E-Business Suite Release 11i with Oracle Internet Directory and Oracle Single Sign-Onnote 444573.1 Basic checks for user integration when using Oracle E-Business Suite 11i with Oracle AS 10gOrace Access Manager / AccessGate----------------------------------------------------------------------------------------------------note 975182.1 Integrating Oracle E-Business Suite with Oracle Access Manager using Oracle E-Business Suite AccessGatenote 1077460.1 Troubleshooting Oracle Access Manager and Oracle E-Business Suite AccessGateWebcenter----------------------------------------------------------------------------------------------------note 1074345.1 Using WebCenter 11.1.1 with Oracle E-Business Suite Release 12
note 557221.1 Oracle WebCenter 10g Application Creation and Deployment Guide for Oracle E-Business Suite Release 12Secure Enterprise Search ----------------------------------------------------------------------------------------------------note.566097.1 Oracle E-Business Suite Secure Enterprise Search Release Notes, Release 12.1.1note.744820.1 Oracle E-Business Suite Secure Enterprise Search Best Practices, Release 12note.462377.1 Installing Oracle E-Business Suite Secure Enterprise Search, Release 12note.740499.1 Oracle E-Business Suite Secure Enterprise Search Release Notes, Release 12.0.6 note 726239.1 Oracle E-Business Suite Secure Enterprise Search Troubleshooting Guidelines, Release 12SOA/BPEL/Webservices----------------------------------------------------------------------------------------------------note 556540.1 Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12.1note 565922.1 Oracle E-Business Suite Integrated SOA Gateway Release Notes, Release 12.1.1note 815196.1 Oracle E-Business Suite Integrated SOA Gateway 12.1.1 Consolidated One-Offnote 726414.1 Oracle E-Business Suite Integrated SOA Gateway Troubleshooting Guide, Release 12note 755067.1 Using Oracle BPEL 10g with E-Business Suite Release 12.1.1Note 782455.1 How Can I Expose E-Business Suite Integration Interfaces as Web Services in Release 11i and R12.0MWA----------------------------------------------------------------------------------------------------note 782162.1 MWA Troubleshooting Tips for Release 12note 269991.1 MWA Troubleshooting Tips for Release 11iCertified/Supported----------------------------------------------------------------------------------------------------http://blogs.oracle.com/stevenchan/certifications.htmlnote 363827.1 Rebaselined Oracle Applications Technology Components for Releases 11.5.7, 11.5.8, 11.5.9, and 11.5.10
note 883202.1 Minimum Baseline Patch Requirements for Extended Support on Oracle E-Business Suite 11.5.10
note 1199724.1 E-Business Suite 11.5.10 Minimum Patch Level and Extended Support Information CenterWEBADI----------------------------------------------------------------------------------------------------note 417692.1 Installing, Configuring and Troubleshooting Web ADI (Web Applications Desktop Integrator)note 452452.1 R12 Installing, Configuring and Troubleshooting Web ADI (Web Applications Desktop Integrator)note 294739.1 How to enable tracing for WEBADInote 726989.1 List of Patches in Web Applications Desktop Integrator (Web ADI) for Releases 11i and 12 Diagnostics----------------------------------------------------------------------------------------------------note 167000.1 E-Business Suite Diagnostics Installation Guidenote 421245.1 E-Business Suite Diagnostics References for R12note 179661.1 E-Business Suite Diagnostics 11i Test CatalogInstallation----------------------------------------------------------------------------------------------------note 761564.1 Oracle Applications Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86note 402310.1 Oracle Applications Installation and Upgrade notes Release 12 (12.0) for Linux (32-bit)note 406982.1 Cloning Oracle Applications Release 12 with Rapid Clone note 559518.1 Cloning Oracle E-Business Suite Release 12 RAC-Enabled Systems with Rapid Clone note 421409.1 Unbreakable Linux enviroment check before R12 installnote 458533.1 How to Enable Enterprise Manager on the Oracle E-Business Suite Release 12 note 603716.1 Using AS10g AS Control with eBusiness Suite Rel 12note 452120.1 How to locate the log files and troubleshoot RapidWiz for R12note 316806.1 Oracle Applications Installation Update notes, Release 11i (11.5.10.2)note:230672.1 Cloning Oracle Applications Release 11i with Rapid Clonenote 207296.1 How to Find out Linux Version Information?Database----------------------------------------------------------------------------------------------------note:454750.1 Oracle Apps Release 12 with Oracle Database 10.2.0 interoperability notesnote 735276.1 Interoperability notes E-Business Suite R12 with Oracle Database 11gR1 note 388577.1 Configuring Oracle Applications Release 12 with 10g R2 RACnote 466649.1 Using Oracle 11g Release 1 Real Application Clusters and Automatic Storage Management with Oracle E-Business Suite Release 12note 216550.1 Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0)note 362203.1 Oracle Applications Release 11i with Oracle 10g Release 2 (10.2.0)note 452783.1 Oracle Applications Release 11i with Oracle 11g Release 1 (11.1.0) note 362135.1 Configuring Oracle Applications Release 11i with 10g R2 RAC and ASMnote 554539.1 Using Database Partitioning with Oracle E-Business Suite
Tuesday, June 14, 2011
Monday, October 06, 2008
Sunday, February 17, 2008
Backup and Recovery using Oracle RMAN

Overview of RMAN Functional Components
The RMAN environment consists of the utilities and databases that play a role in backing up your data. At a minimum, the environment for RMAN must include the following:
- The target database to be backed up
- The RMAN client, which interprets backup and recovery commands, directs server sessions to execute those commands, and records your backup and recovery activity in the target database control file.
Some environments will also use these optional components:
- A flash recovery area, a disk location in which the database can store and manage files related to backup and recovery
- Media management software, required for RMAN to interface with backup devices such as tape drives
- A recovery catalog database, a separate database schema used to record RMAN activity against one or more target databases
Please check the above diagram illustrates these components
New Features in Oracle Database 10g Release 2Backup Set Encryption
Backup security is vital to the well-being of any company. Backups should only be able to be opened and read by their creators. With Oracle Database 10gR2, backup sets made to disk can now be encrypted, for the whole database or particular tablespaces, using the new CONFIGURE ENCRYPTION FOR [DATABASE TABLESPACE …] option.
Unused Block Compression
With unused block compression (enabled by default), only the currently used blocks are read and written during a full backup. This speeds up backups and reduces backup size. In previous releases, blocks that are currently unused, but had been used at some point in the past, were required to continue to be backed up. Also, blocks that have never been used are never backed up.
Dynamic Channel Allocation for RAC Environments
By configuring the PARALLELISM parameter, RMAN will dynamically allocate the specified number of channels across all active RAC nodes, to perform the backup or restore operation. RMAN utilizes Oracle Clusterware (formerly known as Cluster Ready Services) to allocate channels to the least loaded nodes, to perform the operations. In this way, the overall backup or restore workload can be distributed across the RAC nodes more efficiently.
Enterprise Manager Enhancements
Oracle Enterprise Manager, a single, integrated solution for administering and monitoring systems and applications based on the Oracle technology stack, is further enhanced for managing and monitoring backup jobs.
Database Control allows DBAs to view all backup jobs by date range and backup type (e.g. full, datafile, archive log), along with their status (e.g. "completed", "completed with warnings"), input and output sizes, and output rate. Each backup job can be further drilled down to review input files and output backup sets/image copies, their sizes, and compression ratio (if enabled).
Grid Control offers several enhancements to manage backups across the enterprise. Backup jobs can be viewed across all target databases, and a failed job can be easily restarted without having to resubmit the job again. In case a backup job fails, the DBA can be notified immediately via email. In addition, user-defined RMAN scripts can be created as jobs and applied to any number of target databases. The recovery wizard has also been enhanced to allow restore and recovery to a different Oracle home, in the event that the original Oracle home or database is lost.
Please find the Oracle Recovery Manager 10g overview in below PDF:
http://www.oracle.com/technology/deploy/availability/pdf/TWP_HA_RMANOverview_10g_111503.pdf
Oracle Recovery Manager 10g New Features Overview:
http://www.oracle.com/technology/deploy/availability/pdf/rman_10g_fov.pdf
Using Recovery Manager with Oracle Data Guard in Oracle Database 10g:
http://www.oracle.com/technology/deploy/availability/pdf/RMAN_DataGuard_10g_wp.pdf
RMAN Backup and Recovery Optimization:
http://www.oracle.com/technology/deploy/availability/pdf/br_optimization.pdf
RMAN and Media Manager Troubleshooting Guide:
http://www.oracle.com/technology/deploy/availability/pdf/rman_mm_troubleshoot.pdf
Oracle Database 10g Migration to Automatic Storage Management:
http://www.oracle.com/technology/deploy/availability/pdf/Technical_WP_ASM_Migration.pdf
Version Control Manager
It is very difficult to manage and coordinate concurrent development process and the teams sitting in different locations.
Version Manager enables teams of any size and varying locations to coordinate concurrent development, with secure access and a complete audit trail. Version Manager improves the quality of the final product and accelerates team development enterprise-wide by automating common tasks; increasing code reuse; and eliminating problems caused by lost changes, overwrites, and content errors.
Architecture Over view:
It works on client-server architecture model. Application server resides on the server and java applet is required to access the application from PC.
The following are the installation steps:
1. Install the license Manager
2. Get the license from Serena site
3. Enable the license manager by applying the license key
4. Install Apache software (Optional)
4. Install the Version Control Manager
5. Integrate the Apache with Version Manager Application server.
Apache server installation is optional. You can use the application server (JBOSS) which will be installed by Version Manager directly to access the version manager.
Version Manager Works based on the two license models . They are:
1. Named licenses
2. Concurrent licenses
Mercury IT Governance Center ( Kintana )

Kintana ( ITG ) Details
Note: The IT Governance Name has been changed to PPM ( projects and porrtfolio Management Centre ). Please check www.hp.com for more detials .
Architecture Over View
Mercury IT Governance Center employs a three-tier architecture consisting of:
Client Tier
The client tier consists of:
- The Mercury IT Governance Center standard interface, which is rendered using JSP (Java Server Pages) and is accessed using a Web browser.
- The Mercury IT Governance Workbench interface, executed using a Java applet installed on the client machine, and launched using the Sun Java plug-in to a Web browser
Communication between the client and application server tiers is accomplished as follows:
- For the standard interface, HTTP or HTTPS, with no code required on end user's smachines. The client accesses information from the database through the J2EE application server using a shared database session pool.
- For the Workbench interface, RMI (Remote Method Invocation) or SRMI (Secure Remote Method Invocation), which has been optimized by Mercury for use in Mercury IT Governance Center.
The architecture and communication protocols have been created to minimize the number of round trips between the applet and server, and the volume of data transferred.
Application Server Tier
The application server:
- Runs on the Microsoft Windows, Sun Solaris, HP-UX, IBM AIX, and Red Hat Linux platforms
- Uses the JBoss Application Server, which has full J2EE 1.3 (Java 2 Platform, Enterprise Edition) support
- Houses workflow, scheduling, notification, and execution engines that drive automated tasks like code deployment to remote systems, dynamic routing, and email notifications
- Can run on one or more machines as a cluster to improve performance and scale hardware as usage increases
- Can optionally integrate with external Web servers like Sun Java System Web Server (formerly Sun ONE Web Server and iPlanet), Microsoft IIS, and Apache
- Maintains a database connection pool that caches connections to the database, which eliminates the need to restart the application server if the database shuts down for scheduled maintenance or system failure
- The protocol used for communication between Mercury IT Governance Server
and Mercury IT Governance Web server is AJP13—a protocol similar to HTTP that has been optimized for performance.
Communication between the application server and database tiers is achieved
using JDBC (Java Database Connectivity).
Database Tier
The database tier consists of an Oracle database containing the tables,
procedures, PL/SQL packages, and other components used by the Mercury IT
Governance Center products. All transaction, setup, and auditing data is stored
in the database. Mercury IT Governance Center can run on a single database
instance, or can leverage Oracle RAC (Real Application Cluster) configuration
for load balancing, redundancy, and failover.
Mercury IT Governance Center supports the following Oracle database
features:
- A relational data model
- Use of Oracle stored procedures to implement business logic (for example,workflow processing)
- Use of a database pool to eliminate creation of a separate database session for each user or transaction
- Database caching of frequently used data, programs, and procedures to improve performance
Business Technology Optimization and the IT Governance Process :
Business technology optimization refers to the strategies and processes involved in aligning IT with business goals to maximize IT’s business value. Mercury IT Governance Center is used to digitize and automate IT business processes from demand through production to enable customers to optimize and align IT strategy and execution.
IT Governance Centre :
IT Governance Centre consist a set of products ( applications ) :
- Change management
- Demand Management
- Portfolio Management
- Program Management
- Project Management
- Resource Managemen
- Time Management
- Financial Management
Change Management:
Mercury Change Management enables you to plan, package, release, and deploy changes to your applications portfolio. It digitizes best practice software change management processes across platforms and environments (such as mainframe, UNIX, NT, and Linux), types of change (code,configurations, content), or applications (such as Oracle,PeopleSoft, SAP, and Siebel). By automating formerly manual tasks, Change Management lets you accomplish more with less and dramatically lessen the risk of “broken” deployments.
With Mercury Change Management, you can:
- You can automate code migration accorss the instances ( Ex. code like sql components , oracle forms , reports , discoverer reports , packages , procesedures , Oracle applications 11i AOL components etc )
- You can automate patch application of Oracle E-business suite instances.
- You can also automate the clonning of instances.
Demand Management:
Mercury Demand Management is a product of Mercury IT Governance Center that manages requests from creation to implementation. Each request is processed using a graphical workflow. Demand Management features tools and configurable processes for dealing with these requests. Data is captured by prompting for process-specific information. This ensures the required information is collected and validated at the appropriate time in the process.
Mercury Demand Management can follow complex business rules by using different approval methods. Email and pager notifications can be generated as the request passes through the various stages of the workflow. Prioritization and delegation features allow requests to efficiently advance through their specific workflow, routing them to the relevant department, group, orindividual.
Portfolio Management :
Mercury Portfolio Management provides a real-time governance setup that supports your strategic, financial, functional, and technical requirements. Ideal for new initiatives that grow and transform your business as well as existing applications that run your business, Mercury Portfolio Management can help you align your IT portfolio with your business strategy and maximize portfolio value.
Mercury Portfolio Management allows business and IT stakeholders to collaboratively govern your portfolio with proper levels of review and approval. Mercury Portfolio Management monitors the entire portfolio lifecycle (proposal justification and review, project initiation, execution, deployment, and benefits realization) and enables stakeholders to make better portfolio decisions and analyze what-if scenarios using easy-to-build scenario comparisons.
Program Management:
Mercury Program Management allows a program manager to deliver a new business capability or solve a problem using programs. Using programs, a program manager can do the following:
- Oversee related IT projects
- Coordinate inter-project deliverable and milestones
- Manage scope change
- Identify and mitigate risks
- Resolve inter-project issues
- Manage the allocation of resources
- Initiate program requests (by stakeholders)
Project Management:
Mercury Project Management enables organizations to streamline and standardize the management of project activities using a template-based,collaborative approach. Project plans are defined as a hierarchical structure of projects and subprojects that logically group and organize tasks or activities.
Project Management defines the step-by-step processes required to complete specific tasks and deliverables. Organizations can easily manage project plan activities within and across the technology chain because all project team members, whether internal or external, collaborate and interact through an intuitive interface. The underlying product framework guides users through a dynamic, self-documenting process to support activities such as the execution of standardized checklists or the collection of deliverables using document attachments.
Resource Management:
Mercury IT Governance Center provides an array of tools for managing personnel related to IT initiatives. Organizational modeling capabilities keep track of where resources are located and who they report to. Skill modeling capabilities unlock the potential of resources. As resources are assigned to tasks and requests, executives and managers have full visibility into the capacity of their teams and the load placed on them, in terms of both current operational use and capacity planning for the future.
Time Management:Talk about the time management of the resources and effective utilization of time.
Financial Management : it talks about the budget
Note : For more detials about the licence and complete documentation please contact HP ( www.hp.com ) . The reference for the above content are HP-Mercury Documents.