Skip Headers
Oracle® Fusion Applications Customer Relationship Management Enterprise Deployment Guide
11g Release 5 (11.1.5)

Part Number E16684-13
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

4 Preparing the Database for an Enterprise Deployment

This chapter provides information about how the database tier is implemented in an enterprise deployment topology.

This chapter includes the following topics:

4.1 Understanding the Database in the Enterprise Deployment Topology

The Oracle Fusion Applications reference enterprise deployment topology uses a single database for the following components:

Implementing Oracle Business Intelligence Data Warehouse requires a separate database for following components:

For the enterprise topology, Oracle Real Application Clusters (Oracle RAC) databases are highly recommended. You must set up these databases before you can install and configure the Oracle Fusion Applications components. You install the Oracle Fusion Applications and Oracle Fusion Middleware metadata repositories into existing databases using the Fusion Applications Repository Creation Utility (Fusion Applications RCU).

4.2 Setting Up the Database

Before loading the metadata repository into your database, check that the database meets the requirements described in these sections:

Note:

When creating the database, ensure that the length of the Oracle System ID (SID) does not exceed eight (8) characters.

For example:

  • SID: abcd12345 is invalid

  • SID: abcd123 is valid

4.2.1 Database Host Requirements

Note the following requirements for the hosts FUSIONDBHOST1 and FUSIONDBHOST2 in the data tier:

  • Oracle Clusterware

    For Oracle Database 11g Release 2 (11.2.0.3) for Linux, refer to the Oracle Database Installation Guide.

  • Oracle Real Application Clusters

    For Oracle RAC 11g Release 2 (11.2.0.3) for Linux or Oracle Database 10g Release 2 (10.2) for Linux, refer to the Oracle Database Installation Guide.

  • Oracle Automatic Storage Management (optional)

    Oracle ASM gets installed for the node as a whole. It is recommended that you install it in a separate Oracle Home from the Database Oracle Home. This option comes in at runInstaller. In the Select Configuration page, select the Configure Automatic Storage Management option to create a separate Oracle ASM home.

4.2.2 Supported Database Versions

Oracle Fusion Applications requires the presence of a supported database and schemas. To check if your database is certified or to see all certified databases, refer to the supported platforms documentation for Oracle Fusion Applications.

To check the release of your database, you can query the PRODUCT_COMPONENT_VERSION view as follows:

SQL> SELECT VERSION FROM SYS.PRODUCT_COMPONENT_VERSION WHERE PRODUCT LIKE 'Oracle%';

Notes:

  • The database you use as the Oracle Fusion Applications supporting database must support the AL32UTF8 character set.

  • When installing the database, please ensure that Oracle Label Security is enabled, as shown in Figure 4-1. In the case of an Oracle RAC installation, the Oracle Label Security should be enabled on all the nodes.

You enable Oracle Label Security in the Select Database Edition screen, shown in Figure 4-1, using Oracle Universal Installer.

Figure 4-1 Oracle Label Security

Oracle Label Security

4.2.3 Minimum Database Configuration Parameters

Table 4-1 shows the recommended minimum init.ora parameters for an Oracle database. The database shipped with the Oracle Fusion Applications software contains this configuration. When you run the Fusion Applications RCU, its prerequisite check feature checks to see that the database meets these minimum requirements.

Table 4-1 Minimum Requirements for Database Configuration

INST_ID Parameter Value

_b_tree_bitmap_plans

FALSE

audit_trail

NONE

compatible

11.2.0

db_files

1024

db_recovery_file_dest_size

2147483648

db_writer_processes

1

disk_asynch_io

FALSE

fast_start_mttr_target

3600

filesystemio_options

Setall

job_queue_processes

10

log_buffer

10485760

log_checkpoints_to_alert

TRUE

max_dump_file_size

10M

memory_target

unset or N/A

nls_sort

BINARY

open_cursors

500

pga_aggregate_target

>= 8589934592 (8 GB)

plsql_code_type

NATIVE

processes

5000

session_cached_cursors

500

sga_target

>=19327352832 (18 GB)

trace_enabled

FALSE

undo_management

AUTO


For example, to use the SHOW PARAMETER command using SQL*Plus to check the value of the initialization parameter:

  1. As the SYS user, enter the SHOW PARAMETER command:

    SQL> SHOW PARAMETER processes
    
  2. Set the initialization parameter using the following commands:

    SQL> ALTER SYSTEM SET processes=5000 SCOPE=SPFILE;
    
    SQL> ALTER SYSTEM SET open_cursors=500 SCOPE=SPFILE;
    
  3. Restart the database.

    Note:

    The method that you use to change a parameter's value depends on whether the parameter is static or dynamic, and on whether your database uses a parameter file or a server parameter file. See the Oracle Database Administrator's Guide for details on parameter files, server parameter files, and how to change parameter values.

