Blogs

OEM 13.5 Installation – Part 1

This article illustrates the OEM 13.5 installations. In this installation both the database and OEM repo going to be under same server.

Also I have mentioned the main oracle document link to get more understanding of the installation requirements and 13.5 new features.

Oracle Enterprise Manager Cloud Control 13.5 – Installation and Upgrade

 

13.5 New Features
Cloud Control Introduction

 

I know most of the experienced dba are fully conversant with 13c cloud control, But the freshers who are searching to get the flavour of OEM under noted guide lines will be useful.

 

What is OEM used for Oracle?

Oracle Enterprise Manager is a system management tool which provides an integrated solution for managing your heterogeneous environment. It combines a graphical console, agents, common services, and tools to provide an integrated, comprehensive systems management platform for managing Oracle products.

 

From the Oracle Enterprise Manager’s Console, you can:

• Administer, diagnose, and tune multiple databases.
• Distribute software to multiple servers and clients.
• Schedule jobs on multiple nodes at varying time intervals.
• Monitor objects and events throughout the network.
• Customize your display using multiple graphic maps and groups of network objects, such as nodes and databases.
• Administer Oracle Parallel Servers. For information about administering Oracle Parallel Servers, see the Oracle Parallel Server Support for the Oracle Enterprise Manager Console Guide.
• Integrate participating Oracle or third-party tools.

 

1 Pre-requisites

1.1 Hardware Requirements

Database:

OMS Repository:

 

1.2 RPM Requirements

Required rpm for Oracle Linux 7.

There rpm can be installed from oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

  yum -y localinstall oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

 

1.3 Download the 13.5binary

You can down the installation files from edelivery or mention the Oracle URL.

Oracle Software Delivery Cloud

Oracle Enterprise Manager Downloads

This OEM 13.5 binary consists of 5 files. To perform the installation we need to execute em13500_linux64.bin executable.

 

2. Installation

2.1 Database Installation for Repo

We need to create a new database for the repository. Please find the below mention commands to create
the database for the OEM repository.

export ORACLE_HOME=/u01/local/oracle/Oracle_19c
export PATH=$PATH:/usr/local/oracle/Oracle_19c/bin


dbca -silent -createDatabase                                                    \
     -templateName General_Purpose.dbc                                          \
     -gdbname emcdb -sid emcdb -responseFile NO_VALUE                           \
     -characterSet AL32UTF8                                                     \
     -sysPassword SysPassword1                                                  \
     -systemPassword SysPassword1                                               \
     -createAsContainerDatabase true                                            \
     -numberOfPDBs 1                                                            \
     -pdbName emrep                                                             \
     -pdbAdminPassword PdbPassword1                                             \
     -databaseType MULTIPURPOSE                                                 \
     -memoryMgmtType auto_sga                                                   \
     -totalMemory 2000                                                          \
     -storageType FS                                                            \
     -datafileDestination /oradata                                              \
     -redoLogFileSize 50                                                        \
     -emConfiguration NONE                                                      \
     -ignorePreReqs

expected output logs:

[oracle@oem13c ~]$ dbca -silent -createDatabase                                                    \
>      -templateName General_Purpose.dbc                                          \
>      -gdbname emcdb -sid emcdb -responseFile NO_VALUE                           \
>      -characterSet AL32UTF8                                                     \
>      -sysPassword SysPassword1                                                  \
>      -systemPassword SysPassword1                                               \
>      -createAsContainerDatabase true                                            \
>      -numberOfPDBs 1                                                            \
>      -pdbName emrep                                                             \
>      -pdbAdminPassword PdbPassword1                                             \
>      -databaseType MULTIPURPOSE                                                 \
>      -memoryMgmtType auto_sga                                                   \
>      -totalMemory 2000                                                          \
>      -storageType FS                                                            \
>      -datafileDestination /oradata                                              \
>      -redoLogFileSize 50                                                        \
>      -emConfiguration NONE                                                      \
>      -ignorePreReqs
Prepare for db operation
8% complete
Copying database files
31% complete
Creating and starting Oracle instance

32% complete
36% complete
40% complete
43% complete
46% complete
Completing Database Creation
51% complete
53% complete
54% complete
Creating Pluggable Databases
58% complete
77% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
 /u01/app/oracle/cfgtoollogs/dbca/emcdb.
Database Information:
Global Database Name:emcdb
System Identifier(SID):emcdb
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/emcdb/emcdb.log" for further details.

After completing the installation set the bash profile as mentioned below.

########### Bash profile

[oracle@oem13c ~]$ cat /home/oracle/scripts/setEnv.sh
# Oracle Settings
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_HOSTNAME=crs01.localdomain
export ORACLE_UNQNAME=emcdb
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19.0.0/dbhome_1
export ORA_INVENTORY=/u01/app/oraInventory
export ORACLE_SID=emcdb
export PDB_NAME=EMREP
export DATA_DIR=/oradata

export PATH=/usr/sbin:/usr/local/bin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
[oracle@oem13c ~]$

Configure listener for repository database. Use netca or netmgr graphical tools to configure the listener.

###### set database local listener parameter
alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.200)(PORT = 1525))';

###### Configure Listener

[oracle@oem13c admin]$ lsnrctl status

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 01-OCT-2021 13:37:35

Copyright (c) 1991, 2019, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=crs01.localdomain)(PORT=1525)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                01-OCT-2021 13:35:27
Uptime                    0 days 0 hr. 2 min. 8 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/oem13c/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1525)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1525)))
Services Summary...
Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s).
  Instance "emcdb", status READY, has 1 handler(s) for this service...
Service "cd4eb736d6c94084e055000000000001" has 1 instance(s).
  Instance "emcdb", status READY, has 1 handler(s) for this service...
Service "emcdb" has 1 instance(s).
  Instance "emcdb", status READY, has 1 handler(s) for this service...
Service "emcdbXDB" has 1 instance(s).
  Instance "emcdb", status READY, has 1 handler(s) for this service...
Service "emrep" has 1 instance(s).
  Instance "emcdb", status READY, has 1 handler(s) for this service...
The command completed successfully

Set the below-mentioned database parameters as mentioned below, We need to set hidden parameters _allow_insert_with_update_check this is required for OEM installation.

################# DB parameters.

sqlplus / as sysdba <

 

2.2 Repo Installation 

 We need to create below mention mount points location to install the OEM repo.

########## OEM report directory
mkdir -p /u02/app/oracle/middleware
mkdir -p /u02/app/oracle/agent

Execute the em13500_linux64.bin executable to start the installation in graphical mode.

Let’s perform this using the advanced installation.

This figure shows the prerequisites check.

Select required plugging for OEM installation.

Set passwords for WebLogic domain and node manager.

Set repository database settings for OEM 13c installation.

This figures shows the database parameter , even there is option to fixed some of the parameters via GUI.

To set up sga sizes you need to set and bounce the database.

Tablespace settings for OEM repository

Configure Oracle library location

Make sure to keep this because this figure has the port configuration details

Installation summary

Installation progress

Execute root.sh to complete the installation

Congratulations! Now installation is complete

Access OEM via URL:

Login via sysman user.

More from this Author