Wednesday, October 21, 2015

TNS-00584: Valid node checking configuration error

Issue

TNS-00584: Valid node checking configuration error
Issue with listener startup as shown below:
LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 20-AUG-2012 22:28:13

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

Starting /u01/oracle/visdb/10.2.0/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.4.0 - Production
System parameter file is /u01/oracle/visdb/10.2.0/network/admin/VIS_optimebs24/listener.ora
Log messages written to /u01/oracle/visdb/10.2.0/network/admin/vis.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROCVIS)))
Error listening on: (ADDRESS=(PROTOCOL=TCP)(Host=optimebs24.estuate)(Port=1521))
TNS-12560: TNS:protocol adapter error
 TNS-00584: Valid node checking configuration error


Listener failed to start. See the error message(s) above...


solution

For this error  edit sqlnet.ora file means comment tcp and invited node validation

java.lang.Exception: Control file creation failed : RC-00118: Error occurred during creation of database

RC-50004: Fatal: Error occurred in ApplyDatabase: Control file creation failed / RC-00118 'Error occurred during creation of database
Error : in ApplyDBTier_01291502.log file

Exception occurred: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
    Trying to connect using SID as ServiceName.DomainName
getConnectionUsingServiceName() -->
    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sudb2.corp.singiri.com)(PORT=1525))(CONNECT_DATA=(SERVICE_NAME=SUP1.corp.singiri.com)))
    Exception occurred: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

    Connection could not be obtained; returning null

-------------------ADX Database Utility Finished---------------

RC-00118: Error occurred during creation of database

Raised by oracle.apps.ad.clone.ApplyDatabase
StackTrace:
java.lang.Exception: Control file creation failed
     at oracle.apps.ad.clone.ApplyDatabase.doConf(ApplyDatabase.java:635)
     at oracle.apps.ad.clone.ApplyDatabase.doApply(ApplyDatabase.java:473)
     at oracle.apps.ad.clone.ApplyDatabase.(ApplyDatabase.java:366)
     at oracle.apps.ad.clone.ApplyDBTier.(ApplyDBTier.java:110)
     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
     at java.lang.reflect.Constructor.newInstance(Constructor.java:501)
     at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:67)
     at java.lang.Thread.run(Thread.java:637)


Solution A:

Step 1: To verify the apps password is valid ,which you provided by Target server while running adcfgclone.pl on dbTier

(Or)

Workaround:

1. Modify the Contextfile 'CTXORIG.xml', whcih is created by the pre-cloning script, which is found under the Database $ORACLE_HOME/appsutil/clone/context/db directory :

ORIGINAL :


ACTION :

UPDATE the file with the SID name of the TARGET Instance, e.g. TEST :


Please Note :
The modification can be implemented after the pre-cloning STEPS - before STARTING the 'adcfgclone dbTier' . This works best when done on the target system, after you have copied the files from source.

If the Clone has already failed, the workaround/solution would be :

1. correct the s_db_listener value in the Target context file named '_.xml' located under the DB $ORACLE_HOME/appsutil
2. shutdown the target Database
3. execute 'perl adcfgclone.pl dbTier

 Error B:

System parameter file is $RDBMS_ORACLE_HOME/network/admin/clone_dbclone/listener.ora
Log messages written to $RDBMS_ORACLE_HOME/network/admin/clone.log
Error listening on: (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCclone))
TNS-12555: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00525: Insufficient privilege for operation
Linux IA64 Error: 1: Operation not permitted
 
Solution B :


Please Apply the following solution:

1- change permission /var/tmp/ . oracle

[root@dbclone tmp]# chmod -R 777 .oracle/

Friday, October 16, 2015

Understanding and Managing Licensing Options in Oracle E-Business Suite


To BottomTo Bottom

This knowledge document describes the licensing options for Oracle E-Business Suite applications products.
The most current version of this document can be obtained in My Oracle Support Knowledge Document 1639705.1.
There is a change log at the end of this document.

In This Document

This document is divided into the following sections:

Section 1: Licensing Options

Oracle E-Business Suite applications products can be activated from Rapid Install or from License Manager within Oracle Applications Manager.
From Rapid Install, applications products can be activated for the following license models:
  • License E-Business Suite (Suite Licensing)
  • License Component Applications (Component Licensing)
Install Oracle E-Business Suite - Licensing Selection window
From License Manager, applications products can be activated as follows:
  • License E-Business Suite
  • License Component Application
  • License Applications Product
Oracle Applications Manager Web Site

1.1 License E-Business Suite

This option is used to register a predefined set of Oracle E-Business Suite applications products. This licensing model allows wide access to applications functionality and will automatically register all applications products included in Oracle E-Business Suite.
The applications products that are preselected are licensed automatically as a part of the suite. The ones that are not checked are usually not part of the Oracle E-Business Suite price bundle and must be registered separately as add-on products.
Install Oracle E-Business Suite - License additional products screen

1.2 License Component Applications

This option is used to register applications products by component applications. You should choose this option if your licensing agreement is for individual applications component products.
These products are licensed based on the number of authorized users or on the number of business transactions processed. All individual applications products are listed on this screen.
License products screen

1.3 License Applications Products