4.3 Creating and Starting the Database Services

Oracle recommends using the Oracle Enterprise Manager Fusion Middleware Control Cluster Managed Services screen or SQL*Plus to create database services that client applications will use to connect to the database.

To configure this using SQL*Plus:

  1. Use the CREATE_SERVICE subprogram to create the database service.

    Log in to SQL*Plus as the sysdba user and run the following command:

    SQL> EXECUTE DBMS_SERVICE.CREATE_SERVICE
    (SERVICE_NAME => 'crm.mycompany.com',
    NETWORK_NAME => 'crm.mycompany.com'
    );
    
  2. Add the service to the database and assign it to the instances using srvctl:

    prompt> srvctl add service -d fusiondb -s crm.mycompany.com -r 
    fusiondb1,fusiondb2
    
  3. Start the service using srvctl:

    prompt> srvctl start service -d fusiondb -s crm.mycompany.com
    
  4. Verify that the crm service is running on instance(s) fusiondb1 and fusiondb2:

    prompt> srvctl status service -d fusiondb
    

Note:

For more information about the srvctl command, see the Oracle Real Application Clusters Administration and Deployment Guide.

Oracle recommends that a specific database service be used for a product suite even when they share the same database. It is also recommended that the database service used is different than the default database service. For example, for Oracle Fusion Customer Relationship Management the database would be crmdb.mycompany.com and the default service is one with the same name. The Oracle Fusion Customer Relationship Management install is configured to use the service crm.mycompany.com.

4.3.1 Updating the Kernel Parameters

This section describes how to update the kernel parameters for Linux before the database is installed.

To update the parameters:

  1. Log in as root and add or edit the following values in the /etc/sysctl.conf file:

    fs.file-max = 6815744
    kernel.shmall = 2097152
    kernel.shmmax = 2147483648
    kernel.shmmni = 4096
    kernel.sem = 250 32000 100 128
    net.core.rmem_default = 4194304
    net.core.rmem_max = 4194304
    net.core.wmem_default = 262144
    net.core.wmem_max = 1048576
    net.ipv4.ip_forward = 0
    net.ipv4.conf.default.rp_filter = 1
    tcp.ipv4.tcp_wmem = 262144 262144 262144
    tcp.ipv4.tcp_rmem = 4194304 4194304 4194304
    fs.aio-max-nr = 1048576
    net.ipv4.ip_local_port_range = 9000 65000
    
  2. Execute the following command to activate the changes:

    /sbin/sysctl -p
    

4.3.2 Adding a Database Patch

To add a patch to the database, set the path to Opatch in the database installation directory and run the following command:

./opatch napply ORACLE_BASE/repository/installers/database/patch -skip_duplicate 
-skip_subset

For the location of the repository, see Section 5.3.1, "Creating the Installation Environment" in Chapter 5, "Using the Provisioning Process to Install Components for an Enterprise Deployment."

4.4 Loading the Oracle Fusion Applications Repository into the Oracle RAC Database

