Oracle Enterprise Manager 12c Administration Cookbook

Oracle Enterprise Manager 12c Administration Cookbook

By : Dhananjay Papde, Tushar Nath, Vipul Patel

Buy this Book

Oracle Enterprise Manager 12c Administration Cookbook

By: Dhananjay Papde, Tushar Nath, Vipul Patel

Buy this Book

Overview of this book

Oracle Enterprise Manager is a key tool for any Oracle Administrator, allowing them to manage their Oracle installations and selected other applications, providing a one stop place to manage and maintain the entire infrastructure in any organization. The Oracle Enterprise Manager 12c Cookbook will give administrators a head start towards implementing OEM in their organizations, by taking you through all the aspects of installation, upgrade, configuration, and monitoring of various servers, databases, and various Oracle Fusion Middleware components. Starting with the installation and upgrade of your OEM installation, this book then takes you through the process of using OEM12c to configure and monitor your Oracle application and database servers, including the various supported Oracle Fusion Middleware products. This book will uncover various installations options (with simple advanced options) and various upgrade options. The book will also cover monitoring the infrastructure using Active Session History Analytics. There are recipes on creating, cloning databases, and creating templates. Additionally there are recipes on Configuration of Oracle Business Intelligence, Oracle Golden Gate, Oracle Business Intelligence Publisher, and Oracle Weblogic using OEM12c.

Oracle Enterprise Manager 12c Administration Cookbook

Credits

Foreword

About the Authors

About the Reviewers

www.PacktPub.com

Preface

Free Chapter

Prerequisites of OEM 12c Installation

Introduction

Creating operating system groups and users

Checking hardware requirements

Checking OS requirements

Checking package, kernel parameters, and library requirements

Meeting host file requirements

Installing the Oracle 11gR2 RDBMS software for an OEM repository database

Creating an OEM repository database

Setting up a Listener and a Local Net Service name configuration

Meeting OEM repository database requirements

Installation of OEM 12c

Introduction

Installing Enterprise Manager System with Simple configuration option

Installing Enterprise Manager System with Advanced configuration option

Understanding Advanced Installer options

Installing Oracle Management Agent using the RPM file

Installing Oracle Management Agent using the agentDeploy.sh script

Upgrade to OEM 12c

Introduction

Performing pre-upgrade tasks

Upgrading using the 1-system upgrade approach (on the same host)

Upgrading using the 2-system upgrade approach (on a different host)

Configuring OEM 12c

Introduction

Prerequisites for configuring automatic discovery

Configuring automatic discovery of unmanaged host machines using IP Scan

Configuring automatic discovery of targets on managed hosts

Checking for and promoting discovered targets

Adding host targets manually

Adding non-host targets manually

Configuring Administration Groups

Creating template collections and associating them with Administration Groups

Configuring a Software Library

Managing Oracle Database Using OEM 12c

Introduction

Configuring a database target

Creating a single instance database

Cloning a single instance database

Creating database templates

Uploading database templates to the Software Library

Creating an Oracle Database Clone from a reference home

Provisioning Oracle Database software

Removing a database target

Managing Database Performance Using OEM 12c

Introduction

Using Active Session History Analytics

Using the Real-Time Automatic Database Diagnostics Monitor (ADDM) feature

Using the Compare Period AutomaticDatabase Diagnostics Monitor (ADDM) feature

Comparing period reports

Middleware Management Using OEM 12c

Introduction

Managing Oracle Business Intelligence

Integrating BI Publisher with Enterprise Manager 12

Creating sample reports in BI Publisher

Implementing BI Publisher Security Model

Managing and monitoring Oracle GoldenGate

Setting up Application Dependency and Performance (ADP) Manager in Cloud Control

Setting up JVM Diagnostics (JVMD) Manager in Cloud Control

Discovering and managing Weblogic Server Target

Deploying ADP agents on Weblogic Target nodes

Deploying JVMD Agents on Weblogic Target nodes

Incident and Problem Management Using an iDevice (iPhone, iPod Touch, or iPad)

Introduction

Setting up OEM12c on an iDevice

Using Incident management on an iDevice

Using problem management on an iDevice

Index

Customer Reviews

5 star

4 star

3 star

2 star

1 star

Installing the Oracle 11gR2 RDBMS software for an OEM repository database