This option is only available through License Manager in Oracle Applications Manager, and allows you to register individual Oracle E-Business Suite applications products. This option is generally used for off-cycle products (those that are released between release update packs) or for products not explicitly included in the product family groupings.
Oracle Applications Manager - Applications products page
License Manager does not set up license agreements or determine pricing, but performs the registration procedure that makes new components accessible to all Oracle E-Business Suite utilities. License Manager simply applies the logic defined by the Oracle Pricing guidelines.
Contact your sales representative if you have any questions about the most appropriate licensing options for your organization.

Section 2: Activating Oracle E-Business Suite Products

Rapid Install lays down the files for all Oracle E-Business Suite applications products regardless of their license status. However, the products must be marked as licensed so they can be identified as active components of Oracle E-Business Suite. This information is stored in the STATUS column in the FND_PRODUCT_INSTALLATIONS table.
You can check the status by running the following query with the APPS account in SQL*Plus:
set pages 20000;
col application_id for 9999;
col application_name for A50;
col status for A1;
col application_short_name for A10;
select fa.application_id,
fa.application_short_name,
fpi.status,
fatl.application_name
from
fnd_product_installations fpi,
fnd_application fa,
fnd_application_tl fatl
where
(
fa.application_id = fpi.application_id and
fa.application_id = fatl.application_id and
fatl.language = 'US'
)
order by fa.application_short_name;
The possible values for STATUS are:
  • I - Installed
  • N - Not Installed
  • S - Shared
There is both a functional and technical impact in Oracle E-Business Suite when activating applications products in the FND_PRODUCT_INSTALLATIONS table.
  • From the technical perspective, an Installed flag marks products for inclusion in patching and other tasks that will be performed to update and maintain the system after the initial installation.
  • From a functional point of view, the behavior of some products and how they interact with each other may change depending on their status in this table.
Note: As a best practice and to avoid any functional issues, always perform a full backup of your Oracle E-Business Suite database before activating any product.

Section 3: Product Dependencies

When processing a product, Rapid Install and License Manager automatically calculate the dependencies with other products and set all dependent products to Shared or Fully Installed if needed.
The product dependencies are constructed by using the following files:
  • RapidWiz.ini
  • adlicmgr.ini
  • applprod.txt

3.1 RapidWiz.ini and adlicmgr.ini

Used by Rapid Install, RapidWiz.ini is located under /startCD/Disk1/rapidwiz.
The counterpart of RapidWiz.iniadlicmgr.ini is used by the License Manager component of Oracle Applications Manager. This file is located under $AD_TOP/resource in Release 11i, and under $AD_TOP/admin/template in Release 12.x. The files differ only in that RapidWiz.ini contains additional information for the exclusive use of Rapid Install.
The [Product Groupings] section in these files includes the list of the application IDs for the products that will be activated when selecting each family.
For example:
Financials={101,140,200,222,240,260,600,8400,8401,8450,8901,231,673}
The above application IDs correspond to the following Oracle E-Business Suite applications:
GL,OFA,AP,AR,PN,CE,AX,IGI,PSB,PSA,FV,BNE,IBY
Note: The application IDs and corresponding application short names can be obtained from the APPLICATION_ID and APPLICATION_SHORT_NAME columns in the FND_APPLICATION table.

3.2 applprod.txt

This file is located under $APPL_TOP/admin, and contains all the dependency information between Oracle E-Business Suite applications products. This file dictates which other dependent products will be set as Fully Installed or Shared when selecting a particular product.
The following example shows the dependencies for Oracle Payables in bold italics.
# ##################################################
# Payables
# ##################################################
#
# application id, abbreviation, shortname, prefix
200 ap SQLAP APP
# multiple product installations for msob, "controlled release", shared only
# optional fourth field is "stub product". default is No
Yes No No No
# multilingual, has NLADD.sql
Yes Yes
# install oracle id, default ORACLE username, default ORACLE password
200 AP AP
# concurrent conflict set id (logical database id)
0
# minimum version you can upgrade from, for shared and for fully-installed
8.0.57 8.0.57
# shared products; this lists fnd and some subset of:
fnd ax ak az gl inv po fa ar ont as per pay mfg bom eng wip pa dt xla ce qa crp mrp ff
# product libraries needed for "make -f .mk all"
fnd alr inv bom crp eng mrp wip po gl ar pay ff dt ap fa
# when install this product, set these other products to install
ax ak az
# requires that these other products are fully installed or installing
ax ak az
#

Section 4: Product Families and Product Activation

When you perform a new installation, you will first select a product family, which in turn will ultimately activate products that are included in that particular family.

When you choose the License E-Business Suite option, License Manager will look at the following entry in adlicmgr.ini:
[Suite Products]
Suite Families={Basic,Marketing & Sales Intelligence,Supply Chain & Order Management Intelligence,Procurement Intelligence,Service Intelligence,Projects intelligence,Financials Intelligence,Balanced Scorecard,Enterprise Planning and Budgeting,Profitability Manager,Marketing,TeleSales,Field Sales,Order Management,Inventory Management,Purchasing,Discrete Manufacturing,Process Manufacturing,TeleService,Service Contracts,Project Costing,Project Billing,Financials,Human Resources}
When you choose the License Component Application option, License Manager will look at the following entry in adlicmgr.ini:
[Product Families]
All Families={All,Intelligence,Marketing & Sales,Channel Revenue Management,Order Management,Logistics,Supply Chain Planning,Procurement,Manufacturing,Asset Lifecycle Management,Service,Projects,Product Lifecycle Management,Financial,Human Resources,Learning Management,Master Data Management - Customer Hub for B2B,Master Data Management - Customer Hub for B2C,Master Data Management - Site Hub,Master Data Management - Administrative & Development,Master Data Management - Product Information Management,Master Data Management - Vertical Product Hub,Product Hub Options,Interaction Center Technology,Financial Services,Communications/Utilities,Public Sector/University,High Tech,Aerospace Defense and Transportation}
When you select a product family, for example "Service Contracts", License Manager will search for the entry Service Contracts={515,870,542} to obtain the initial list of application IDs. With that list, License Manager will look at entries in applprod.txt that correspond to those application IDs and will create the dependency tree for the rest of the products that need to be activated. In other words, License Manager will fully activate the three products included in Service Contracts (515, 870 and 542), searching inapplprod.txt for all their dependent products and setting them to Shared or Fully Installed accordingly. This will occur for each product that is fully activated.
From the dependent list, License Manager will set all the products from the Shared list to Shared and all the products from the Fully Installed list to Fully Installed. Shared products will not fully activate other products. Only fully activated products will cause License Manager to look at all the dependencies that need to be Shared or Fully Installed.

Section 5: Unlicensing a Product

Unlicensing a product is not supported. Some applications will behave differently if some modules are fully activated or shared. Changing a product from Fully Installed to Shared or Not Installed may cause result in unpredictable behavior, especially if you continue to use Oracle E-Business Suite after the product was activated.
Note: Oracle strongly recommends that you never use SQL*Plus, database triggers, or any other tool to manually modify Oracle E-Business Suite data unless otherwise instructed by Oracle Development.
If you inadvertently activate a product, you have two options:
  • Restore a full backup of the Oracle E-Business Suite database from before you activated the offending product.
This is our preferred and supported recommendation to assure data consistency, since there is a functional impact on Oracle E-Business Suite: any transactions executed as a result of incorrectly activating a product would result in an unpredictable state within the product dependencies.
  • Export and import the FND_PRODUCT_INSTALLATIONS table with the state from before you activated the offending product.
Although this is the only table used by License Manager, this option is only feasible if no Oracle E-Business products at all were used after the offending product was incorrectly activated. If you are not certain whether Oracle E-Business Suite was used, we recommend you seek assistance from the relevant product support team to determine if there could be any adverse functional impact.

R12.2 Informatin documents

GOAL

 This document serves to provide engineers, with a list of useful 12.2 documents to help support customers through the initial stages of general availability

SOLUTION

newHow to be notified when MOS notes are updated here

Start Here !
Oracle E-Business Suite Release 12.2 Information Center Note 1581299.1
Oracle E-Business Suite Release 12.2: Technical Planning, Getting Started, and Go-Live Checklist Note 1585857.1

Media Packs (edelivery)
here

12.2 Documentation
http://docs.oracle.com/cd/E26401_01/index.htm Always use this Web Library as it contains the most recent versions of the documentation
Oracle E-Business Suite Release Notes, Release 12.2 Note 1320300.1 Very Important!. Read this before/during/after upgrade/install (contains checksums)
newOracle E-Business Suite Release 12.2 Technology Stack Documentation Roadmap Note 1934915.1

EBS 12.2 Stage Creation Information
R12.2: How To Create the Stage In Preparation For Installation Note 1596433.1
See the official installation guide for information on creating the EBS 12.2 stage

newStartCD 49 is now released ! (LATEST)  See Patch 19378467
Important StartCD 48 & 49 Information: Resolving Domain Deployment Issues When Installing Oracle E-Business Suite Release 12.2 Note 1906545.1
Blog Announcement here

newImportant: New Connection Handling Fixes (improves performance) Blog Announcement here

newChanging Hostnames, IP address or looking for Admin Server high availability?
Configuring Oracle E-Business Suite Release 12.x Using Logical Host Names Note 1968231.1
Blog Announcement here


11.2.0.4 News - Oracle Database 11g Release 2 Version 11.2.0.4 is NOW certified on some platforms for 12.2 Tip, 11.2.0.4 DB often means less one off-patches and less less one-off conflicts

Planning
Oracle E-Business Suite Release 12.2: Technical Planning, Getting Started, and Go-Live Checklist Note 1585857.1
Which Oracle E-Business Suite Release Should You Target: 12.1 or 12.2? Note 1592197.1
Oracle E-Business Suite Release 12.2: Upgrade Sizing and Best Practices Note 1597531.1
EBS File Comparison Report [VIDEO] Note 1446430.1
11i - 12 EBS Data Model Comparison Report Overview  Note 1290886.1 Object definition changes for 12.2
Oracle E-Business Suite Upgrades and Platform Migration Note 1377213.1
See the installation guide for sizing and managed server recommendations
Oracle E-Business Suite Release 12.1 and 12.2 Transfer of Information (TOI) Online Training Note 807319.1
Choosing a Shared File System for Oracle E-Business Suite here
EBS ATG Seed Data Comparison Report  Note 1327399.1

