Skip Headers
Oracle® Fusion Applications Installation Notes
11g Release 1 (11.1.1.5.0)
 

View PDF

 

Beta Draft: 2011-05-19

Oracle® Fusion Applications

Installation Notes

11g Release 1 (11.1.1.5.0)

May 2011

These installation notes provide information about manually installing an instance of Oracle Database Enterprise Edition (single-node) or Oracle Real Application Clusters (Oracle RAC). It contains the following sections:

For information about provisioning Oracle Fusion Applications, see the Oracle Fusion Applications Installation Guide.

1 Overview

Though Oracle Fusion Applications provisioning automates the installation and configuration of a transaction database for use with Oracle Fusion Applications environments, you can manually install an instance of Oracle Database (single-node) or Oracle Real Application Clusters to meet your specific requirements. To manually install and configure the transaction database, perform the following tasks.

  1. Install Oracle Database or Oracle RAC.

  2. Apply database patches.

  3. If installing an instance of Oracle Database, configure the database listener.

  4. Create transaction database instances using Oracle Database Configuration Assistant (DBCA).

  5. Start the database.

  6. Complete any post-installation tasks that are required by the database patches.

2 Installing Oracle Database or Oracle RAC

The first step in creating a custom transaction database instance is to install the database software.

2.1 How to Install Oracle Database

Install Oracle Database interactively instead of using the Provisioning Wizard. See the Oracle 11g Release 2 Documentation Library for information about how to install Oracle Database interactively.

When performing the installation, ensure that the following components are enabled:

  • Oracle Partitioning (default)

  • Oracle OLAP (default)

  • Oracle Label Security (select for runtime requirements)

  • Oracle Data Mining RDBMS Files (default)

  • Oracle Real Application Testing (default)

If these components are not enabled, application functionality will not work.When performing the installation, choose the option to perform a software-only installation. You will manually create the database instance and configure the database as described in the following sections.

2.2 How to Install Oracle RAC

For complete information about manually installing and configuring Oracle RAC, refer to the Oracle 11g Release 2 Documentation Library.

3 Applying Database Patches

Oracle Fusion Applications requires several database patches. When you install a database manually, you must apply these patches to your database before you run the Oracle Fusion Applications Repository Creation Utility (Applications RCU). With Oracle Database, you must also apply the patches before configuring the database listener.

Before you apply the database patches, you must ensure that all database instances are stopped and that your file system is ready for patching.

3.1 How to Apply Patches to Oracle RAC

For information about applying patches to an Oracle RAC database instance, see the Oracle Database 2 Day + Real Application Clusters Guide 11g Release 2 Guide.

3.2 How to Apply Patches to Oracle Database

You use OPatch to apply patches to Oracle Database. For information about OPatch, see the Oracle Universal Installer and OPatch User's Guide.

To apply the database patches to Oracle Database:

  1. Navigate to the database ORACLE_HOME/OPatch directory.

  2. Invoke the OPatch command using the following parameters:

    ./opatch napply REPOSITORY_LOCATION/installers/database/patch -skip_duplicates -skip_subset
    

    The REPOSITORY_LOCATION is the path to the directory that was created when the applications media pack was unzipped.

4 Configuring the Database Listener for Oracle Database

If you are using Oracle Database, you must configure the database listener as described in the Oracle 11g Release 2 Documentation Library. After you complete the configuration, start the database listener.

5 Creating the Transaction Database Instance

You can use Oracle Database Configuration Assistant (DBCA) to create the transaction database from a database template that is shipped with Oracle Fusion Applications software. This template contains the database structure and features, but is not seeded. It is generic for use across platforms.

Instructions on database installation and configuration can be found in the Oracle 11g Release 2 Documentation Library.

If you choose to not use the database template, you must ensure that your database configuration parameters are aligned with the values specified in the "Minimum Configuration Parameters for Oracle Database" section in the Oracle Fusion Applications Installation Guide.

5.1 How to Create a Single-Node Instance of Oracle Database from the Template

You use DBCA to manually create an an instance of Oracle Database from the non-seeded database template that is shipped with Oracle Fusion Applications software.