Assuming that all of the prerequisites are met for the OMS and management repository, this recipe describes the installation of the Oracle 11g software for the OEM repository database

Getting ready

Before you start, ensure that the server is connected to the network, and an SSH or a telnet client is available. Also, make sure you have access to the Unix server as a root user or as a privileged user and a Unix user.

To install the RDBMS software, the X Windows server needs to be started. X Windows helps in providing a graphical user interface from the Unix server. Xming is used in this example, although any Windows software, such as Hummingbird Exceed, can also be used.

How to do it...

Download the Oracle software.

The Oracle RDBMS version used for the installation is 11.2.0.2. The software can be downloaded from the Oracle's metalink site. 11.2.0.2.5 Patch Set Update (patch13343424) is OS-specific and will be used to patch the database to ensure no patch bundles.

p10098816_112020_Linux-x86-64_1of7.zip
p10098816_112020_Linux-x86-64_2of7.zip
p10098816_112020_Linux-x86-64_3of7.zip
p10098816_112020_Linux-x86-64_4of7.zip
p10098816_112020_Linux-x86-64_5of7.zip
p10098816_112020_Linux-x86-64_6of7.zip
p10098816_112020_Linux-x86-64_7of7.zip
p13343424_112020_Linux-x86-64.zip

After downloading the software, copy the software to a staging directory on the server using scp. Unzip the software in the staging directory. In this example mount point/spare is created to be used as a staging directory.
```
cd /spare
unzip p10098816_112020_Linux-x86-64_1of7.zip
unzip p10098816_112020_Linux-x86-64_2of7.zip
chown -R oracle:oinstall /spare/database
```

Create the oraInventory directory if it does not alredy exist on the server.

# mkdir -p /home/oraInventory
# chown -R oracle:oinstall /home/oraInventory

Change the ownership of the ORACLE_BASE directory (in this example, /dboracle) to user oracle.
```
# chown -R oracle:oinstall /dboracle
```
Now, start a new session with SSH and connect as user oracle. In this example the user has used oracle.
```
cd /spare/database
 $ export ORACLE_BASE=/dboracle
$ export TEMP=/u01/tmp
$ ./runInstaller
```
Select the I wish to receive security updates via My Oracle Support checkbox if you wish to receive security updates. In this example, we have left the option unchecked.
Click on the Next button.
Select the Skip software updates button on the next screen. Other options available are Use My Oracle Support Credentials for download or Use pre-downloaded software updates. Choose one of the options as per the requirement.
Click on the Next button.
Select the Install database software only option.
Click on the Next button.
Select the Single instance database installation option. Other options available for high availability are Oracle Real Application Cluster database installation and Oracle RAC One Node database installation.
Click on the Next button.
Select the default language as English, and then click on the Next button.
Select Enterprise Edition.
Click on the Next button.
The Oracle base location is selected automatically, as Oracle base is set in the Unix environment before installation. Specify or review the Oracle Base field and the Software Location field.
Click on the Next button.
The Oracle Inventory path will be detected by the installer automatically if any previous installation exists. In this example, it's a new installation, so you need to specify the Inventory Directory field.
The Oracle inventory group install will be selected by default.
Click on the Next button.
Database Administrator Group dba and Database Operator group oper are chosen by default.
Click on the Next button.
Pre-requisites Checks screen is displayed. If any of the checks appear as failed (for example, if the minimum swap space available is 16 GB and the server has only, say, 12 GB), then resolve the issue before proceeding.
Click on the Next button.
Review the Summary screen of the software installation.
Click on the Install button.
The installation begins and will take some time to complete. The following screen is displayed. Log in to the server in another telnet session and execute the script as a root user or a privileged user with root privileges.
The following script appears in the preceding screenshot:
```
 #  . /home/oraInventory/orainstRoot.sh
 #. /dboracle/product/11.2.0/dbhome_1/root.sh
```
Click on OK after the execution of the script as a root user.
Click on the Close button. This marks the completion of the Oracle RDBMS 11gR2 installation.
Apply required patch set update.
The patch set update compatible with the Oracle 11.2.0.2 RDBMS software for the OEM repository database is 11.2.0.2.5 and needs to be installed. Also, ensure that you use the OPatch utility Version 11.2.0.1.3 or later.
If 11.2.0.3 is being installed, then apply the latest compatible patch set update.