Reducing Upgrade DowntimeBest Practices for Minimizing Oracle E-Business Suite Release 12 Upgrade Downtime Note 1581549.1
Udayan and Samer's presentation at OOW provides a summary of methods in reducing upgrade downtime: Here

Upgrade Advisors
Upgrade Advisor: E-Business Suite (EBS) 11i Upgrade to 12.2 Note 1614508.1
Upgrade Advisor: E-Business Suite (EBS) Upgrade from 12.0/12.1 to 12.2.x Note 1593640.1

Database Preparation
Database Preparation Guidelines for an E-Business Suite Release 12.2 Upgrade Note 1349240.1
Database Patch Set Update Overlay Patches Required for Use with PSUs and Oracle E-Business Suite Note 1147107.1 resource for database patch conflicts
Database Initialization Parameters for Oracle E-Business Suite Release 12 Note 396009.1 Contains 12.2 specific settings
Oracle E-Business Suite Release 11i & R12 Patches Required with Oracle Database 11g Release 2 (11.2.0) on Exadata Note 1392527.1
Interoperability Notes E-Business Suite Release 12.2 with Database 11g Release 2 Note 1623879.1
Installing Oracle Applications Suite 12.2.2 on RAC and 2 AppsTiers with Shared APPL_TOP and ASM (external, non-Oracle)..here
How to use the My Oracle Support Conflict Checker Tool [Video] Note 1091294.1
Export/Import Process for Oracle E-Business Suite Release 12.2 Database Instances Using Oracle Database 11.2 Note 1613716.1
Checks and Potential Issues Installing EBS R12.2 on RAC Cluster using Rapid Install Note 1595139.1
Business Continuity for Oracle E-Business Release 12 Using Oracle 11g Release 2 and Later Physical Standby Database Note 1070033.1
Using Oracle 11g Release 2 Real Application Clusters and Automatic storage management with Oracle E-Business Suite Release 12.2 Note 1453213.1
Using TDE Tablespace Encryption with Oracle E-Business Suite Release 12.2 Note 1585296.1
Using Active Data Guard Reporting with Oracle E-Business Suite Release 12.2 and Oracle Databases 11g and 12c (12.1.0.1 and 12.1.0.2) Note 1944539.1
Oracle Active Data Guard 11.2.0.4 Certified with EBS 12.2.3 here
Using Oracle Database In-Memory with Oracle E-Business Suite Note 2025309.1, Blog announcement here
Business Continuity for Oracle E-Business Suite Release 12.2 Using Oracle 12c (12.1.0.2) Physical Standby Database Note 1963472.
Transportable Databases for EBS Release12.2 Note 2011169.1
Transportable Database 12c Certified for EBS 12.2 Database Migration here
Oracle Data Guard 11.2.0.4 Certified with EBS 12.2 here


Database 12c *NEW*
Interoperability Notes Oracle EBS 12.2 with Oracle Database 12c Release 1 Note 1926201.1
Using Oracle 12c Release 1 (12.1) Real Application Clusters with Oracle E-Business Suite Release R12.2 Note 1626606.1
Using TDE Column Encryption with Oracle E-Business Suite Release 12.2 Note 1585696.1
Using TDE Tablespace Encryption with Oracle E-Business Suite Release 12.2 on Oracle Database 12c Release 1 (12.1.0) Note 1926686.1
Export/Import Process for Oracle EBS 12.2 Using Oracle Database 12c Release 1 Note 1926203.1
Using Oracle EBS 12.2 with a Database Tier Only Platform on Oracle Database 12c Release 1 Note 1926202.1
Blog Announcement here 12.1.0.1
Blog Announcement here 12.1.0.2

Operating System Preparation
Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for IBM AIX on Power Systems (64-bit) Note 1330703.1
Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Linux x86-64 Note 1330701.1 Save Time! ...try the Pre-Install RPM, available for Linux 5 and 6
Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Oracle Solaris on SPARC (64-bit) Note 1330702.1
Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for HP-UX Itanium Note 1330704.1
Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Microsoft Windows x64 (64-bit) Note 1330706.1
Oracle E-Business Suite Technology Stack Release Notes for Release 12.2 Note 1376618.1
Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for HP-UX Itanium Note 1330704.1
Oracle VM Virtual Appliances for Oracle E-Business Suite Deployment Guide, Release 12.2.3 Note 1620448.1
Oracle VM Virtual Appliances for Oracle E-Business Suite Deployment Guide, Release 12.2.4 Note 1928303.1
Certified Oracle Solaris and SPARC Virtualization and Partitioning Technologies for Oracle E-Business Suite Note 1234632.1
REDHAT6 - 12.2.2 Rapid Install Preinstall Checks Note 1588970.1
EBS 12.2 now certified on Oracle Linux 7 and Red Hat Enterprise Linux 7 - Blog announcement here
Rapid Install and Stage
MD5 Checksums for R12.2 Rapid Install Media Note 1505510.1
RDA - Health Check / Validation Engine Guide Note 250262.1
Checks and Potential Issues Installing EBS R12.2 on RAC Cluster using Rapid Install Note 1595139.1
R12.1 and 12.2 Oracle E-Business Suite Preinstall Patches Report [Video]
Understanding and Managing Licensing Options in Oracle E-Business Suite Note 1639705.1

