Skip Headers
JD Edwards EnterpriseOne Application Pack for Oracle Enterprise Manager Cloud Control Implementation Guide
Release 9.1

E26776-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

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

2 Install the Database for Enterprise Manager

This chapter shows an example of a new installation of Enterprise Manager. For existing installations, refer to the Caution below. After you have reviewed the Caution, existing installations of Enterprise Manager can proceed to Chapter 5, "Import the JD Edwards Application Pack OPAR".

An Oracle database must be installed that is configured expressly for use by Enterprise Manager (see Caution below). For reference purposes, this chapter shows an example of installing the Oracle database for use by Enterprise Manager. However, Oracle strongly recommends that you use the OEM Oracle database installation software instructions under the direction of an Oracle DBA.

Caution:

Both new and existing installation of the Oracle database must perform the procedures in the section of this chapter entitled: Section 2.2, "Post Installation Required Database Configuration".

This chapter contains the following topics:

2.1 Running the Oracle Database Installer

Note:

This procedure assumes you have obtained the software component for the Oracle database as described in the chapter of this guide entitled: Section 1.4, "Obtaining Oracle Software Components from the Oracle Software Delivery Cloud".

On the machine where you have downloaded the Oracle 11g database installer:

  1. Change directory to directory where you downloaded the installer. For example:

    cd /u01/downloads/db11gr2/database

  2. Launch the installer using this command:

    ./runInstaller

    This image is described in surrounding text.
    Description of the illustration install_db_install_option.gif

  3. On Configure Security Updates, in order to be informed of security issues you must either provide an email address or choose to receive security updates via My Oracle Support. If you have an Oracle Support account, it will be easier if click the checkbox to choose to receive security updates via My Oracle Support.

  4. Click the Next button.

    This image is described in surrounding text.
    Description of the illustration install_db_grid_option.gif

  5. On Select Installation Option, click this radio button:

    Create and configure a database

  6. Click the Next button.

    This image is described in surrounding text.
    Description of the illustration install_db_sys_class.gif

  7. On System Class, click this radio button to install on a server class system.

    Server Class

    This option allows for more advanced configuration options.

  8. Click the Next button.

    This image is described in surrounding text.
    Description of the illustration install_db_type.gif

  9. On Node Selection, choose this radio button:

    Single instance database installation

  10. Click the Next button.

    This image is described in surrounding text.
    Description of the illustration install_db_typical.gif

  11. On Select Install Type, click this radio button:

    Typical Install

  12. Click the Next button.

    This image is described in surrounding text.
    Description of the illustration install_db_config.gif

  13. On Typical Install Configuration, complete these fields:

    • Oracle base

      Enter your Oracle base location. For example:

      /u01/app/oracle

    • Software location

      Enter or browse to the location of your Oracle base folder. This location must exist and be empty. For example:

      /u01/app/oracle/oradata

    • Global database name

      Enter the global database name. For example:

      emrep

    • Administrative Password

      Enter the administrative password for the global database.

    • Confirm Password

      Reenter the administrative password for the global database.

  14. Click the Next button.

    This image is described in surrounding text.
    Description of the illustration install_db_inventory.gif

  15. On Create Inventory, if this is your first installation on this host, you are prompted to enter an Inventory Directory. The installer automatically sets up subdirectories for each product to contain inventory data. The subdirectory for each product typically requires 150 KB of disk space. Optionally you can also choose between the available values in the oraInventory Group Name pulldown. For example, your inventory directory might be:

    /u01/app/oraInventory

    Note:

    This directory must exist and be empty.
  16. Click the Next button.

    This image is described in surrounding text.
    Description of the illustration install_db_checks.gif

    The installer begins the prerequisite check and displays the progress as it verifies that the target environment meets the minimum installation and configuration requirements for products you have selected.

    This image is described in surrounding text.
    Description of the illustration install_db_summary.gif

    When the requisites check completes, the Summary screen is displayed.

  17. On Summary, review the contents. Optionally you can click the Save Response File... button to save the contents of the Summary screen.

  18. Click the Finish button to begin the actual installation.

    This image is described in surrounding text.
    Description of the illustration install_db_progress.gif

    The installer displays a progress bar of In Progress and Pending tasks.

    This image is described in surrounding text.
    Description of the illustration install_db_db_assist.gif

    After the point in the installation when the database is successfully created, the installer displays an Xterm window for the Database Configuration Assistant.

    Note:

    All database accounts except SYS, SYSTEM, DBSNMP, and SYSMAN are locked. Optionally, you can click the Password Management... button to view a complete list of locked accounts or manage the database accounts (except DBSNMP and SYSMAN). From the Password Management window, unlock only the accounts you will use. Oracle Corporation strongly recommends changing the default passwords immediately after unlocking the account.
  19. If you clicked the Password Management... button this Xterm window for Password Management is displayed: This image is described in surrounding text.
    Description of the illustration install_db_pswd_man.gif

  20. On Password Management, you can Lock or unlock database user accounts and/or change the default passwords.

    If you choose to change accounts settings or passwords, click the OK button. Otherwise, click Cancel to return to the Database Configuration Assistant Xterm window.

  21. On Database Configuration Assistant, click the OK button to resume the remaining installer tasks.

    This image is described in surrounding text.
    Description of the illustration install_db_scripts.gif

  22. On the Xterm window for Execute Configuration scripts, you must execute the configuration scripts as the "root" user. To execute the configuration scripts:

    • Open a terminal window.

    • Log in as "root".

    • Run the scripts and verify that they ran successfully.

    • Return to this window.

  23. On Execute Configuration Scripts, after you have executed the scripts as described in the preceding step, click the OK button to continue.

    This image is described in surrounding text.
    Description of the illustration install_db_finish.gif

  24. On Finish, verify the installation of the Oracle Database was successful and click the Close button.