Before loading the Oracle Fusion Applications repository into a database, you must apply database patch 10220058 in order to run the Oracle Fusion Applications Repository Creation Utility (Fusion Applications RCU) with Oracle Database 11g Enterprise Edition Release 11.2.0.2.0. To find the patch, go to My Oracle Support (https://support.oracle.com) and click the Patches & Updates tab.

The Fusion Applications RCU components are included in the zipped Fusion Applications RCU file delivered in the provisioning framework. (The location of the file is ORACLE_BASE/installers/apps_rcu/linux/rcuHome_fusionapps_linux.zip.) Unzip the file to the RCU_HOME location on the FUSIONDBHOST1 machine. For example, ORACLE_BASE/rcu.

Once you have the Fusion Applications RCU installed, do the following:

  1. Copy all the required dump files locally on FUSIONDBHOST1 (for example, to /tmp):

    FUSIONDBHOST1> cd RCU_HOME/rcu/integration/fusionapps
    FUSIONDBHOST1> cp export_fusionapps_dbinstall.zip /tmp
    FUSIONDBHOST1> cd RCU_HOME/rcu/integration/biapps/schema
    FUSIONDBHOST1> cp otbi.dmp /tmp
    FUSIONDBHOST1> cd /tmp
    FUSIONDBHOST1> unzip export_fusionapps_dbinstall.zip
    

    Note:

    When running Fusion Applications RCU for Oracle RAC, you must copy the export_fusionapps_dbinstall.zip file as well as otbi.dmp to all the nodes of the Oracle RAC.

  2. Create the incident_logs directory on FUSIONDBHOST1:

    FUSIONDBHOST1> cd ORACLE_HOME
    FUSIONDBHOST1> mkdir incident_logs
    
  3. Start Fusion Applications RCU from the /bin directory in the Fusion Applications RCU home directory:

    cd RCU_HOME/bin
    ./rcu
    
  4. In the Welcome screen (if displayed), click Next.

  5. In the Create Repository screen, shown in Figure 4-2, select Create to load component schemas into a database. Click Next.

    Figure 4-2 Create Repository Screen

    Create Repository Screen
  6. In the Database Connection Details screen, shown in Figure 4-3, enter connect information for your database:

    • Database Type: Select Oracle Database

    • Host Name: Specify the name of the node on which the database resides. For the Oracle RAC database, specify the VIP name or one of the node names as the host name: FUSIONDBHOST1-VIP

    • Port: Specify the listen port number for the database; for example 1521

    • Service Name: Specify the service name of the database (crm.mycompany.com)

    • Username: Specify the name of the user with DBA or SYSDBA privileges: SYS

    • Password: Enter the password for the SYS user

    • Role: Select the database user's role from the list: SYSDBA (required by the SYS user)

    Click Next.

    Figure 4-3 Database Connection Details Screen

    Database Connection Details Screen
  7. The Repository Creation Utility selects the required components automatically, as shown in Figure 4-4.

    Figure 4-4 Select Components Screen

    Select Components Screen (1)

    Click Next. The Repository Creation Utility checks the prerequisites, as shown in Figure 4-5.

    Figure 4-5 Prerequisite Check

    Prerequisite Check

    Click OK.

  8. In the Schema Passwords screen, shown in Figure 4-6, enter passwords for the main and additional (auxiliary) schema users, and click Next.

    Note:

    For increased security, do the following:

    • Specify different schema passwords for all schemas

    • Ensure that all passwords are more than eight (8) characters in length.

    Figure 4-6 Schema Passwords Screen

    Schema Passwords Screen
  9. In the Custom Variables screen, shown in Figure 4-7, enter the required values.

    Fusion Applications

    • FUSIONAPPS_DBINSTALL_DP_DIR: The directory on the database server where you unzipped export_fusionapps_dbinstall.zip and copied the otbi.dmp file. For example, /tmp.

    • APPLCP_FILE_DIR: Used by Oracle Enterprise Scheduler to store the log and output files. For example, ORACLE_HOME/incident_logs.

    • APPLLOG_DIR: Location of the PL/SQL log file from Oracle Fusion Applications PL/SQL procedures, on the database server. For example, ORACLE_HOME/incident_logs.

    • OBIEE Backup Directory: Location of the Oracle Business Intelligence Enterprise Edition dump files.

      Note:

      When specifying an Oracle Business Intelligence Enterprise Edition (OBIEE) backup directory, set it to be a shared directory with read/write permissions for both FUSIONDB hosts.

    • KEYFLEXCOMBFILTER: Location of the Filter XMLSchema. For example, /tmp.

    Secure Enterprise Search

    • Do you have Advanced Compression Option (ACO) License? Yes (Y) or No (N): Default is No.

    • Do you have Oracle Partitioning option License? Yes (Y) or No (N): Default is No.

    Master and Work Repository

    Note: The default values are the only valid values. If you change any of these values, the ODI-related provisioning process will not work.

    • Master Repository ID: Default = 501

    • Supervisor Password: Enter and confirm your ODI supervisor password.

    • Work Repository Type: (D) Development or (R). Default = D

    • Work Repository ID: Default = 501

    • Work Repository Name: Default = FUSIONAPPS_WREP

    • Work Repository Password: Default = None. Enter and confirm your ODI supervisor password.

    Oracle Transactional BI

    • Directory on the database server where Oracle Transactional Business Intelligence import and export files are stored. For example, /tmp.

    Activity Graph and Analytics

    • Install Analytics with Partitioning (Y/N): Default is N.

    Click Next to continue.

    Figure 4-7 Custom Variables Screen

    Custom Variables Screen
  10. In the Map Tablespaces screen, click Next.

  11. In the Summary screen, click Create.

  12. In the Completion Summary screen, click Close.

Note:

If you encounter any issues while using the Repository Creation Utility, check the logs at RCU_HOME/rcu/log.

Note:

Oracle recommends using the database used for identity management to store the Oracle WSM policies. It is therefore expected to use the IM database information for the OWSM MDS schemas, which will be different from the one used for the rest of SOA schemas. To create the required schemas in the database, repeat the steps above using the IM database information, but select only "AS Common Schemas: Metadata Services" in the Select Components screen (Step 7).

4.5 Backing Up the Database

After you have loaded the metadata repository in your database, you should make a backup.

Backing up the database is for the explicit purpose of quick recovery from any issue that may occur in the further steps. You can choose to use your backup strategy for the database for this purpose or simply make a backup using operating system tools or RMAN for this purpose. It is recommended that you use Oracle Recovery Manager for the database, particularly if the database was created using Oracle ASM. If possible, a cold backup using operating system tools such as tar can also be performed.