Release Notes
Oracle E-Business Suite Release Notes, Release 12.2 Note 1320300.1 contains database patch checker steps and checksums
Oracle E-Business Suite Technology Stack and Applications DBA Release Notes for Release 12.2.3 Note 1606170.1
Oracle Application Framework Release Notes for Release 12.2.3 Note 1593782.1
Oracle E-Business Suite Product Specific Release Notes, Release 12.2.4 Note 1903217.1

Upgrade Performance
Express Diagnosis of Oracle E-Business Suite Release 12 Upgrade Performance Issues Note 1583752.1
Best Practices for Minimizing Oracle E-Business Suite Release 12.1.3 and 12.2.n Upgrade Downtime Note 1581549.1

Online Enablement
Using the Online Patching Readiness Report in Oracle E-Business Suite Release 12.2 Note 1531121.1

CPU and Security Related Information
Oracle E-Business Suite Releases 11i and 12 Critical Patch Update Knowledge Document (January 2014) Note 1605340.1
Secure Configuration Guide for Oracle E-Business Suite Release 12 Note 403537.1
Release 12.2 Flexfield Value Set Security Documentation Update for Patch 17305947:R12.FND.C Note 1589204.1
Sensitive Administrative Pages in Oracle E-Business Suite Note 1334930.1
Oracle E-Business Suite Releases 11i and 12 Critical Patch Update Knowledge Document (July 2014) Note 1668237.1
Oracle E-Business Suite Releases 11i and 12 Critical Patch Update Knowledge Document (October 2014) Note 1923805.1
Oracle E-Business Suite Releases 11i and 12 Critical Patch Update Knowledge Document (January 2015) Note 1954250.1
Oracle E-Business Suite Releases 11i and 12 Critical Patch Update Knowledge Document (April 2015) Note 1986100.1
newOracle E-Business Suite Releases 11i and 12 Critical Patch Update Knowledge Document (July 2015) Note 2013117.1


FAQ's
Oracle E-Business Suite Release 12.2: Online Patching FAQ Note 1583902.1
Oracle E-Business Suite Release 12.2 - Frequently Asked Questions Note 1471962.1
Frequently Asked Questions About Using AutoConfig With Oracle Applications Release 12.2 Note 1352571.1

newAD and TXK C Delta 7
Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 Note 1617461.1
Oracle E-Business Suite Applications DBA and Technology Stack Release Notes for R12.AD.C.Delta.7 and R12.TXK.C.Delta.7 Note 2033780.1
Applying A Non-Current Version of the AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 Note 1903052.1
Blog Announcement here

AD and TXK C Delta 6
Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 Note 1617461.1
Oracle E-Business Suite Applications DBA and Technology Stack Release Notes for R12.AD.C.Delta.6 and R12.TXK.C.Delta.6 Note 1983782.1
Applying A Non-Current Version of the AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 Note 1903052.1
Blog Announcement here

AD and TXK C Delta 5 
Oracle E-Business Suite Technology Stack and Applications DBA Release Notes for R12.TXK.C.Delta.5 and R12.AD.C.Delta.5 Note 1644660.1
Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 Note 1617461.1
E-Business Suite RUP, AD and TXK RUP Information, Release 12.2 Note 1583092.1
Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes Note 1594274.1
Oracle E-Business Suite Release 12.2: Validations Performed By the adop Online Patching Utility Note 1678355.1
Oracle E-Business Suite Release 12.2: Suite-Wide Rollup and AD/TXK Delta Information Note 1583092.1
Oracle E-Business Suite Release 12.2:Now Available - Essential Bundle Fixes for AD Delta 5 and TXK Delta 5 Note 1934471.1
Blog announcement here

AD and TXK C Delta 4
Oracle E-Business Suite Technology Stack and Applications DBA Release Notes for R12.TXK.C.Delta.4 and R12.AD.C.Delta.4 Note 1624423.1
Applying A Non-Current Version of the AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 Note 1903052.1
E-Business Suite RUP, AD and TXK RUP Information, Release 12.2 Note 1583092.1
Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes Note 1594274.1
Oracle E-Business Suite Release 12.2: Now Available - Essential Consolidated Rollup Patches for AD Delta 4 and TXK Delta 4 Note 1674784.1
Blog announcement here
Oracle E-Business Suite Release 12.2: Validations Performed By the adop Online Patching Utility Note 1678355.1

12.2.4 *Latest*
Oracle E-Business Suite Release 12.2.4 Readme Note 1617458.1
Blog announcement here
R12.1 / R12.2 : Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Documents Note 1302189.1
New User Interface - Blog announcement here
New Simplified Home Page in EBS 12.2.4 - Blog announcement here
Oracle E-Business Suite Release 12.2.4 Upgrade Considerations for OA Framework-based Applications Note 1927975.1