2.2 Post Installation Required Database Configuration

After you install a new Oracle database for exclusive use by Cloud Control 12c, the Cloud Control documentation recommends you configure your database using this procedure.

  1. Drop the management repository using this line command:

    emca -deconfig dbcontrol db -repos drop

    A sample of the resulting console session is shown below.

    [oracle@denlx01 bin]$ ./emca -deconfig dbcontrol db -repos drop
     
    STARTED EMCA at Aug 10, 2011 11:44:38 AM
    EM Configuration Assistant, Version 11.2.0.0.2 Production
    Copyright (c) 2003, 2005, Oracle.  All rights reserved.
     
    Enter the following information:
    Database SID: emrep
    Listener port number: 1521
    Password for SYS user:
    Password for SYSMAN user:
     
    Do you wish to continue? [yes(Y)/no(N)]: Y
    Aug 10, 2011 11:44:55 AM oracle.sysman.emcp.EMConfig perform
    INFO: This operation is being logged at /home/oracle/cfgtoollogs/emca/emrep/emca_2011_08_10_11_44_37.log.
    Aug 10, 2011 11:44:55 AM oracle.sysman.emcp.util.DBControlUtil stopOMS
    INFO: Stopping Database Control (this may take a while) ...
    Aug 10, 2011 11:45:19 AM oracle.sysman.emcp.EMReposConfig invoke
    INFO: Dropping the EM repository (this may take a while) ...
    Aug 10, 2011 11:47:10 AM oracle.sysman.emcp.EMReposConfig invoke
    INFO: Repository successfully dropped
    Enterprise Manager configuration completed successfully
    FINISHED EMCA at Aug 10, 2011 11:47:14 AM
    You have new mail in /var/spool/mail/oracle
    [oracle@denlx01 bin]$
    
  2. Per requirements for Cloud Control, you must change the Oracle database init parameters.

    Connected to the Oracle database as sysdba, use this command sequence:

    alter system set session_cached_cursors=200 scope=spfile;
    alter system set remote_login_passwordfile=SHARED scope=spfile;
    alter system set aq_tm_processes=1 scope=spfile;
    alter system set processes=500 scope=spfile;
    alter system set log_buffer=10485760 scope=spfile;
    shutdown immediate
    startup