This article will show an installation of Oracle Enterprise Manager Cloud Control 12c in silent mode (no GUI, command line only).

OEM Cloud Control 12c is a centralised management software for administrating and monitoring all oracle's products, especially oracle database.
It is quite powerful and it becomes very handy when you manage many databases, and its base features are free of charge to use.

Before starting, you will need ...
... a Oracle RDBMS 11g or 12c installed (on localhost or another server, see here)
... to download Oracle Enterprise Manager Cloud Control 12c installation files (here)
... at least 14GB free disk space

About licensing

The full Oracle Enterprise Manager Licensing Information can be found here, and it says:

The base installation of Enterprise Manager Cloud Control 12c includes several features free of charge with the purchase of any Oracle software license or Support contract.

Oracle Enterprise Manager Licensing Information

Enterprise Manager includes a restricted-use license of the Oracle Database for use only with the Oracle Management Repository or other complementary repositories included with Enterprise Manager (such as, AWR Warehouse, Ops Center, Real User Experience Insight, Load Testing, and Test Manager). Additional database options or additional servers for disaster recovery require separate licensing.

Oracle Enterprise Manager Licensing Information

In other words, OEM Cloud Control 12c base functionalities are free to use as long as you have a Oracle licence (or support) for any target you want to manage with it.
And a Oracle database which is only use for OEM does not required additional licence except for Dataguard and RAC option.

List of "free of charge" base functionalities list can be reviewed in "chapter 10 : Base Enterprise Manager Functionality".

Functionality packs which requires a licence can be enabled or disabled as describe in "chapter 1.3: Enabling and Disabling the Oracle Enterprise Manager Packs".
It is recommanded to disable packs you are not licenced to.

 

OEM 12c database repository

OEM Cloud Control 12c required an oracle database 11g/12c as a repository to store its data.
This oracle database repository is not created by the installer.

So you need to create a new Oracle database or you can use an existing database, it can be on a different server as long as it is accessible by the OEM 12c.

For example, the command below will create emrep oracle instance on ASM storage.

[oracle]$ dbca -silent -createDatabase \
-templateName New_Database.dbt \
-gdbName emrep -sid emrep \
-sysPassword ... \
-systemPassword ... \
-storageType ASM \
-asmSysPassword ... \
-asmsnmpPassword ... \
-diskGroupName DATA -recoveryGroupName FRA \
-recoveryAreaDestination FRA \
-databaseType MULTIPURPOSE \
-characterSet AL32UTF8 -nationalCharacterSet AL16UTF16 \
-totalMemory 4096 -automaticMemoryManagement true \
-redoLogFileSize 640 \
-listeners LISTENER -registerWithDirService false \
-emConfiguration NONE

Decompress install files

For this article, I have downloaded Oracle Enterprise Manager Cloud Control 12c Release 5 (12.1.0.5) installation files for Linux x86-64 (64-bit) at oracle.com.

# Extract oem12c install files
[oracle]$ ls em12105_linux64_disk*.zip | xargs -I{} unzip {} -d ./em12c_inst

Prerequisite check

The command below will check system and database parameters and do report about what it needs to be fixed for this installation.
Run this command can be executed as many times as you need to check and fix.