12.2.3
Oracle E-Business Suite Release Notes, Release 12.2 Note 1320300.1
Oracle E-Business Suite Release 12.2.3 Readme Note 1586214.1
Applying the 12.2.3 AD and TXK Release Update Pack Note 1586217.1
E-Business Suite RUP, AD and TXK RUP Information, Release 12.2 Note 1583092.1
Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes Note 1594274.1


12.2.2 *Not Recommended*
Oracle E-Business Suite Release 12.2.2 Readme Note 1506669.1
Applying the 12.2.2 AD and TXK Release Update Pack Note 1560906.1
Oracle E-Business Suite Technology Stack Release Notes for Release 12.2.2 Note 1376618.1
Oracle E-Business Suite Release Notes, Release 12.2 Note 1320300.1


Cloning
Cloning Oracle E-Business Suite Release 12.2 with Rapid Clone Note 1383621.1
Cloning Oracle E-Business Suite Release 12.2 RAC Enabled Systems with Rapid Clone Note 1679270.1 RAC to RAC Cloning is now certified
Blog Announcement here
Cloning Oracle E-Business Suite Release 12.2 Environments integrated with Oracle Access Manager 11gR2 (11.1.2) and Oracle E-Business Suite AccessGate Note 1614793.1


Technology Stack
Enabling SSL in Oracle E-Business Suite Release 12.2 Note 1367293.1
Oracle E-Business Suite Release 12.2 Configuration in a DMZ Note 1375670.1
Using Load-Balancers with Oracle E-Business Suite Release 12.2 Note 1375686.1 contains information on WLS clustering
Using Forms Socket Mode with Oracle E-Business Suite Release 12 Note 384241.1
Using the Latest JDK 7.0 Update with Oracle E-Business Suite Release 12.2 Note 1530033.1
Using JDK 6.0 Latest Update with Oracle E-Business Suite Release 12.2 Note 1459546.1
Sharing The Application Tier File System in Oracle E-Business Suite Release 12.2 Note 1375769.1
Using AutoConfig to Manage System Configurations in Oracle E-Business Suite Release 12.2 see the Setup Guide
Upgrading Oracle Fusion Middleware Technology Stack of Oracle E-Business Suite Release 12.2 to 11.1.1.7(11gR1 PS6) Note 1590356.1
Best Practices for Deploying EBS 12.2 on Oracle Database Appliance here
Business Continuity for Oracle E-Business Release 12.2 Using Oracle 11g Physical Standby Database Note 1491855.1
How To Change or Reset The WebLogic Administration Password In 12.2 E-Business Suite Note 1385751.1
R12.2 How To Re-attach Oracle Homes To The Central Inventory Note 1586607.1
JSP Page Handling and File Locations in Release 12.2 Note 1928874.1
Oracle E-Business Suite Release 12.2: Adding or Deleting 11gR2 Oracle RAC Nodes Note 1570554.1
Release 12.2 OHS configuration File maintenance Note 1676430.1 Oracle internal only

Performance and TuningOracle E-Business Suite Recommended Performance Patches Note 244040.1
Oracle Fusion Middleware - Performance and Tuning for Oracle WebLogic Server 11g Release 1 (10.3.6) here

Framework
Oracle Application Framework Profile Options, Release 12.2.3 Note 1593843.1
Oracle Application Framework Development FAQ Release 12.2 Note 1455932.1
Oracle Application Framework Release Notes for Release 12.2.3 Note 1593782.1
Oracle Application Framework Release Notes for Release 12.2.4 Note 1676223.1
11i - 12.2 Oracle Application Framework Troubleshooting Guide Note 1496055.1

Managed Server Related InformationManaging Configuration of Oracle HTTP Server and Oacore, Oafm, Forms and Forms-c4ws Applications in Oracle E-Business Suite Release 12.2 Note 1905593.1
How To Install And Integrate Jrockit Mission Control With Ebusiness Suite 12.2 Note 1377695.1
ORACLE JRockit and Memory Consumption - Memory Leaks In Java Heap Note 1137239.1
Using Oracle Fusion Middleware Diagnostic Framework With Oracle E-Business Suite Release 12.2 Note 1428056.1 Thread dumps and incident capture
12.2 Debgging Managed Server Performance and Stability Note 1908444.1 Internal Only
Different ways to take thread dumps in WebLogic Server Note 1098691.1
Why is my JVM process larger than my max heap size? Here
Oracle E-Business Suite 12.2 Data Source Connection Pool Diagnostics Note 1940996.1

Patching
Oracle E-Business Suite 12.2 Patching Technology Components Guide Note 1355068.1
12.2: Running Maintenance Procedures During An Open Online Patching Cycle Note 1580108.1
List of features / programs disabled during online patching. See the Maintenance Guide 'Patching Procedures'
12.2: Functionality Disabled During An Online Patching Cycle Note 1586609.1
ADOP and Online Patching Quick Reference Guide for E-Business Suite 12.2 Note 1522734.1 Oracle internal only
Oracle E-Business Suite Release 12.2: Backup and Recovery Guidelines For Online Patching Cutover Note 1584097.1
Online Patching Troubleshooting Guidelines For Support Note 1642731.1 Oracle internal only
How To Automatically Set the Current Run Edition / File System for EBS 12.2 Note 1545584.1
Patching & Maintenance Advisor: E-Business Suite (EBS) R12.2 Note 1590494.1
How to Find E-Business Suite & E-Business Suite Technology Stack Patches Note 1633974.2
How to Restore An Abandoned Node in Oracle E-Business Suite Release 12.2 Note 1677498.1