To create a single-node Oracle Database instance:

  1. Edit the non-seeded database template at PROV_FRMWK_HOME/provisioning/provisioning/template/dbca/empty_database_11.2.dbt and set the process initialization parameter to 2500 as shown in the following text:

    <initParam name="processes"              value="2500"/>
    
  2. Navigate to the database ORACLE_HOME/bin directory and execute the following command:

    dbca -silent -createDatabase \
    -templateName  PROV_FRMWK_HOME/provisioning/provisioning/template/dbca/empty_database_11.2.dbt  \
    -gdbName "ORACLE_SID" \
    -sid "ORACLE_SID" \
    -sysPassword "SYS_PASSWORD" \
    -systemPassword "SYSTEM_PASSWORD" \
    -emConfiguration "NONE" \
    -characterSet "AL32UTF8" - \
    -nationalCharacterSet "AL16UTF16" \
    -variables ORACLE_BASE=ORACLE_BASE, ORACLE_HOME=ORACLE_HOME \
    -initParams audit_trail=NONE \
    -datafileDestination DATAFILE_LOC
    

    Replace the following variables with the appropriate values:

    • PROV_FRMWK_HOME - Home of Fusion Applications Provisioning framework

    • ORACLE_SID - Global database name of the Oracle Fusion Applications database

    • SYS_PASSWORD - Sys password

    • SYSTEM_PASSWORD - System user password

    • ORACLE_BASE - Top level directory for the database installation.

    • ORACLE_HOME - Oracle home of the database installation

    • DATAFILE_LOC - Physical location of the files that store the data of all logical structures in the database

5.2 How to Create an Oracle RAC Database Instance from the Template

You use DBCA to manually create a database instance for each Oracle RAC node using the non-seeded database template that is shipped with Oracle Fusion Applications software.

To create an Oracle RAC database instance:

  1. Edit the non-seeded database template at PROV_FRMWK_HOME/provisioning/provisioning/template/dbca/empty_database_11.2.dbt and set the process initialization parameter to 2500 as shown in the following text:

    <initParam name="processes"              value="2500"/>
    
  2. For each RAC node, navigate to the database ORACLE_HOME/bin directory of the RAC node and execute the following command:

    dbca -silent -createDatabase \
    -templateName  PROV_FRMWK_HOME/provisioning/provisioning/template/dbca/empty_database_11.2.dbt  \
    -gdbName "ORACLE_SID" \
    -sid "ORACLE_SID" \
    -sysPassword "SYS_PASSWORD" \
    -systemPassword "SYSTEM_PASSWORD" \
    -emConfiguration "NONE" \
    -characterSet "AL32UTF8" - \
    -nationalCharacterSet "AL16UTF16" \
    -variables ORACLE_BASE=ORACLE_BASE, ORACLE_HOME=ORACLE_HOME \
    -initParams audit_trail=NONE \
    -datafileDestination DATAFILE_LOC \
    -nodeinfo node1,node2
    

    Replace the following variables with the appropriate values:

    • PROV_FRMWK_HOME - Home of Fusion Applications Provisioning framework

    • ORACLE_SID - Global database name of the Oracle Fusion Applications database

    • SYS_PASSWORD - Sys password

    • SYSTEM_PASSWORD - System user password

    • ORACLE_BASE - Top level directory for the database installation.

    • ORACLE_HOME - Oracle home of the database installation

    • DATAFILE_LOC - Physical location of the files that store the data of all logical structures in the database

6 Starting the Database

Refer to the Oracle 11g Release 2 Documentation Library for instructions on how to start the database.

7 Completing Post-Installation Tasks

After you have applied the patches and started the database, check the release notes for each patch to determine whether you need to perform post-installation tasks.


Oracle Fusion Applications Installation Notes, 11g Release 1 (11.1.1.5.0)

Copyright © 2011 Oracle and/or its affiliates. All rights reserved.

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:

U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle America, Inc., 500 Oracle Parkway, Redwood City, CA 94065.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.

This documentation is in prerelease status and is intended for demonstration and preliminary use only. It may not be specific to the hardware on which you are using the software. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to this documentation and will not be responsible for any loss, costs, or damages incurred due to the use of this documentation.

The information contained in this document is for informational sharing purposes only and should be considered in your capacity as a customer advisory board member or pursuant to your beta trial agreement only. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described in this document remains at the sole discretion of Oracle.

This document in any form, software or printed matter, contains proprietary information that is the exclusive property of Oracle. Your access to and use of this confidential material is subject to the terms and conditions of your Oracle Software License and Service Agreement, which has been executed and with which you agree to comply. This document and information contained herein may not be disclosed, copied, reproduced, or distributed to anyone outside Oracle without prior written consent of Oracle. This document is not part of your license agreement nor can it be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates.