Tushar Thakker
1st ed. 2015
Tushar Thakker
Param Labs, Dubai, United Arab Emirates
ISBN 978-1-4842-0984-4
e-ISBN 978-1-4842-0983-7
DOI 10.1007/978-1-4842-0983-7
Library of Congress Control Number: 2015949704
© Tushar Thakker 2015
Pro Oracle Fusion Applications
Managing Editor: Welmoed Spahr
Lead Editor: Jonathan Gennick
Development Editor: Douglas Pundick
Technical Reviewer: Dhananjay Papde
Editorial Board: Steve Anglin, Mark Beckner, Gary Cornell, Louise Corrigan, Jim DeWolf, Jonathan Gennick, Robert Hutchinson, Michelle Lowman, James Markham, Susan McDermott, Matthew Moodie, Jeffrey Pepper, Douglas Pundick, Ben Renow-Clarke, Gwenan Spearing, Matt Wade, Steve Weiss
Coordinating Editor: Jill Balzano
Copy Editor: Kezia Endsley
Compositor: SPi Global
Indexer: SPi Global
Artist: SPi Global
Cover Designer: Anna Ishchenko
For information on translations, please e-mail [email protected] , or visit www.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 www.apress.com/bulk-sales .
Any source code or other supplementary material referenced by the author in this text is available to readers at www.apress.com . For detailed information about how to locate your book’s source code, go to www.apress.com/source-code/ .
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. Exempted from this legal reservation are brief excerpts in connection with reviews or scholarly analysis or material supplied specifically for the purpose of being entered and executed on a computer system, for exclusive use by the purchaser of the work. Duplication of this publication or parts thereof is permitted only under the provisions of the Copyright Law of the Publisher’s location, in its current version, and permission for use must always be obtained from Springer. Permissions for use may be obtained through RightsLink at the Copyright Clearance Center. Violations are liable to prosecution under the respective Copyright Law.
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.
Printed on acid-free paper
Dedicated to my parents, my beautiful wife Dipti and our beloved son Param.
Oracle Fusion Applications is an evolving product and at present has matured enough for Oracle customers to start implementing it or plan their applications roadmap accordingly. Lately there have been many new projects kicking off and the curiosity toward Oracle Fusion Applications is constantly increasing. Since Oracle is investing heavily in Oracle Fusion Applications development and marketing, having this essential installation and administration book with practical tips will boost your confidence when building an on-premise implementation of Fusion Applications. This book will prove to be a must-have handbook for anyone planning an implementation of Oracle Fusion Applications.
I started working on Oracle Fusion Applications installation since its early releases and I can assure you that the installation process has evolved and improved a lot since then. After successfully completing the Fusion Applications installation on various releases, I noticed that a large number of users were facing difficulties in the provisioning process due to the complexity involved as well as because there was no step-by-step handbook available at that time. I started helping a large number of Fusion Applications aspirants through my blog and it was fulfilling to see a number of blog users successfully completing the tedious process of Fusion Applications installation using my step-by-step guides. Based on their success stories, I decided to share my experiences with a large number of readers using this comprehensive book.
Most of the examples in this book are from actual installations. I have been supporting a very large number of Fusion Applications aspirants during their Fusion Applications installation and helping them with various issues reported by them during provisioning process.
Understand the Fusion Applications architecture and how it maps to your physical infrastructure
Design network and storage topologies to support your installation
Provision Identity Management to control and manage the applications access
Provision an Oracle Fusion Applications environment
Manage those environments on an ongoing basis
Identify, diagnose, and resolve the day-to-day problems
Understand types of Fusion Applications patches and various methods to apply them on a regular basis
Oracle Fusion Applications is one of the most anticipated knowledge upgrades for most professionals in the Oracle Applications domain. Pro Oracle Fusion Applications is aimed at following the audience as well as all those who are involved in the technical aspects of standing up an on-premise installation of Oracle Fusion Applications. This includes:
Oracle Database Administrators and Applications DBAs
WebLogic Administrators
Oracle Identity Management Administrators
System Architects
Technical consultants
Application Implementers and Administrators
Oracle Partners and System Integrators
End-user clients planning to implement Oracle Fusion Applications
Pro Oracle Fusion Applications is organized into 16 chapters divided in four main sections. The book begins with an introduction to Oracle Fusion Applications followed by planning for the installation. Later it explains the end-to-end installation process followed by the day-to-day administration of the installed environment. In order to maintain the logical flow of the content, it is strongly recommended that you read the chapters in the given order.
Part I Introduction
Chapter 1 : Introduction to Oracle Fusion Applications
We will begin with introducing Oracle Fusion Applications and the product families included in the suite along with their adoption options for new as well as existing Oracle customers. Later we will explain the Fusion Applications architecture along with explaining the key components or building blocks of the Fusion Applications instance, including the Oracle Identity Management infrastructure and how they interact. We will also look at the standard-based business process model and security model of Oracle Fusion Applications.
Part II Planning
Chapter 2 : Planning an Installation
We begin this chapter with roles and responsibilities of various individuals involved in the entire process of planning, provisioning, and managing an Oracle Fusion Applications environment. We look at various possible topologies for Oracle Fusion Applications and learn how to choose the best suitable topology and required hardware for a specific installation. You also learn how to plan the required hardware, network, and storage configuration based on your business requirements. You also learn how to calculate the memory requirement for your installation based on the selected product configurations.
Chapter 3 : Setting Up the Hosts for Provisioning
In this chapter, we first discuss the concepts of end-to-end Fusion Applications provisioning process. We will explore the role of each physical host of the selected topology and learn how to group them among Identity Management nodes and Fusion Applications nodes. We will discuss the steps involved in the provisioning process along with the dependencies among the steps. Later you will learn how to prepare the selected hosts for provisioning, including required operating system, network, and storage.
Part III Installation
Chapter 4 : Creating Identity Management Database
This chapter deals with various options for preparing the Oracle Database to host Identity Management components. We look at installing the Identity Management database, applying required database patches, as well as creating the required schemas using the Repository Creation Utility for Identity Management.
Chapter 5 : Preparing for Identity Management Provisioning
In this chapter, we discuss the structure of the Identity Management Provisioning framework and discuss how to install it on all Identity Management hosts of the selected topology. Later we look at the importance of the Identity Management provisioning response file and explore step-by-step instructions on creating them. We look at the importance of each of the parameters being stored while going through the relevant screens during the response file creation.
Chapter 6 : Provisioning Identity Management Environment
This chapter provides a step-by-step guide on provisioning an Oracle Identity Management environment, which is a prerequisite for the Fusion Applications installation. We will explore the various graphical as well as command-line interfaces available to provision the Identity Management components. This chapter also explains how to deal with failed Identity Management installations and restart them manually.
Chapter 7 : Post-Provisioning Configuration for Identity Management Nodes
This chapter concludes the Identity Management provisioning section by explaining how to validate the installed Identity Management components and perform the post-provisioning configuration for each of these components. These post-provisioning configuration steps prepare the Identity Management environment to be used with any fresh installation of Fusion Applications.
Chapter 8 : Creating Fusion Applications Transaction Database
This chapter explains how to prepare the Fusion Applications Transaction database using the provisioning framework provided with the installation repository. We begin with learning how to install the Fusion Applications provisioning framework on the database nodes followed by how to use it to create a fresh transaction database with required patches and updates pre-installed. You also see how to run the Repository Creation Utility to prepare Fusion Applications-related schemas.
Chapter 9 : Preparing for Fusion Applications Provisioning
This is a very important chapter before we look at the actual provisioning process since it deals with preparing the Fusion Applications provisioning response file. During the response file creation we explore all the important parameters required for setting up an Oracle Fusion Applications environment. We begin with understanding the directory structure and various options available with the provisioning framework. We prepare a response file based on the selected topology. We also have a look at updating an existing response file as well as creating one for extending an existing Applications environment.
Chapter 10 : Provisioning Fusion Applications Environment
In this final chapter of the Fusion Applications installation, we look at the automated installation orchestration using the graphical wizard as well as the command-line interface. We look at the important input files used by the provisioning process as well as various output files, logs, and flags created during the installation which aids us while troubleshooting the installation issues. We also learn how to restart a failed or aborted installation using automated or manual cleanup/restore procedures.
Part IV Administration
Chapter 11 : Understanding Fusion Applications Interface
After the installation is complete, we will have a bird’s eye view of the applications interface. We learn how Fusion Applications differs from existing Applications Suites in Oracle as well as other vendors and how it provides the most efficient way to perform various tasks from a single consolidated interface. After reading this chapter, you will be able to identify and use many aspects of the interface, including dashboards, navigation icons, and personalization tools. You will also quickly look the Enterprise Scheduler, including learning how it maps with traditional applications suites and how to submit an example scheduled request.
Chapter 12 : Getting Started with Administration
From this chapter onward, we begin looking at Fusion Applications administration. First we explore the various methods for starting up or stopping the complete Fusion Applications environment, including the Identity Management components. Later we look at Fusion Applications Functional Setup Manager and how it is one of the most important components for Administrators as well as Application Implementers.
Chapter 13 : Managing Fusion Applications Security
Fusion Applications Security Setup is one of the first administration tasks you may need to perform before business users can start using the applications modules. We look at the role-based access control model of Fusion Applications along with various functional and data roles available. This chapter also explains how the roles are stored and synchronized between various Identity Management components. This chapter provides a step-by-step guide to setting up initial IT security-related roles and users.
Chapter 14 : Monitoring Fusion Applications Environment
This chapter explains the importance of Oracle Enterprise Manager Cloud Control in managing a complete Fusion Applications environment, which replaces a number of individual Enterprise Managers and dashboards using a single consolidated interface. We look at the steps involved in installing Cloud Control software and it with all the components of Fusion Applications environment. We explore how we can leverage the consolidated interface of Cloud Control for monitoring every layer of Fusion Applications, including database, middleware and web tier. We also see how it compares to traditional monitoring interfaces used in earlier versions of Fusion Applications.
Chapter 15 : Diagnosing and Troubleshooting
In this chapter, we discuss some of the most important Fusion Applications’ administrative tasks, including diagnosing and troubleshooting various issues. Troubleshooting applications or database issues may involve liaising with multiple teams, including system administrators, network teams, core DBAs, and Identity Management specialists. We look at various steps involved in diagnosing and troubleshooting, including tracing the applications issues at the database level as well as troubleshooting them at the JVM level. This chapter also explains troubleshooting issues with Enterprise Scheduler jobs.
Chapter 16 : Patching and Ongoing Administration
This chapters begins by explaining the various types of patches that are available for Fusion Applications environment, including applications and middleware artifacts. We look at the different patching mechanisms or each of these patch types including manual patching as well as patch automation utilities. Later we look at ongoing administration of Fusion Applications, including maintenance of the applications file system as well as database objects. We conclude the chapter by looking at the recommended practices for backing up and restoring the entire Fusion Applications environment.
Apress makes every effort to make sure that there are no errors in the text or the code. However, to err is human, and as such we recognize the need to keep you informed of any mistakes as they’re discovered and corrected. Errata sheets are available for all our books at www.apress.com . If you find an error that hasn’t already been reported, please let us know. The Apress web site acts as a focus for other information and support, including the code from all Apress books, sample chapters, previews of forthcoming titles, and articles on related topics.
If you have any questions regarding the book, please feel free to contact me directly at the following email address: [email protected] or at Twitter@tusharthakker .
This book couldn’t have been conceptualized without the overwhelming support from the users of my blog OraTraining.com , who recognized my efforts in bringing Oracle Fusion Applications knowledge to everyone at the time when there were limited online resources available. The feedback from my blog users, along with their success stories, encouraged me to spread the knowledge to a larger audience through this book.
I would like to thank my friend Anil Passi (founder of apps2fusion.com and author of several Oracle Applications books) for encouraging me to write this book. I sincerely thank the entire Apress Editorial team, especially Jonathan Gennick who gave me an opportunity to write this book, Douglas Pundick who guided me in every aspect of this project by providing best practices for authors, Jill Balzano who has been tremendously helpful throughout the book by answering all my queries in detail, and Dhanajay Papde who carefully reviewed all the chapters and provided accurate technical suggestions from an existing Oracle Applications Administrator’s point of view. I must also thank all those who have helped directly or indirectly in my career to reach this stage, including but not limited to Raj Adigal, Palani Ramasamy, Banakar Basavaraj, Gautam Thakkar, Dr. Sabri Al Azazi, Jose Jayapal, and Rochak Puri.
Last but not the least, this book would not have been complete without exceptional support from my dear wife Dipti and our little son Param, who allowed me to spend countless days focusing on Oracle Fusion Applications when it was in its early stages as well as while writing this book despite the constant humming of the servers at home which hosted the Fusion Applications instance for this book. At the same time, the constant encouragement from my parents to learn from failure helped me stay strong through a number of challenges while installing initial versions of Fusion Applications on modest hardware.
Tushar Thakkeris a Senior Oracle Architect and an avid technology blogger. He is a Certified Oracle Apps DBA and Project Management Professional (PMP). He has more than 13 years of experience working on various Oracle products with some of the top technology giants, including Oracle and EMC as well as government organizations in India and UAE. Tushar is the founder of a technology startup called Param Labs and the well-known Oracle education blog OraTraining.com , where he writes a number of step-by-step guides for various Oracle products and their new releases. He also runs a free Oracle troubleshooting portal named OraSupport.com , where he resolves any Oracle-related issues faced by users. Tushar believes in spreading Oracle knowledge to as many people as possible, hence creating a larger Oracle user community.
Dhananjay Papdehas extensive IT experience on Oracle databases, the E-Business Suite, and BI. He is a lead specialist and Oracle Technical Architect at SITA in the UK. He is the author of Oracle Enterprise Manager 12c Administration Cookbook and was also the technical Reviewer of the book entitled Pro Oracle Fusion Applications: Installation and Administration. He is an Oracle ACE Associate and won the Oracle Fusion Middleware Innovation Award at Oracle Open World 2011. He has been a speaker at various events, including Oracle Open World 2013, 2014, UKOUG Annual Conferences in 2012, Tech13, Apps14 and SIG, and Oracle Data Innovation Forum in London and Dublin.
18.226.98.208