Troubleshooting
12.2 Ebusiness Suite - Collecting Fusion Middleware Log Files Note 1362900.1
Rapid Install for E-Business Suite Release 12.2 Note 1378579.1 see appendix A for Rapid Install log file locations
Oracle Applications E-Business Suite 12.2 Fusion Middleware Log Files: Locate,View, and Control Note 1366187.1
Using Oracle Fusion Middleware Diagnostic Framework With Oracle E-Business Suite Release 12.2 Note 1428056.1 
12.2 E-Business Suite - Collecting Online Patching and fs_clone Log Files Note 1542162.1 Oracle internal only
Oracle E-Business Suite Integrated SOA Gateway Troubleshooting Guide, Release 12.2 Note 1317697.1
Oracle E-Business Suite Release 12.2: Resolving Database PSU Conflicts Note 1665813.1 Oracle internal only
12.2 E-Business Suite - How To Enable FND: Debug / AF Logging When Login Is Not Possible Note 1563168.1
Script to Diagnose adop and Other AD-TXK Issues in Oracle E-Business Suite Release 12.2 Note 1901242.1
EBS 12.2 - Summary Of The Login Process And What To Expect When One Of The Components Fails Note 1984710.1

Mobile
Oracle Mobile Approvals for Oracle E-Business Suite Implementation Guide, Release 12.1 and Release 12.2 Note 1642423.1
Oracle E-Business Suite Mobile Apps Administrator’s Guide for Release 12.1 and Release 12.2 Note 1642431.1
Oracle E-Business Suite Mobile Apps, Release 12.1 and 12.2 Documentation Note 1641772.1
Mobile Web Applications (MWA) Troubleshooting Tips for Release 12 Mobile Web Applications Server Note 782162.1

Integrations
Integrating Oracle E-Business Suite Release 12.2 with Oracle Access Manager 11gR1 (11.1.1.5.0) using Oracle E-Business Suite AccessGate Note 1368292.1
Using Discoverer 11.1.1 with Oracle E-Business Suite Release 12.2 Note 1380591.1
Using Oracle WebCenter 11.1.1 with Oracle E-Business Suite Release 12.2 Note 1332645.1
Using Oracle Portal 11.1.1 with Oracle E-Business Suite Release 12.2 Note 1381347.1
Integrating Oracle E-Business Suite Release 12.2 with Oracle Access Manager 11gR2 (11.1.2) using Oracle E-Business Suite AccessGate Note 1576425.1
Integrating Oracle E-Business Suite Release 12.2 with Oracle Internet Directory 11gR1 Note 1371932.1
R11i/R12.0/R12.1/R12.2 : Getting Started with Oracle Application Management Pack for Oracle E-Business Suite (AMP) Release 12.1.0.2.0 Note 1532970.1
Getting Started with Oracle Application Management Pack for Oracle E-Business Suite (AMP), Release 12.1.0.3.0 Note 1623105.1
Oracle E-Business Suite Extensions for Oracle Endeca Globalization Guide, Release 12.2 V5 Note 1613997.1
Oracle E-Business Suite Integrated SOA Gateway Release Notes for Release 12.2 Note 1374577.1
Integrating Oracle E-Business Suite Release 12.2 with Oracle BPEL in Oracle SOA Suite 11g R1 Note 1584883.1
Tutorial: Publishing EBS 12.2 PL/SQL APIs as REST Services here
Oracle Access Manager 11gR2 Patchset 3 (11.1.2.3.0) is now certified here
Using Application Management Suite With E-Business Suite 12.2 here


CustomizationsDeploying Customizations in Oracle E-Business Suite Release 12.2 Note 1577661.1
OA Framework - How to find the correct version of JDeveloper to use with eBusiness Suite 11i or Release 12.x Note 416708.1
How To Add Classes To The Classpath In The 12.2 E-Business Suite File System Note 1331703.1
Creating a Custom Application in Oracle E-Business Suite Release 12.2 Note 1577707.1
Guidance for Integrating Custom and Third-Party Products With Oracle E-Business Suite Release 12.2 Note 1916149.1
How to De-register a Custom Schema in the e-business Suite 12.2 Note 1644146.1
Preparing Your Customizations for EBS 12.2 here

Other
Oracle Web Applications Desktop Integrator Release Notes for Release 12.2 Note 1375758.1
Oracle E-Business Suite NLS Release Notes, Release 12.2 Note 1314621.1
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Documents Note 1302189.1
Oracle VM Templates for Oracle E-Business Suite Deployment Guide, Release 12.2 Note 1590941.1
Oracle VM Templates for Oracle E-Business Suite for Exalogic Deployment Guide, Release 12.2.4 Note 1954255.1
Oracle Application Framework Release Notes for Release 12.2.2 Note 1300894.1
Oracle Application Framework Release Notes for Release 12.2.3 Note 1593782.1
Oracle XML Gateway Release Notes for Release 12.2 Note  1374575.1
Oracle XML Gateway Release Notes for Release 12.2.3 Note 1604864.1


