Showing posts with label EBS. Show all posts
Showing posts with label EBS. Show all posts
Tuesday, 10 March 2015
Thursday, 25 October 2012
Handy Oracle Support Notes for Apps DBA
Useful Articles for the Oracle E-Business Suite Technology Stack for Technical Consultant / DBA [ID 828157.1]
Installation
----------------------------------------------------------------------------------------------------
note 761564.1 Oracle Applications Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86
note 402310.1 Oracle Applications Installation and Upgrade notes Release 12 (12.0) for Linux (32-bit)
note 406982.1 Cloning Oracle Applications Release 12 with Rapid Clone
note 559518.1 Cloning Oracle E-Business Suite Release 12 RAC-Enabled Systems with Rapid Clone
note 421409.1 Unbreakable Linux enviroment check before R12 install
note 458533.1 How to Enable Enterprise Manager on the Oracle E-Business Suite Release 12
note 603716.1 Using AS10g AS Control with eBusiness Suite Rel 12
note 452120.1 How to locate the log files and troubleshoot RapidWiz for R12
note 316806.1 Oracle Applications Installation Update notes, Release 11i (11.5.10.2)
note:230672.1 Cloning Oracle Applications Release 11i with Rapid Clone
note 207296.1 How to Find out Linux Version Information?
Database
----------------------------------------------------------------------------------------------------
note:454750.1 Oracle Apps Release 12 with Oracle Database 10.2.0 interoperability notes
note 735276.1 Interoperability notes E-Business Suite R12 with Oracle Database 11gR1
note 388577.1 Configuring Oracle Applications Release 12 with 10g R2 RAC
note 466649.1 Using Oracle 11g Release 1 Real Application Clusters and Automatic Storage Management with Oracle E-Business Suite Release 12
note 216550.1 Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0)
note 362203.1 Oracle Applications Release 11i with Oracle 10g Release 2 (10.2.0)
note 452783.1 Oracle Applications Release 11i with Oracle 11g Release 1 (11.1.0)
note 362135.1 Configuring Oracle Applications Release 11i with 10g R2 RAC and ASM
note 554539.1 Using Database Partitioning with Oracle E-Business Suite
Java
----------------------------------------------------------------------------------------------------
note 418664.1 Overview of Using Java with Oracle E-Business Suite Release 12
note 455492.1 Using Latest Update of Java 6.0 with Oracle E-Business Suite Release 12
note 384249.1 Using Latest Update of JDK 5.0 with Oracle E-Business Suite Release 12note 300482.1 Overview of Using Java with Oracle E-Business Suite Release 11i
note 401561.1 Using J2SE Version 6 with Oracle E-Business Suite 11i
note 304099.1 Using J2SE Version 5.0 with Oracle E-Business Suite 11i, Release 11.5.10
note 246105.1 Upgrading to J2SE 1.4.2 with Oracle Applications 11
inote 130091.1 Upgrading Oracle Applications 11i to use JDK 1.3
JRE/Jinitiator/EBS Client Software
----------------------------------------------------------------------------------------------------
note 389422.1 Recommended Browsers for Oracle E-Business Suite Release 12
note 393931.1 Deploying Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12note 285218.1 Recommended Browsers for Oracle Applications 11
inote 290807.1 Deploying Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite 11i
note 124606.1 Upgrading JInitiator with Oracle E-Business Suite 11inote 1155883.1 Oracle E-Business Suite Desktop Client Hardware and Software Requirements
Forms
----------------------------------------------------------------------------------------------------
note 437878.1 Upgrading OracleAS 10g Forms and Reports in Oracle E-Business Suite Release 12Installation
----------------------------------------------------------------------------------------------------
note 761564.1 Oracle Applications Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86
note 402310.1 Oracle Applications Installation and Upgrade notes Release 12 (12.0) for Linux (32-bit)
note 406982.1 Cloning Oracle Applications Release 12 with Rapid Clone
note 559518.1 Cloning Oracle E-Business Suite Release 12 RAC-Enabled Systems with Rapid Clone
note 421409.1 Unbreakable Linux enviroment check before R12 install
note 458533.1 How to Enable Enterprise Manager on the Oracle E-Business Suite Release 12
note 603716.1 Using AS10g AS Control with eBusiness Suite Rel 12
note 452120.1 How to locate the log files and troubleshoot RapidWiz for R12
note 316806.1 Oracle Applications Installation Update notes, Release 11i (11.5.10.2)
note:230672.1 Cloning Oracle Applications Release 11i with Rapid Clone
note 207296.1 How to Find out Linux Version Information?
Database
----------------------------------------------------------------------------------------------------
note:454750.1 Oracle Apps Release 12 with Oracle Database 10.2.0 interoperability notes
note 735276.1 Interoperability notes E-Business Suite R12 with Oracle Database 11gR1
note 388577.1 Configuring Oracle Applications Release 12 with 10g R2 RAC
note 466649.1 Using Oracle 11g Release 1 Real Application Clusters and Automatic Storage Management with Oracle E-Business Suite Release 12
note 216550.1 Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0)
note 362203.1 Oracle Applications Release 11i with Oracle 10g Release 2 (10.2.0)
note 452783.1 Oracle Applications Release 11i with Oracle 11g Release 1 (11.1.0)
note 362135.1 Configuring Oracle Applications Release 11i with 10g R2 RAC and ASM
note 554539.1 Using Database Partitioning with Oracle E-Business Suite
SSO/OID
----------------------------------------------------------------------------------------------------
note 876539.1 Using the Latest Oracle Internet Directory 11gR1 Patchset with Oracle Single Sign-on and Oracle E-Business Suite
----------------------------------------------------------------------------------------------------
note 876539.1 Using the Latest Oracle Internet Directory 11gR1 Patchset with Oracle Single Sign-on and Oracle E-Business Suite
note 376811.1 Integrating Oracle E-Business Suite Release 12 with 10g AS Oracle Internet Directory and Oracle Single Sign-On
note 261914.1 Integrating Oracle E-Business Suite Release 11i with Oracle Internet Directory and Oracle Single Sign-On
note 444573.1 Basic checks for user integration when using Oracle E-Business Suite 11i with Oracle AS 10g
Performance
----------------------------------------------------------------------------------------------------
note 163208.1 bde_last_analyzed.sql - Verifies CBO Statistics
note 174605.1 bde_chk_cbo.sql - Reports Database Initialization Parameters related to an Apps 12 or 11i instance
note 396009.1 Database Initialization Parameters for Oracle Applications Release 12
note 216205.1 Database Initialization Parameters for Oracle Applications 11i
note 744143.1 Tuning performance on eBusiness suite
note 169935.1 Troubleshooting Oracle Applications Performance Issues
note 244040.1 Oracle E-Business Suite Recommended Performance Patches
Security
----------------------------------------------------------------------------------------------------
note 738923.1 Oracle E-Business Suite Releases 11i and 12 Critical Patch Update note (January 2009)
note 403537.1 Best Practices for Securing Oracle E-Business Suite Release 12
note 189367.1 Best Practices for Securing the E-Business Suite Release 11i
Ihelp
----------------------------------------------------------------------------------------------------
Note 740834.1 R12: Troubleshooting iHelp
Advanced Configurations
----------------------------------------------------------------------------------------------------
note 380483.1 Oracle E-Business Suite Release 12 Additional Configuration and Deployment Options
note 384248.1 Sharing The Application Tier File System in Oracle E-Business Suite Release 12
note 217368.1 Advanced Configurations and Topologies for Enterprise Deployments of E-Business Suite 11i
note 233428.1 Sharing the Application Tier File System in Oracle Applications 11i
note 233436.1 Installing Oracle Application Server 10g with Oracle E-Business Suite Release 11i
note 364439.1 Tips and Queries for Troubleshooting Advanced Topologies
DMZ
----------------------------------------------------------------------------------------------------
note 380490.1 Oracle E-Business Suite R12 Configuration in a DMZ
note 726953.1 Case History: Implementing a Reverse Proxy Alone in the DMZ Configuration - R12
note 287176.1 DMZ Configuration with Oracle E-Business Suite 11i
note 438744.1 Case History: Implementing a Reverse Proxy Alone in a DMZ Configuration - 11i
note 460564.1 Hints and Tips for Troubleshooting the URL Firewal
Loadbalancer
----------------------------------------------------------------------------------------------------
note 380489.1 Using Load-Balancers with Oracle E-Business Suite Release 12
note 727171.1 Implementing Load Balancing On Oracle E-Business Suite - Documentation For Specific Load Balancer Hardware
note 601694.1 How To Check Session Persistence On BigIP F5 And Cisco Ace Load Balancer Appliances
note 603325.1 Using Cisco ACE Series Application Control Engine with Oracle E-Business Suite Release 12
SSL
----------------------------------------------------------------------------------------------------
note 376700.1 Using SSL with Oracle E-Business Suite Release 12
note 261914.1 Integrating Oracle E-Business Suite Release 11i with Oracle Internet Directory and Oracle Single Sign-On
note 444573.1 Basic checks for user integration when using Oracle E-Business Suite 11i with Oracle AS 10g
Performance
----------------------------------------------------------------------------------------------------
note 163208.1 bde_last_analyzed.sql - Verifies CBO Statistics
note 174605.1 bde_chk_cbo.sql - Reports Database Initialization Parameters related to an Apps 12 or 11i instance
note 396009.1 Database Initialization Parameters for Oracle Applications Release 12
note 216205.1 Database Initialization Parameters for Oracle Applications 11i
note 744143.1 Tuning performance on eBusiness suite
note 169935.1 Troubleshooting Oracle Applications Performance Issues
note 244040.1 Oracle E-Business Suite Recommended Performance Patches
Security
----------------------------------------------------------------------------------------------------
note 738923.1 Oracle E-Business Suite Releases 11i and 12 Critical Patch Update note (January 2009)
note 403537.1 Best Practices for Securing Oracle E-Business Suite Release 12
note 189367.1 Best Practices for Securing the E-Business Suite Release 11i
Ihelp
----------------------------------------------------------------------------------------------------
Note 740834.1 R12: Troubleshooting iHelp
Advanced Configurations
----------------------------------------------------------------------------------------------------
note 380483.1 Oracle E-Business Suite Release 12 Additional Configuration and Deployment Options
note 384248.1 Sharing The Application Tier File System in Oracle E-Business Suite Release 12
note 217368.1 Advanced Configurations and Topologies for Enterprise Deployments of E-Business Suite 11i
note 233428.1 Sharing the Application Tier File System in Oracle Applications 11i
note 233436.1 Installing Oracle Application Server 10g with Oracle E-Business Suite Release 11i
note 364439.1 Tips and Queries for Troubleshooting Advanced Topologies
DMZ
----------------------------------------------------------------------------------------------------
note 380490.1 Oracle E-Business Suite R12 Configuration in a DMZ
note 726953.1 Case History: Implementing a Reverse Proxy Alone in the DMZ Configuration - R12
note 287176.1 DMZ Configuration with Oracle E-Business Suite 11i
note 438744.1 Case History: Implementing a Reverse Proxy Alone in a DMZ Configuration - 11i
note 460564.1 Hints and Tips for Troubleshooting the URL Firewal
Loadbalancer
----------------------------------------------------------------------------------------------------
note 380489.1 Using Load-Balancers with Oracle E-Business Suite Release 12
note 727171.1 Implementing Load Balancing On Oracle E-Business Suite - Documentation For Specific Load Balancer Hardware
note 601694.1 How To Check Session Persistence On BigIP F5 And Cisco Ace Load Balancer Appliances
note 603325.1 Using Cisco ACE Series Application Control Engine with Oracle E-Business Suite Release 12
SSL
----------------------------------------------------------------------------------------------------
note 376700.1 Using SSL with Oracle E-Business Suite Release 12
Note 1330799.1 Login Page Fails To Render On SSL Terminated Application Tiers
note 123718.1 11i A Guide to Understanding and Implementing SSL for Oracle Applications
----------------------------------------------------------------------------------------------------
note 418664.1 Overview of Using Java with Oracle E-Business Suite Release 12
note 455492.1 Using Latest Update of Java 6.0 with Oracle E-Business Suite Release 12
note 384249.1 Using Latest Update of JDK 5.0 with Oracle E-Business Suite Release 12note 300482.1 Overview of Using Java with Oracle E-Business Suite Release 11i
note 401561.1 Using J2SE Version 6 with Oracle E-Business Suite 11i
note 304099.1 Using J2SE Version 5.0 with Oracle E-Business Suite 11i, Release 11.5.10
note 246105.1 Upgrading to J2SE 1.4.2 with Oracle Applications 11
inote 130091.1 Upgrading Oracle Applications 11i to use JDK 1.3
JRE/Jinitiator/EBS Client Software
----------------------------------------------------------------------------------------------------
note 389422.1 Recommended Browsers for Oracle E-Business Suite Release 12
note 393931.1 Deploying Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12note 285218.1 Recommended Browsers for Oracle Applications 11
inote 290807.1 Deploying Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite 11i
note 124606.1 Upgrading JInitiator with Oracle E-Business Suite 11inote 1155883.1 Oracle E-Business Suite Desktop Client Hardware and Software Requirements
Forms
----------------------------------------------------------------------------------------------------
note 750359.1 Upgrading to Previous Version of OracleAS 10g Forms and Reports in Oracle E-Business Suite Release 12
note 384241.1 Using Forms Socket Mode with Oracle E-Business Suite Release 12
note 438652.1 R12 Forms Runtime Diagnostics (FRD), Tracing And Logging For Forms In Oracle Applicationsnote 125767.1 Upgrading Developer 6i with Oracle Applications 11i
note 232313.1 Information on Previous Versions of Developer 6i Patchsets
note 201340.1 Using Forms Listener Servlet with Oracle Applications 11i
note 150168.1 Obtaining Forms Runtime Diagnostics (FRD) In Oracle Applications 11i
note 760250.1 Diagnosing Forms Mouse Focus Problems Using JRE in Release 11inote 1207184.1 Enhanced Signing of Oracle E-Business Suite JAR Files
OracleAS
----------------------------------------------------------------------------------------------------
note 454811.1 Upgrading to the Latest OracleAS 10g 10.1.3.x Patch Set in Oracle E-Business Suite Release 12
note 743518.1 Starting up AS10g services in an EBusiness Suite Release 12 environment
JDBC
----------------------------------------------------------------------------------------------------
note 557194.1 monitor_jdbc_conn.sql - Script to monitor JDBC connections in Apps eBusiness Suite
note 427759.1 How To Prevent Inactive JDBC Connections In Oracle Applications
JVM
----------------------------------------------------------------------------------------------------
note 362851.1 Guidelines to setup the JVM in Apps Ebusiness Suite 11i and R12
note 567551.1 Configuring various JVM tuning parameters for Oracle E-Business suite 11i and R12
note 370583.1 Basic troubleshooting of JVM consuming cpu or too many JDBC connections in Apps 11i
Apache/mod_jserv
----------------------------------------------------------------------------------------------------
note 230688.1 11i Basic Apache/mod_jserv Troubleshooting with Hello.class
Debug/Trace
----------------------------------------------------------------------------------------------------
note 422419.1 R12 - How To Enable and Collect Debug for HTTP, OC4J and OPMN
Note 443671.1 R12 - Collecting Configuration Information for HTTP, OC4J and OPMN
note 427848.1 How to Enable Execution Context ID (ECID) in the R12 access_log
note 455154.1 R12: How To Obtain A Thread Dump When OC4J is shutdown
note 603390.1 How To Create a User Event Trace in R11i / R12
OA Framework
----------------------------------------------------------------------------------------------------
note 391554.1 Oracle Application Framework Documentation Resources, Release 12
note 275880.1 Oracle Application Framework Release 11i Documentation Road Map
note 275875.1 Oracle Application Framework Troubleshooting Release 11i (11.5.10)
note 357597.1 How To Generate A SQL Trace In OA Framework For Oracle Applications
WebCache
----------------------------------------------------------------------------------------------------
note 380486.1 Installing and Configuring Web Cache 10g and Oracle E-Business Suite 12
note 306653.1 Installing and Configuring Web Cache 10.1.2 and Oracle E-Business Suite 11i
JDeveloper
----------------------------------------------------------------------------------------------------
note 330236.1 Configuring JDeveloper For Use With Oracle Applications 11i and R12
note 357218.1 Troubleshooting JDeveloper setup for Oracle Applications
note 416708.1 How to find the correct version of JDeveloper to use with eBusiness Suite 11i or Release 12.x
JVM
----------------------------------------------------------------------------------------------------
note 362851.1 Guidelines to setup the JVM in Apps Ebusiness Suite 11i and R12
note 567551.1 Configuring various JVM tuning parameters for Oracle E-Business suite 11i and R12
note 370583.1 Basic troubleshooting of JVM consuming cpu or too many JDBC connections in Apps 11i
Apache/mod_jserv
----------------------------------------------------------------------------------------------------
note 230688.1 11i Basic Apache/mod_jserv Troubleshooting with Hello.class
Debug/Trace
----------------------------------------------------------------------------------------------------
note 422419.1 R12 - How To Enable and Collect Debug for HTTP, OC4J and OPMN
Note 443671.1 R12 - Collecting Configuration Information for HTTP, OC4J and OPMN
note 427848.1 How to Enable Execution Context ID (ECID) in the R12 access_log
note 455154.1 R12: How To Obtain A Thread Dump When OC4J is shutdown
note 603390.1 How To Create a User Event Trace in R11i / R12
OA Framework
----------------------------------------------------------------------------------------------------
note 391554.1 Oracle Application Framework Documentation Resources, Release 12
note 275880.1 Oracle Application Framework Release 11i Documentation Road Map
note 275875.1 Oracle Application Framework Troubleshooting Release 11i (11.5.10)
note 357597.1 How To Generate A SQL Trace In OA Framework For Oracle Applications
WebCache
----------------------------------------------------------------------------------------------------
note 380486.1 Installing and Configuring Web Cache 10g and Oracle E-Business Suite 12
note 306653.1 Installing and Configuring Web Cache 10.1.2 and Oracle E-Business Suite 11i
JDeveloper
----------------------------------------------------------------------------------------------------
note 330236.1 Configuring JDeveloper For Use With Oracle Applications 11i and R12
note 357218.1 Troubleshooting JDeveloper setup for Oracle Applications
note 416708.1 How to find the correct version of JDeveloper to use with eBusiness Suite 11i or Release 12.x
Portal
----------------------------------------------------------------------------------------------------
note 380484.1 Using Oracle Portal 10g with Oracle E-Business Suite Release 12
note 305918.1 Using Oracle Portal 10g with Oracle E-Business Suite Release 11i
Orace Access Manager / AccessGate
----------------------------------------------------------------------------------------------------
note 975182.1 Integrating Oracle E-Business Suite with Oracle Access Manager using Oracle E-Business Suite AccessGate
note 1077460.1 Troubleshooting Oracle Access Manager and Oracle E-Business Suite AccessGate
Webcenter
----------------------------------------------------------------------------------------------------
note 1074345.1 Using WebCenter 11.1.1 with Oracle E-Business Suite Release 12
Orace Access Manager / AccessGate
----------------------------------------------------------------------------------------------------
note 975182.1 Integrating Oracle E-Business Suite with Oracle Access Manager using Oracle E-Business Suite AccessGate
note 1077460.1 Troubleshooting Oracle Access Manager and Oracle E-Business Suite AccessGate
Webcenter
----------------------------------------------------------------------------------------------------
note 1074345.1 Using WebCenter 11.1.1 with Oracle E-Business Suite Release 12
note 557221.1 Oracle WebCenter 10g Application Creation and Deployment Guide for Oracle E-Business Suite Release 12
Secure Enterprise Search
----------------------------------------------------------------------------------------------------
note.566097.1 Oracle E-Business Suite Secure Enterprise Search Release Notes, Release 12.1.1
note.744820.1 Oracle E-Business Suite Secure Enterprise Search Best Practices, Release 12
note.462377.1 Installing Oracle E-Business Suite Secure Enterprise Search, Release 12
note.740499.1 Oracle E-Business Suite Secure Enterprise Search Release Notes, Release 12.0.6
note 726239.1 Oracle E-Business Suite Secure Enterprise Search Troubleshooting Guidelines, Release 12
SOA/BPEL/Webservices
----------------------------------------------------------------------------------------------------
note 556540.1 Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12.1
note 565922.1 Oracle E-Business Suite Integrated SOA Gateway Release Notes, Release 12.1.1
note 815196.1 Oracle E-Business Suite Integrated SOA Gateway 12.1.1 Consolidated One-Off
note 726414.1 Oracle E-Business Suite Integrated SOA Gateway Troubleshooting Guide, Release 12
note 755067.1 Using Oracle BPEL 10g with E-Business Suite Release 12.1.1
Note 782455.1 How Can I Expose E-Business Suite Integration Interfaces as Web Services in Release 11i and R12.0
MWA
----------------------------------------------------------------------------------------------------
note 782162.1 MWA Troubleshooting Tips for Release 12
note 269991.1 MWA Troubleshooting Tips for Release 11i
Certified/Supported
----------------------------------------------------------------------------------------------------http://blogs.oracle.com/stevenchan/certifications.html
note 363827.1 Rebaselined Oracle Applications Technology Components for Releases 11.5.7, 11.5.8, 11.5.9, and 11.5.10
Secure Enterprise Search
----------------------------------------------------------------------------------------------------
note.566097.1 Oracle E-Business Suite Secure Enterprise Search Release Notes, Release 12.1.1
note.744820.1 Oracle E-Business Suite Secure Enterprise Search Best Practices, Release 12
note.462377.1 Installing Oracle E-Business Suite Secure Enterprise Search, Release 12
note.740499.1 Oracle E-Business Suite Secure Enterprise Search Release Notes, Release 12.0.6
note 726239.1 Oracle E-Business Suite Secure Enterprise Search Troubleshooting Guidelines, Release 12
SOA/BPEL/Webservices
----------------------------------------------------------------------------------------------------
note 556540.1 Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12.1
note 565922.1 Oracle E-Business Suite Integrated SOA Gateway Release Notes, Release 12.1.1
note 815196.1 Oracle E-Business Suite Integrated SOA Gateway 12.1.1 Consolidated One-Off
note 726414.1 Oracle E-Business Suite Integrated SOA Gateway Troubleshooting Guide, Release 12
note 755067.1 Using Oracle BPEL 10g with E-Business Suite Release 12.1.1
Note 782455.1 How Can I Expose E-Business Suite Integration Interfaces as Web Services in Release 11i and R12.0
MWA
----------------------------------------------------------------------------------------------------
note 782162.1 MWA Troubleshooting Tips for Release 12
note 269991.1 MWA Troubleshooting Tips for Release 11i
Certified/Supported
----------------------------------------------------------------------------------------------------http://blogs.oracle.com/stevenchan/certifications.html
note 363827.1 Rebaselined Oracle Applications Technology Components for Releases 11.5.7, 11.5.8, 11.5.9, and 11.5.10
note 883202.1 Minimum Baseline Patch Requirements for Extended Support on Oracle E-Business Suite 11.5.10
note 1199724.1 E-Business Suite 11.5.10 Minimum Patch Level and Extended Support Information Center
WEBADI
----------------------------------------------------------------------------------------------------
note 417692.1 Installing, Configuring and Troubleshooting Web ADI (Web Applications Desktop Integrator)
note 452452.1 R12 Installing, Configuring and Troubleshooting Web ADI (Web Applications Desktop Integrator)
note 294739.1 How to enable tracing for WEBADI
note 726989.1 List of Patches in Web Applications Desktop Integrator (Web ADI) for Releases 11i and 12
Diagnostics
----------------------------------------------------------------------------------------------------
note 167000.1 E-Business Suite Diagnostics Installation Guide
note 421245.1 E-Business Suite Diagnostics References for R12
note 179661.1 E-Business Suite Diagnostics 11i Test Catalog
WEBADI
----------------------------------------------------------------------------------------------------
note 417692.1 Installing, Configuring and Troubleshooting Web ADI (Web Applications Desktop Integrator)
note 452452.1 R12 Installing, Configuring and Troubleshooting Web ADI (Web Applications Desktop Integrator)
note 294739.1 How to enable tracing for WEBADI
note 726989.1 List of Patches in Web Applications Desktop Integrator (Web ADI) for Releases 11i and 12
Diagnostics
----------------------------------------------------------------------------------------------------
note 167000.1 E-Business Suite Diagnostics Installation Guide
note 421245.1 E-Business Suite Diagnostics References for R12
note 179661.1 E-Business Suite Diagnostics 11i Test Catalog
Oracle E-business suite (11i & R12) Cloning Master Note
Master Note: Rapid Clone Documentation Resources For Release 11i and 12 [ID 799735.1]
Rapid Clone of E-Business Suite Release 11i:
Note 230672.1 - 'Cloning Oracle Applications Release 11i with Rapid Clone'Note 216664.1 - 'FAQ: Cloning Oracle Applications Release 11i'
Note 398619.1 - 'Clone Oracle Applications 11i using Oracle Application Manager (OAM Clone)'
Note 165195.1 - 'Using AutoConfig to Manage System Configurations with Oracle Applications 11i'
Note 364565.1 - 'Troubleshooting RapidClone issues with Oracle Applications 11i'
Note 760637.1 - 'Manually Cloning Oracle Applications Release 11i with 10g or 11g RAC'
Note 362473.1 - 'Cloning E-Business Suite Using Hot Backup for Minimal Downtime of Source Environment'
Note 233428.1 - 'Sharing the Application Tier File System in Oracle Applications 11i'
Note 243880.1 - 'Shared APPL_TOP FAQ'
Note 238276.1 - 'Migrating to Linux with Oracle Applications Release 11i'
Note 218089.1 - 'Autoconfig FAQ'
Note 270519.1 - 'Customizing an AutoConfig Environment'
Note 316806.1 - 'Oracle Applications Installation Update Notes, Release 11i (11.5.10.2)'
Rapid Clone of E-Business Suite Release R12:
Note 406982.1 - 'Cloning Oracle Applications Release 12 with Rapid Clone'Note 603104.1 - 'Troubleshooting RapidClone issues with Oracle Applications R12'
Note 559518.1 - 'Cloning Oracle E-Business Suite Release 12 RAC-Enabled Systems with Rapid Clone'
Note 387859.1 - 'Using AutoConfig to Manage System Configurations in Oracle E-Business Suite Release 12'
Note 549389.1 - 'Oracle Applications Release Notes, Release 12.0.4'
Note 394692.1 - 'Oracle Applications Documentation Resources, Release 12'
Generic - Rapid Clone of E-Business Suite Release 11i or R12:
Note 783188.1 - 'Certified RAC Scenarios for E-Business Suite Cloning'Note 375650.1 - 'How To Run Rapid Clone (adcfgclone.pl) Non-Interactively'
Note 760772.1 - 'Cloning Oracle Application 11i /R12 with Rapid Clone - Database (9i/10g/11g) Using Hot Backup on Open Database'
Note 343917.1 - 'Frequently Asked Questions: Oracle E-Business Suite Support on x86-64'
Note 311717.1 - 'Frequently Asked Questions: Oracle E-Business Suite Support on Itanium'
Note 419475.1- 'Removing Credentials from a Cloned EBS Production Database'
Cloning via the E-Business Suite Plugin 4.0 (Grid Manager Plugin)
Note 1224313.1 - 'Getting Started with Oracle E-Business Suite Plug-in, Release 4.0'Note 812294.1 - 'Troubleshooting Guide and Known Issues List for the Oracle Application Management Pack for Oracle E-Business Suite'
Note 250262.1 - 'RDA 4 - HCVE Users' Guide and Available Rule Sets' = OS pre-check diagnostics for EBS 11i & 12
Sunday, 14 October 2012
E-Business Suite R12 Administration Basics
Apps Tiers:
Database Tier (
Database & DB Listener )
Application Tier (
WebServer, Forms, Reports, Concurrent Manager, Discoverer, Apps Listener)
File System:
The major difference between R12 and 11i has been the introduction of INST_TOP with R12, called the Instance Top. This top has all the
configuration and log files separate for ease of maintenance and autoconfig doesn’t
have to do any changes in APPL_TOP. The other major change is the introduction
of 10gAS for both forms and iAS.
APPL_TOP à
Product directories (AP,GL), also AD_TOP àAPPL_TOP/ad
COMMON_TOP àCommon
file, logs, java, html, etc
ORA_TOP à
ORACLE_HOME for 10g (forms) and IAS_ORACLE_HOME for application server 10gAS
DATA_TOP à
DB files
DB_HOME à
DB file system (ORACLE_HOME)
$INST_TOP/admin/scripts ($ADMIN_SCRIPTS_HOME)
$INST_TOP/appl ($APPL_CONFIG_HOME)
$INST_TOP/fnd/12.0.0/secure ($FND_SECURE)
$INST_TOP/certs
$INST_TOP/logs ($LOG_HOME – autoconfig logs here by default)
$INST_TOP/ora ($ORA_CONFIG_HOME)
$INST_TOP/ora/10.1.2
$INST_TOP/ora/10.1.3 ($ORACLE_CONFIG_HOME)
$INST_TOP/pids
$INST_TOP/portal
$INST_TOP/appl ($APPL_CONFIG_HOME)
$INST_TOP/fnd/12.0.0/secure ($FND_SECURE)
$INST_TOP/certs
$INST_TOP/logs ($LOG_HOME – autoconfig logs here by default)
$INST_TOP/ora ($ORA_CONFIG_HOME)
$INST_TOP/ora/10.1.2
$INST_TOP/ora/10.1.3 ($ORACLE_CONFIG_HOME)
$INST_TOP/pids
$INST_TOP/portal
Order of StartUp of
Services:
First DB Listener, Database & then Application Tier Services
First DB Listener, Database & then Application Tier Services
Order of ShutDown of Services:
First Application Tier Services then Database & DB Listener
First Application Tier Services then Database & DB Listener
Database startup/shutdown scripts:
cd $INSTALL_BASE/db/tech_st/11.1.0
addbctl.sh database startup shutdown script
addlnctl.sh database listener Script
cd $INSTALL_BASE/db/tech_st/11.1.0
addbctl.sh database startup shutdown script
addlnctl.sh database listener Script
Application Tier Startup/Shutdown Scripts
Source environment from $INSTALL_BASE/apps/apps_st/appl
Source environment from $INSTALL_BASE/apps/apps_st/appl
cd $ADMIN_SCRIPTS_HOME
adalnctl.sh Apps Listener Control
Script
adapcctl.sh Apache/Web Server Control Script
adcmctl.sh Concurrent Manager Control Script
addisctl.sh Discoverer Control Script
adfrmctl.sh Forms server Control Script
adrepctl.sh Report Server Control Script
adstpall.sh Stop All Middle/Application Tier
adstrtall.sh Start All Middle/Application Tier
adapcctl.sh Apache/Web Server Control Script
adcmctl.sh Concurrent Manager Control Script
addisctl.sh Discoverer Control Script
adfrmctl.sh Forms server Control Script
adrepctl.sh Report Server Control Script
adstpall.sh Stop All Middle/Application Tier
adstrtall.sh Start All Middle/Application Tier
Context File: Used
by adconfig.sh for configuring the application.
$INST_TOP/appl/admin is the
new location for Context File
If not sure, query FND_OAM_CONTEXT_FILES
table.
Log Files:
$LOG_HOME à $INST_TOP/logs
Concurrent
Manager
$LOG_HOME/appl/conc
àconcurrent requests log and out files
$LOG_HOME/appl/admin à mid tier startup scripts log files
$LOG_HOME/appl/admin à mid tier startup scripts log files
Apache
Logs (10.1.3
Oracle Home)
$LOG_HOME/ora/10.1.3/Apache
à Apache Error and Access log files
$LOG_HOME/ora/10.1.3/j2ee à j2ee related log files
$LOG_HOME/ora/10.1.3/opmn à opmn related log files
$LOG_HOME/ora/10.1.3/j2ee à j2ee related log files
$LOG_HOME/ora/10.1.3/opmn à opmn related log files
Forms
& Reports related logs (10.1.2
Oracle Home)
$LOG_HOME/ora/10.1.2/forms
$LOG_HOME/ora/10.1.2/reports
$LOG_HOME/ora/10.1.2/reports
Finding
Application or file Version:
How to find Application
Version (R12)
select release_name from apps.fnd_product_groups;
Apache or Application Server in Apps R12
Log in as Application user, set environment variable and run below query
Log in as Application user, set environment variable and run below query
$IAS_ORACLE_HOME/Apache/Apache/bin/httpd
–version
Forms & Report
version in R12
$ORACLE_HOME/bin/rwrun | grep Release
$ORACLE_HOME/bin/rwrun | grep Release
Oracle
Jinitiator in R12
Log in as Application user, set environment variable and run below query
grep jinit_ver_comma $CONTEXT_FILE
Oracle Java Plug-in in R12
Log in as Application user, set environment variable and run below query
grep plugin $CONTEXT_FILE
Log in as Application user, set environment variable and run below query
grep jinit_ver_comma $CONTEXT_FILE
Oracle Java Plug-in in R12
Log in as Application user, set environment variable and run below query
grep plugin $CONTEXT_FILE
File Version on file system
adident Header
strings | grep Header
adident Header
strings
Discoverer Version for R12 (10g AS)
Check under Application Server Section as 10g AS Discoverer is on standalone
Check under Application Server Section as 10g AS Discoverer is on standalone
Workflow
Version with Apps
Connect to Database as apps user
select TEXT Version from WF_RESOURCES where NAME = ‘WF_VERSION’;
Connect to Database as apps user
select TEXT Version from WF_RESOURCES where NAME = ‘WF_VERSION’;
Oracle Database
select * from v$version;
$ORACLE_HOME/OPatch/opatch lsinventory –detail
$ORACLE_HOME/OPatch/opatch lsinventory –detail
Operating System
Solaris : cat
/etc/release
Red Hat Linux : cat /etc/redhat-release
Red Hat Linux : cat /etc/redhat-release
E-Business Suite 11i Administration Basics
I have tried and put together a basic administration know how that any apps DBA should have knowledge of to support a Oracle e-business 11i Instance. It has the start/stop scripts, Log locations, File system structure.
Application Tiers:
Database Tier (
Database & DB Listener )
Application Tier (
WebServer, Forms, Reports, Concurrent Manager, Discoverer, Apps Listener)
File System:
APPL_TOP à
Product directories (AP,GL), also AD_TOP àAPPL_TOP/ad
COMMON_TOP àCommon
file, logs, java, html, etc
ORA_TOP à
ORACLE_HOME for 8i (forms) and IAS_ORACLE_HOME for application server 9iAS
DATA_TOP à
DB files
DB_HOME à
DB file system (ORACLE_HOME)
DB Listener, Database and then Application Tier Services
Order of ShutDown of Services:
Application Tier Services then Database and DB Listener
Application Tier Services then Database and DB Listener
Database startup/shutdown scripts:
ORACLE_HOME / appsutil/scripts /SID_hostname
addbctl.sh database startup shutdown script
addlnctl.sh database listener Script
ORACLE_HOME / appsutil/scripts /SID_hostname
addbctl.sh database startup shutdown script
addlnctl.sh database listener Script
Application Tier Startup/Shutdown Scripts
OAD_TOP/admin/scripts/ SID_hostname
OAD_TOP/admin/scripts/ SID_hostname
adalnctl.sh Apps Listener Control
Script
adapcctl.sh Apache/Web Server Control Script
adcmctl.sh Concurrent Manager Control Script
addisctl.sh Discoverer Control Script
adfrmctl.sh Forms server Control Script
adrepctl.sh Report Server Control Script
adstpall.sh Stop All Middle/Application Tier
adstrtall.sh Start All Middle/Application Tier
adapcctl.sh Apache/Web Server Control Script
adcmctl.sh Concurrent Manager Control Script
addisctl.sh Discoverer Control Script
adfrmctl.sh Forms server Control Script
adrepctl.sh Report Server Control Script
adstpall.sh Stop All Middle/Application Tier
adstrtall.sh Start All Middle/Application Tier
Context File:
Used
by adconfig.sh for configuring the application.
DB:$ORACLE_HOME/ appsutil/
scripts $CONTEXT_NAME ($ORACLE_HOME/
appsutil/bin/adconfig.sh )
APP:$COMMON_TOP/admin/scripts/$CONTEXT_NAME
($AD_TOP/bin/adconfig.sh)
Log Files:
$APPLCSF à
Application support/scripts file à
$COMMON_TOP/admin/
$APPLCSF/$APPLLOG àFor concurrent request out files and
logs
$APACHE_TOP/Apache/logs.
Finding
Application or file Version:
select release_name from apps.fnd_product_groups;
Web Apache or
Application Server in Apps 11i
Log in as Application user, set
environment variable
$IAS_ORACLE_HOME/Apache/Apache/bin/httpd
–version
Forms & Report version in 11i
$ORACLE_HOME/bin/f60run | grep Version | grep Forms
$ORACLE_HOME/bin/f60run | grep Version | grep Forms
Forms & Report
version in R12/12i
$ORACLE_HOME/bin/rwrun | grep Release
$ORACLE_HOME/bin/rwrun | grep Release
Oracle
Jinitiator in 11i/R12/12i
Log in as Application user, set environment variable
grep jinit_ver_comma $CONTEXT_FILE
Oracle Java Plug-in in 11i/R12/12iLog in as Application user, set environment variable and run below query
grep plugin $CONTEXT_FILE
Log in as Application user, set environment variable
grep jinit_ver_comma $CONTEXT_FILE
Oracle Java Plug-in in 11i/R12/12iLog in as Application user, set environment variable and run below query
grep plugin $CONTEXT_FILE
File Version on file system
adident Header
strings | grep Header
adident Header
strings
OA Framework Version
http:// hostname.domainName:port/OA_HTML/OAInfo.jsp (Only for 11i)
http:// hostname.domainName:port/OA_HTML/OAInfo.jsp (Only for 11i)
adident
Header $FND_TOP/html/Ojsp
adident Header $OA_HTML/Ojsp
adident Header $OA_HTML/Ojsp
Discoverer Version for 11i
Log in as Application user, set environment variable and run below query
$ORACLE_HOME/bin/disc4ws | grep -i Version
Log in as Application user, set environment variable and run below query
$ORACLE_HOME/bin/disc4ws | grep -i Version
Discoverer Version
for 11i
Check under Application Server Section as 10g AS Discoverer is on standalone
Check under Application Server Section as 10g AS Discoverer is on standalone
Workflow
Version with Apps
Connect to Database as apps user
select TEXT Version from WF_RESOURCES where NAME = ‘WF_VERSION’;
Connect to Database as apps user
select TEXT Version from WF_RESOURCES where NAME = ‘WF_VERSION’;
Oracle Database
select * from v$version;
$ORACLE_HOME/OPatch/opatch lsinventory –detail
$ORACLE_HOME/OPatch/opatch lsinventory –detail
Solaris : cat
/etc/release
Red Hat Linux : cat /etc/redhat-release
Red Hat Linux : cat /etc/redhat-release
Subscribe to:
Comments (Atom)