Practical Oracle E-Business Suite: An Implementation and Management Guide

793 Pages·2016·37.429 MB·English

by  Syed Zaheer, Erman Arslan (auth.)

Practical Oracle
E-Business Suite
An Implementation and
Management Guide
—
Syed Zaheer and Erman Arslan
Practical Oracle
E-Business Suite
An Implementation and Management Guide

Syed Zaheer and Erman Arslan
Practical Oracle E-Business Suite: An Implementation and Management Guide
Syed Zaheer Erman Arslan
Bahadurpura, Hyderabad Tesvikiye, Istanbul
India Turkey
ISBN-13 (pbk): 978-1-4842-1423-7 ISBN-13 (electronic): 978-1-4842-1422-0
DOI 10.1007/978-1-4842-1422-0
Library of Congress Control Number: 2016952811
Copyright © 2016 by Syed Zaheer and Erman Arslan
This work is subject to copyright. All rights are reserved by the Publisher, whether the whole or part of the
material is concerned, specifically the rights of translation, reprinting, reuse of illustrations, recitation,
broadcasting, reproduction on microfilms or in any other physical way, and transmission or information
storage and retrieval, electronic adaptation, computer software, or by similar or dissimilar methodology now
known or hereafter developed.
Trademarked names, logos, and images may appear in this book. Rather than use a trademark symbol with
every occurrence of a trademarked name, logo, or image we use the names, logos, and images only in an
editorial fashion and to the benefit of the trademark owner, with no intention of infringement of the trademark.
The use in this publication of trade names, trademarks, service marks, and similar terms, even if they are
not identified as such, is not to be taken as an expression of opinion as to whether or not they are subject to
proprietary rights.
While the advice and information in this book are believed to be true and accurate at the date of publication,
neither the authors nor the editors nor the publisher can accept any legal responsibility for any errors or
omissions that may be made. The publisher makes no warranty, express or implied, with respect to the
material contained herein.
Managing Director: Welmoed Spahr
Acquisitions Editor: Susan McDermott
Developmental Editor: Laura Berendson, Douglas Pundick
Technical Reviewer: Maris Elsins
Editorial Board: Steve Anglin, Pramila Balen, Laura Berendson, Aaron Black, Louise Corrigan,
Jonathan Gennick, Robert Hutchinson, Celestin Suresh John, Nikhil Karkal, James Markham,
Susan McDermott, Matthew Moodie, Natalie Pao, Gwenan Spearing
Coordinating Editor: Rita Fernando
Copy Editor: Kim Wimpsett
Compositor: SPi Global
Indexer: SPi Global
Cover image selected by Freepik.com.
Distributed to the book trade worldwide by Springer Science+Business Media New York, 233 Spring Street, 6th
Floor, New York, NY 10013. Phone 1-800-SPRINGER, fax [phone], e-mail o [email protected] ,
or visit w ww.springer.com . Apress Media, LLC is a California LLC and the sole member (owner) is
Springer Science + Business Media Finance Inc (SSBM Finance Inc). SSBM Finance Inc is a Delaware corporation.
For information on translations, please e-mail [email protected] , or visit w ww.apress.com .
Apress and friends of ED books may be purchased in bulk for academic, corporate, or promotional use.
eBook versions and licenses are also available for most titles. For more information, reference our Special
Bulk Sales–eBook Licensing web page at w ww.apress.com/bulk-sales .
Any source code or other supplementary materials referenced by the author in this text is available to
readers at w ww.apress.com . For detailed information about how to locate your book’s source code, go to
w ww.apress.com/source-code/ .
Printed on acid-free paper
This book is dedicated to my mother, Asuman Arslan,
and to my father, Osman Ertug˘rul Arslan.
—Erman Arslan
T his book is dedicated to my parents.
—Syed Zaheer
Contents at a Glance
About the Authors ...................................................................................................xxi
About the Technical Reviewer ..............................................................................xxiii
Acknowledgments .................................................................................................xxv
Introduction .........................................................................................................xxvii
■ Chapter 1: Architecture .........................................................................................1
■ Chapter 2: Installation and Confi guration ...........................................................35
■ Chapter 3: Oracle E-Business Suite Upgrades ...................................................103
■ Chapter 4: Oracle E-Business Suite 12.2 File System .......................................155
■ Chapter 5: Patching Concepts ...........................................................................199
■ Chapter 6: Working with the Applications DBA Online Patching Tool (adop) ....245
■ Chapter 7: Managing FMW/WebLogic ................................................................351
■ Chapter 8: AutoConfi g to Manage EBS System Confi guration Changes .............441
■ Chapter 9: SYSADMIN Fundamentals .................................................................483
■ Chapter 10: Oracle EBS Concurrent Managers ..................................................531
■ Chapter 11: Cloning Oracle EBS Systems ..........................................................579
■ Chapter 12: An Introduction to Oracle EBS Security .........................................641
■ Chapter 13: Oracle E-Business Suite 12.2 Performance Recommendations .....675
■ Chapter 14: Oracle E-Business Suite 12.2 on Engineered Systems ...................735
Index .....................................................................................................................765
v
Contents
About the Authors ...................................................................................................xxi
About the Technical Reviewer ..............................................................................xxiii
Acknowledgments .................................................................................................xxv
Introduction .........................................................................................................xxvii
■ Chapter 1: Architecture .........................................................................................1
Introduction to Oracle E-Business Suite ...........................................................................1
CRM Applications Family ..................................................................................................2
Service Management Family ............................................................................................2
Financial Management Family .........................................................................................3
Human Capital Management Family ................................................................................4
Project Portfolio Management Family ..............................................................................5
Advanced Procurement Family ........................................................................................5
Supply Chain Management Family ...................................................................................6
Understanding the Oracle E-Business Suite’s Three-Tier Architecture Model .................7
Concurrent Processing ...................................................................................................11
Database Tier and EBS Data Model ................................................................................11
Understanding the EBS 12.2 Technology Stack Components .........................................15
Oracle EBS 12.2 File System Structure ..........................................................................19
Application Tier File System ...........................................................................................23
Technology Stack Changes in EBS 11i/12.1/12.2 ...........................................................32
Summary ........................................................................................................................34
vii
■ CONTENTS
■ Chapter 2: Installation and Confi guration ...........................................................35
New Features in Release 12.2’s Rapidwiz Install Wizard ...............................................35
Preparing for Installation ................................................................................................37
Hardware Prerequisites ........................................................................................................................37
Computing Requirements .....................................................................................................................38
Space Requirements ............................................................................................................................38
Software Requirements ........................................................................................................................39
Software Tools Requirements ...............................................................................................................39
Kernel Version .......................................................................................................................................39
Operating System Packages .................................................................................................................40
Confi guring the yum Repository for EBS 12 Package Installation ..................................42
Get the Repository File with Wget ........................................................................................................42
Oracle EBS 12.2 Stage Directory Structure ....................................................................49
Build Stage Menu Options ....................................................................................................................51
Copy Patches to Existing Stage Area ....................................................................................................53
List Files in the TechPatches Directory .................................................................................................53
Copy Patches to Existing Stage Area ....................................................................................................54
Single-Node Installation .................................................................................................54
Before Running Rapidwiz .....................................................................................................................54
Multinode Installation .....................................................................................................73
Key Points Related to Multinode Installation ........................................................................................74
Rapidwiz Install: RAC Database Option .................................................................................................74
Shared APPL_TOP in Oracle EBS 12.2 ..................................................................................................75
Post-installation Steps ...................................................................................................76
Post-installation Steps for the Application ...........................................................................................76
Client PC Requirements ........................................................................................................................79
Post-installation Steps for the Database ..............................................................................................80
How to Deal with Failed Installations .............................................................................81
Rapidwiz Installation Process ...............................................................................................................81
viii
■ CONTENTS
How to Deal with Corrupted/Lost Technology Stack Components .................................83
Replacing the Oracle EBS Database Technology Stack (RDBMS Oracle Home) ....................................83
Replacing the Oracle EBS 10g AS (10.1.2: Tools) Technology Stack .....................................................92
Replacing the Oracle Fusion Middleware Technology Stack ..............................................................102
Summary ......................................................................................................................102
■ Chapter 3: Oracle E-Business Suite Upgrades ...................................................103
Introduction to the Oracle E-Business Suite Upgrade Process ....................................103
Road Map to 12.2 Upgrade ...........................................................................................103
Preparation of an Oracle EBS 12.2 Upgrade .................................................................105
Operating System and Server Upgrade ..............................................................................................105
Virtualization Considerations ..............................................................................................................105
Space and Computing Capacity Considerations .................................................................................106
Upgrade the Database ........................................................................................................................106
Purge/Archive Data .............................................................................................................................107
Upgrade Dependent EBS Integrated Applications ...............................................................................107
Upgrading Oracle E-Business Suite: 12.2.0 to 12.2.5 ...................................................108
Patching Utilities Used for Different Tech Stack Components ............................................................110
Upgrade Demonstration ......................................................................................................................110
Execution of checkMTpatch.sh ...........................................................................................................110
Execution of checkDBpatch.sh ...........................................................................................................113
Installation of the RDBMS Patches .....................................................................................................115
Applying Latest AD and TKX Patches ..................................................................................................120
Apply WebLogic Patches .....................................................................................................................121
Installation of 12.2.5 Upgrade Patch ..................................................................................................121
Post-upgrade Tasks ............................................................................................................................124
Upgrading from 12.1.3 to 12.2.0 ..................................................................................126
Phase 1 ...............................................................................................................................................126
Phase 2 ...............................................................................................................................................126
Phase 3 ...............................................................................................................................................126
Phase 4 ...............................................................................................................................................126
ix
■ CONTENTS
Upgrade Environment Details .......................................................................................127
Oracle EBS Database Upgrade............................................................................................................128
Oracle Application Upgrade ................................................................................................................129
Install 12.2.0 Tech Stack Components ................................................................................................129
Prepare for 12.2.0 Upgrade Patch ......................................................................................................142
Apply Main Upgrade Patch .................................................................................................................143
Confi gure the EBS Upgrade Using Rapidwiz .......................................................................................144
Finishing the Upgrade.........................................................................................................................150
Enable Online Patching .......................................................................................................................151
Post-upgrade Steps ............................................................................................................................153
EBS Upgrade Timing Summary ...........................................................................................................153
Summary ......................................................................................................................154
■ Chapter 4: Oracle E-Business Suite 12.2 File System .......................................155
Oracle E-Business Suite File System Architecture Overview .......................................155
Understanding the Application Dual and Noneditioned File Systems ...........................157
Oracle EBS 12.2 Environment Variables .......................................................................166
Working with Environment Variables on the Application Tier and Navigating the
Application File System ................................................................................................177
Scenario 1: Starting the Application Services.....................................................................................177
Scenario 2: You Want to Check the SMTP Server Settings in CONTEXT_FILE .....................................180
Scenario 3: You Want to Connect to the EBS Database Remotely from the EBS
Application Tier Node ..........................................................................................................................181
Working with Environment Variables on the Database Tier and Navigating the Database
File System ...................................................................................................................183
Scenario 1: Restarting the EBS Database and the Database Listener ................................................185
Scenario 2: Modifying the Database Confi guration Using AutoConfi g ................................................187
EBS 12.2 Applications Log Files ...................................................................................189
EBS 12.2 Database Log Files ........................................................................................191
Summary ......................................................................................................................198
x
■ CONTENTS
■ Chapter 5: Patching Concepts ...........................................................................199
Introduction to Oracle Patching in EBS 12.2 ................................................................199
Types of the Patches and Deciding the Patching Order ...............................................201
The Manual Method ............................................................................................................................203
The Patch Application Assistant Method ............................................................................................210
Different Patching Utilities Under Oracle EBS 12.2 ......................................................220
Patching WebLogic with BSU (BEA Smart Update) .......................................................221
Patching the Application Tier Oracle Homes and the Database with Opatch ...............223
Applying the Applications Patches with the ADOP Utility .............................................225
Introduction to Online Patching Utility (adop) ...............................................................226
Technological Changes for Supporting Online Patching .....................................................................227
Understanding Edition-Based Redefi nition Usage in Online Patching ................................................229
Phases of Online Patching ..................................................................................................................234
Backup Best Practices for EBS 12.2 Patching ..............................................................237
Summary ......................................................................................................................244
■ Chapter 6: Working with the Applications DBA Online Patching Tool (adop) ....245
Overview of adop .........................................................................................................245
Working with the adop Utility .......................................................................................247
adop Command-Line Parameters and Options.............................................................252
Executing the Patching Cycle .......................................................................................262
Prepare Phase ....................................................................................................................................263
List of Restricted Functionalities in the Online Patching Cycle ..........................................................266
Apply Phase ........................................................................................................................................267
Finalize Phase .....................................................................................................................................269
Cutover ...............................................................................................................................................270
Cleanup ...............................................................................................................................................272
Abort Phase ........................................................................................................................................273
Hotpatch Mode .............................................................................................................275
Downtime Mode ...........................................................................................................279
xi