Functional References
Oracle E-Business Suite Product Specific Release Notes, Release 12.2.2 Note 1585844.1

Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Linux x86-64

GA (6.1) or higher of Oracle Linux 6 is required
GA (6.1) or higher of Red Hat Enterprise Linux (RHEL) 6 is required
Note: Oracle has released an E-Business Suite Pre-Install RPM (available on ULN and public yum) that includes all required rpms for both the application and database tiers of an R12 installation - please see the 'E-Business Suite Pre-Install RPM' section below for more details.
If not using the pre-install rpm, the following packages (or versions of packages) which are not part of the OS distribution media must be downloaded separately (from http://oss.oracle.com/projects/compat-oracle/files/Enterprise_Linux/) for both Oracle Linux 6 and RHEL 6 and installed manually on the application tier:
  • openmotif21-2.1.30-11.EL6.i686 (32-bit)1
  • xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386 (32-bit)
Additionally, the following rpm needs to be installed from the Oracle Linux 6 or RHEL 6 distribution media on the application tier:
  • libXrender-0.9.5-1.el6.i686
If not using the pre-install rpm, the following packages must be installed from the Oracle Linux 6 or RHEL 6 distribution media on both the application and database tiers:
  • binutils-2.20.51.0.2-5.20.el6.x86_64
  • compat-libstdc++-296-2.96-144.el6.i686
  • compat-libstdc++-33-3.2.3-69.el6.i686
  • gcc-4.4.5-6.el6.x86_64
  • gcc-c++-4.4.5-6.el6.x86_64
  • glibc-2.12-1.7.el6.i686 (32-bit)
  • glibc-2.12-1.7.el6.x86_64
  • glibc-common-2.12-1.7.el6.x86_64
  • glibc-devel-2.12-1.7.el6.i686 (32-bit)
  • glibc-devel-2.12-1.7.el6.x86_64
  • libgcc-4.4.4-13.el6.i686
  • libgcc-4.4.4-13.el6.x86_64
  • libstdc++-devel-4.4.4-13.el6.i686
  • libstdc++-devel-4.4.4-13.el6.x86_64
  • libstdc++-4.4.4-13.el6.i686
  • libstdc++-4.4.4-13.el6.x86_64
  • libXi-1.3-3.el6.i686
  • libXp-1.0.0-15.1.el6.i686
  • libXp-1.0.0-15.1.el6.x86_64
  • libXtst-1.0.99.2-3.el6.i686
  • libaio-0.3.107-10.el6.i686
  • libaio-0.3.107-10.el6.x86_64
  • libgomp-4.4.4-13.el6.x86_64
  • make-3.81-19.el6.x86_64
  • gdbm-1.8.0-36.el6.i686
  • gdbm-1.8.0-36.el6.x86_64
  • redhat-lsb-4.0-3.0.1.el6.x86_64
  • sysstat-9.0.4-11.el6.x86_64
  • util-linux-ng-2.17.2-6.el6.x86_64
Additionally, the following RPMs are required for the database tier (running Oracle Database 11gR2):
  • compat-libcap1-1.10-1.x86_64
  • compat-libstdc++-33-3.2.3-69.el6.x86_64
  • elfutils-libelf-devel-0.148.1-el6.x86_64
  • libaio-devel-0.3.107-10.el6.i686
  • libaio-devel-0.3.107-10.el6.x86_64
  • unixODBC-2.2.14-11.el6.i686
  • unixODBC-devel-2.2.14-11.el6.i686
  • xorg-x11-utils-7.4-8.el6.x86_64
Alternatively on the database tier, users can install the following pre-install rpm (available via ULN on http://linux.oracle.com or the Oracle Public yum repository on http://public-yum.oracle.com) :
  • oracle-rdbms-server-11gR2-preinstall.x86_64
The E-Business Suite Pre-Install RPM includes all the above required rpms and dependencies for running the application and database tiers - see the 'E-Business Suite Pre-Install RPM' section below for more details.
Note:
1: The openmotif package version must be 2.1.30 (for example, openmotif-2.3.3-1 is not supported). 

Wednesday, October 14, 2015

FAILED: file mth_pre_upgrade.sql on worker 15 for product mth username MTH. R12.1.3 Upgrade

ROR No:2 ( This error will occur, if we are running the patch for the second time)

FAILED: file mth_pre_upgrade.sql on worker 15 for product mth username MTH.
sqlplus -s MTH/***** @/u01/app/oracle/EBS/apps/apps_st/appl/mth/12.0.0/patch/115/sql/mth_pre_upgrade.sql
Connected.
DECLARE
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
ORA-06512: at line 59

Time when worker failed: Mon Apr 09 2012 00:28:06
"adwork002.log" 234201L, 8356714C         
Cause : As we have already started this patch. It created the table MTH_RESOURCES_D_TEMP. Hence we have to rename this as MTH_RESOURCES_D_TEMP_OLD.


SQL> conn mth/mth
Connected.
SQL> rename MTH_RESOURCES_D_TEMP to MTH_RESOURCES_D_TEMP_OLD;

Table renamed.

SQL> exit
1) Then, restart the worker using adctrl utility.