# OEM12c prerequisite-check
[oracle]$ cd ./em12c_inst
[oracle]$ ./install/requisites/bin/emprereqkit -executionType install \
-prerequisiteXMLLoc install/requisites/list \
-dbHost oralab01 -dbPort 1521 -dbSid emrep \
-dbUser SYS -dbPassword ... -dbRole sysdba \
-runPrerequisites


    Checking Temp space: must be greater than 400 MB.   Actual 9156 MB    Passed
    Checking swap space: must be greater than 150 MB.   Actual 1639 MB    Passed
    Preparing to Bootstrap  Please wait ...
    BootStrap To /tmp/emprereqkit_101915183145_BS Completed
    Oracle Enterprise Manager Cloud Control 12c Release 3
    Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.

    Running EMPrereqKit ............

    Result of prerequisite-check , for scenario install :                                            

    --------------------------------------------------------------------------------------------------------------------------------------------------------------------------
                        Prerequisite Name                   | Status |              Corrective Action             |        Recommendation       
    --------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      Check for invalid objects in the database selected for|  Pass  |                   NA                       |               NA           
      Check the job_queue_processes instance parameter value|  Pass  |                   NA                       |               NA           
      Check the CBO stats gathering job                     |  Pass  |                   NA                       |               NA           
      Check nls_length_semantics parameter                  |  Pass  |                   NA                       |               NA           
      Check for automatic UNDO management                   |  Pass  |                   NA                       |               NA           
      Ensure that the undo tablespace has at least one dataf|  Pass  |                   NA                       |               NA           
      Ensure that the SYSTEM tablespace has at least one dat|  Pass  |                   NA                       |               NA           
      Ensure that the Oracle partitioning option is installe|  Pass  |                   NA                       |               NA           
      Check remote_login_passwordfile parameter             |  Pass  |                   NA                       |               NA           
      Check max_enabled_roles init parameter                |  Pass  |                   NA                       |               NA           
      Check for the global stale percent                    |  Pass  |                   NA                       |               NA           
      Check if SYSMAN schema is absent for new install      |  Fail  |                 MANUAL                     |  SYSMAN schema should be absent before instal
      Check the existence of public synonyms                |  Fail  |                 MANUAL                     |  Remove the public synonyms
      Check the absence of mgmt tablespaces                 |  Pass  |                   NA                       |               NA           
      Check the absence of EM schemas                       |  Fail  |                 MANUAL                     |  Remove the EM schemas     
      Check the db edition                                  |  Pass  |                   NA                       |               NA           
      Check optimizer sql plan baseline capture.            |  Pass  |                   NA                       |               NA           
      Check if temporary tablespace group TEMP exist        |  Pass  |                   NA                       |               NA           
      Check if the temporary tablespace datafile is set to a|  Pass  |                   NA                       |               NA           
      Check parallel max servers parameter                  |  Fail  |  set parallel_max_servers to 8             |  The parallel max servers parameter will be t
      Check that the secure file instance parameter is set t|  Pass  |                   NA                       |               NA           
      Check the compatible instance parameter value.        |  Pass  |                   NA                       |               NA           
      Check the db_block_size instance parameter value.     |  Pass  |                   NA                       |               NA           
      Check the processes instance parameter value          |  Fail  |                 MANUAL                     |  The processes instance parameter needs to be
      Check the memory_target instance parameter value.     |  Fail  |                 MANUAL                     |  Oracle recommends setting memory_target (AMM
      Check the workarea_size_policy instance parameter valu|  Pass  |                   NA                       |               NA           
      Check the session_cached_cursors instance parameter va|  Fail  |                 MANUAL                     |  The session_cached_cursors instance paramete
      Check the open_cursors instance parameter value.      |  Pass  |                   NA                       |               NA           
      Check the log_buffer instance parameter value.        |  Pass  |                   NA                       |               NA           
      Check the shared_pool_size instance parameter value.  |  Fail  |                 MANUAL                     |  The shared_pool_size instance parameter shou
      Check the db_cache_size instance parameter value.     |  Pass  |                   NA                       |               NA           
      Check the large_pool_size instance parameter value.   |  Pass  |                   NA                       |               NA           
      Check the java_pool_size instance parameter value.    |  Pass  |                   NA                       |               NA           
      Check the streams_pool_size instance parameter value. |  Pass  |                   NA                       |               NA           
      Check the timed_statistics instance parameter value.  |  Pass  |                   NA                       |               NA           
      Check the statistics_level instance parameter value.  |  Pass  |                   NA                       |               NA           
      Check the redo log size.                              |  Fail  |                 MANUAL                     |  Redo Log file size should be 600000000 bytes
    --------------------------------------------------------------------------------------------------------------------------------------------------------------------------
                            NE = Not Executed                        NA = Not Applicable
    --------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    For more details, check the log file at /mnt/nfs/uxora_share/em12c_inst/prerequisiteResults/log/LATEST/

As the report says, SYSMAN schema should be absent before install on the target database repository. On the database host, you can use commands below as oracle user:

# Remove sysman repository
[oracle]$ sqlplus / as sysdba
SQL> alter user SYSMAN identified by pwd12345 account unlock;
SQL> exit

[oracle]$ emca -deconfig dbcontrol db -repos drop -silent -SYS_PWD ... -SYSMAN_PWD pwd12345 -SID emrep -PORT 1521

    STARTED EMCA at 19-Oct-2015 21:50:50
    EM Configuration Assistant, Version 11.2.0.0.2 Production
    Copyright (c) 2003, 2005, Oracle.  All rights reserved.


    19-Oct-2015 21:50:51 oracle.sysman.emcp.EMConfig perform
    INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/emrep/emca_2015_10_19_21_50_50.log.
    19-Oct-2015 21:50:51 oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
    WARNING: EM is not configured for this database. No EM-specific actions can be performed.
    19-Oct-2015 21:50:51 oracle.sysman.emcp.EMReposConfig invoke
    INFO: Dropping the EM repository (this may take a while) ...
    19-Oct-2015 21:52:06 oracle.sysman.emcp.EMReposConfig invoke
    INFO: Repository successfully dropped
    Enterprise Manager configuration completed successfully
    FINISHED EMCA at 19-Oct-2015 21:52:06

# Fix oracle parameter up to the prerequisite check report
[oracle]$ sqlplus / as sysdba

SQL> alter system set memory_target=3G scope=spfile ;

SQL> alter system set parallel_max_servers=8 scope=both ;

SQL> alter system set processes=600 scope=spfile ;

SQL> alter system set session_cached_cursors=256 scope=spfile ;

SQL> alter system set shared_pool_size=640M scope=both ;

SQL> alter database add logfile size 640m ;
SQL> alter database add logfile size 640m ;
SQL> alter database add logfile size 640m ;
SQL> alter system switch logfile;
SQL> alter database drop logfile group 1;
SQL> alter database drop logfile group 2 ;
SQL> alter database drop logfile group 3 ;

SQL> shutdown immediate ;
SQL> startup ;

Software installation

After all prerequisite check successfully pass, we can now install the OEM 12c Cloud Control with the following command.
After installation succeeded, you will be required to execute /u01/app/oracle/product/em12c/oms/allroot.sh as root.

# Install oem12c
[oracle]$ cd ./em12c_inst
[oracle]$ ./runInstaller -silent -waitForCompletion -showProgress -responseFile $PWD/response/new_install.rsp \
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false \
DECLINE_SECURITY_UPDATES=true \
INSTALL_UPDATES_SELECTION=skip \
ORACLE_MIDDLEWARE_HOME_LOCATION=/u01/app/oracle/product/em12c \
AGENT_BASE_DIR=/u01/app/oracle/product/agent12c \
WLS_ADMIN_SERVER_PASSWORD=... \
WLS_ADMIN_SERVER_CONFIRM_PASSWORD=... \
NODE_MANAGER_PASSWORD=... \
NODE_MANAGER_CONFIRM_PASSWORD=... \
ORACLE_INSTANCE_HOME_LOCATION=/u01/app/oracle/product/em12c/gc_inst \
DATABASE_HOSTNAME="oralab01" \
LISTENER_PORT=1521 \
SERVICENAME_OR_SID="emrep" \
SYS_PASSWORD=... \
SYSMAN_PASSWORD=... \
SYSMAN_CONFIRM_PASSWORD=... \
DEPLOYMENT_SIZE="SMALL" \
MANAGEMENT_TABLESPACE_LOCATION="+DATA/emrep/datafile/mgmt.dbf" \
CONFIGURATION_DATA_TABLESPACE_LOCATION="+DATA/emrep/datafile/mgmt_ecm_depot1.dbf" \
JVM_DIAGNOSTICS_TABLESPACE_LOCATION="+DATA/emrep/datafile/mgmt_ad4j.dbf" \
AGENT_REGISTRATION_PASSWORD=... \
AGENT_REGISTRATION_CONFIRM_PASSWORD=...

    ...
    ...
    ...
    *** The Installation was Successful. ***


    This information is also available at:

        /u01/app/oracle/product/em12c/oms/install/setupinfo.txt

    See below for information pertaining to your Enterprise Manager installation:


    Use the following URL to access:

        1. Enterprise Manager Cloud Control URL: https://oralab01:7803/em
        2. Admin Server URL: https://oralab01:7102/console

    The following details need to be provided during the additional OMS install:

        1. Admin Server Hostname: oralab01
        2. Admin Server Port: 7102

    You can find the details on ports used by this deployment at : /u01/app/oracle/product/em12c/oms/install/portlist.ini


     NOTE:
     An encryption key has been generated to encrypt sensitive data in the Management Repository. If this key is lost, all encrypted data in the Repository becomes unusable.

     A backup of the OMS configuration is available in /u01/app/oracle/product/em12c/gc_inst/em/EMGC_OMS1/sysman/backup on host oralab01. See Cloud Control Administrators Guide for details on how to back up and recover an OMS.

     NOTE: This backup is valid only for the initial OMS configuration. For example, it will not reflect plug-ins installed later, topology changes like the addition of a load balancer, or changes to other properties made using emctl or emcli. Backups should be created on a regular basis to ensure they capture the current OMS configuration. Use the following command to backup the OMS configuration:
    /u01/app/oracle/product/em12c/oms/bin/emctl exportconfig oms -dir <backup dir="">


    Warning: The following configuration scripts need to be executed as the "root" user
      /u01/app/oracle/product/em12c/oms/allroot.sh
    To execute the configuration scripts:
     1. Open a new  terminal window
     2. Login in as "root"
     3. Run the scripts

    Enterprise Manager Cloud Control Installation has finished.

Please leave comments and suggestions,
Michel.

Reference
Installing Enterprise Manager in Silent Mode (oracle.com)
Oracle Enterprise Manager Licensing Information (oracle.com)

Enjoyed this article? Please like it or share it.

Add comment

Please connect with one of social login below (or fill up name and email)

     


Security code
Refresh