Updated Metalink Notes

Updated Metalink Notes

Updated Metalink Note:

NOTE.74660.1 : Resolving Invalid Objects in Oracle Applications
NOTE.338879.1 : Landscape1309 - Linux Landscape Quick Reference
NOTE.341782.1 : Linux Quick Reference
NOTE.312572.1 : About Oracle Applications Technology Updates for Release 11.
NOTE.316806.1 : Oracle Applications Installation Update Notes, Release 11i
NOTE.370274.1 : New Features in Oracle Application 11i
NOTE.275734.1 : India Localization
NOTE.47837.1 : Applications Utilities FAQ
NOTE.189487.1 : System Administration FAQ's
NOTE.289786.1 : Installing Oracle Applications: A Guide to Using Rapid
NOTE.245079.1 : Steps to clone a 11i RAC environment to a non-RAC
NOTE.243693.1 : Rapid Clone Coredumps when Running Adcfgclone.pl
NOTE.231701.1 : How to Find Patching History (10.7, 11.0, 11i)
NOTE.139684.1 : Oracle Applications Current Patchset Comparison Utility -
NOTE.331746.1 : Oracle Accelerator FAQ for Global Product Support (Internal
NOTE.144751.1 : Applications Patching - Time Saving Techniques
NOTE.232833.1 : Oracle Applications Release Notes, Release 11i (11.5.9)
NOTE.110372.1 : 11i: How to Clean up the UNIX Environment After Install
NOTE.156219.1 : Net8i/9i Basic configuration of LISTENER.ORA and TNSNAMES.
NOTE.69725.1 : Configuring TNSNAMES.ORA, SQLNET.ORA,and LISTENER.ORA in
NOTE.356878.1 : How to relink the whole Applications 11i Installation
NOTE.233428.1 : Sharing the Application Tier File System in Oracle
NOTE.130686.1 : How to Generate Form, Library and Menu for Oracle
NOTE.246105.1 : Upgrading to J2SE 1.4.2 with Oracle Applications 11i
NOTE.139949.1 : NEED TO CLEAR APACHE, BROWSER OR JINITIATOR CACHE FOR
NOTE.133972.1 : How to Reset the APPS and APPLSYS Passwords in Release 11.5
NOTE.216980.1 : FNDLOAD Fails with PLS-306 in call to LOAD_ROW
NOTE.333785.1 : Oracle Applications Internationalization Guide
NOTE.222663.1 : Internationalization Update Notes for the Oracle E-Business Suite 11i
NOTE.372952.1 : Customer Translations
NOTE.168330.1 : Reload Applications Related Java Objects
NOTE.287176.1 : DMZ Configuration with Oracle E-Business Suite 11i
NOTE.233436.1 : Installing Oracle Application Server 10g with Oracle E-
NOTE.231701.1 : How to Find Patching History (10.7, 11.0, 11i)
NOTE.139684.1 : Oracle Applications Current Patchset Comparison Utility -
NOTE.238276.1 : Migrating to Linux with Oracle Applications Release 11i
NOTE.242480.1 : Using a Staged Applications 11i System to Reduce Patching
NOTE.1076329.6 : SQL*Plus Errors - SP1.MSB Not Found
NOTE.248857.1 : Oracle Applications Tablespace Model Release 11i -
NOTE.269293.1 : Oracle Applications Tablespace Model FAQs
NOTE.258330.1 : About Oracle Applications Manager Minipack 11i.OAM.H
NOTE.268837.1 : Gathering Debug Weboam Log
NOTE.342332.1 : Troubleshooting Login Problems in Oracle Applications 11i
NOTE.112577.1 : How to customize reports at runtime using XML - simple
NOTE.144689.1 : How to Generate a Report (.rdf) File from the UNIX Command
NOTE.211424.1 : How to Enable a Large SGA(over 1.7GB) on RedHat Advanced
NOTE.345145.1 : Is There A Way To Automate The Prompts For Adcfgclone.Pl?
NOTE.1812.1 : TECH : Getting a Stack Trace from a CORE file
NOTE.144599.1 : How to Generate a .pll Library File for Applications 11i
NOTE.282038.1 : Oracle Applications Release 11i with Oracle Database 10g
NOTE.208375.1 : How To Convert A Single Instance Database To RAC In A
NOTE.279956.1 : Oracle E-Business Suite Release 11i with 9i RAC :
NOTE.312731.1 : Configuring Oracle Applications Release 11i with 10g RAC
NOTE.362135.1 : Configuring Oracle Applications Release 11i with 10g R2 RAC
NOTE.1067473.6 : Custom Forms do not Show up in FNDSCMON Form
NOTE.232834.1 : Oracle Applications Release 11.5.9 Maintenance Pack
NOTE.216550.1 : Oracle Applications Release 11i with Oracle9i Release 2 (9.
NOTE.362203.1 : Oracle Applications Release 11i with Oracle 10g Release 2 (10.2.0)
NOTE.233038.1 : AD Command Line Options
NOTE.186125.1 : Applications 11i and Standby Databases
NOTE.260887.1 : Steps to Clean Nonexistent Nodes or IP Addresses from
NOTE.342459.1 : Diagnostics Overview
NOTE.394615.1 : Adaddnode.Pl failed with : ORA-00001 : unique constraint
NOTE.338003.1 : How to change the hostname and/or port of the Database Tier
NOTE.341322.1 : How to change the hostname of an Applications Tier using AutoConfig
NOTE.333785.1 : Oracle Applications Internationalization Guide
NOTE.211708.1 : Detailed Explanations of How NLS/MLS is Being Handled in 11i
NOTE.73352.1 : NLS/MLS Frequently Asked Questions
NOTE.72324.1 : Guidelines on Resolving NLS/MLS issues
NOTE.316365.1 : Oracle Applications Release 11.5.10.2 Maintenance Pack
NOTE.230627.1 : 9i Export/Import Process for Oracle Applications Release 11i
NOTE.331221.1 : 10g Export/Import Process for Oracle Applications Release 11i
NOTE.362205.1 : 10g Release 2 Export/Import Process for Oracle Applications Release 11i
NOTE.259552.1 : 11.5.9 Category 3 Preupgrade Instructions for 9.2.0.4
NOTE.341281.1 : How to disable the language selection option available in AppsLocalLogin.jsp
NOTE.389472.1 : OATM Migration fails with ORA-22853 for LOB objects
NOTE.174605.1 : bde_chk_cbo.sql - Reports Database Initialization
NOTE.333785.1 : Oracle Applications Internationalization Guide
NOTE.124721.1 : Migrating an Applications Installation to a New Character
NOTE.66320.1 : Changing the Database Character Set or the Database
NOTE.119164.1 : Changing Database Character Set - Valid Superset Definitions
NOTE.123670.1 : Use Scanner Utility before Altering the Database Character
NOTE.213015.1 : SYS.METASTYLESHEET marked as having convertible data (ORA-
NOTE.258895.1 : SYS.RULE$ marked as having convertible data (ORA-12716 when
NOTE.258902.1 : SYS.JOB$ marked as having convertible data
NOTE.43208.1 : Certified Compilers
NOTE.270806.1 : 11.5.9 : Invalid Objects - IES Java Classes
NOTE.165114.1 : Resolving Invalid Java Classes in Oracle Applications
NOTE.343253.1 : Tns-12555, Tns-12560, Tns-00525, Linux Error : 1 Starting
NOTE.150168.1 : Obtaining Forms Runtime Diagnostics (FRD) In Oracle
NOTE.210193.1 : Use of Multiple Organizations In Oracle Applications
NOTE.165035.1 : Current Issues - Multiple Organizations Architecture
NOTE.208267.1 : Improved Convert to Multi-Org Process In Oracle
NOTE.226456.1 : Multiple Organizations in Oracle Applications R11i, March
NOTE.259546.1 : Setting Up Multiple Organizations in Oracle HRMS
NOTE.131081.1 : How can I find which version of Portal I am running ?
NOTE.262125.1 : Sun.io.MalformedInputException For OraSCV.asc,emreadme.txt,
NOTE.216205.1 : Database Initialization Parameters for Oracle Applications
NOTE.213015.1 : SYS.METASTYLESHEET marked as having convertible data (ORA-
NOTE.283225.1 : How to Recreate the Listener for Event and Listener for
NOTE.153960.1 : FAQ : X Server testing and troubleshooting
NOTE.146468.1 : Installing and Upgrading Oracle9i Application Server with
NOTE.233428.1 : Sharing the Application Tier File System in Oracle
NOTE.351283.1 : Interoperability Notes : Oracle Applications Release 11i
NOTE.287453.1 : Oracle Applications 11.5.10 - Installation Update Notes for
NOTE.317226.1 : Concurrent Managers Do Not Start With GSM Profile Option
NOTE.311015.1 : Adgendbc.sh Errors Running AutoConfig
NOTE.337937.1 : Step By Step - 10gR2 RAC with ASM install on Linux(x86) -
NOTE.266043.1 : Support of Linux and Oracle Products on Linux
NOTE.224302.1 : Raw Devices on Linux
NOTE.134395.1 : Cannot Connect to Personal Home Page : Your Session is no
NOTE.351646.1 : Configuring Oracle E-Business Suite Release 11i with 10g
NOTE.230688.1 : Basic ApacheJServ Troubleshooting with IsItWorking.class
NOTE.70276.1 : HOW TO INTEGRATE APPLICATIONS RELEASE 11 WITH CUSTOM
NOTE.273449.1 : Diagnosing Login Problems with Apps 11.5.9 (FND.G)
NOTE.139863.1 : Configuring and Troubleshooting the Self Service Framework
NOTE.342332.1 : Troubleshooting Login Problems in Oracle Applications 11i
NOTE.233428.1 : Sharing the Application Tier File System in Oracle
NOTE.252422.1 : Requesting Translation Synchronization Patches
NOTE.287176.1 : DMZ Configuration with Oracle E-Business Suite 11i
NOTE.68713.1 : Troubleshooting Self-Service Web Applications Login
NOTE.304489.1 : Using Oracle Applications with a Split Configuration
NOTE.225074.1 : 11i AOL : Cannot login to PHP after DB upgrade to 9.2.0.2
NOTE.358140.1 : Troubleshooting Unix coredumps and obtaining stack traces
NOTE.1007808.6 : HOW TO HANDLE CORE DUMPS ON UNIX
NOTE.1812.1 :
NOTE.169706.1 : Oracle Database on AIX,HP-UX,Linux,MacOSX,Solaris,Tru64
NOTE.197031.1 : 32-bit/64-bit Certification/Conversion Issues on Oracle
NOTE.300172.1 : Obsolescence of KOREAN_LEXER Lexer Type
NOTE.225456.1 : Troubleshooting Guide for Cloning Issues
NOTE.161474.1 : Oracle Applications Remote Diagnostics Agent (APPS_RDA)
NOTE.111383.1 : The Basics About Report Review Agent (FNDFS) on 11i
NOTE.210062.1 : Generic Service Management (GSM) in Oracle Applications 11i
NOTE.316447.1 : About Oracle XML Publisher Release 5.5
NOTE.295036.1 : About XML Publisher Release 5.0
NOTE.130091.1 : Upgrading Oracle Applications 11i to use JDK 1.3
NOTE.292424.1 : Cleaning your Windows System After a Failed Oracle
NOTE.124606.1 : Upgrading JInitiator with Oracle Applications 11i
NOTE.316806.1 : Oracle Applications Installation Update Notes, Release 11i
NOTE.177183.1 : Succesfully Installing NLS/MLS in 11i
NOTE.134007.1 : CMCLEAN.SQL - Non Destructive Script to Clean Concurrent Manager Tables
NOTE.1010501.7 : FAQ : Licensing and de-licensing a product, country-specific
NOTE.217368.1 : Advanced Configurations and Topologies for Enterprise
NOTE.287176.1 : DMZ Configuration with Oracle E-Business Suite 11i
NOTE.302738.1 : Using Virtual Hostnames with Oracle Applications Release 11i
NOTE.403311.1 : United States Time Zone Changes 2007 : E-Business Suite
NOTE.333785.1 : Oracle Applications Internationalization Guide
NOTE.232313.1 : Information on Previous Versions of Developer 6i Patchsets
NOTE.240862.1 : Install Oracle Unicode Fonts for Dynamic Image Generation
NOTE.60966.1 : Getting Rid Of Those Pesky Invalid Objects In Oracle
NOTE.400830.1 : How to Render Non ASCII Characters in Personalized
NOTE.285218.1 : Recommended Browsers for Oracle Applications 11i
NOTE.403311.1 : United States & Canada 2007 Daylight Saving Time (DST)
NOTE.289788.1 : Upgrading Oracle Applications
NOTE.316804.1 : Oracle Applications NLS Release Notes, Release 11i (11.5.10.
NOTE.189867.1 : Troubleshooting FRM-92050, FRM-92100, FRM-92101, FRM-92102
NOTE.253763.1 : After Cloning on Target instance FRM-92050 Failed to
NOTE.274783.1 :

Amol's Bookmark
*********************************************************************
NOTE.167000.1 : eBusiness Suite Support - Oracle Diagnostics Support Pack
NOTE.235307.1 : OSS Application Diagnostics Tools : FAQ and Troubleshooting
NOTE.231142.1 : About Oracle Diagnostics version 2.1
NOTE.262006.1 : About Oracle Diagnostics 2.2
NOTE.300976.1 : Support Diagnostics Newsletter for Applications Core
NOTE.357223.1 : "This test can be executed only after logging into
NOTE.363759.1 : How To Add Diagnostic Tools To Responsibility Menu

Installation
*********

NOTE.215868.1 : 11i Release Notes
NOTE.77219.1 : Applications Release 11.0.3 One-Hour Install for Unix
NOTE.287453.1 : Oracle Applications 11.5.10 - Installation Update Notes for
NOTE.292424.1 : Cleaning your Windows System After a Failed Oracle
NOTE.110372.1 : 11i : How to Clean up the UNIX Environment After Install
NOTE.169402.1 : How To Cleanup After A Failed Applications Installation On
NOTE.48602.1 : How do I determine which products are fully installed, and
NOTE.124353.1 : WIN : Manually Removing all Oracle Components on Microsoft
NOTE.275493.1 : Removing 10g Database and Software from AIX, HP-UX, Linux,
NOTE.279519.1 : How to completely remove 8i / 9i Database and Software from
NOTE.232831.1. : Oracle Applications NLS Release Notes 11.5.9 - B10846-01
NOTE.287453.1 : Oracle Applications 11.5.10 - Installation Update Notes for
NOTE.187240.1 : Applications AOL Scenarios : Is It Supported ?
NOTE.287453.1 : Oracle Applications 11.5.10 - Installation Update Notes for
NOTE.316806.1 : Oracle Applications Installation Update Notes, Rel 11.5.10.2
NOTE.360079.1 : Global and Local Inventory explained
NOTE.295185.1 : How to Recreate the Global oraInventory
NOTE.197028.1 : Software Requirements and Tools for Oracle Applications
NOTE.201392.1 : Visual C++ Requirement for Release 11i on Windows
NOTE.268776.1 : GNU Make Requirement for Release 11i For Windows
NOTE.181244.1 : Configuring VNC Or XVFB As The X Server For Applications 11i
NOTE.153960.1 : FAQ : X Server testing and troubleshooting

Patching
*******

NOTE.174436.1 : Oracle Applications Patching FAQ
NOTE.175485.1 : How to Apply an 11i Patch When adpatch is Already Running
NOTE.231701.1 : How to Find Patching History (10.7, 11.0, 11i)
NOTE.252422.1 : Requesting Translation Synchronization Patches in Release
NOTE.316366.1 : 11.5.10 Oracle E-Business Suite Consolidated Update 2 (CU2)
NOTE.259484.1 : Release 11.5.10 Maintenance Pack Installation Instructions
NOTE.316365.1 : Oracle Applications Release 11.5.10.2 Maintenance Pack
NOTE.139684.1 : Oracle Applications Current Patchset Comparison Utility -
NOTE.181665.1 : Release 11i Adpatch Basics
NOTE.358247.1 : ORA-00001 : unique constraint violated error while applying
NOTE.358417.1 : Unable to Start Concurrent Managers After Applying 11i.
NOTE.353414.1 : Application Technology Group (ATG) Patching Policy
NOTE.359198.1 : XDF files fail to load on HP-UX, Memory Fault(Coredump)
NOTE.232834.1 : Oracle Applications Release 11.5.9 Maintenance Pack
NOTE.337274.1 : About Oracle Applications Technology 11i.ATG_PF.H Rollup 3
NOTE.244040.1 : Oracle E-Business Suite Recommended Performance Patches
NOTE.367756.1 : Uploading Java Objects To Patch History Tables Fails While
NOTE.76708.1 : Using ADSPLICE To Add Products To The APPL_TOP In

Cloning
******

NOTE.230672.1 : Cloning Oracle Applications Release 11i with Rapid Clone
NOTE.216664.1 : FAQ : Cloning Oracle Applications Release 11i
NOTE.242123.1 : Create new middle tier node in existing Apps 11i
NOTE.238276.1 : Migrating to Linux with Oracle Applications Release 11i
NOTE.364565.1 : Troubleshoot RapidClone or OAM Clone issues

Upgrade
*******

NOTE.200963.1 : R11.5.3/R11.5.4/R11.5.5 Upgrade And Install Issues
NOTE.289765.1 : Oracle Applications Release 11i (11.5.10) Upgrade Assistant
NOTE.289788.1 : Upgrading Oracle Applications

Autoconfig
**********

NOTE.165195.1 : Using AutoConfig to Manage System Configurations with
NOTE.218089.1 : Autoconfig FAQ
NOTE.270519.1 : Customizing an AutoConfig Environment
NOTE.260887.1 : Steps to Clean Nonexistent Nodes or IP Addresses from
NOTE.341322.1 : How to change the hostname of an Applications Tier using
NOTE.338003.1 : How to change the hostname and/or port of the Database Tier
NOTE.108865.1 : How To Create a Database Connection(DBC) File and

AD Utilities
**********

NOTE.233038.1 : AD Command Line Options

Relinking
********

NOTE.69798.1 : Basics of Relinking an Executable or Binary in an Oracle
NOTE.1009722.6 : How to relink Oracle Concurrent Program Executables on Unix

OAM
****

NOTE.210062.1 : Generic Service Management (GSM) in Oracle Applications 11i
NOTE.117264.1 : FAQ (Oracle Applications Manager)
NOTE.177089.1 : OAM11i Standalone Mode Setup and Configuration
NOTE.214962.1 : How To Determine The Version Of OAM (Oracle Application
NOTE.258330.1 : About Oracle Applications Manager Minipack 11i.OAM.H
NOTE.166115.1 : Oracle Applications Manager 11i integrated with Oracle
NOTE.185431.1 : Troubleshooting Oracle Applications Manager OAM 2.0 for 11i
NOTE.73959.1 : Installation and Configuration of Oracle Application Manager
NOTE.225024.1 : Oracle Applications Manager 11i Documentation Roadmap
NOTE.338317.1 : Basic Information on Cloning An 11.5.10 System Using OAM

NLS/MLS
*******

NOTE.15389.1 : NLS DEBUGGING SUCCESS GUIDE ** INTERNAL ONLY **
NOTE.227332.1 : NLS considerations in Import/Export - Frequently Asked
NOTE.15095.1 : Export/Import and NLS Considerations
NOTE.175300.1 : A Guide to Debugging Globalization (NLS) Support Issues
NOTE.124721.1 : Migrating an Applications Installation to a New Character

Forms
*****

NOTE.130686.1 : How to Generate Form, Library and Menu for Oracle
NOTE.177610.1 : Oracle Forms in Applications FAQ
NOTE.141012.1 : How to Manually Generate an 11.5 Form on Unix

Apps Database
*************

NOTE.174605.1 : bde_chk_cbo.sql - Reports Database Initialization
NOTE.186125.1 : Applications 11i and Standby Databases
NOTE.248857.1 : Oracle Applications Tablespace Model Release 11i -
NOTE.216205.1 : Database Initialization Parameters for Oracle Applications
NOTE.285267.1 : Oracle E-Business Suite 11i and Database FAQ
NOTE.230627.1 : 9i Export/Import Process for Oracle Applications Release 11i
NOTE.183078.1 : Recreating Applications 11i JAVA objects in the database
NOTE.216212.1 : Business Continuity for Oracle Applications Release 11i,
NOTE.282038.1 : Oracle Applications Release 11i with Oracle Database 10g
NOTE.340859.1 : Upgrading Oracle Applications 11i Database to 10g with
NOTE.174605.1 : bde_chk_cbo.sql - Reports Database Initialization
NOTE.216211.1. : Nologging in the E-Business Suite
NOTE.282038.1 : Oracle Applications Release 11i with Oracle Database 10g

RAC / Apps RAC
**************

NOTE.220970.1 : RAC : Frequently Asked Questions
NOTE.312731.1 : Configuring Oracle Applications Release 11i with 10g RAC
NOTE.270901.1 : How to Dynamically Add a New Node to an Existing 9.2.0 RAC
NOTE.294652.1 : E-Business Suite 11i on RAC : Configuring Database Load balancing & Failover
NOTE.312731.1 : Configuring Oracle Applications Release 11i with 10g RAC
NOTE.279956.1 : Oracle E-Business Suite Release 11i with 9i RAC :
NOTE.277825.1 : How to setup Tnsnames.ora (806) for 11i and RAC

Database
********

NOTE.1012933.6 : General Information : Alert Logs and Trace Files
NOTE.209870.1 : How to Reload the JVM in 9.2.0.X
NOTE.175472.1 : How to Reload the JVM in 8.1.7.X
NOTE.159143.1 : Separating Multiple 8i or 9i Oracle Versions to Avoid
NOTE.307349.1 : OUI tips for Oracle RDBMS 10.1.X on OpenVMS
NOTE.130814.1 : How to move LOB Data to Another Tablespace

System Administration
*******************

NOTE.189457.1 : Oracle Applications Systems Administration Setup and Usage
NOTE.290525.1 : Oracle User Management FAQ
NOTE.316277.1 : Unable To Change Guest User Password In Oracle Applications
NOTE.311552.1 : How to optimize the purge process in a high transaction
NOTE.154850.1 : How to Run the Purge Concurrent Request and/or Manager Data

Jserver
******

NOTE.295484.1 : Clear Server Cache and Bounce Apache (Web Server)
NOTE.220188.1 : Oracle Applications Release 11i apps.zip Re-architect
NOTE.230688.1 : Basic ApacheJServ Troubleshooting with IsItWorking.class

Invalid Objects
*************

NOTE.60558.1 : Troubleshooting the Source of Invalid Objects
NOTE.266910.1 : How To Resolve IES Invalid Java Classes After Loading JAR
NOTE.113947.1 : Step by Step Troubleshooting Guide to Solve APPS Invalid
UNIX / LINUX / WINDOWS
=======================
NOTE.1007808.6 : HOW TO HANDLE CORE DUMPS ON UNIX
NOTE.1812.1 : TECH : Getting a Stack Trace from a CORE file
NOTE.28588.1 : TECH : Using Truss / Trace on Unix
Advanced Configuration:
======================
NOTE.217368.1 : Advanced Configurations and Topologies for Enterprise
NOTE.226880.1 : Configuration of Load Balancing and Transparent Application
NOTE.97926.1 : Failover Issues and Limitations [Connect-time failover and
NOTE.123718.1 : 11i : A Guide to Understanding and Implementing SSL for
Techstack:
=========

NOTE.162488.1 : Complete Guide to JInitiator 1.1.8 Setup & Troubleshooting
NOTE.312572.1 : About Oracle Applications Technology Updates for Release 11.
NOTE.246105.1 : Upgrading to J2SE 1.4.2 with Oracle Applications 11i
NOTE.94091.1 : Example : Identifying Connection String Problems in JDBC

Workflow:
========

NOTE.298550.1 : Troubleshooting Workflow Data Growth Issues

General:
=======

NOTE.184977.1 : Certify FAQ, Product Navigation & User's Guide
NOTE.224882.1 : Common Commands asked by Oracle Support for Troubleshooting
NOTE.110415.1 : Payables MRC Frequently Asked Questions
NOTE.285218.1 : Recommended Browsers for Oracle Applications 11i
NOTE.257650.1 : Resolving Problems with Connection Idle Timeout
NOTE.270523.1 : How To Find the Oracle Applications Framework and Rollup
NOTE.301504.1 : "Cannot Complete Applications Logon" Error After Selecting
NOTE.315094.1 : JTF Login Page - an operational assessment for CRM
NOTE.242490.1 : How To Configure The "/etc/hosts" File On Linux
NOTE.282038.1 : Oracle Applications Release 11i with Oracle Database 10g Release 1
NOTE.342861.1 : Java Version Conflict When Migrating Platforms
NOTE.209999.1 : Oracle Applications Manager in Oracle Applications 11.5.8
NOTE.198160.1 : Summary note to LOB's/BLOB's/CLOB's/NCLOB's and BFILES
NOTE.159244.1 : How To Use FNDCPASS to Change The Oracle Users, APPS, APPLSYS and Application Module Passwords (INV, AR, AP, etc.) For Applications 11.5 in Unix
NOTE.186981.1 : Oracle Application Server with Oracle E-Business Suite
NOTE.333436.1 : Oracle E-Business Suite 11i on Windows Server 2003 Service
NOTE.356878.1 : How to relink the whole Applications 11i Installation
NOTE.197031.1 : 32-bit/64-bit Certification/Conversion Issues on Oracle
NOTE.158577.1 : NLS_LANG Explained (How does Client-Server Character
NOTE.227331.1 : Setting NLS Parameters - Frequently Asked Questions
NOTE.124721.1 : Migrating an Applications Installation to a New Character
NOTE.43208.1 : Certified Compilers
NOTE.66320.1 : Changing the Database Character Set or the Database
NOTE.279956.1 : Oracle E-Business Suite Release 11i with 9i RAC :
NOTE.260393.1 : Java Mailer and Other 11.5.9/OWF G Current Issues in
NOTE.232313.1 : Information on Previous Versions of Developer 6i Patchsets
NOTE.125767.1 : Upgrading Developer 6i with Oracle Applications 11i
NOTE.371438.1 : adpreclone.pl dbTier fails with RC-50409 : Topology
NOTE.135949.1 : Troubleshooting the Personal Home Page Login Problems in 11.
NOTE.164317.1 : Upgrading JDBC drivers with Oracle Applications 11i
NOTE.302035.1 : How to Test a JDBC Thin Driver Connection From the SSO
NOTE.365735.1 : How to use Digital Certificates for 11i Applications
NOTE.357922.1 : Autoconfig Reverts to old Context File Values.
NOTE.206511.1 : How to Find a JAR File Which Contains a Particular JAVA
NOTE.68839.1 : 8i Using loadjava and dropjava to Load and Unload Java
NOTE.165123.1 : JAVA CLASS - ORA-29534 : referenced object
NOTE.165114.1 : Resolving Invalid Java Classes in Oracle Applications
NOTE.271218.1 : Yellow bar's and Java security error , The daddy of all
NOTE.294932.1 : Recommendations to Install Oracle Applications 11i
NOTE.169706.1 : Oracle Database on AIX,HP-UX,Linux,MacOSX,Solaris,Tru64
NOTE.342442.1 : Cloning Multi-Node to Single-Node Oracle Applications
NOTE.233428.1 :
NOTE.302738.1 : Using Virtual Hostnames with Oracle Applications Release 11i
NOTE.356433.1 : Using Oracle Applications Release 11i with Virtual
NOTE.362135.1 : Configuring Oracle Applications Release 11i with 10g R2 RAC
NOTE.159270.1 : How To Use FNDCPASS to Change The Oracle Users, APPS,
NOTE.303237.1 : Migrating Red Hat Linux 2.1 or 3.0 to Red Hat Linux 4.0
NOTE.91985.1 :
NOTE.200963.1 : R11.5.3/R11.5.4/R11.5.5 Upgrade And Install Issues
NOTE.272789.1 : Post Clone Problem : Login/Portal Server Installation May
NOTE.339664.1 : Analyst Crib Sheet for NLS/MLS issues in Oracle
NOTE.211708.1 : Detailed Explanations of How NLS/MLS is Being Handled in 11i
NOTE.245079.1 : Steps to clone a 11i RAC environment to a non-RAC
NOTE.362135.1 : Configuring Oracle Applications Release 11i with 10g R2 RAC
NOTE.362135.1 : Configuring Oracle Applications Release 11i with 10g R2 RAC
NOTE.312731.1 : Configuring Oracle Applications Release 11i with 10g RAC
NOTE.131321.1 : How to Relink Oracle Database Software on UNIX
NOTE.231876.1 : Windows OS Upgrade for 11i E-Business Suite
NOTE.184977.1 : Certify FAQ, Product Navigation & User's Guide
NOTE.209810.1 : How to Relink Oracle Applications 11i Programs After
NOTE.361428.1 : Using Linux Desktop Clients with Oracle Applications 11i
NOTE.296559.1 :
NOTE.275734.1 : India Localization
NOTE.364439.1 : Tips and Queries for Troubleshooting Advanced Topologies
NOTE.372928.1 : Oracle Critical Patch Update July 2006 Documentation Map
NOTE.372931.1 : E-Business Suite Critical Patch Update Note
NOTE.268837.1 : Gathering Debug Weboam Log
NOTE.292996.1 : How to Re-Install Intermedia on an 11i Environment
NOTE.160121.1 : Introduction to Sun Cluster v3
NOTE.188135.1 : Documentation Index for Real Application Clusters
NOTE.251351.1 : How to Change the Characterset in a Standby Database in 9i
NOTE.362203.1 : Oracle Applications Release 11i with Oracle 10g Release 2
NOTE.362205.1 : 10g Release 2 Export/Import Process for Oracle Applications
NOTE.1009718.6 : HOW TO SOLVE UNDEFINED SYMBOL ERRORS ON UNIX AND VMS
NOTE.316889.1 : Complete checklist for manual upgrades to 10gR2
NOTE.223721.1 : How to Install XVFB on Linux for dynamic image generartion
NOTE.130091.1 : Upgrading Oracle Applications 11i to use JDK 1.3
NOTE : 163400.1 : Release Content Documents and Features Summary Matrices
NOTE.253918.1 : Autopatch Fails with "Unable to call adppdepRunFndLoad
NOTE.166650.1 : Working Effectively With Oracle Support Services
NOTE.333785.1 : Oracle Applications Internationalization Guide
NOTE.119164.1 : Changing Database Character Set - Valid Superset Definitions
NOTE.17210.1 : Supported NLS Character Sets
NOTE.179133.1 : The correct NLS_LANG in a Windows Environment
NOTE.226565.1 : 9iRAC Useful Views and Statistics (INTERNAL ONLY)
NOTE.387046.1 : RCONFIG : Frequently Asked Questions
NOTE.200340.1 : RAC : Cache Fusion
NOTE.265253.1 : 10g Recyclebin Features And How To Disable it( _recyclebin )
NOTE.312594.1 : Get Warning Messages Trying To Generate Jar Files From
NOTE.242480.1 : Using a Staged Applications 11i System to Reduce Patching
NOTE.134007.1 : CMCLEAN.SQL - Non Destructive Script to Clean Concurrent
NOTE.365228.1 : About Oracle Applications Technology 11i.ATG_PF.H Rollup 4
NOTE.371016.1 : How To License A New Product.
NOTE.151654.1 : How To Start the License Manager After Installing Oracle
NOTE.279430.1 : How To Change Project Installation From Shared To Full
NOTE.123891.1 : How to deactivate a language in e-Business Suite
NOTE.216550.1 : Oracle Applications Release 11i with Oracle9i Release 2 (9.
NOTE.341437.1 : Business Continuity for Oracle Applications Release 11i
NOTE.246105.1 : Upgrading to J2SE 1.4.2 with Oracle Applications 11i
NOTE.304748.1 : Internal : E-Business Suite 11i with Database FAQ
NOTE.308320.1 : How to install the 10.1.0 Enterprise Manager Grid Control
NOTE.291901.1 : Maintenance Mode - A New Feature in 11.5.10
NOTE.134527.1 : TNS-00516 Starting TNS Listener
NOTE.300482.1 : Overview of Using Java with Oracle E-Business Suite Release
NOTE.208256.1 : WIN : How to Remove a Single ORACLE_HOME and Its Traces on
NOTE.363827.1 : Rebaselined Oracle Applications Technology Components for
NOTE.373611.1 : How to move Concurrent Processing Server from one node to
NOTE.240818.1. : Concurrent Processing: Transaction Manager Setup and Configuration Requirement in an 11i RAC Environment
NOTE.69660.1 : Understanding Data Auditing in Oracle Application Tables
NOTE.60828.1 : Overview of Oracle Applications AuditTrails
NOTE.134949.1 : Release 11.0.3 and Oracle 8i Release 8.1.6 Interoperability
NOTE.342332.1 : Troubleshooting Login Problems in Oracle Applications 11i
NOTE.189256.1 : UNIX : Script to Verify Installation Requirements for Oracle
NOTE.296559.1 : FAQ : Common Tracing Techniques within the Oracle
NOTE.177183.1 : Succesfully Installing NLS/MLS in 11i
NOTE.73352.1 : NLS/MLS Frequently Asked Questions
NOTE.399789.1 : NLS Frequently Asked Questions
NOTE.339664.1 : Analyst Crib Sheet for NLS/MLS issues in Oracle
NOTE.227331.1 : Setting NLS Parameters - Frequently Asked Questions
NOTE.110849.1 : Installing and Relinking Oracle Developer on UNIX Platforms
NOTE.76535.1 : Troubleshooting Issues Which Arise During the Application of Release 11 Patches
NOTE.316804.1 : Oracle Applications NLS Release Notes, Release 11i (11.5.10.
NOTE.287176.1 : DMZ Configuration with Oracle E-Business Suite 11i
NOTE.310840.1 : AFPCAL Received Failure Code While Parsing or Running
NOTE.371434.1 : Using Openfiler iSCSI with an Oracle database
NOTE.233040.1 : When Oracle Applications Automatic Patch Prerequisite
NOTE.236469.1 : Using Distributed AD in Applications Release 11.5.
NOTE.233043.1 : 11.5.9 Oracle E-Business Suite Consolidated Update 2
NOTE.108185.1 : Oracle Applications Object Library SQL scripts
NOTE.201662.1 : How To Manually Relink on Windows NT or Windows 2000
NOTE.306906.1 : How to create missing DB objects from xdf files
NOTE.396708.1 : Guidelines to Determine whether a Bug or SR is a LinuxOS
NOTE.166762.1 : Oracle Applications Manager 11i Availability
NOTE.60966.1 : Getting Rid Of Those Pesky Invalid Objects In Oracle
NOTE.216589.1 : Step By Step Guide to Creating a Custom Application in
NOTE.105127.1 : FAQ (Customization)
NOTE.243880.1 : Shared APPL_TOP FAQ
NOTE.409045.1 : How to clone from Rac to Non-rac in Oracle Applications 11i.
NOTE.373611.1 : How to move Concurrent Processing Server from one node to
NOTE.342442.1 : Cloning Multi-Node to Single-Node Oracle Applications
NOTE.261428.1 : Setting up 11i E-Business suite using a hardware load
NOTE.224875.1 : Installation, Patching & Upgrade Frequently Asked Questions
NOTE.278816.1 : How to Setup Parallel Concurrent Processing using Shared
NOTE.286506.1 : Sharing Middle-tier Oracle Home in E-Business Suite 11i
NOTE.105133.1 : Concurrent Manager Questions and Answers Relating to
NOTE.69336.1 : Basic information about Concurrent Managers
NOTE.169706.1 : Oracle Database on AIX,HP-UX,Linux,MacOSX,Solaris,Tru64
NOTE.345145.1 : Is There A Way To Automate The Prompts For Adcfgclone.Pl?
*********************************************************************
NOTE.416338.1 : How To Upgrade JDK / J2SE 1.4 Sub-Versions
NOTE.225165.1 : Patching Best Practices and Reducing Downtime
NOTE.368628.1 : Is The 'Personal Home Page' Mode Supported In Oracle 11i Applications?
NOTE.387859.1 : Using AutoConfig to Manage System Configurations in Oracle
NOTE.402306.1 : Oracle Applications Installation and Upgrade Notes Release
NOTE.160214.1 : How to change the oracle users, APPS, APPLSYS and
NOTE.159244.1 : How To Use FNDCPASS to Change The Oracle Users, APPS,
NOTE.335515.1 : Relink fails for Oracle 9.2.0.7.0 on LINUX x86 server on
NOTE.372800.1 : How to Implement an SSL CA Root Certificate in JInitiator
NOTE.402312.1 : Oracle Applications Installation and Upgrade Notes Release
NOTE.394692.1 : Oracle Applications Documentation Resources, Release 12
NOTE.603104.1 : Troubleshooting RapidClone issues with Oracle Applications R12
NOTE.384248.1 : Sharing The Application Tier File System in Oracle E-Business Suite Release 12
NOTE.388577.1 : Configuring Oracle Applications Release 12 with 10g R2 RAC
NOTE.559518.1 : Cloning Oracle Applications Release 12 with Rapid Clone on RAC Enabled Systems
NOTE.393861.1 : Globalization Guide for Oracle Applications Release 12
NOTE.372800.1 : How to Implement an SSL CA Root Certificate in JInitiator
NOTE.184876.1 : Oracle Application Object Library Middle (Web) Tier Setup
NOTE.403385.1 : Duplicate Responsibilities Created On Sysadmin Login And
NOTE.380483.1 : Oracle E-Business Suite Release 12 Additional Configuration
NOTE.148903.1 : Interoperability Notes Oracle Applications Release 11i with
NOTE.364704.1 : A Guide to Configure, Maintain & Troubleshoot JDBC Buffers
NOTE.148902.1 : Interoperability Notes Oracle Applications Release 11.0
NOTE.337762.1 : How to Remove an Oracle Applications 11i node
NOTE.399362.1 : Oracle Applications Release 12 Upgrade Sizing and Best
NOTE.104457.1 : Invalid Objects In Oracle Applications FAQs
NOTE.132604.1 : Upgrading OJSP with Oracle Applications 11i
NOTE.215268.1 : Implementing and Using the JSP Precompiler
NOTE.316900.1 : ALERT : Oracle 10g Release 2 (10.2) Support Status and Alerts
NOTE.189908.1 : ALERT : Oracle9i Release 2 (9.2) Support Status and Alerts
NOTE.380490.1 : Oracle E-Business Suite R12 Configuration in a DMZ
NOTE.269291.1 : Oracle Applications Tablespace Migration Utility User
NOTE.206511.1 : How to Find a JAR File Which Contains a Particular JAVA
NOTE.406982.1 : Cloning Oracle Applications Release 12 with Rapid Clone
NOTE.262125.1 : Sun.io.MalformedInputException For OraSCV.asc,emreadme.txt,
NOTE.419839.1 : How to enable Apache, OC4J and OPMN logging in Oracle
NOTE.422419.1 : How To Enable and Collect Debug for HTTP, OC4J and OPMN in
NOTE.15390.1 : How to Determine and Change DB_NAME or ORACLE_SID
NOTE.375682.1 : About Oracle Applications Technology ATG_PF.H Rollup 5
NOTE.135715.1. : Diagnostic Steps for Intermittent FRM-99999 & FRM-92100
NOTE.185489.1 : Setting Up Parallel Concurrent Processing On Unix Server
NOTE.431496.1 : Java In The Database For Oracle Applications : Introduction
NOTE.183408.1 : Raw Devices and Cluster Filesystems With Real Application
NOTE.277366.1 : Technology Validation Utility for Oracle Applications
NOTE.394448.1 : Getting Started with the Application Management Pack for
NOTE.412044.1 : Application Management Pack for Oracle E-Business Suite
NOTE.375113.1 : Oracle Diagnostics 2.4
NOTE.405425.1 : Oracle Diagnostics 2.5
NOTE.201340.1 : Using Forms Listener Servlet with Oracle Applications 11i
NOTE.160337.1 : How To Manually Change The APPS, APPLSYS and APPLSYSPUB
NOTE.372322.1 : HP Tru64 UNIX Migration Strategy for Oracle E-Business
NOTE.303709.1 : Reclaiming unused space in APPLSYSD tablespace
NOTE.130183.1 : How to Get Log Files from Various Programs for Oracle
NOTE.269129.1 : How to Implement Printing for Oracle Applications : Getting
NOTE.297522.1 : How to investigate printing issues and work towards its resolution ?
NOTE.215527.1 : Maintenance Wizard Overview
NOTE.452120.1 : How to locate the log files and troubleshoot RapidWiz for
NOTE.312640.1 : Oracle Text : Re-installation of Applications 11i (11.5.10)
**************
*** iSetup ***
**************
NOTE.402785.1 : iSetup dependency with Deinstall and Reinstall of XMLDB
NOTE.368670.1 : About Oracle iSetup Minipack 11i.AZ.H
NOTE.243554.1 : How to Deinstall and Reinstall XML Database (XDB)
NOTE.244523.1 : Security Alert #57 : Buffer Overflows in EXTPROC of Oracle
NOTE.433435.1 : Japanese characters are displayed like square boxes in
NOTE.455366.1 : Investigating NoClassDefFoundError in eBusiness 11i when
NOTE.197409.1 : Error Opening Oracle*Terminal File fmrweb.res
NOTE.312553.1 : How To Use the Original Forms for Reprint Instead of the
NOTE.438086.1 : Platform Migration with Oracle Applications Release 12
NOTE.458452.1 : Complying with Daylight Saving Time (DST) and Time Zone
NOTE.189367.1 : Best Practices for Securing the E-Business Suite
NOTE.300969.1 : Troubleshooting SSL with Oracle Applications 11i
NOTE.444524.1 : About Oracle Applications Technology ATG_PF.H Rollup 6
NOTE.265253.1 : 10g Recyclebin Features And How To Disable it( _recyclebin )
NOTE.428262.1 : How to identify the form name attached to an f60webmx
NOTE.68839.1 : 8i Using loadjava and dropjava to Load and Unload Java
NOTE.405521.1 : Oracle Enterprise Manager Grid Control Release Notes for
NOTE.187905.1 : bde_imt_index_status.sql - List all interMedia Text indexes
NOTE.388577.1 : Configuring Oracle Applications Release 12 with 10g R2 RAC
NOTE.345106.1 : Login Links On New Rapid Install Homepage Do Not Function
NOTE.443521.1 : Enterprise Manager Grid Control Plug-in for Oracle Applications, Version 1.0/1.2
NOTE.398412.1 : Workflow Queues Creation Scripts
NOTE.77483.1 : External Support FTP site : Information Sheet
NOTE.122452.1 : Global Customer Services Policy Regarding Customizations
NOTE.257911.1 : How To Use Rotatelogs In 9iAS Release 1 (1.0.2.x)
NOTE.276845.1 : Apache Web Server Hangs Every Other Time Running Adapcctl.
NOTE.218893.1 : How to Create The Service Manager 'FNDSM' on Oracle
NOTE.437878.1 : Upgrading Forms and Reports 10g in Oracle Applications
NOTE.290807.1 : Upgrading Sun JRE with Oracle Applications 11i
NOTE.280167.1 : AS10g with Apps 11i - Summary of Login process
NOTE.357218.1 : Troubleshooting JDeveloper setup for Oracle Applications
NOTE.403339.1 : Oracle 10gR2 Database Preparation Guidelines for an E-Business Suite Release 12 Upgrade
NOTE.463249.1 : After Clone Forms Is Trying To Connect To Target Instance
NOTE.386374.1 : How to enable/disable/change password of the listeners for Oracle Applications 11i
NOTE.454750.1 : Oracle Apps Release 12 with Oracle Database 10.2.0 interoperability notes
NOTE.428503.1 : Integrating Oracle E-Business Suite Release 11i with Oracle Database Vault 10.2.0.3
NOTE.443761.1 : How to check if a certain Patch was applied to Oracle Applications instance using 'adpatch'?
NOTE.291783.1 : Getting Started with the Oracle Grid Control Plug-in for Oracle Applications in Release 11i (AMP v1)
NOTE.468980.1 : How to Remove the Language Icons in the AppsLocalLogin.jsp
NOTE.398619.1 : Clone Oracle Applications 11i using Oracle Application Manager (OAM Clone)
NOTE.295606.1 : Oracle Application Server 10g with Oracle E-Business Suite Release 11i Troubleshooting
NOTE.169706.1 : Oracle® Database on AIX®,HP-UX®,Linux®,Mac OS® X,
Solaris®,Tru64 Unix® Operating Systems Installation and
Configuration Requirements Quick Reference (8.0.5 to 11.1)
NOTE.109665.1 : Organization Setup Frequently Asked Questions - FAQ
NOTE.434395.1 : ATG Service Request Creation
NOTE.438086.1 : Platform Migration with Oracle Applications Release 12
NOTE.469213.1 : How To Encrypt The Apps Password In Wdbsvr.App
NOTE.293369.1 : OPatch documentation list
NOTE.275379.1 : Script To Check What Workflow Related Patches Are Installed
NOTE.388577.1 : Configuring Oracle Applications Release 12 with 10g R2 RAC
NOTE.264157.1 : The correct NLS_LANG setting in Unix Environments
NOTE.91985.1 : Step by Step on Cloning the ORACLE_HOME (Including DB) and
NOTE.74838.1 : Migrating Apps Release 11.0 from UNIX Host To A Second
NOTE.396009.1 : Database Initialization Parameters for Oracle Applications Release 12
NOTE.391406.1 : How to get a clean Autoconfig Environment
NOTE.560719.1 : How to troubleshoot iSetup issues
NOTE.406376.1 : Oracle E-Business Tax Release 12 Known Issues
NOTE.577713.1 : On Windows, After 10g Upgrade, Running Autoconfig on Apps
NOTE.343917.1 : Frequently Asked Questions : Oracle E-Business Suite Support
NOTE.553831.1 : java.lang.ArrayIndexOutOfBoundsException Error when
NOTE.119319.1 : How to Replace Oracle Logo with Company Logo on Applications 11i Sign-On Screen
NOTE.554336.1 : How Do You Manually Generate A Form In Release 12 (frmcmp)
NOTE.444286.1 : How to manually generate a R12 report on Unix
NOTE.356433.1 : Using Oracle Applications Release 11i with Virtual Hostnames and Business Continuity
NOTE.555081.1 : Concurrent Manager Does Not Start if the Profile Option "Concurrent : GSM Enabled" is Set "Y" at Site Level
NOTE.149124.1 : Creating a StatsPack performance report
NOTE.471566.1 : Migrating Oracle E-Business Suite R12 from Linux 32-bit to Linux 64-bit
NOTE.397757.1 : How to Speed Up Index Creation on FND_LOBS by indexing Only FND_HELP Data
NOTE.375127.1 : How to restart the adworker having status fixed,restart,wait
NOTE.353150.1 : OPatch Failing Validation Phase When Archiving Really Did Not Fail
NOTE.215527.1 : Maintenance Wizard Overview
NOTE.564465.1 : Sysadmin And User Responsibility Not Available
NOTE.219968.1 : SQL*Net, Net8, Oracle Net Services - Tracing and Logging at a Glance
NOTE.417122.1 : Resolving the Library Cache Locks
NOTE.419475.1 : Removing Credentials from a Cloned EBS Production Database

Metalink Important Note IDs

1. How to run OATM migration utility ---- Note:404954.1

2. 11.5.10 Oracle E-Business Suite Consolidated Update 2 (CU2)---- Note:316366.1

3. Upgrading Oracle Applications ---- Note:289788.1

4. E-Business Suite Diagnostics Patch Installation Guide ---- Note:167000.1

5. Step by Step Troubleshooting Guide to Solve APPS Invalid Objects ---- Note:113947.1

6. Compatibility Matrix for Export And Import Between Different Oracle Versions ----Note:132904.1

7. ORA-06550 Running Sys.Utl_recomp.Recomp_parallel(1) During ADPATCH or ADADMIN Session ---- Note:362727.1

8. Now Available: Oracle E-Business Suite Release 12.0.4 ---- Note:556312.1

9. Cloning Oracle Applications Release 11i with Rapid Clone ---- Note:230672.1

10.Upgrading Developer 6i with Oracle Applications 11i ---- Note:125767.1

11.The Basics About Report Review Agent (FNDFS) on 11i ---- Note:111383.1

12.How To Use FNDCPASS to Change The Oracle Users, APPS, APPLSYS and Application Module Passwords (INV, AR, AP, etc.) For Applications 11.5 in Unix ---- Note:159244.1

13.USAGE OF INDIA LOCALIZATION PATCH TOOL (INDPATCH) ---- Note:376756.1

14.Sharing the Application Tier File System in Oracle Applications 11i ----Note:233428.1

15.Shared APPL_TOP FAQ ---- Note:243880.1

16.Using a Staged Applications 11i System to Reduce Patching Downtime ---- Note:242480.1

17.Summary of Possible Reasons and Solutions for the Problem Where All Concurrent Requests Stuck in Pending Phase ---- Note:182154.1

18.Release 11i Adpatch Basics ---- Note:181665.1

19.How to Apply an 11i Patch When adpatch is Already Running ---- Note:175485.1

20.How to Create a Custom Concurrent Manager ---- Note:170524.1

21.Concurrent Manager Questions and Answers Relating to Generic Platform ----Note:105133.1

22.E-Business Suite Diagnostics Patch Installation Guide ---- Note:167000.1

After Change GRC Admin User password Update PEA.PROPERTIES in ERP Database R12

   
To implement the solution, follow these steps:

If EBS had PEA installed earlier and working fine before installing/upgrading after which issue is showing up then do step 1 and 2 otherwise go directly to step 3.

1. Login to EBS database server and go to previous PEA stage location.

2. Run following to drop previous java files footprint, make sure to replace value of x with actual value:

Run this command from OS Prompt.

cd /home/oracle/grc2/grc866

dropjava -user apps/password -force -verbose -resolve lib/grc-encryption-8.6.6.1-SNAPSHOT.jar
dropjava -user apps/password -force -verbose -resolve lib/grc-peacommon-8.6.6.1-SNAPSHOT.jar
dropjava -user apps/password -force -verbose -resolve lib/grc-peaebs-8.6.6.1-SNAPSHOT.jar

3. Go to latest PEA stage location.

4. Run following to drop latest java files footprint, make sure to replace value of x with actual value:

dropjava -user apps/password -force -verbose -resolve grcc.properties
dropjava -user apps/password -force -verbose -resolve pea.properties

5. Run following to reinstall java part of latest PEA:

a. Update the install.properities file with correct values.

like apps user password and other required user password.

b. Run following:

Execute the following commands. These commands should not error out:

Run those command first for removing old password.

conn sqlplus / as sysdba - and run below command.


SQL> call dbms_java.dropjava('-verbose com/oracle/grcc/pea/common/PEAProperties.class');

Call completed.

SQL> call dbms_java.dropjava('-verbose pea.properties.class');

Call completed.

SQL> call dbms_java.dropjava('-verbose grcc.properties.class');

Call completed.

SQL>

c. Set the DB environment of APPS (the Oracle EBS database) and execute the installation program:

java -jar grc-peainstallation-8.6.6.1-SNAPSHOT.jar -ebs -manual

This parameter use for test server.
===========================================================
Take this information for providing run time parameter values
=============================================================
The installation program prompts for property values required by the PEA:

• Enter GRCC user name
If you created a wsclient user on your GRC instance, supply the value wsclient here. If not, supply the user name configured for admin user.

• Enter GRCC password
Enter the password for the user identified in the previous property.

• Enter GRCC server name
Supply the fully qualified server name of the server on which GRC is installed. To verify, ping the GRC server from the server where the PEA is being installed.

• Enter GRCC port number
Supply the port number at which the GRC server communicates with other applications.

• Enter GRCC web services URL
This property specifies the URL of the webservice where the GRC instance is installed. This URL should be /grc/services/GrcService/

• Enter GRCC web services timeout
Enter a timeout, in seconds, for communication with the Oracle EBS server. The default value is 60.

• Enter datasource ID
Supply the datasource ID assigned by GRC to the Oracle EBS instance in which you are installing the PEA. (This value is available in the GRC Manage Application Datasources page; see “Determining Datasource IDs,” page 4-7).

After you enter the datasource ID, the installation program presents the prompt, “Connect to GRC server using SSL? (Yes/No).”
• If you select No, PEA installation proceeds without support for SSL.

• If you select Yes, the installation program prompts for an SSL truststore name and an SSL truststore password. Enter the values you created as you ran the keytool command (see “PEAs and SSL” on page 6-1).

d. Run following:

loadjava -user apps/password -force -verbose -resolve lib/grc-encryption-8.6.6.1-SNAPSHOT.jar
loadjava -user apps/password -force -verbose -resolve lib/grc-peacommon-8.6.6.1-SNAPSHOT.jar
loadjava -user apps/password -force -verbose -resolve lib/grc-peaebs-8.6.6.1-SNAPSHOT.jar

e. Run following:

loadjava -user apps/password -force -verbose -resolve grcc.properties
loadjava -user apps/password -force -verbose -resolve pea.properties

6. Bounce the EBS and GRC Application server.

7. Retest the issue.

After Complete this steps. need compile invalied objects..

Bounce is not Required.

How to Apply Patch in Weblogi 10.3.6 Version.

Weblogic Patch Steps
============================

Patch Apply Stesp
=====================================

Patch - p26519424_1036_Generic.zip

1.Login the Weblogic server.

2.Stop application services.

3.Create cache directory in below location.

Location :/-------/----/Middleware/utils/bsu

Directory Name:- cache_dir

4.Copy pacth in below location and unzip patch.

/-------/----/Middleware/utils/bsu/cache_dir

5.Go to below location and run below command to apply patch.

Location :- /-------/----/Middleware/utils/bsu

Command for apply patch:-

./bsu.sh -install -patch_download_dir=/-------/----/Middleware/utils/bsu/cache_dir -patchlist=FMJJ -prod_dir=/-------/----/Middleware/wlserver_10.3


Verifay patch is applied or not.
======================================

1.Login Application node.

2. Go to below location and run the below commmand.

Location:- /-------/----/Middleware/utils/bsu

Command :- ./bsu.sh -report



If patch is faild the roolback using this steps.
======================================

1.Login application node.

2. Go to below location and run below command.

Location:- /-------/----/Middleware/utils/bsu

Command :- ./bsu.sh -remove -patchlist=FMJJ -prod_dir=/-------/----/Middleware/wlserver_10.3/

Oracle Apps R12 cloning online hotbackup/rman

In this article i will illustrate all steps involved in cloning an Oracle E-Business suite environment using online backup.

There are other ways also to do a clone of database with online backup. But in this article I am illustrating rman database cloning with nocatalog option.

- Database will be backed up using rman
- Application File system will be backed up when all services are up and running.

source system - Existing system for which you want to create a new copy
target system - New system on which clone is prepared

Source and target OS  - oracle solaris 10 - sparc 64-bit
Application Version - R12.1.1
Database Version  - 11.1.0.7

High Level Steps:

1. Install all required rapid clone patches from Note "406982.1" on source system if doesn't exists.
2. Run clone preparation script (adpreclone.pl) on database and application Tier
3. Perform full database backup using rman
4. Perform application file system backup using tar/backup tool
5. Copy RDBMS ORACLE_HOME, rman backup pieces and Application FS on target node
6. Create database context file using clone configuration script (adcfgclone.pl)
7. Restore and recover database using rman
8. Run autoconfig on target database node
9. Run clone configuration script on application Tier on targte node. 
10. perform post clone steps

Source System Application dash board:

Source and Target system Information:

check pre-req patches on source system:

- Perform all OS pre-requisites on target system (OS packages, users, groups, kernel parameters, Display, File system privileges and space requirements)

For LINUX refer section "Perform all operating system per-requisites":
http://appsdbaworkshop.blogspot.com/2011/11/installation-of-oracle-applications.html

For Solaris  refer:
http://appsdbaworkshop.blogspot.com/2010/11/oracle-applications-r1211-installation.html

SQL> select BUG_ID, BUG_NUMBER from ad_bugs where bug_number='&num';
Enter value for num: 9239089
old   1: select BUG_ID, BUG_NUMBER from ad_bugs where bug_number='&num'
new   1: select BUG_ID, BUG_NUMBER from ad_bugs where bug_number='9239089'

    BUG_ID BUG_NUMBER
---------- ------------------------------
    374712 9239089

SQL> /
Enter value for num: 9171651
old   1: select BUG_ID, BUG_NUMBER from ad_bugs where bug_number='&num'
new   1: select BUG_ID, BUG_NUMBER from ad_bugs where bug_number='9171651'

    BUG_ID BUG_NUMBER
---------- ------------------------------
    375423 9171651

SQL> /
Enter value for num: 9833058
old   1: select BUG_ID, BUG_NUMBER from ad_bugs where bug_number='&num'
new   1: select BUG_ID, BUG_NUMBER from ad_bugs where bug_number='9833058'

    BUG_ID BUG_NUMBER
---------- ------------------------------
    375424 9833058

SQL> /
Enter value for num: 12404574
old   1: select BUG_ID, BUG_NUMBER from ad_bugs where bug_number='&num'
new   1: select BUG_ID, BUG_NUMBER from ad_bugs where bug_number='12404574'

    BUG_ID BUG_NUMBER
---------- ------------------------------
    375421 12404574

SQL> /
Enter value for num: 12598630
old   1: select BUG_ID, BUG_NUMBER from ad_bugs where bug_number='&num'
new   1: select BUG_ID, BUG_NUMBER from ad_bugs where bug_number='12598630'

    BUG_ID BUG_NUMBER
---------- ------------------------------
    375422 12598630


Run clone preparation script (adpreclone.pl) on database Tier:
 

bash-3.00$ adpreclone.pl dbTier

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adpreclone Version 120.20.12010000.5

Enter the APPS User Password:
Running:
perl
 /data/R12_ERP/db/tech_st/11.1.0/appsutil/bin/adclone.pl 
java=/data/R12_ERP/db/tech_st/11.1.0/appsutil/jre mode=stage 
stage=/data/R12_ERP/db/tech_st/11.1.0/appsutil/clone component=dbTier 
method=CUSTOM 
dbctx=/data/R12_ERP/db/tech_st/11.1.0/appsutil/ERPTEST_devdb.xml 
showProgress
APPS Password :

Beginning database tier Stage - Sun Feb  3 11:45:39 2013

/data/R12_ERP/db/tech_st/11.1.0/appsutil/jre/bin/java
 -Xmx600M -DCONTEXT_VALIDATED=false  
-Doracle.installer.oui_loc=/data/R12_ERP/db/tech_st/11.1.0/oui 
-classpath 
/data/R12_ERP/db/tech_st/11.1.0/lib/xmlparserv2.jar:/data/R12_ERP/db/tech_st/11.1.0/jdbc/lib/ojdbc6.jar:/data/R12_ERP/db/tech_st/11.1.0/appsutil/java:/data/R12_ERP/db/tech_st/11.1.0/oui/jlib/OraInstaller.jar:/data/R12_ERP/db/tech_st/11.1.0/oui/jlib/ewt3.jar:/data/R12_ERP/db/tech_st/11.1.0/oui/jlib/share.jar:/data/R12_ERP/db/tech_st/11.1.0/oui/jlib/srvm.jar:/data/R12_ERP/db/tech_st/11.1.0/jlib/ojmisc.jar  
 oracle.apps.ad.clone.StageDBTier -e 
/data/R12_ERP/db/tech_st/11.1.0/appsutil/ERPTEST_devdb.xml -stage 
/data/R12_ERP/db/tech_st/11.1.0/appsutil/clone -tmp /tmp -method 
CUSTOM    -showProgress
APPS Password :
Log file located at /data/R12_ERP/db/tech_st/11.1.0/appsutil/log/ERPTEST_devdb/StageDBTier_02031145.log

  -     50% completed

Completed Stage...
Sun Feb  3 11:48:10 2013
bash-3.00$


 Run clone preparation script (adpreclone.pl) on Application Tier:

bash-3.00$ adopmnctl.sh status

You are running adopmnctl.sh version 120.6.12010000.4

Checking status of OPMN managed processes...

Processes in Instance: ERPTEST_devappl.devaappl.orasol.com
---------------------------------+--------------------+---------+---------
ias-component                    | process-type       |     pid | status
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group          | OC4J:oafm          |   28611 | Alive
OC4JGroup:default_group          | OC4J:forms         |   28580 | Alive
OC4JGroup:default_group          | OC4J:oacore        |   28503 | Alive
HTTP_Server                      | HTTP_Server        |   28450 | Alive


adopmnctl.sh: exiting with status 0

adopmnctl.sh:
 check the logfile 
/appl/R12_ERP/inst/apps/ERPTEST_devappl/logs/appl/admin/log/adopmnctl.txt
 for more information ...

bash-3.00$ adpreclone.pl appsTier

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adpreclone Version 120.20.12010000.5

Running:
perl
 /appl/R12_ERP/apps/apps_st/appl/ad/12.0.0/bin/adclone.pl 
java=/appl/R12_ERP/apps/tech_st/10.1.3/appsutil/jdk mode=stage 
stage=/appl/R12_ERP/apps/apps_st/comn/clone component=appsTier method= 
appctx=/appl/R12_ERP/inst/apps/ERPTEST_devappl/appl/admin/ERPTEST_devappl.xml
 showProgress
APPS Password :
method defaulted to CUSTOM


Beginning application tier Stage - Sun Feb  3 11:54:33 2013

/appl/R12_ERP/apps/tech_st/10.1.3/appsutil/jdk/bin/java
 -Xmx600M -DCONTEXT_VALIDATED=false  -Doracle.installer.oui_loc=/oui 
-classpath 
/appl/R12_ERP/apps/tech_st/10.1.3/lib/xmlparserv2.jar:/appl/R12_ERP/apps/tech_st/10.1.3/jdbc/lib/ojdbc14.jar:/appl/R12_ERP/apps/apps_st/comn/java/classes:/appl/R12_ERP/apps/tech_st/10.1.3/oui/jlib/OraInstaller.jar:/appl/R12_ERP/apps/tech_st/10.1.3/oui/jlib/ewt3.jar:/appl/R12_ERP/apps/tech_st/10.1.3/oui/jlib/share.jar:/appl/R12_ERP/apps/tech_st/10.1.3/oui/jlib/srvm.jar:/appl/R12_ERP/apps/tech_st/10.1.3/jlib/ojmisc.jar 
 oracle.apps.ad.clone.StageAppsTier -e 
/appl/R12_ERP/inst/apps/ERPTEST_devappl/appl/admin/ERPTEST_devappl.xml 
-stage /appl/R12_ERP/apps/apps_st/comn/clone -tmp /tmp -method CUSTOM   
-showProgress

Log file located at /appl/R12_ERP/inst/apps/ERPTEST_devappl/admin/log/StageAppsTier_02031154.log

  \     80% completed

Completed Stage...
Sun Feb  3 11:57:14 2013

 Perform full database RMAN backup:

bash-3.00$ rman target /

Recovery Manager: Release 11.1.0.7.0 - Production on Sun Feb 3 12:05:35 2013

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: ERPTEST (DBID=1262470248)

RMAN> RUN {
2> configure controlfile autobackup format for device type diks to '/data/R12_ERP/rman_backup/3feb2013_Bkp/%F';
3> configure controlfile autobackup on;
4> allocate channel d1 type disk;
5> backup tag FULL_DB database plus archivelog format '/data/R12_ERP/rman_backup/3feb2013_Bkp/db_%t_%s.bkp';
6> release channel d1;
7> }

new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'DIKS' TO '/data/R12_ERP/rman_backup/3feb2013_Bkp/%F';
new RMAN configuration parameters are successfully stored

new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored

allocated channel: d1
channel d1: SID=359 device type=DISK


Starting backup at 03-FEB-13
current log archived
channel d1: starting archived log backup set
channel d1: specifying archived log(s) in backup set
input archived log thread=1 sequence=22 RECID=1 STAMP=805281948
input archived log thread=1 sequence=23 RECID=2 STAMP=805282565
input archived log thread=1 sequence=24 RECID=3 STAMP=806418436
channel d1: starting piece 1 at 03-FEB-13
channel d1: finished piece 1 at 03-FEB-13
piece handle=/data/R12_ERP/rman_backup/3feb2013_Bkp/db_806418437_7.bkp tag=FULL_DB comment=NONE
channel d1: backup set complete, elapsed time: 00:00:25
Finished backup at 03-FEB-13

Starting backup at 03-FEB-13
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00023 name=/data/R12_ERP/db/apps_st/data/a_txn_data02.dbf
input datafile file number=00025 name=/data/R12_ERP/db/apps_st/data/a_txn_ind01.dbf
input datafile file number=00022 name=/data/R12_ERP/db/apps_st/data/a_txn_data01.dbf
input datafile file number=00024 name=/data/R12_ERP/db/apps_st/data/a_txn_data03.dbf
input datafile file number=00026 name=/data/R12_ERP/db/apps_st/data/a_txn_ind02.dbf
input datafile file number=00027 name=/data/R12_ERP/db/apps_st/data/a_txn_ind03.dbf
input datafile file number=00029 name=/data/R12_ERP/db/apps_st/data/a_txn_ind05.dbf
input datafile file number=00012 name=/data/R12_ERP/db/apps_st/data/undo01.dbf
input datafile file number=00028 name=/data/R12_ERP/db/apps_st/data/a_txn_ind04.dbf
input datafile file number=00009 name=/data/R12_ERP/db/apps_st/data/system09.dbf
input datafile file number=00008 name=/data/R12_ERP/db/apps_st/data/system08.dbf
input datafile file number=00020 name=/data/R12_ERP/db/apps_st/data/a_ref02.dbf
input datafile file number=00019 name=/data/R12_ERP/db/apps_st/data/a_ref01.dbf
input datafile file number=00015 name=/data/R12_ERP/db/apps_st/data/a_media01.dbf
input datafile file number=00006 name=/data/R12_ERP/db/apps_st/data/system06.dbf
input datafile file number=00014 name=/data/R12_ERP/db/apps_st/data/a_int01.dbf
input datafile file number=00021 name=/data/R12_ERP/db/apps_st/data/a_summ01.dbf
input datafile file number=00004 name=/data/R12_ERP/db/apps_st/data/system04.dbf
input datafile file number=00010 name=/data/R12_ERP/db/apps_st/data/system10.dbf
input datafile file number=00002 name=/data/R12_ERP/db/apps_st/data/system02.dbf
input datafile file number=00003 name=/data/R12_ERP/db/apps_st/data/system03.dbf
input datafile file number=00001 name=/data/R12_ERP/db/apps_st/data/system01.dbf
input datafile file number=00005 name=/data/R12_ERP/db/apps_st/data/system05.dbf
input datafile file number=00011 name=/data/R12_ERP/db/apps_st/data/system11.dbf
input datafile file number=00007 name=/data/R12_ERP/db/apps_st/data/system07.dbf
input datafile file number=00013 name=/data/R12_ERP/db/apps_st/data/a_archive01.dbf
input datafile file number=00038 name=/data/R12_ERP/db/apps_st/data/a_txn_data4.dbf
input datafile file number=00017 name=/data/R12_ERP/db/apps_st/data/a_queue01.dbf
input datafile file number=00018 name=/data/R12_ERP/db/apps_st/data/a_queue02.dbf
input datafile file number=00036 name=/data/R12_ERP/db/apps_st/data/apps_ts_tools01.dbf
input datafile file number=00035 name=/data/R12_ERP/db/apps_st/data/sysaux01.dbf
input datafile file number=00037 name=/data/R12_ERP/db/apps_st/data/interim.dbf
input datafile file number=00031 name=/data/R12_ERP/db/apps_st/data/odm.dbf
input datafile file number=00032 name=/data/R12_ERP/db/apps_st/data/olap.dbf
input datafile file number=00034 name=/data/R12_ERP/db/apps_st/data/portal01.dbf
input datafile file number=00016 name=/data/R12_ERP/db/apps_st/data/a_nolog01.dbf
input datafile file number=00030 name=/data/R12_ERP/db/apps_st/data/ctxd01.dbf
input datafile file number=00033 name=/data/R12_ERP/db/apps_st/data/owad01.dbf
channel d1: starting piece 1 at 03-FEB-13
channel d1: finished piece 1 at 03-FEB-13
piece handle=/data/R12_ERP/db/tech_st/11.1.0/dbs/08o11u10_1_1 tag=FULL_DB comment=NONE
channel d1: backup set complete, elapsed time: 00:09:55
Finished backup at 03-FEB-13

Starting backup at 03-FEB-13
current log archived
channel d1: starting archived log backup set
channel d1: specifying archived log(s) in backup set
input archived log thread=1 sequence=25 RECID=4 STAMP=806419062
channel d1: starting piece 1 at 03-FEB-13
channel d1: finished piece 1 at 03-FEB-13
piece handle=/data/R12_ERP/rman_backup/3feb2013_Bkp/db_806419062_9.bkp tag=FULL_DB comment=NONE
channel d1: backup set complete, elapsed time: 00:00:01
Finished backup at 03-FEB-13

Starting Control File Autobackup at 03-FEB-13
piece handle=/data/R12_ERP/db/tech_st/11.1.0/dbs/c-1262470248-20130203-00 comment=NONE
Finished Control File Autobackup at 03-FEB-13

released channel: d1

RMAN>

Restore backup of database and application on Target Node:


- RDBMS Oracle Home

bash-3.00$ pwd
/data/R12_ERP/db
bash-3.00$ ls
apps_st     tech_stbash-3.00$ tar -cvf DbHome.tar tech_st




bash-3.00$ ls
DbHome.tar  apps_st     tech_st
bash-3.00$ scp DbHome.tar oraclone@testappl:/appl/ERP_CLONE/dbclone
The authenticity of host 'testappl (10.10.17.53)' can't be established.
RSA key fingerprint is 04:b2:6a:ac:28:90:12:45:cd:2c:a1:56:fe:cd:2b:a1.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'testappl,10.10.17.53' (RSA) to the list of known hosts.
Password:
DbHome.tar          
 100% 
|****************************************************************************************************|
 12370 MB    10:37
bash-3.00$

bash-3.00$ scp /data/R12_ERP/db/tech_st/11.1.0/dbs/c-1262470248-20130203-00 oraclone@testappl:/appl/rman_backup
Password:
c-1262470248-2013020 100% |************************************************************************************************
bash-3.00$ scp -r /data/R12_ERP/rman_backup/3feb2012_backup  oraclone@testappl:/appl/rman_backup
Password:
ERPTEST_DB_06o11r42_ 100% |************************************************************************************************
ERPTEST_DB_05o11qhe_ 100% |************************************************************************************************

 

- On Target Node testappl

bash-3.00$ pwd
/appl/ERP_CLONE/dbclone
bash-3.00$ tar -xvf DbHome.tar 

Running Clone Configuration script on database Tier using dbTechStack option:

bash-3.00$ pwd
/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/bin
bash-3.00$ ls
adcfgclone.pl  adchkutl.sh    adclone.pl     adclonectx.pl
bash-3.00$ export PATH=/usr/ccs/bin:/usr/bin:/usr/ucb:/etc:.
bash-3.00$ perl adcfgclone.pl dbTechStack

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adcfgclone Version 120.31.12010000.8

Enter the APPS password :

Running:
/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/bin/../jre/bin/java
 -Xmx600M -cp 
/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/jlib/java:/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/jlib/xmlparserv2.jar:/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/jlib/ojdbc5.jar
 oracle.apps.ad.context.CloneContext -e 
/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/bin/../context/db/CTXORIG.xml
 -validate -pairsfile /tmp/adpairsfile_1233.lst -stage 
/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone -dbTechStack 
2> /tmp/adcfgclone_1233.err; echo $? > 
/tmp/adcfgclone_1233.res

Log file located at /appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/bin/CloneContext_0204091224.log

Provide the values required for creation of the new Database Context file.

Target System Hostname (virtual or normal) [testappl] :

Target Instance is RAC (y/n) [n] :

Target System Database SID : CLONE

Target System Base Directory : /appl/ERP_CLONE/dbclone

Target System utl_file_dir Directory List : /usr/tmp

Number of DATA_TOP's on the Target System [1] :

Target System DATA_TOP Directory 1 [/data/R12_ERP/db/apps_st/data] : /appl/ERP_CLONE/dbclone/clone_data

Target System RDBMS ORACLE_HOME Directory [/appl/ERP_CLONE/dbclone/db/tech_st/11.1.0] : /appl/ERP_CLONE/dbclone/tech_st/11.1.0

Do you want to preserve the Display [null] (y/n)  : n

Target System Display [testappl:0.0] :

Do you want the the target system to have the same port values as the source system (y/n) [y] ? : n

Target System Port Pool [0-99] : 22

Checking the port pool 22
done: Port Pool 22 is free
Report file located at /appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/temp/portpool.lst
Complete port information available at /appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/temp/portpool.lst

Creating the new Database Context file from :
  /appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/template/adxdbctx.tmp

The new database context file has been created :
  /appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/CLONE_testappl.xml

Log file located at /appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/bin/CloneContext_0204091224.log
Check Clone Context logfile /appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/bin/CloneContext_0204091224.log for details.

Running Rapid Clone with command:
perl
 /appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/bin/adclone.pl 
java=/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/bin/../jre 
mode=apply stage=/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone 
component=dbTechStack method=CUSTOM 
dbctxtg=/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/CLONE_testappl.xml
 showProgress contextValidated=true
Running:
perl 
/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/bin/adclone.pl 
java=/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/bin/../jre 
mode=apply stage=/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone 
component=dbTechStack method=CUSTOM 
dbctxtg=/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/CLONE_testappl.xml
 showProgress contextValidated=true
APPS Password :

Beginning rdbms home Apply - Mon Feb  4 09:13:28 2013

/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/bin/../jre/bin/java
 -Xmx600M -DCONTEXT_VALIDATED=true  
-Doracle.installer.oui_loc=/appl/ERP_CLONE/dbclone/tech_st/11.1.0/oui 
-classpath 
/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/jlib/xmlparserv2.jar:/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/jlib/ojdbc6.jar:/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/jlib/java:/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/jlib/oui/OraInstaller.jar:/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/jlib/oui/ewt3.jar:/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/jlib/oui/share.jar:/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/jlib/oui/srvm.jar:/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/jlib/ojmisc.jar  
 oracle.apps.ad.clone.ApplyDBTechStack -e 
/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/CLONE_testappl.xml 
-stage /appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone   
-showProgress
APPS Password : Log file located at 
/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/log/CLONE_testappl/ApplyDBTechStack_02040913.log
  \      0% completed

Completed Apply...
Mon Feb  4 09:16:10 2013

Starting database listener for CLONE:
Running:
/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/scripts/CLONE_testappl/addlnctl.sh start CLONE
Logfile: /appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/log/CLONE_testappl/addlnctl.txt

You are running addlnctl.sh version 120.1.12010000.4


Starting listener process CLONE ...


LSNRCTL for Solaris: Version 11.1.0.7.0 - Production on 04-FEB-2013 09:16:10

Copyright (c) 1991, 2008, Oracle.  All rights reserved.

Starting /appl/ERP_CLONE/dbclone/tech_st/11.1.0/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 11.1.0.7.0 - Production
System parameter file is /appl/ERP_CLONE/dbclone/tech_st/11.1.0/network/admin/CLONE_testappl/listener.ora
Log messages written to /appl/ERP_CLONE/dbclone/tech_st/11.1.0/admin/CLONE_testappl/diag/tnslsnr/testappl/clone/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=testappl.orasol.com)(PORT=1543)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=testappl.orasol.com)(PORT=1543)))
STATUS of the LISTENER
------------------------
Alias                     CLONE
Version                   TNSLSNR for Solaris: Version 11.1.0.7.0 - Production
Start Date                04-FEB-2013 09:16:11
Uptime                    0 days 0 hr. 0 min. 4 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /appl/ERP_CLONE/dbclone/tech_st/11.1.0/network/admin/CLONE_testappl/listener.ora
Listener Log File         /appl/ERP_CLONE/dbclone/tech_st/11.1.0/admin/CLONE_testappl/diag/tnslsnr/testappl/clone/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=testappl.orasol.com)(PORT=1543)))
Services Summary...
Service "CLONE" has 1 instance(s).
  Instance "CLONE", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

addlnctl.sh: exiting with status 0

addlnctl.sh:
 check the logfile 
/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/log/CLONE_testappl/addlnctl.txt
 for more information ...

bash-3.00$

• Change ORACLE_SID to ERP test in newly created enviroment file

As we are not using catalog database from target we need to first restore and recover database using the same source SID. Later we can change it to required SID (CLONE) using "nid"

 bash-3.00$ ls -l *.env
-rw-r--r--   1 oraclone dbaclone    4382 Feb  4 09:29 CLONE_testappl.env
-rw-r--r--   1 oraclone dbaclone    4225 Jan 20 15:14 ERPTEST_devdb.env
bash-3.00$ pwd
/appl/ERP_CLONE/dbclone/tech_st/11.1.0
bash-3.00$

ORACLE_SID="ERPTEST"
export ORACLE_SID

#Original Value is CLONE, replaced for restore and recover of rman db

• copy initCLONE.ora to initERPTEST.ora
• Edit db_name to ERPTEST instead of clone in newly copied file and make sure location of control file

db_name                         = ERPTEST
control_files                   = /appl/ERP_CLONE/dbclone/clone_data/cntrl01.dbf

Restore and Recover database using rman on target Node:


- startup nomount

SQL> startup nomount
ORACLE instance started.

Total System Global Area 1069252608 bytes
Fixed Size                  2109352 bytes
Variable Size             427823192 bytes
Database Buffers          624951296 bytes
Redo Buffers               14368768 bytes
SQL> 

 
- List backup piece of controlfile on source system (devdb)

RMAN> list backup of controlfile;

using target database control file instead of recovery catalog

List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3       Full    40.27M     DISK        00:00:02     21-JAN-13
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20130121T092605
        Piece Name: /data/R12_ERP/rman_backup/ERPTEST_DB_03nvv8o3_3_1
  Control File Included: Ckp SCN: 77924707     Ckp time: 21-JAN-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6       Full    40.27M     DISK        00:00:03     03-FEB-13
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20130203T120813
        Piece Name: /data/R12_ERP/rman_backup/3feb2012_backup/ERPTEST_DB_06o11r42_6_1
  Control File Included: Ckp SCN: 78217166     Ckp time: 03-FEB-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
10      Full    40.27M     DISK        00:00:02     03-FEB-13
        BP Key: 10   Status: AVAILABLE  Compressed: NO  Tag: TAG20130203T131743
        Piece Name: /data/R12_ERP/db/tech_st/11.1.0/dbs/c-1262470248-20130203-00
  Control File Included: Ckp SCN: 78223859     Ckp time: 03-FEB-13

- Restore controlfile and mount database

 bash-3.00$ pwd
/appl/rman_backup/3feb2012_backup
bash-3.00$ ls -lrt
total 48953331
-rw-r-----   1 oraclone dbaclone 42237952 Feb  3 14:14 c-1262470248-20130203-00
-rw-r-----   1 oraclone dbaclone 42237952 Feb  3 14:15 ERPTEST_DB_06o11r42_6_1
-rw-r-----   1 oraclone dbaclone 24959320064 Feb  3 14:37 ERPTEST_DB_05o11qhe_5_1
bash-3.00$ pwd
/appl/rman_backup/3feb2012_backup
bash-3.00$ rman target / nocatalog

Recovery Manager: Release 11.1.0.7.0 - Production on Mon Feb 4 10:08:26 2013

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: ERPTEST (not mounted)
using target database control file instead of recovery catalog

RMAN> restore controlfile from '/appl/rman_backup/3feb2012_backup/c-1262470248-20130203-00';

Starting restore at 04-FEB-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=383 device type=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/appl/ERP_CLONE/dbclone/clone_data/cntrl01.dbf
Finished restore at 04-FEB-13
RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

 - Catalog backup Pieces ( not required if location of rman bkp same on target)

RMAN> catalog backuppiece '/appl/rman_backup/3feb2012_backup/ERPTEST_DB_06o11r42_6_1';

cataloged backup piece
backup piece handle=/appl/rman_backup/3feb2012_backup/ERPTEST_DB_06o11r42_6_1 RECID=10 STAMP=806494720

RMAN> catalog backuppiece '/appl/rman_backup/3feb2012_backup/ERPTEST_DB_05o11qhe_5_1';

cataloged backup piece
backup piece handle=/appl/rman_backup/3feb2012_backup/ERPTEST_DB_05o11qhe_5_1 RECID=11 STAMP=806494728

RMAN> catalog backuppiece '/appl/rman_backup/3feb2012_backup/db_806418437_7.bkp';

cataloged backup piece
backup piece handle=/appl/rman_backup/3feb2012_backup/db_806418437_7.bkp RECID=12 STAMP=806498596

RMAN>  catalog backuppiece '/appl/rman_backup/3feb2012_backup/db_806419062_9.bkp';

cataloged backup piece
backup piece handle=/appl/rman_backup/3feb2012_backup/db_806419062_9.bkp RECID=13 STAMP=806498610




- Prepare script for rman restore and run script (If target location is same "ste newname" not required)

bash-3.00$ cat rman_restore.sql
run  {
set newname for datafile 1 to '/appl/ERP_CLONE/dbclone/clone_data/system01.dbf';
set newname for datafile 2 to '/appl/ERP_CLONE/dbclone/clone_data/system02.dbf';
set newname for datafile 3 to '/appl/ERP_CLONE/dbclone/clone_data/system03.dbf';
set newname for datafile 4 to '/appl/ERP_CLONE/dbclone/clone_data/system04.dbf';
set newname for datafile 5 to '/appl/ERP_CLONE/dbclone/clone_data/system05.dbf';
set newname for datafile 6 to '/appl/ERP_CLONE/dbclone/clone_data/system06.dbf';
set newname for datafile 7 to '/appl/ERP_CLONE/dbclone/clone_data/system07.dbf';
set newname for datafile 8 to '/appl/ERP_CLONE/dbclone/clone_data/system08.dbf';
set newname for datafile 9 to '/appl/ERP_CLONE/dbclone/clone_data/system09.dbf';
set newname for datafile 10 to '/appl/ERP_CLONE/dbclone/clone_data/system10.dbf';
set newname for datafile 11 to '/appl/ERP_CLONE/dbclone/clone_data/system11.dbf';
set newname for datafile 12 to '/appl/ERP_CLONE/dbclone/clone_data/undo01.dbf';
set newname for datafile 13 to '/appl/ERP_CLONE/dbclone/clone_data/a_archive01.dbf';
set newname for datafile 14 to '/appl/ERP_CLONE/dbclone/clone_data/a_int01.dbf';
set newname for datafile 15 to '/appl/ERP_CLONE/dbclone/clone_data/a_media01.dbf';
set newname for datafile 16 to '/appl/ERP_CLONE/dbclone/clone_data/a_nolog01.dbf';
set newname for datafile 17 to '/appl/ERP_CLONE/dbclone/clone_data/a_queue01.dbf';
set newname for datafile 18 to '/appl/ERP_CLONE/dbclone/clone_data/a_queue02.dbf';
set newname for datafile 19 to '/appl/ERP_CLONE/dbclone/clone_data/a_ref01.dbf';
set newname for datafile 20 to '/appl/ERP_CLONE/dbclone/clone_data/a_ref02.dbf';
set newname for datafile 21 to '/appl/ERP_CLONE/dbclone/clone_data/a_summ01.dbf';
set newname for datafile 22 to '/appl/ERP_CLONE/dbclone/clone_data/a_txn_data101.dbf';
set newname for datafile 23 to '/appl/ERP_CLONE/dbclone/clone_data/a_txn_data102.dbf';
set newname for datafile 24 to '/appl/ERP_CLONE/dbclone/clone_data/a_txn_data103.dbf';
set newname for datafile 25 to '/appl/ERP_CLONE/dbclone/clone_data/a_txn_ind01.dbf';
set newname for datafile 26 to '/appl/ERP_CLONE/dbclone/clone_data/a_txn_ind02.dbf';
set newname for datafile 27 to '/appl/ERP_CLONE/dbclone/clone_data/a_txn_ind03.dbf';
set newname for datafile 28 to '/appl/ERP_CLONE/dbclone/clone_data/a_txn_ind04.dbf';
set newname for datafile 29 to '/appl/ERP_CLONE/dbclone/clone_data/a_txn_ind05.dbf';
set newname for datafile 30 to '/appl/ERP_CLONE/dbclone/clone_data/ctxd01.dbf';
set newname for datafile 31 to '/appl/ERP_CLONE/dbclone/clone_data/odm.dbf';
set newname for datafile 32 to '/appl/ERP_CLONE/dbclone/clone_data/olap.dbf';
set newname for datafile 33 to '/appl/ERP_CLONE/dbclone/clone_data/owad01.dbf';
set newname for datafile 34 to '/appl/ERP_CLONE/dbclone/clone_data/portal01.dbf';
set newname for datafile 35 to '/appl/ERP_CLONE/dbclone/clone_data/sysaux01.dbf';
set newname for datafile 36 to '/appl/ERP_CLONE/dbclone/clone_data/apps_ts_tools01.dbf';
set newname for datafile 37 to '/appl/ERP_CLONE/dbclone/clone_data/interim.dbf';
set newname for datafile 38 to '/appl/ERP_CLONE/dbclone/clone_data/a_txn_data14.dbf';
restore database;
switch datafile all; }
bash-3.00$ pwd
/export/home/oraclone

RMAN> @/export/home/oraclone/rman_restore.sql

RMAN> run  {
2> set newname for datafile 1 to '/appl/ERP_CLONE/dbclone/clone_data/system01.dbf';
3> set newname for datafile 2 to '/appl/ERP_CLONE/dbclone/clone_data/system02.dbf';
4> set newname for datafile 3 to '/appl/ERP_CLONE/dbclone/clone_data/system03.dbf';
5> set newname for datafile 4 to '/appl/ERP_CLONE/dbclone/clone_data/system04.dbf';
6> set newname for datafile 5 to '/appl/ERP_CLONE/dbclone/clone_data/system05.dbf';
7> set newname for datafile 6 to '/appl/ERP_CLONE/dbclone/clone_data/system06.dbf';
8> set newname for datafile 7 to '/appl/ERP_CLONE/dbclone/clone_data/system07.dbf';
9> set newname for datafile 8 to '/appl/ERP_CLONE/dbclone/clone_data/system08.dbf';
10> set newname for datafile 9 to '/appl/ERP_CLONE/dbclone/clone_data/system09.dbf';
11> set newname for datafile 10 to '/appl/ERP_CLONE/dbclone/clone_data/system10.dbf';
12> set newname for datafile 11 to '/appl/ERP_CLONE/dbclone/clone_data/system11.dbf';
13> set newname for datafile 12 to '/appl/ERP_CLONE/dbclone/clone_data/undo01.dbf';
14> set newname for datafile 13 to '/appl/ERP_CLONE/dbclone/clone_data/a_archive01.dbf';
15> set newname for datafile 14 to '/appl/ERP_CLONE/dbclone/clone_data/a_int01.dbf';
16> set newname for datafile 15 to '/appl/ERP_CLONE/dbclone/clone_data/a_media01.dbf';
17> set newname for datafile 16 to '/appl/ERP_CLONE/dbclone/clone_data/a_nolog01.dbf';
18> set newname for datafile 17 to '/appl/ERP_CLONE/dbclone/clone_data/a_queue01.dbf';
19> set newname for datafile 18 to '/appl/ERP_CLONE/dbclone/clone_data/a_queue02.dbf';
20> set newname for datafile 19 to '/appl/ERP_CLONE/dbclone/clone_data/a_ref01.dbf';
21> set newname for datafile 20 to '/appl/ERP_CLONE/dbclone/clone_data/a_ref02.dbf';
22> set newname for datafile 21 to '/appl/ERP_CLONE/dbclone/clone_data/a_summ01.dbf';
23> set newname for datafile 22 to '/appl/ERP_CLONE/dbclone/clone_data/a_txn_data101.dbf';
24> set newname for datafile 23 to '/appl/ERP_CLONE/dbclone/clone_data/a_txn_data102.dbf';
25> set newname for datafile 24 to '/appl/ERP_CLONE/dbclone/clone_data/a_txn_data103.dbf';
26> set newname for datafile 25 to '/appl/ERP_CLONE/dbclone/clone_data/a_txn_ind01.dbf';
27> set newname for datafile 26 to '/appl/ERP_CLONE/dbclone/clone_data/a_txn_ind02.dbf';
28> set newname for datafile 27 to '/appl/ERP_CLONE/dbclone/clone_data/a_txn_ind03.dbf';
29> set newname for datafile 28 to '/appl/ERP_CLONE/dbclone/clone_data/a_txn_ind04.dbf';
30> set newname for datafile 29 to '/appl/ERP_CLONE/dbclone/clone_data/a_txn_ind05.dbf';
31> set newname for datafile 30 to '/appl/ERP_CLONE/dbclone/clone_data/ctxd01.dbf';
32> set newname for datafile 31 to '/appl/ERP_CLONE/dbclone/clone_data/odm.dbf';
33> set newname for datafile 32 to '/appl/ERP_CLONE/dbclone/clone_data/olap.dbf';
34> set newname for datafile 33 to '/appl/ERP_CLONE/dbclone/clone_data/owad01.dbf';
35> set newname for datafile 34 to '/appl/ERP_CLONE/dbclone/clone_data/portal01.dbf';
36> set newname for datafile 35 to '/appl/ERP_CLONE/dbclone/clone_data/sysaux01.dbf';
37> set newname for datafile 36 to '/appl/ERP_CLONE/dbclone/clone_data/apps_ts_tools01.dbf';
38> set newname for datafile 37 to '/appl/ERP_CLONE/dbclone/clone_data/interim.dbf';
39> set newname for datafile 38 to '/appl/ERP_CLONE/dbclone/clone_data/a_txn_data14.dbf';
40> restore database;
41> switch datafile all; }
executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 04-FEB-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=381 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /appl/ERP_CLONE/dbclone/clone_data/system01.dbf
channel ORA_DISK_1: restoring datafile 00002 to /appl/ERP_CLONE/dbclone/clone_data/system02.dbf
channel ORA_DISK_1: restoring datafile 00003 to /appl/ERP_CLONE/dbclone/clone_data/system03.dbf
channel ORA_DISK_1: restoring datafile 00004 to /appl/ERP_CLONE/dbclone/clone_data/system04.dbf
channel ORA_DISK_1: restoring datafile 00005 to /appl/ERP_CLONE/dbclone/clone_data/system05.dbf
channel ORA_DISK_1: restoring datafile 00006 to /appl/ERP_CLONE/dbclone/clone_data/system06.dbf
channel ORA_DISK_1: restoring datafile 00007 to /appl/ERP_CLONE/dbclone/clone_data/system07.dbf
channel ORA_DISK_1: restoring datafile 00008 to /appl/ERP_CLONE/dbclone/clone_data/system08.dbf
channel ORA_DISK_1: restoring datafile 00009 to /appl/ERP_CLONE/dbclone/clone_data/system09.dbf
channel ORA_DISK_1: restoring datafile 00010 to /appl/ERP_CLONE/dbclone/clone_data/system10.dbf
channel ORA_DISK_1: restoring datafile 00011 to /appl/ERP_CLONE/dbclone/clone_data/system11.dbf
channel ORA_DISK_1: restoring datafile 00012 to /appl/ERP_CLONE/dbclone/clone_data/undo01.dbf
channel ORA_DISK_1: restoring datafile 00013 to /appl/ERP_CLONE/dbclone/clone_data/a_archive01.dbf
channel ORA_DISK_1: restoring datafile 00014 to /appl/ERP_CLONE/dbclone/clone_data/a_int01.dbf
channel ORA_DISK_1: restoring datafile 00015 to /appl/ERP_CLONE/dbclone/clone_data/a_media01.dbf
channel ORA_DISK_1: restoring datafile 00016 to /appl/ERP_CLONE/dbclone/clone_data/a_nolog01.dbf
channel ORA_DISK_1: restoring datafile 00017 to /appl/ERP_CLONE/dbclone/clone_data/a_queue01.dbf
channel ORA_DISK_1: restoring datafile 00018 to /appl/ERP_CLONE/dbclone/clone_data/a_queue02.dbf
channel ORA_DISK_1: restoring datafile 00019 to /appl/ERP_CLONE/dbclone/clone_data/a_ref01.dbf
channel ORA_DISK_1: restoring datafile 00020 to /appl/ERP_CLONE/dbclone/clone_data/a_ref02.dbf
channel ORA_DISK_1: restoring datafile 00021 to /appl/ERP_CLONE/dbclone/clone_data/a_summ01.dbf
channel ORA_DISK_1: restoring datafile 00022 to /appl/ERP_CLONE/dbclone/clone_data/a_txn_data101.dbf
channel ORA_DISK_1: restoring datafile 00023 to /appl/ERP_CLONE/dbclone/clone_data/a_txn_data102.dbf
channel ORA_DISK_1: restoring datafile 00024 to /appl/ERP_CLONE/dbclone/clone_data/a_txn_data103.dbf
channel ORA_DISK_1: restoring datafile 00025 to /appl/ERP_CLONE/dbclone/clone_data/a_txn_ind01.dbf
channel ORA_DISK_1: restoring datafile 00026 to /appl/ERP_CLONE/dbclone/clone_data/a_txn_ind02.dbf
channel ORA_DISK_1: restoring datafile 00027 to /appl/ERP_CLONE/dbclone/clone_data/a_txn_ind03.dbf
channel ORA_DISK_1: restoring datafile 00028 to /appl/ERP_CLONE/dbclone/clone_data/a_txn_ind04.dbf
channel ORA_DISK_1: restoring datafile 00029 to /appl/ERP_CLONE/dbclone/clone_data/a_txn_ind05.dbf
channel ORA_DISK_1: restoring datafile 00030 to /appl/ERP_CLONE/dbclone/clone_data/ctxd01.dbf
channel ORA_DISK_1: restoring datafile 00031 to /appl/ERP_CLONE/dbclone/clone_data/odm.dbf
channel ORA_DISK_1: restoring datafile 00032 to /appl/ERP_CLONE/dbclone/clone_data/olap.dbf
channel ORA_DISK_1: restoring datafile 00033 to /appl/ERP_CLONE/dbclone/clone_data/owad01.dbf
channel ORA_DISK_1: restoring datafile 00034 to /appl/ERP_CLONE/dbclone/clone_data/portal01.dbf
channel ORA_DISK_1: restoring datafile 00035 to /appl/ERP_CLONE/dbclone/clone_data/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00036 to /appl/ERP_CLONE/dbclone/clone_data/apps_ts_tools01.dbf
channel ORA_DISK_1: restoring datafile 00037 to /appl/ERP_CLONE/dbclone/clone_data/interim.dbf
channel ORA_DISK_1: restoring datafile 00038 to /appl/ERP_CLONE/dbclone/clone_data/a_txn_data14.dbf
channel ORA_DISK_1: reading from backup piece /data/R12_ERP/rman_backup/3feb2012_backup/ERPTEST_DB_05o11qhe_5_1
channel ORA_DISK_1: errors found reading piece handle=/data/R12_ERP/rman_backup/3feb2012_backup/ERPTEST_DB_05o11qhe_5_1
channel ORA_DISK_1: failover to piece handle=/appl/rman_backup/3feb2012_backup/ERPTEST_DB_05o11qhe_5_1 tag=TAG20130203T120813
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:12:21
Finished restore at 04-FEB-13

datafile 1 switched to datafile copy
input datafile copy RECID=39 STAMP=806496604 file name=/appl/ERP_CLONE/dbclone/clone_data/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=40 STAMP=806496605 file name=/appl/ERP_CLONE/dbclone/clone_data/system02.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=41 STAMP=806496605 file name=/appl/ERP_CLONE/dbclone/clone_data/system03.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=42 STAMP=806496606 file name=/appl/ERP_CLONE/dbclone/clone_data/system04.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=43 STAMP=806496606 file name=/appl/ERP_CLONE/dbclone/clone_data/system05.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=44 STAMP=806496607 file name=/appl/ERP_CLONE/dbclone/clone_data/system06.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=45 STAMP=806496607 file name=/appl/ERP_CLONE/dbclone/clone_data/system07.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=46 STAMP=806496608 file name=/appl/ERP_CLONE/dbclone/clone_data/system08.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=47 STAMP=806496609 file name=/appl/ERP_CLONE/dbclone/clone_data/system09.dbf
datafile 10 switched to datafile copy
input datafile copy RECID=48 STAMP=806496609 file name=/appl/ERP_CLONE/dbclone/clone_data/system10.dbf
datafile 11 switched to datafile copy
input datafile copy RECID=49 STAMP=806496610 file name=/appl/ERP_CLONE/dbclone/clone_data/system11.dbf
datafile 12 switched to datafile copy
input datafile copy RECID=50 STAMP=806496611 file name=/appl/ERP_CLONE/dbclone/clone_data/undo01.dbf
datafile 13 switched to datafile copy
input datafile copy RECID=51 STAMP=806496612 file name=/appl/ERP_CLONE/dbclone/clone_data/a_archive01.dbf
datafile 14 switched to datafile copy
input datafile copy RECID=52 STAMP=806496612 file name=/appl/ERP_CLONE/dbclone/clone_data/a_int01.dbf
datafile 15 switched to datafile copy
input datafile copy RECID=53 STAMP=806496613 file name=/appl/ERP_CLONE/dbclone/clone_data/a_media01.dbf
datafile 16 switched to datafile copy
input datafile copy RECID=54 STAMP=806496613 file name=/appl/ERP_CLONE/dbclone/clone_data/a_nolog01.dbf
datafile 17 switched to datafile copy
input datafile copy RECID=55 STAMP=806496614 file name=/appl/ERP_CLONE/dbclone/clone_data/a_queue01.dbf
datafile 18 switched to datafile copy
input datafile copy RECID=56 STAMP=806496614 file name=/appl/ERP_CLONE/dbclone/clone_data/a_queue02.dbf
datafile 19 switched to datafile copy
input datafile copy RECID=57 STAMP=806496615 file name=/appl/ERP_CLONE/dbclone/clone_data/a_ref01.dbf
datafile 20 switched to datafile copy
input datafile copy RECID=58 STAMP=806496615 file name=/appl/ERP_CLONE/dbclone/clone_data/a_ref02.dbf
datafile 21 switched to datafile copy
input datafile copy RECID=59 STAMP=806496616 file name=/appl/ERP_CLONE/dbclone/clone_data/a_summ01.dbf
datafile 22 switched to datafile copy
input datafile copy RECID=60 STAMP=806496617 file name=/appl/ERP_CLONE/dbclone/clone_data/a_txn_data101.dbf
datafile 23 switched to datafile copy
input datafile copy RECID=61 STAMP=806496618 file name=/appl/ERP_CLONE/dbclone/clone_data/a_txn_data102.dbf
datafile 24 switched to datafile copy
input datafile copy RECID=62 STAMP=806496619 file name=/appl/ERP_CLONE/dbclone/clone_data/a_txn_data103.dbf
datafile 25 switched to datafile copy
input datafile copy RECID=63 STAMP=806496619 file name=/appl/ERP_CLONE/dbclone/clone_data/a_txn_ind01.dbf
datafile 26 switched to datafile copy
input datafile copy RECID=64 STAMP=806496620 file name=/appl/ERP_CLONE/dbclone/clone_data/a_txn_ind02.dbf
datafile 27 switched to datafile copy
input datafile copy RECID=65 STAMP=806496620 file name=/appl/ERP_CLONE/dbclone/clone_data/a_txn_ind03.dbf
datafile 28 switched to datafile copy
input datafile copy RECID=66 STAMP=806496621 file name=/appl/ERP_CLONE/dbclone/clone_data/a_txn_ind04.dbf
datafile 29 switched to datafile copy
input datafile copy RECID=67 STAMP=806496621 file name=/appl/ERP_CLONE/dbclone/clone_data/a_txn_ind05.dbf
datafile 30 switched to datafile copy
input datafile copy RECID=68 STAMP=806496622 file name=/appl/ERP_CLONE/dbclone/clone_data/ctxd01.dbf
datafile 31 switched to datafile copy
input datafile copy RECID=69 STAMP=806496622 file name=/appl/ERP_CLONE/dbclone/clone_data/odm.dbf
datafile 32 switched to datafile copy
input datafile copy RECID=70 STAMP=806496623 file name=/appl/ERP_CLONE/dbclone/clone_data/olap.dbf
datafile 33 switched to datafile copy
input datafile copy RECID=71 STAMP=806496623 file name=/appl/ERP_CLONE/dbclone/clone_data/owad01.dbf
datafile 34 switched to datafile copy
input datafile copy RECID=72 STAMP=806496624 file name=/appl/ERP_CLONE/dbclone/clone_data/portal01.dbf
datafile 35 switched to datafile copy
input datafile copy RECID=73 STAMP=806496624 file name=/appl/ERP_CLONE/dbclone/clone_data/sysaux01.dbf
datafile 36 switched to datafile copy
input datafile copy RECID=74 STAMP=806496625 file name=/appl/ERP_CLONE/dbclone/clone_data/apps_ts_tools01.dbf
datafile 37 switched to datafile copy
input datafile copy RECID=75 STAMP=806496625 file name=/appl/ERP_CLONE/dbclone/clone_data/interim.dbf
datafile 38 switched to datafile copy
input datafile copy RECID=76 STAMP=806496626 file name=/appl/ERP_CLONE/dbclone/clone_data/a_txn_data14.dbf

RMAN> **end-of-file**

RMAN> 

 - List backup of archive logs and recover database until last available seq

RMAN> list backup of archivelog all;


List of Backup Sets
===================


BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
1       822.21M    DISK        00:00:11     21-JAN-13
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20130121T092549
        Piece Name: /data/R12_ERP/rman_backup/ERPTEST_DB_01nvv84u_1_1

  List of Archived Logs in backup set 1
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    22      77784979   20-JAN-13 77924429   21-JAN-13

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
4       103.00K    DISK        00:00:00     21-JAN-13
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: TAG20130121T093606
        Piece Name: /data/R12_ERP/rman_backup/ERPTEST_DB_04nvv8o6_4_1

  List of Archived Logs in backup set 4
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    23      77924429   21-JAN-13 77924713   21-JAN-13

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
7       1.20G      DISK        00:00:22     03-FEB-13
        BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: FULL_DB
        Piece Name: /data/R12_ERP/rman_backup/3feb2013_Bkp/db_806418437_7.bkp

  List of Archived Logs in backup set 7
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    22      77784979   20-JAN-13 77924429   21-JAN-13
  1    23      77924429   21-JAN-13 77924713   21-JAN-13
  1    24      77924713   21-JAN-13 78223108   03-FEB-13

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
9       226.00K    DISK        00:00:00     03-FEB-13
        BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: FULL_DB
        Piece Name: /data/R12_ERP/rman_backup/3feb2013_Bkp/db_806419062_9.bkp

  List of Archived Logs in backup set 9
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    25      78223108   03-FEB-13 78223850   03-FEB-13


RMAN> RUN {
2> set until sequence 26 thread 1;
3> recover database;
4> }

executing command: SET until clause

Starting recover at 04-FEB-13
using channel ORA_DISK_1

starting media recovery

channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=24
channel ORA_DISK_1: reading from backup piece /data/R12_ERP/rman_backup/3feb2013_Bkp/db_806418437_7.bkp
channel ORA_DISK_1: errors found reading piece handle=/data/R12_ERP/rman_backup/3feb2013_Bkp/db_806418437_7.bkp
channel ORA_DISK_1: failover to piece handle=/appl/rman_backup/3feb2012_backup/db_806418437_7.bkp tag=FULL_DB
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
archived log file name=/appl/ERP_CLONE/dbclone/clone_data/archive/1_24_805117931.dbf thread=1 sequence=24
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=25
channel ORA_DISK_1: reading from backup piece /data/R12_ERP/rman_backup/3feb2013_Bkp/db_806419062_9.bkp
channel ORA_DISK_1: errors found reading piece handle=/data/R12_ERP/rman_backup/3feb2013_Bkp/db_806419062_9.bkp
channel ORA_DISK_1: failover to piece handle=/appl/rman_backup/3feb2012_backup/db_806419062_9.bkp tag=FULL_DB
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/appl/ERP_CLONE/dbclone/clone_data/archive/1_25_805117931.dbf thread=1 sequence=25
media recovery complete, elapsed time: 00:00:01
Finished recover at 04-FEB-13

RMAN>

- Rename online LOGFILES:

bash-3.00$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.7.0 - Production on Mon Feb 4 13:36:24 2013

Copyright (c) 1982, 2008, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
/data/R12_ERP/db/apps_st/data/log02a.dbf
/data/R12_ERP/db/apps_st/data/log02b.dbf
/data/R12_ERP/db/apps_st/data/log01a.dbf
/data/R12_ERP/db/apps_st/data/log01b.dbf


SQL> alter database rename file '/data/R12_ERP/db/apps_st/data/log02a.dbf' to '/appl/ERP_CLONE/dbclone/clone_data/log02a.dbf';

Database altered.

SQL> alter database rename file '/data/R12_ERP/db/apps_st/data/log02b.dbf' to '/appl/ERP_CLONE/dbclone/clone_data/log02b.dbf'
  2  ;

Database altered.

SQL> alter database rename file '/data/R12_ERP/db/apps_st/data/log01a.dbf' to '/appl/ERP_CLONE/dbclone/clone_data/log01a.dbf';

Database altered.

SQL> alter database rename file '/data/R12_ERP/db/apps_st/data/log01b.dbf' to '/appl/ERP_CLONE/dbclone/clone_data/log01b.dbf';

Database altered.

SQL>

- Open database using resetlogs:




SQL> alter database open resetlogs;

Database altered.

SQL>

-   Create and drop TEMP tablspace

SQL> create TEMPORARY TABLESPACE TEMP3 TEMPFILE '/appl/ERP_CLONE/dbclone/clone_data/temp003.dbf' size 2048M;

Tablespace created.

SQL> ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp3;

Database altered.

SQL> drop tablespace temp1 including contents and datafiles;

Tablespace dropped.

SQL> drop tablespace temp2 including contents and datafiles;

Tablespace dropped.

SQL>

- Change database name using "nid" command

bash-3.00$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.7.0 - Production on Mon Feb 4 13:59:47 2013

Copyright (c) 1982, 2008, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 1069252608 bytes
Fixed Size                  2109352 bytes
Variable Size             427823192 bytes
Database Buffers          624951296 bytes
Redo Buffers               14368768 bytes
Database mounted.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
bash-3.00$ nid TARGET=SYS/oracle DBNAME=CLONE

DBNEWID: Release 11.1.0.7.0 - Production on Mon Feb 4 14:02:31 2013

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Connected to database ERPTEST (DBID=1262470248)

Connected to server version 11.1.0

Control Files in database:
    /appl/ERP_CLONE/dbclone/clone_data/cntrl01.dbf

Change database ID and database name ERPTEST to CLONE? (Y/[N]) => Y

Proceeding with operation
Changing database ID from 1262470248 to 1005337143
Changing database name from ERPTEST to CLONE
    Control File /appl/ERP_CLONE/dbclone/clone_data/cntrl01.dbf - modified
    Datafile /appl/ERP_CLONE/dbclone/clone_data/system01.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/system02.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/system03.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/system04.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/system05.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/system06.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/system07.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/system08.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/system09.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/system10.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/system11.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/undo01.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/a_archive01.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/a_int01.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/a_media01.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/a_nolog01.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/a_queue01.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/a_queue02.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/a_ref01.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/a_ref02.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/a_summ01.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/a_txn_data101.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/a_txn_data102.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/a_txn_data103.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/a_txn_ind01.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/a_txn_ind02.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/a_txn_ind03.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/a_txn_ind04.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/a_txn_ind05.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/ctxd01.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/odm.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/olap.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/owad01.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/portal01.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/sysaux01.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/apps_ts_tools01.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/interim.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/a_txn_data14.db - dbid changed, wrote new name
    Datafile /appl/ERP_CLONE/dbclone/clone_data/temp003.db - dbid changed, wrote new name
    Control File /appl/ERP_CLONE/dbclone/clone_data/cntrl01.dbf - dbid changed, wrote new name
    Instance shut down

Database name changed to CLONE.
Modify parameter file and generate a new password file before restarting.
Database ID for database CLONE changed to 1005337143.
All previous backups and archived redo logs for this database are unusable.
Database has been shutdown, open database with RESETLOGS option.
Succesfully changed database name and ID.
DBNEWID - Completed succesfully.

bash-3.00$

- Change ORACLE_SID in environment file and start database with reset logs:

bash-3.00$ grep ORACLE_SID CLONE_testappl.env
ORACLE_SID="CLONE"
export ORACLE_SID
bash-3.00$ pwd
/appl/ERP_CLONE/dbclone/tech_st/11.1.0
bash-3.00$ echo $ORACLE_SID
CLONE
bash-3.00$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.7.0 - Production on Mon Feb 4 14:12:56 2013

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup mount
ORACLE instance started.

Total System Global Area 1069252608 bytes
Fixed Size                  2109352 bytes
Variable Size             427823192 bytes
Database Buffers          624951296 bytes
Redo Buffers               14368768 bytes
Database mounted.
SQL> alter database open resetlogs;

Database altered.

SQL> select open_mode, name from v$database;

OPEN_MODE  NAME
---------- ---------
READ WRITE CLONE

SQL>

- Run autoconfig on database Tier:

bash-3.00$ adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/log/CLONE_testappl/02041433/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.
        Using ORACLE_HOME location : /appl/ERP_CLONE/dbclone/tech_st/11.1.0
        Classpath                   : :/appl/ERP_CLONE/dbclone/tech_st/11.1.0/jdbc/lib/ojdbc6.jar:/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/java/xmlparserv2.jar:/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/java:/appl/ERP_CLONE/dbclone/tech_st/11.1.0/jlib/netcfg.jar:/appl/ERP_CLONE/dbclone/tech_st/11.1.0/jlib/ldapjclnt11.jar

        Using Context file          : /appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/CLONE_testappl.xml

Context Value Management will now update the Context file
UnsatisfiedLinkError exception loading native library: njni11

        Updating Context file...COMPLETED

        Attempting upload of Context file and templates to database...COMPLETED

Updating rdbms version in Context file to db111
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.

- Run clone Configuration script on application Tier (testappl):

bash-3.00$ pwd
/data/appclone/R12_ERP/apps/apps_st/comn/clone/bin
bash-3.00$ export PATH=/usr/ccs/bin:/usr/bin:/usr/ucb:/etc:.
bash-3.00$ perl adcfgclone.pl appsTier

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adcfgclone Version 120.31.12010000.8

Enter the APPS password :

Running:
/data/appclone/R12_ERP/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -cp /data/appclone/R12_ERP/apps/apps_st/comn/clone/jlib/java:/data/appclone/R12_ERP/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/data/appclone/R12_ERP/apps/apps_st/comn/clone/jlib/ojdbc14.jar oracle.apps.ad.context.CloneContext -e /data/appclone/R12_ERP/apps/apps_st/comn/clone/bin/../context/apps/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_26828.lst -stage /data/appclone/R12_ERP/apps/apps_st/comn/clone  2> /tmp/adcfgclone_26828.err; echo $? > /tmp/adcfgclone_26828.res

Log file located at /data/appclone/R12_ERP/apps/apps_st/comn/clone/bin/CloneContext_0205121512.log

Provide the values required for creation of the new APPL_TOP Context file.

Target System Hostname (virtual or normal) [testappl] :

Target System Database SID : CLONE

Target System Database Server Node [testappl] :

Target System Database Domain Name [orasol.com] :

Target System Base Directory : /data/appclone/R12_ERP

Target System Tools ORACLE_HOME Directory [/data/appclone/R12_ERP/apps/tech_st/10.1.2] :

Target System Web ORACLE_HOME Directory [/data/appclone/R12_ERP/apps/tech_st/10.1.3] :

Target System APPL_TOP Directory [/data/appclone/R12_ERP/apps/apps_st/appl] :

Target System COMMON_TOP Directory [/data/appclone/R12_ERP/apps/apps_st/comn] :

Target System Instance Home Directory [/data/appclone/R12_ERP/inst] :

Target System Root Service [enabled] :

Target System Web Entry Point Services [enabled] :

Target System Web Application Services [enabled] :

Target System Batch Processing Services [enabled] :

Target System Other Services [disabled] :

Do you want to preserve the Display [devappl:0.0] (y/n)  : n

Target System Display [testappl:0.0] :

RC-00217: Warning: Configuration home directory (s_config_home) evaluates to /data/appclone/R12_ERP/inst/apps/CLONE_testappl. A directory with this name already exists and is not empty.

Do you want to continue (y/n)   : y


Do you want the the target system to have the same port values as the source system (y/n) [y] ? : n

Target System Port Pool [0-99] : 22

Checking the port pool 22
done: Port Pool 22 is free
Report file located at /data/appclone/R12_ERP/inst/apps/CLONE_testappl/temp/portpool.lst
Complete port information available at /data/appclone/R12_ERP/inst/apps/CLONE_testappl/temp/portpool.lst

UTL_FILE_DIR on database tier consists of the following directories.

1. /usr/tmp
2. /usr/tmp
3. /appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/outbound/CLONE_testappl
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] :

Backing up /data/appclone/R12_ERP/inst/apps/CLONE_testappl/appl/admin/CLONE_testappl.xml to /data/appclone/R12_ERP/inst/apps/CLONE_testappl/appl/admin/CLONE_testappl.xml0.bak

Creating the new APPL_TOP Context file from :
  /data/appclone/R12_ERP/apps/apps_st/appl/ad/12.0.0/admin/template/adxmlctx.tmp

The new APPL_TOP context file has been created :
  /data/appclone/R12_ERP/inst/apps/CLONE_testappl/appl/admin/CLONE_testappl.xml

Log file located at /data/appclone/R12_ERP/apps/apps_st/comn/clone/bin/CloneContext_0205121512.log
Check Clone Context logfile /data/appclone/R12_ERP/apps/apps_st/comn/clone/bin/CloneContext_0205121512.log for details.

Running Rapid Clone with command:
perl /data/appclone/R12_ERP/apps/apps_st/comn/clone/bin/adclone.pl java=/data/appclone/R12_ERP/apps/apps_st/comn/clone/bin/../jre mode=apply stage=/data/appclone/R12_ERP/apps/apps_st/comn/clone component=appsTier method=CUSTOM appctxtg=/data/appclone/R12_ERP/inst/apps/CLONE_testappl/appl/admin/CLONE_testappl.xml showProgress contextValidated=true
Running:
perl /data/appclone/R12_ERP/apps/apps_st/comn/clone/bin/adclone.pl java=/data/appclone/R12_ERP/apps/apps_st/comn/clone/bin/../jre mode=apply stage=/data/appclone/R12_ERP/apps/apps_st/comn/clone component=appsTier method=CUSTOM appctxtg=/data/appclone/R12_ERP/inst/apps/CLONE_testappl/appl/admin/CLONE_testappl.xml showProgress contextValidated=true
APPS Password :

Beginning application tier Apply - Tue Feb  5 12:15:57 2013

/data/appclone/R12_ERP/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true  -Doracle.installer.oui_loc=/oui -classpath /data/appclone/R12_ERP/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/data/appclone/R12_ERP/apps/apps_st/comn/clone/jlib/ojdbc14.jar:/data/appclone/R12_ERP/apps/apps_st/comn/clone/jlib/java:/data/appclone/R12_ERP/apps/apps_st/comn/clone/jlib/oui/OraInstaller.jar:/data/appclone/R12_ERP/apps/apps_st/comn/clone/jlib/oui/ewt3.jar:/data/appclone/R12_ERP/apps/apps_st/comn/clone/jlib/oui/share.jar:/data/appclone/R12_ERP/apps/apps_st/comn/clone/jlib/oui/srvm.jar:/data/appclone/R12_ERP/apps/apps_st/comn/clone/jlib/ojmisc.jar  oracle.apps.ad.clone.ApplyAppsTier -e /data/appclone/R12_ERP/inst/apps/CLONE_testappl/appl/admin/CLONE_testappl.xml -stage /data/appclone/R12_ERP/apps/apps_st/comn/clone    -showProgress
APPS Password : Log file located at /data/appclone/R12_ERP/inst/apps/CLONE_testappl/admin/log/ApplyAppsTier_02051215.log
  /     89% completed

Completed Apply...
Tue Feb  5 12:20:51 2013


Do you want to startup the Application Services for CLONE? (y/n) [y] :

Starting application Services for CLONE:
Running:
/data/appclone/R12_ERP/inst/apps/CLONE_testappl/admin/scripts/adstrtal.sh -nopromptmsg

You are running adstrtal.sh version 120.15.12010000.3

The logfile for this session is located at /data/appclone/R12_ERP/inst/apps/CLONE_testappl/logs/appl/admin/log/adstrtal.log
Executing service control script:
/data/appclone/R12_ERP/inst/apps/CLONE_testappl/admin/scripts/adopmnctl.sh start
script returned:
****************************************************

You are running adopmnctl.sh version 120.6.12010000.4

Starting Oracle Process Manager (OPMN) ...

adopmnctl.sh: exiting with status 0

adopmnctl.sh: check the logfile /data/appclone/R12_ERP/inst/apps/CLONE_testappl/logs/appl/admin/log/adopmnctl.txt for more information ...


.end std out.

.end err out.

****************************************************


Executing service control script:
/data/appclone/R12_ERP/inst/apps/CLONE_testappl/admin/scripts/adalnctl.sh start
script returned:
****************************************************

adalnctl.sh version 120.3

Checking for FNDFS executable.
Starting listener process APPS_CLONE.

adalnctl.sh: exiting with status 0


adalnctl.sh: check the logfile /data/appclone/R12_ERP/inst/apps/CLONE_testappl/logs/appl/admin/log/adalnctl.txt for more information ...


.end std out.

.end err out.

****************************************************


Executing service control script:
/data/appclone/R12_ERP/inst/apps/CLONE_testappl/admin/scripts/adapcctl.sh start
script returned:
****************************************************

You are running adapcctl.sh version 120.7.12010000.2

Starting OPMN managed Oracle HTTP Server (OHS) instance ...

adapcctl.sh: exiting with status 0

adapcctl.sh: check the logfile /data/appclone/R12_ERP/inst/apps/CLONE_testappl/logs/appl/admin/log/adapcctl.txt for more information ...


.end std out.

.end err out.

****************************************************


Executing service control script:
/data/appclone/R12_ERP/inst/apps/CLONE_testappl/admin/scripts/adoacorectl.sh start
script returned:
****************************************************

You are running adoacorectl.sh version 120.13

Starting OPMN managed OACORE OC4J instance  ...

adoacorectl.sh: exiting with status 0

adoacorectl.sh: check the logfile /data/appclone/R12_ERP/inst/apps/CLONE_testappl/logs/appl/admin/log/adoacorectl.txt for more information ...


.end std out.

.end err out.

****************************************************


Executing service control script:
/data/appclone/R12_ERP/inst/apps/CLONE_testappl/admin/scripts/adformsctl.sh start
script returned:
****************************************************

You are running adformsctl.sh  version 120.16.12010000.3

Starting OPMN managed FORMS OC4J instance  ...
Calling txkChkFormsDeployment.pl to check whether latest FORMSAPP.EAR is deployed...
Program : /data/appclone/R12_ERP/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkChkFormsDeployment.pl started @ Tue Feb  5 12:40:02 2013

*** Log File = /data/appclone/R12_ERP/inst/apps/CLONE_testappl/logs/appl/rgf/TXK/txkChkFormsDeployment_Tue_Feb_5_12_40_00_2013/txkChkFormsDeployment_Tue_Feb_5_12_40_00_2013.log

File "/data/appclone/R12_ERP/apps/tech_st/10.1.3/j2ee/forms/applications/forms/formsweb/WEB-INF/lib/frmsrv.jar" exists. Proceeding to check the size...

=============================================
*** Latest formsapp.ear has been deployed ***
=============================================


Program : /data/appclone/R12_ERP/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkChkFormsDeployment.pl completed @ Tue Feb  5 12:40:03 2013

Perl script txkChkFormsDeployment.pl got executed successfully



adformsctl.sh: exiting with status 0

adformsctl.sh: check the logfile /data/appclone/R12_ERP/inst/apps/CLONE_testappl/logs/appl/admin/log/adformsctl.txt for more information ...


.end std out.
*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS
*** Log File = /data/appclone/R12_ERP/inst/apps/CLONE_testappl/logs/appl/rgf/TXK/txkChkFormsDeployment_Tue_Feb_5_12_40_00_2013/txkChkFormsDeployment_Tue_Feb_5_12_40_00_2013.log

.end err out.

****************************************************


Executing service control script:
/data/appclone/R12_ERP/inst/apps/CLONE_testappl/admin/scripts/adoafmctl.sh start
script returned:
****************************************************

You are running adoafmctl.sh version 120.8

Starting OPMN managed OAFM OC4J instance  ...

adoafmctl.sh: exiting with status 0

adoafmctl.sh: check the logfile /data/appclone/R12_ERP/inst/apps/CLONE_testappl/logs/appl/admin/log/adoafmctl.txt for more information ...


.end std out.

.end err out.

****************************************************


Executing service control script:
/data/appclone/R12_ERP/inst/apps/CLONE_testappl/admin/scripts/adcmctl.sh start
script returned:
****************************************************

You are running adcmctl.sh version 120.17.12010000.5

Starting concurrent manager for CLONE ...
Starting CLONE_0205@CLONE Internal Concurrent Manager
Default printer is noprint

adcmctl.sh: exiting with status 0


adcmctl.sh: check the logfile /data/appclone/R12_ERP/inst/apps/CLONE_testappl/logs/appl/admin/log/adcmctl.txt for more information ...


.end std out.

.end err out.

****************************************************


Executing service control script:
/data/appclone/R12_ERP/inst/apps/CLONE_testappl/admin/scripts/jtffmctl.sh start
script returned:
****************************************************

You are running jtffmctl.sh version 120.3

Validating Fulfillment patch level via /data/appclone/R12_ERP/apps/apps_st/comn/java/classes
Fulfillment patch level validated.
Starting Fulfillment Server for CLONE on port 9322 ...

jtffmctl.sh: exiting with status 0


.end std out.

.end err out.

****************************************************


All enabled services for this node are started.

adstrtal.sh: Exiting with status 0

adstrtal.sh: check the logfile /data/appclone/R12_ERP/inst/apps/CLONE_testappl/logs/appl/admin/log/adstrtal.log for more information ...

bash-3.00$

- Perform post clone steps:

• Run FND conc clean procedure
• change apps, sys, system, password
• change site NAME
• change SGA size as required  (deault 1GB will be configured)
• Reduce concurrent managers as required depending on the resources

- Run FND conc. clean, change apps, sys, system, password and run autoconfig

- On AppsTier

bash-3.00$ FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS appsclone

- On DB Tier

SQL> select NODE_NAME from fnd_nodes;

NODE_NAME
------------------------------
AUTHENTICATION
DEVAPPL
DEVDB
TESTAPPL

SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN;

PL/SQL procedure successfully completed.

SQL> commit;

Commit complete.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

bash-3.00$ cd CLONE_testappl/
bash-3.00$ ls
adautocfg.sh   adchknls.pl    addbctl.sh     addlnctl.sh    adexecsql.pl   adlsnodes.sh   adpreclone.pl  adstopdb.sql   adstrtdb.sql
bash-3.00$ adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/log/CLONE_testappl/02051300/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.
        Using ORACLE_HOME location : /appl/ERP_CLONE/dbclone/tech_st/11.1.0
        Classpath                   : :/appl/ERP_CLONE/dbclone/tech_st/11.1.0/jdbc/lib/ojdbc6.jar:/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/java/xmlparserv2.jar:/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/java:/appl/ERP_CLONE/dbclone/tech_st/11.1.0/jlib/netcfg.jar:/appl/ERP_CLONE/dbclone/tech_st/11.1.0/jlib/ldapjclnt11.jar

        Using Context file          : /appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/CLONE_testappl.xml

Context Value Management will now update the Context file
UnsatisfiedLinkError exception loading native library: njni11

        Updating Context file...COMPLETED

        Attempting upload of Context file and templates to database...COMPLETED

Updating rdbms version in Context file to db111
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.
bash-3.00$

- Running autoconfig on application Tier:

bash-3.00$ cd /appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/scripts/CLONE_testappl
bash-3.00$ adautocfg.sh
Enter the APPS user password:

The log file for this session is located at: /data/appclone/R12_ERP/inst/apps/CLONE_testappl/admin/log/02051301/adconfig.log

AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.
        Using CONFIG_HOME location     : /data/appclone/R12_ERP/inst/apps/CLONE_testappl
        Classpath                   : /data/appclone/R12_ERP/apps/apps_st/comn/java/lib/appsborg2.zip:/data/appclone/R12_ERP/apps/apps_st/comn/java/classes

        Using Context file          : /data/appclone/R12_ERP/inst/apps/CLONE_testappl/appl/admin/CLONE_testappl.xml

Context Value Management will now update the Context file

        Updating Context file...COMPLETED

        Attempting upload of Context file and templates to database...COMPLETED

Configuring templates from all of the product tops...
        Configuring AD_TOP........COMPLETED
        Configuring FND_TOP.......COMPLETED
        Configuring ICX_TOP.......COMPLETED
        Configuring MSC_TOP.......COMPLETED
        Configuring IEO_TOP.......COMPLETED
        Configuring BIS_TOP.......COMPLETED
        Configuring AMS_TOP.......COMPLETED
        Configuring CCT_TOP.......COMPLETED
        Configuring WSH_TOP.......COMPLETED
        Configuring CLN_TOP.......COMPLETED
        Configuring OKE_TOP.......COMPLETED
        Configuring OKL_TOP.......COMPLETED
        Configuring OKS_TOP.......COMPLETED
        Configuring CSF_TOP.......COMPLETED
        Configuring IGS_TOP.......COMPLETED
        Configuring IBY_TOP.......COMPLETED
        Configuring JTF_TOP.......COMPLETED
        Configuring MWA_TOP.......COMPLETED
        Configuring CN_TOP........COMPLETED
        Configuring CSI_TOP.......COMPLETED
        Configuring WIP_TOP.......COMPLETED
        Configuring CSE_TOP.......COMPLETED
        Configuring EAM_TOP.......COMPLETED
        Configuring FTE_TOP.......COMPLETED
        Configuring ONT_TOP.......COMPLETED
        Configuring AR_TOP........COMPLETED
        Configuring AHL_TOP.......COMPLETED
        Configuring OZF_TOP.......COMPLETED
        Configuring IES_TOP.......COMPLETED
        Configuring CSD_TOP.......COMPLETED
        Configuring IGC_TOP.......COMPLETED

AutoConfig completed successfully.
bash-3.00$

- Oracle Application Dashboard for clone:

I Believe this post will be helpful for those who are looking for some document for performing Oracle E-Business suite cloning online(hot backup).