Using Oracle Enterprise Manager Cloud Control 12c: to use this Student Guideฺ

Unauthorized reproduction or distribution prohibitedฺ Copyright© 2016, Oracle and/or its affiliatesฺ
n se
lic e
ble
fe r a
an s
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D
Using Oracle Enterprise
Manager Cloud Control 12c
Activity Guide
D73244GC20
Edition 2.0 | January 2015 | D89883
Learn more from Oracle University at oracle.com/education/
Author Copyright © 2015, Oracle and/or its affiliates. All rights reserved.
Daniela Hansell Disclaimer
This document contains proprietary information and is protected by copyright and other
Technical Contributors intellectual property laws. You may copy and print this document solely for your own
and Reviewers use in an Oracle training course. The document may not be modified or altered in any
way. Except where your use constitutes "fair use" under copyright law, you may not
Steve Stelting use, share, download, upload, copy, print, display, perform, reproduce, publish, license,
post, transmit, or distribute this document in whole or in part without the express
Lachlan Williams authorization of Oracle.
The information contained in this document is subject to change without notice. If you
Editors find any problems in the document, please report them in writing to: Oracle University,
Malavika Jinka 500 Oracle Parkway, Redwood Shores, California 94065 USA. This document is not
warranted to be error-free.
Smita Kommini
Restricted Rights Notice
Graphic Designers If this documentation is delivered to the United States Government or anyone using the
e
Seema Bopaiah
documentation on behalf of the United States Government, the following notice is
e n s
Daniela Hansell
applicable:
e lic
U.S. GOVERNMENT RIGHTS
r a bl
Publishers s fe
The U.S. Government’s rights to use, modify, reproduce, release, perform, display, or
an
disclose these training materials are restricted by the terms of the applicable Oracle
Joseph Fernandez
n - t r
license agreement and/or the applicable U.S. Government contract.
Srividya Rameshkumar Trademark Notice

a no
Jobi Varghese Oracle and Java are registered trademarks
h s of Oracleeฺand/or its affiliates. Other names
aowners.
z Guid
)
may be trademarks of their respective
ฺ d
d o o nt
e d e
o or Stu
a n i@ this
j e br use
z ( ad to
i A zi
n
bra
Dje
Table of Contents
Reference Material for All Practices ...............................................................................................................i-1
Practices Reference Material: Overview ........................................................................................................i-2
Practices for Lesson 1: Introduction ..............................................................................................................1-1
Practices for Lesson 1: Overview ...................................................................................................................1-2
Practice 1-1: Checking the Virtual Machines (VMs) .......................................................................................1-3

Practice 1-2: Getting to Know Your Oracle Software Classroom Environment ..............................................1-5
Practices for Lesson 2: Reviewing Enterprise Manager Core Concepts ....................................................2-1
Practice 2-1: Accessing Enterprise Manager .................................................................................................2-3
Practice 2-2: Monitoring OMS and OMR ........................................................................................................2-5
Practices for Lesson 3: Managing Cloud Control .........................................................................................3-1
Practices for Lesson 3: Overview ...................................................................................................................3-2 n se
Practice 3-1: Preparing Your Database for Backup........................................................................................3-3 lic e
b
Practice 3-2: Performing a Backup.................................................................................................................3-6
a le
s f er
Practices for Lesson 4: Monitoring Targets ..................................................................................................4-1
r an
- t
on
Practice 4-1: Reviewing Oracle-Provided Monitoring Templates ...................................................................4-3
n
a
Practice 4-2: Creating a Monitoring Template ................................................................................................4-5
s
a e ฺ
Practice 4-3: Comparing and Applying a Monitoring Template ......................................................................4-7
h d
dz t Gu) i
Practice 4-4: Comparing Metric Settings ........................................................................................................4-9
o ฺ
r e do den
Practices for Lesson 5: Managing Hosts .......................................................................................................5-1
o tu
o S
a
Practice 5-2: Monitoring Hosts
i@ this
Practice 5-1: Verifying YaST ..........................................................................................................................5-3
n
.......................................................................................................................5-6
Practice 5-3: Working e
j br in uthesHost
Remotely
e OS.............................................................................................5-11
( ad6: Managing
Practices for Lesson
z
to Groups ....................................................................................................6-1
A zifor Lesson 6: Overview...................................................................................................................6-2
Practices
i
e b ranPractice 6-1: Creating a Privilege-Propagating Group ...................................................................................6-3
Practice 6-2: Creating a Second Group .........................................................................................................6-8
D j Practice 6-3: Testing the Group .....................................................................................................................6-9
Practices for Lesson 7: Managing Systems and Services ...........................................................................7-1
Practice 7-1: Reviewing Existing Systems and Services ................................................................................7-3
Practice 7-2: Creating a System.....................................................................................................................7-5
Practice 7-3: Creating a Generic Service .......................................................................................................7-7
Practice 7-4: Monitoring a Web Application ...................................................................................................7-8
Practice 7-5: Creating and Testing a Web Transaction ..................................................................................7-10
Practices for Lesson 8: Using the Job System .............................................................................................8-1
Practice 8-1: Creating and Executing a Simple SQL Job ...............................................................................8-3
Practice 8-2: Creating and Executing OS Jobs ..............................................................................................8-5
Practice 8-3: Creating and Executing a Multi-Target Job ...............................................................................8-7
Copyright © 2015. Oracle and/or its affiliates. All rights reserved.
Using Oracle Enterprise Manager Cloud Control 12c Table of Contents

iii
Practices for Lesson 9: Managing Incidents .................................................................................................9-1
Practice 9-1: Preparing an Incident ................................................................................................................9-3
Practice 9-2: Finding and Resolving an Incident ............................................................................................9-4
Practices for Lesson 10: Patching and Provisioning....................................................................................10-1
Practices for Lesson 10: Overview .................................................................................................................10-2
Practice 10-1: Preparing for Offline Patching .................................................................................................10-3

Practice 10-2: Patching Offline .......................................................................................................................10-6
Practices for Lesson 11: Managing Configurations......................................................................................11-1
Practice 11-1: Viewing Configuration Details .................................................................................................11-3
Practice 11-2: Viewing Configuration History and Topology ..........................................................................11-4
Practice 11-3: Comparing Configurations ......................................................................................................11-6
Practice 11-4: Searching Configurations ........................................................................................................11-8
ns e
Practices for Lesson 12: Managing Compliance ...........................................................................................12-1 ice
l e l
r a b
e
Practice 12-1: Reviewing Predefined Compliance Objects ............................................................................12-3
sf
n
Practice 12-2: Using Compliance Standards ..................................................................................................12-5
a
n -tr
Practices for Lesson 13: Producing and Using EM Reports ........................................................................13-1
o
n
a
) h as deฺ
Practice 13-1: Reviewing and Running Oracle-Provided Reports ..................................................................13-3
dz t Gui
Practice 13-2: Creating a Report with Information Publisher ..........................................................................13-6
o ฺ
r e do den
o o S tu
a n i@ this
j e br use
z ( ad to
i A zi
n
bra
Dje
Copyright © 2015. Oracle and/or its affiliates. All rights reserved.
Using Oracle Enterprise Manager Cloud Control 12c Table of Contents

iv
n se
lic e
ble
fe r a
ans
n - t r
no
ReferenceaMaterial for All
ha s
Practices eฺ
ฺ d z) Guid
d o oOverviewnt
o r e tude
@ o sS
r a n e thi
i
d j eb o us
(a t
zi z
n i A
e b ra
D j
Copyright © 2015, Oracle and/or its affiliates. All rights reserved.
Reference Material for All Practices

Chapter i - Page 1
Practices Reference Material: Overview
Overview
These pages provide a ready reference of host names, usernames, and passwords that you will
be using throughout the practices.
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter i - Page 2
Practice: Getting to Know Your Classroom Environment
Host Name Username and Database Applications
Passwords Instance(s)
Your classroom PC vncuser/vnctech

root/oracle
em12.example.com root/oracle em12rep Enterprise Manager Cloud
oracle/oracle system/oracle_4U Control
sys/ oracle_4U sysman/Oracle123
dbsnmp/dbsnmp emadmin/emadmin
n se
WebLogic Server
lic e
weblogic/webl0gic
ble
(w.e.b.l.zero.g.i.c)
fe r a
ans
nodemanager/n0demanager
n - t r
(n.zero.d.e.m.a.n.a.g.e.r)
host01.example.com root/oracle a no orcl
oracle/oracle
) h as deฺ system/ oracle_4U
o ฺ dz t Gui dbsnmp/dbsnmp
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter i - Page 3
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter i - Page 4
n se
lic e
ble
fe r a
ans
n - t r
Practices aforno
Lesson 1:
ha s
Introduction eฺ
ฺ d z) Guid
d o oChaptern1t
o r e tude
@ o sS
r a n e thi
i
d j eb o us
(a t
zi z
n i A
e b ra
D j
Practices for Lesson 1: Introduction

Chapter 1 - Page 1
Practices for Lesson 1: Overview
Practices Overview
In these practices, you will log in to your terminal, and view the lecture and the hands-on
practices. You will also familiarize yourself with the VM environment and your Oracle software
environment (the databases, listeners, and Oracle Enterprise Manager running).
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 1 - Page 2
Practice 1-1: Checking the Virtual Machines (VMs)
Overview
In this practice, you access your classroom PC as user vncuser and check your VMs in
preparation for all the following tasks.
Assumptions
You are logged in to your classroom PC as the vncuser user.
Tasks
1. Double-click the Terminal icon on your desktop.
2. To check your classroom environment, enter: su – root and then the root password.
$ su - root
n se
Password:
lic e
ble
fe r a
nsState
# xm list
Name ID Mem VCPUs
t r a
Time(s)
no 2 r----- 21048.4 n-
Domain-0
a1024 0
host01
) h as 2860
d e ฺ 12 -b---- 6 666.7
em12
ฺ G ui column shows how long they
dzThe Time(s)
4096 -b---- 52427.3
Note the two VMs running: em12 and host01. o nt will not exactly match with your
dothese dnumbers
have been running. It is most likelyre
that e
output. o o S tu
Exit the root session:
a n i@ this
j e br use
ad
# exit
( to
z
i step if the previous step completed successfully.
zthis
A
3. iSkip
b ran If for some reason your VMs are not up and running, you must complete the following steps
D j e to start them up.
Make sure you exit the root session as directed in Step 2. From a terminal window, log in
as user vncuser and perform the following steps:
$ su - root -c "startVMs.sh"
Password:
131022 11:50:43 Shutting down VMs =
131022 11:50:43 All VMs have been shutdown =
131022 11:50:43 Starting VMs =
131022 11:50:43 Create new domain /OVS/running_pool/host01 = begin
131022 11:50:44 Domain creation = completed
131022 11:50:44 Create new domain /OVS/running_pool/em12/v = begin
131022 11:50:45 Domain creation = completed
131022 11:50:45 All VMs have been started = done
Note: This script executes quickly.

Chapter 1 - Page 3
4. The following is only for your information. There are no tasks involved. After the VMs are
started, some tasks are automatically performed:
• Two databases (em12rep on em12 and orcl on host01) are already created and the
instances are automatically started.
• The appropriate listeners are started.
You will perform some of the startup tasks manually as part of the exercises.
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 1 - Page 4
Practice 1-2: Getting to Know Your Oracle Software Classroom
Environment
Overview
In this optional practice, you get to know your classroom environment by starting a terminal
session and navigating to your host machines as the oracle user.
Assumptions
You are logged in to your classroom PC as the vncuser user.
Tasks
1. Start a terminal session by double-clicking the Terminal icon.
2. Ping the host01 host and the em12 host to confirm that they are running. Use the –c4
n se
switch to limit the ping count to four attempts.
lic e
$ ping –c4 host01
ble
PING host01.example.com (192.0.2.111) 56(84) bytes of data.
fe r a
64 bytes from host01.example.com (192.0.2.111): icmp_seq=1 ttl=64 time=0.099 ms
ans
n - t r
no
a
as deฺ
) h i
ฺ
--- host01.example.com ping statistics
o dz t Gu---
o
4 packets transmitted, 4 dreceived,
e en 0% packet loss, time 3002ms
r u d
rtt min/avg/max/mdev
@ oo= 0.091/0.109/0.132/0.017
s S t ms
r a ni e thi
$ ping –c4
d j ebem12o us
a t (192.0.2.101) 56(84) bytes of data.
PING (em12.example.com
i z
i Az
64 bytes from em12.example.com (192.0.2.101): icmp_seq=1 ttl=64 time=0.102 ms
ran 64 bytes from em12.example.com (192.0.2.101): icmp_seq=2 ttl=64 time=0.092 ms
D jeb 64 bytes from em12.example.com (192.0.2.101): icmp_seq=3 ttl=64 time=0.085 ms

64 bytes from em12.example.com (192.0.2.101): icmp_seq=4 ttl=64 time=0.115 ms
--- em12.example.com ping statistics ---

4 packets transmitted, 4 received, 0% packet loss, time 2999ms
rtt min/avg/max/mdev = 0.085/0.098/0.115/0.015 ms
Note that your times may not match exactly the numbers above.
3. Log in to the em12 host as the oracle user. Use a secure shell session with the –X
(capital X) option to forward the X display, just in case it is needed. Accept the RSA key if
asked.
$ ssh –X oracle@em12
oracle@em12's password:
Last login: ….

Chapter 1 - Page 5
4. Your training environment is configured so that the em12rep database instance is
automatically started. This database is your Enterprise Manager Cloud Control repository.
Verify that the database instance has been started.
a. Check if the database and associated listener have been created and started.
[oracle@em12 ~]$ ps –ef | grep pmon
oracle 2880 1 0 10:27 ? 00:00:02 ora_pmon_em12rep

oracle 5471 2798 0 15:39 pts/0 00:00:00 grep pmon
Note that your process IDs and times may not match exactly the numbers above.
The Process Monitor (PMON) output shows you the database name (em12rep) that
you use to set environment variables.
[oracle@em12 ~]$ ps -ef | grep lsnr
oracle 5507 2798 0 15:40 pts/0 00:00:00 grep lsnr
oracle 7222 1 0 10:55 ? 00:00:01
n se
/u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr LISTENER -inherit
lic e
b. Set the environment variables for the database instance. ble
fe r a
[oracle@em12 ~]$ . oraenv
ans
ORACLE_SID = [oracle] ? em12rep
n - t r
The Oracle base has been set to /u01/app/oracle
a no
Note that the output of this command depends on the
h a s ORACLE_SID
e ฺ value already
existing in your environment.
d z ) u id
ฺ t Grun a simple SQL query, and then
c. Log in to the database to confirm thatoit is available,
o
exit from SQL*Plus. d e n
[oracle@em12 ~]$ sqlplus o ore / Sastusysdba
d
SQL*Plus: Release
a n i@ t h
11.2.0.3.0 is Production on Mon Oct 14 23:24:05 2013
Copyrighte(c)
j br 1982,us2011,
e Oracle. All rights reserved.
z ( ad to:to
i
i AzOracle Database 11g Enterprise Edition Release 11.2.0.3.0 -
Connected
ran
jeb
64bit Production
D With the Partitioning, OLAP, Data Mining and Real Application
Testing options
SQL>
SQL> select name, log_mode from v$database;

NAME LOG_MODE
--------- ------------
EM12REP NOARCHIVELOG
SQL>
The LOG_MODE parameter will be used and explained during the database backup
practice. The V$DATABASE view displays the currently active database information.

Chapter 1 - Page 6
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release
11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application
Testing options
5. Explore the basic commands for controlling Cloud Control and start your test environment.
In a production environment, the OMS and agents are configured to start automatically at
the operating system startup.
a. To stop the Oracle Management Service, including the Administration Server, HTTP
Server, and Node Manager, use the following command:
$[oracle@em12 ~]$
/u01/app/oracle/product/middleware/oms/bin/emctl stop oms –all
Depending on the existing state of your OMS, the output of your control command will
n se
be displayed as follows:
lic e
Oracle Enterprise Manager Cloud Control 12c Release 4
ble
Copyright (c) 1996, 2014 Oracle Corporation. All rights reserved.
fe r a
Stopping WebTier...
ans
WebTier Successfully Stopped n - t r
Stopping Oracle Management Server...
a no
Oracle Management Server Successfully Stopped
) h as deฺ
AdminServer Successfully Stopped
o ฺ dz t Gui
do den
Oracle Management Server is Down
Or, it may look like this: o r e tu
Oracle Enterprisei@
o S
s Control 12c Release 4
n Manager t h iCloud
Copyright (c)ra e
e b u s
1996, 2014 Oracle Corporation. All rights reserved.
Stopping
( a djWebTier...
to Stopped
i z
WebTier Successfully
n i AzStopping Oracle Management Server...

ra
jeb
Node Manager Not Running
D Oracle Management Server is Down
Note that the emctl stop oms command will stop only the management service.
b. Start the OMS:
[oracle@em12 ~]$
/u01/app/oracle/product/middleware/oms/bin/emctl start oms

Copyright (c) 1996, 2014 Oracle Corporation. All rights
reserved.
Starting Oracle Management Server...
Starting WebTier...
WebTier Successfully Started
Oracle Management Server Successfully Started
Oracle Management Server is Up

Chapter 1 - Page 7
Note that the startup time may vary.
c. Check the status of the OMS:
[oracle@em12 ~]$
/u01/app/oracle/product/middleware/oms/bin/emctl status oms

reserved.
WebTier is Up
d. Retrieve a detailed status of your OMS. Note that the sysman password is required.
[oracle@em12 ~]$
n se
/u01/app/oracle/product/middleware/oms/bin/emctl status oms –details
lic e
ble
fe r a
ans
Enter Enterprise Manager Root (SYSMAN) Password : <SYSMAN password>
n - t r
Console Server Host : em12.example.com
a no
as deฺ
HTTP Console Port : 7788
HTTPS Console Port : 7802
) h
HTTP Upload Port : 4889
o ฺ dz t Gui
HTTPS Upload Port
r do den
: 4903
e
EM Instance Home
o o tu
: /u01/app/oracle/product/gc_inst/em/EMGC_OMS1
S
n i@ this
OMS Log Directory Location :
/u01/app/oracle/product/gc_inst/em/EMGC_OMS1/sysman/log
a
e br use
OMS is not configured with SLB or virtual hostname
j
(ad to
Agent Upload is locked.
z
i A zi OMS Console is locked.
Active CA ID: 1
ran
j e b Console URL: https://em12.example.com:7802/em
D Upload URL: https://em12.example.com:4903/empbs/upload
WLS Domain Information

Domain Name : GCDomain
Admin Server Host : em12.example.com
Admin Server HTTPS Port: 7102
Admin Server is RUNNING
Oracle Management Server Information

Managed Server Instance Name: EMGC_OMS1
Oracle Management Server Instance Host: em12.example.com
WebTier is Up
BI Publisher is not configured to run on this host.

Chapter 1 - Page 8
e. Stop, start, and check the status of your management agent:
[oracle@em12 ~]$
/u01/app/oracle/product/agent12c/agent_inst/bin/emctl stop agent
reserved.
Stopping agent ...... stopped.
Depending on the existing status of your agent, the output may vary.
[oracle@em12 ~]$
/u01/app/oracle/product/agent12c/agent_inst/bin/emctl start agent
reserved. n se
Starting agent ........................... started. lic e
ble
fe r a
[oracle@em12 ~]$
ans
/u01/app/oracle/product/agent12c/agent_inst/bin/emctl status agent
n - t r
no
a
) h as deฺ
dz t Gui
---------------------------------------------------------------
o ฺ
do den
Agent Version : 12.1.0.4.0
OMS Version
r e
: 12.1.0.4.0
o tu
Protocol Version o S
: 12.1.0.1.0
Agent Home
a n i@ this
: /u01/app/oracle/product/agent12c/agent_inst
j e br use
Agent Log Directory :
(ad to
/u01/app/oracle/product/agent12c/agent_inst/sysman/log
z
i A zi Agent Binaries :
ran /u01/app/oracle/product/agent12c/core/12.1.0.4.0
j e b Agent Process ID : 3499

D Parent Process ID
Agent URL
: 3446
: https://em12.example.com:3872/emd/main/
Local Agent URL in NAT : https://em12.example.com:3872/emd/main/
Repository URL : https://em12.example.com:4903/empbs/upload
Started at : 2014-10-06 01:54:29
Started by user : oracle
Operating System : Linux version 2.6.39-400.17.1.el6uek.x86_64
(amd64)
Last Reload : (none)
Last successful upload : 2014-10-07 04:26:39
Last attempted upload : 2014-10-07 04:26:39
Total Megabytes of XML files uploaded so far : 1.49
Number of XML files pending upload : 0
Size of XML files pending upload(MB) : 0
Available disk space on upload filesystem : 18.55%
Collection Status : Collections enabled

Chapter 1 - Page 9
Heartbeat Status : Ok
Last attempted heartbeat to OMS : 2014-10-07 04:27:10
Last successful heartbeat to OMS : 2014-10-07 04:27:10
Next scheduled heartbeat to OMS : 2014-10-07 04:28:10
---------------------------------------------------------------
Agent is Running and Ready

The output will vary slightly in your environment.
f. Exit the em12 host session.
[oracle@em12 ~]$
exit
logout
Connection to em12 closed. n se
lic e
6. Explore the host01 host. Log in as the oracle user.
ble
$ ssh oracle@host01
fe r a
oracle@host01's password:
t r a ns
7. Your training environment is configured so that the orcl database
n o n-instance, its listener,
and a Cloud Control agent are automatically started.
s a
h
a. Check if the database and the associated listener a have e
been
d ฺ created and started.
[oracle@host01 ~]$ ps –ef | ฺgrep
)
dz pmon u i
o t G
oracle 2497
e do ?den 00:00:00 ora_pmon_orcl
1 0 11:11
r
oracle 4373 3463 o o 0 11:50
S tupts/0 00:00:00 grep pmon
a n i@ this
j e br ~]$ u seps –ef | grep lsnr
ad 2164 to 1 0 11:11 ?
[oracle@host01
i z (
oracle 00:00:00
i A z/u01/app/oracle/product/12.1.0/dbhome_1/bin/tnslsnr LISTENER -inherit
b ran oracle 4393 3463 0 11:51 pts/0 00:00:00 grep lsnr

D j e b. Set the environment variables for the database instance.
[oracle@host01 ~]$ . oraenv
ORACLE_SID = [oracle] ? orcl
c. Log in to the database to confirm that it is available, run a simple SQL query, and then
exit from SQL*Plus.
[oracle@host01 ~]$ sqlplus / as sysdba
SQL> select name, log_mode from v$database;
NAME LOG_MODE
--------- ------------
ORCL NOARCHIVELOG
SQL> exit
d. Check the status of the agent:
[oracle@host01 ~]$
/u01/app/oracle/product/agent12c/agent_inst/bin/emctl status agent

Chapter 1 - Page 10
The bottom of the status should indicate:
Agent is Running and Ready
e. Exit the host01 host session.
[oracle@host01 ~]$ exit
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 1 - Page 11
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 1 - Page 12
n se
lic e
ble
fe r a
ans
n - t r
Practices aforno Lesson 2:
Reviewing
h s e ฺ
a Enterprise
) i d
ฺdz t GCore
oManager
u Concepts
r e do Chapter
d en2
oo s St u
@
ni e thi
r a
d j eb o us
(a t
zi z
n i A
e b ra
D j
Practices for Lesson 2: Reviewing Enterprise Manager Core Concepts

Chapter 2 - Page 1
Practices Overview
In this practice, you act as an Enterprise Manager administrator. You access Oracle Enterprise
Manager Cloud Control 12c as the emadmin user. Summary is your home page.
You receive the questions and requests listed below through emails. Completing these practice
steps has no effect on the other course practices, so choose to answer the questions that are
most relevant to you.
Perform OMS and OMR monitoring tasks while logged in to Enterprise Manager Cloud Control
as the emadmin user.
Your instructor might suggest a time period for these tasks. Please try to complete the task
within the suggested time period.
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 2 - Page 2
Practice 2-1: Accessing Enterprise Manager
Overview
In this practice, you access Oracle Enterprise Manager Cloud Control 12c as the emadmin
user.
Assumptions
• You are logged in to your classroom PC as the vncuser user.
• You reviewed the “Console Overview and Customization” demonstration or have the
equivalent navigation knowledge.
Tasks
1. Start a terminal session by double-clicking the Terminal icon.
n se
2. Log in to the host01 host as the oracle user. Use a secure shell session with the –X
lic e
(capital X) option to forward the X display. Accept the RSA key if asked.
ble
$ ssh -X oracle@host01.example.com
fe r a
oracle@host01.example.com's password:
t r a ns
3. Bring up Firefox for accessing the Enterprise Manager Cloud Control
n on- console:
[oracle@host01 ~]$ firefox &
s a
h a d e ฺ
4. Click the EM bookmark on the Firefox toolbar. This )
dz t G i
guides you to a location of this format:
u case, this location is
o ฺ
https://<em_server_hostname>.<domain>:<port>/em. In your
https://em12.example.com:7802/em. do en
r e u d
ooneedstoupSadd
5. If this is the first time you are bringing
@
atbrowser, you would receive a This Connection
is Untrusted message and
a n i you
t h i a security exception.
a. Click I Understand
j e br theuRisks.
se
b. At the a
( d of the
bottom topage, click Add Exception.
z
c. zIni the Add Security Exception pop-up window, click Get Certificate.
n i A
d. Confirm that “Permanently store this exception” is selected in your training environment
b ra and click Confirm Security Exception.
D j e The Enterprise Manager Cloud Control console appears next.
In your environment, this exception has already been confirmed.
6. Best practices for using Oracle Enterprise Manager suggest that you create a new EM
Administrator and reserve the use of SYSMAN (default EM Administrator and repository
owner) only for tasks that are SYSMAN specific. In your environment, a new EM
Administrator, emadmin, with Super Administrator privileges, has already been created.
Enter emadmin in the User Name field and the password for the user emadmin in the
Password field. Then click Login.

Chapter 2 - Page 3
The first time a new user logs in to Enterprise Manager, the “Welcome to Enterprise
Manager Cloud Control” page appears and allows the user to select the Enterprise
Manager Home Page. The choice of pages include, among others:
− Welcome Page
− All Targets
− Sitemap
− Summary
− Databases
− Incidents
− SOA
− Middleware
− Composite Application
n se
− Services
lic e
− Business Applications
ble
− Compliance Dashboard
fe r a
− Middleware and Database Cloud ans
n - t r
− Infrastructure Cloud
a no
Each choice has a Preview and a Select As My Home button. The user emadmin has the
Enterprise Summary as the default page.
) h as deฺ
ฺ dz t Gui
The default page has global menus with the following choices: Enterprise, Targets,
o
r e do den
Favorites, History, and Search Target Name (next to the search entry field). Each of the
o o S tu
menu items has drop-down menus with further choices.
7. i@ this
Question: How can you change your home selection after the initial setup?
a n
j e br use
Answer: Navigate to a new page of interest, and click EMADMIN > Set Current Page as
(ad
My Home.
to
zi z
n i A
e b ra
D j

Chapter 2 - Page 4
Practice 2-2: Monitoring OMS and OMR
Overview
In this practice, you monitor the OMS and the OMR by using the Cloud Control console.
Note: Most probably, your graphs and numbers will look different from the possible answers
below.
Assumptions
You are logged in to Enterprise Manager Cloud Control as the emadmin user.
Tasks
If needed, navigate to the Enterprise Summary page by selecting Enterprise > Summary.
This screenshot is the basis for the answers to the next few questions. Your Enterprise
Summary page may contain values different from those in this example. These values depend n se
on how long your environment has been running, its performance during this time, and other lic e
factors. ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D
1. How many targets are being monitored with Status? (22)

2. What is their status? (22 are up)
3. Do you have any open incidents? (May vary on each environment)
4. Do you have any open problems? (May vary on each environment)
5. What is the platform for your hosts? (Oracle Linux Server release 6.3)

Chapter 2 - Page 5
6. Are you set up to receive patch recommendations? (No) You may have to scroll down to
see this information on the page.
n se
lic e
ble
fe r a
ans
7. Review the overall status of Cloud Control.
n - t r
a no
a. Navigate to Setup > Manage Cloud Control > Health Overview.
b. Review your Management Services and Repository page to see the name of the host
(top-right corner) and the main sections.
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D
c. Is there a job backlog? If yes, what is the estimated time to clear the job backlog?
(There is no job backlog in this example.)

Chapter 2 - Page 6
8. Click the “i” quick information icon next to the Management Services and Repository
page title.
What is the version of the OMS and Repository? (12.1.0.4.0)

n se
When you finish reviewing the information, click the “x” icon to close the pop-up page. lic e
9. Drill down into Management Service in Use ble
fe r a
em12.example.com:4889_Management_Service
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D What is the monitoring agent? (em12.example.com:3872)

Chapter 2 - Page 7
10. Monitor the Repository Operations. Navigate to Setup > Manage Cloud Control >
Repository.
a. What is the name of the database that contains the OMR? (em12rep.example.com)
b. When will the next Agent Ping operation be executed? (Oct 22,2014 10:56:18 PM GMT
in this example)
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
c. Was the Daily Maintenance o tu (Yes in this example)
ojob errorSfree?
d. What is the space n i@ (3.184
used? t h s in this example)
iGB
a
r vary. se
bwill
Your answers
j e
dof log files, u
a
11. To view a(list toclick Enterprise > Monitoring > Logs.
i z
n i Az
bra
Dje
a. Click Add… target to open the Select Targets dialog box, select
EMGC_GCDomain/instance1/ohs1, and click Select.
b. Use the Expand/Collapse control next to Selected Targets to collapse the Selected
Targets panel and reveal the search criteria. You can also use the scroll bar at the right
of the Search panel.

Chapter 2 - Page 8
c. Select the message types that interest you (at a minimum, Incident Error and Error),
set a date range of Most Recent 1 Days and click Search to execute the search.
d. Wait until the processing is finished. How many log rows did Enterprise Manager
return? You may need to adjust the number of days and message types to have rows
n se
returned.
lic e
e. Click Enterprise > Summary to return to the home page.
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 2 - Page 9
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 2 - Page 10
n se
lic e
ble
fe r a
ans
n - t r
forno
Practices a Lesson 3:
s
ha Cloud
Managing eฺ Control
ฺ d z) Guid
d o oChaptern3t
o r e tude
@ o sS
r a n e thi
i
d j eb o us
(a t
zi z
n i A
e b ra
D j
Practices for Lesson 3: Managing Cloud Control

Chapter 3 - Page 1
Practices Overview
Your target database is in the orcl.example.com database instance.
In these practices, you set up and test backup and recovery settings, and then perform a one-
time backup of the orcl.example.com database instance. Optionally, you view backup
reports.
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 3 - Page 2
Practice 3-1: Preparing Your Database for Backup
Overview
The purpose of this practice is to understand how to prepare a database instance for backup
operations. The same concepts can be applied to a database instance hosting a repository with
the understanding that, in this case, if the database is shut down, the Cloud Control system will
be brought down as well.

In this practice, you will perform the backup tasks on a non-repository database, namely the
orcl.example.com database.
Assumptions
Tasks n se
1. Navigate to Targets (global menu) > Databases and select the Search List view. lic e
2. Click the database instance link: orcl.example.com. ble
fe r a
3. To confirm and change your backup settings, navigate to Availability > Backup &
ans
Recovery > Backup Settings.
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D 4. To perform database administration tasks, your access authorization is checked either
explicitly by your providing database login credentials, or implicitly through preferred
credentials.
Starting with database version 12c, the SYSBACKUP user, with the SYSBACKUP privilege, is
created automatically at installation time. The SYSBACKUP privilege, a subset of the
SYSDBA privileges, includes all the privileges required to back up and recover the database.
In this training environment, you will create a credential for the SYS user with the SYSDBA
role and saved as a Named Credential. However, in a production environment, it is
recommended that you create a user and grant the SYSBACKUP privilege in order to
perform backup and recovery operations.

Chapter 3 - Page 3
Enter the username SYS and its password, choose the SYSDBA role, select the Save As
check box, and enter the name NC_DB_SYS. Click Login.
n se
5. Click the Policy tab and select or confirm the following options: lic e
a. Under Backup Policy:
a b le
• Automatically backup the control file and server parameter files f er
(SPFILE) with
every backup and database structural change
t ra n
• Optimize the whole database backup by skipping o n -
nunchanged
read-only and offline data files that have beenabacked up
files such as
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
b. Undera
( d Redo
Archived to Log Deletion Policy:
z
i archived redo log files after they have been backed up the specified
i Aznumber of times.
Delete
ran
D jeb c. Under Host Credentials:
Create a new Named Host Credential named NC_HOST_ORACLE by entering the
Username oracle and its password as Password and selecting to Save As
NC_HOST_ORACLE.

Chapter 3 - Page 4
6. Click the Device tab, review any settings that interest you, and then click Test Disk
Backup.
Most probably, you see a processing indicator, which should be followed by a success
message.
7. Click Apply to save your backup settings.
8. To change your recovery settings and determine if a restart of the database is needed,
navigate to Availability > Backup & Recovery > Recovery Settings.
9. Check ARCHIVELOG Mode, and then click Apply.
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
e doAfter dreading
10. This setting requires a database restart.
r en the entire Confirmation, click Yes.
oo s St u
@
ni e thi
r a
d j eb o us
a
(the t
z i z
11. To restart database, select NC_HOST_ORACLE as the host named credential and
n i A
NC_DB_SYS as the database named credential. Then click OK.
r a
b 12. On the next screen, click Show SQL, followed by Return.
Dje
13. Click Yes to restart your database.

A progress indicator is displayed, followed by a success message.

Chapter 3 - Page 5
Practice 3-2: Performing a Backup
Overview
In this practice, you create a one-time backup of the USERS tablespace (for training purposes).
For the sake of practicing the workflow, select the following backup settings:
•
Full Backup – selected

• Also back up all archived logs on disk – deselected
• Delete obsolete backups – selected
Note: For a “complete online backup,” both data files and archive logs are needed; so normally
you do select to back up the archive logs.
Assumptions
You are logged in to Enterprise Manager Cloud Control as the emadmin user. Your database is
n se
prepared for backups (with ARCHIVELOG mode enabled) as outlined in Practice 3-1. You start
lic e
on the orcl.example.com database instance page.
ble
fe r a
Tasks
t r a ns
on-
1. To schedule your training backup, navigate to Availability > Backup & Recovery >
Schedule Backup.
a n
2. Ensure that Tablespaces is selected under Customized a s Backupฺ and NC_HOST_ORACLE is
e
selected as the Named Credential for the Host. ) h i d
z u
3. Click Schedule Customized Backup. oฺd tG
d o e n
o ore Stud
a n i@ this
j e br use
z ( ad to
i A zi
n
bra
Dje
4. Click Add to add a tablespace.

5. Select the USERS tablespace and click the Select button.
6. Click Next.
7. Confirm the following settings, which are chosen to save space in the training environment,
and then click Next.
• Full Backup – selected

Chapter 3 - Page 6
• Also back up all archived logs on disk – deselected
• Delete obsolete backups – selected
n se
lic e
ble
fe r a
8. Accept Disk as destination and click Next.
ans
9. Accept the default Job Name and Schedule of One Time (Immediately) and click Next.
n - t r
10. Review your job definition and click Submit Job.
a no
11.
as deฺ
You should receive a job submission success message. Click View Job.
) h
12. Refresh ฺ
the Execution: orcl.example.comdz page G uithe job finishes successfully.
until
d o o nt
e d e
o or Stu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 3 - Page 7
13. Review the backup steps by clicking the status links, especially Step: Backup. Here is an
excerpt.
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
14. Use the global menu
j e br Targets
u se>notice
Databases. Select the “Database Load Map” radio button
( a d
to view the Job Activities
t o and the latest run of the Backup Job you just performed.
A z iz tosection.
15. Navigate the orcl.example.com home page by clicking the link in the Most Affected
a n iMembers To review backup reports, navigate to Availability > Backup &
e b r Recovery > Backup Reports, then review the details and status of your last backup job.
D j 16. Optionally, for backup administration tasks, you can navigate to Availability > Backup &
Recovery > Manage Current Backups.

Chapter 3 - Page 8
n se
lic e
ble
fe r a
ans
n - t r
forno
s eฺ
ha Targets
Monitoring
ฺ d z) Guid
d o oChaptern4t
o r e tude
@ o sS
r a n e thi
i
d j eb o us
(a t
zi z
n i A
e b ra
D j
Practices for Lesson 4: Monitoring Targets

Chapter 4 - Page 1
Practices Overview
Enterprise Manager Cloud Control monitors all its managed targets. That is, metrics are
collected for each managed target according to predefined collection schedules.
1. In these practices, you monitor targets with templates. First, review the Oracle-provided
templates.
• Do all monitored items have the same collection schedule?
• Which setting is used to prevent false alerts due to spikes in metric values?
• Can you edit or delete Oracle-provided templates?
2. Next, use the Create Like functionality to create your own monitoring template for an agent.
You want alerts to trigger and clear in about 10 minutes.
3. When your new template is complete, compare the monitoring settings of your template n se
with a target, and then you apply this template, so that Cloud Control will automatically lic e
monitor the managed target with your customized settings. ble
Note: Comparing a Monitoring Template is just an example to show you the workflow. In fe r a
your own organization, you might use this functionality for ad-hoc comparison of a template ans
against a target that is not part of an administration group. n - t r
no
4. In this practice, you compare the host metric “CPU in I/O Wait (%)” of the
a
) h as deฺ
host01.example.com host to the em12.example.com host. Which host shows a higher
wait time?
o ฺ dz t Gui
Note that the important monitoring tasks, such as monitoring a target that has a Down status, is
e do den
covered in the Managing Incidents practice.
r
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 4 - Page 2
Practice 4-1: Reviewing Oracle-Provided Monitoring Templates
Overview
In this practice, you review the Oracle-provided templates.
• Do all monitored items have the same collection schedule?
• Which setting is used to prevent false alerts due to spikes in metric values?
• Can you edit or delete Oracle-provided templates?
Assumptions
Tasks
1. Navigate to Enterprise (global menu) > Monitoring > Monitoring Templates.
n se
2. If the Oracle-provided templates are not displayed, select “Display Oracle Certified lic e
templates” and then click Go ble
fe r a
3. Review the list of Oracle-provided templates and click the “Oracle Certified Template for
ans
Host targets” link.
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D
4. On the “View Monitoring Template: Oracle Certified Template for Host targets” page,
click the Metric Thresholds tab.
5. Click Collapse All, and then expand the “Oracle Certified Template for Host targets” folder.
Do all monitored items have the same collection schedule?
Answer: No

Chapter 4 - Page 3
6. Expand the Load node and click the Edit icon for CPU in I/O Wait %.
n s e
7. Review the “View Advanced Settings: CPU in I/O Wait %” page. Which setting is used to lic e
prevent false alerts due to spikes in metric values?
a b le
s f er
- t r an
n on
s a
h a d e ฺ
)
dz t Gu i
o ฺ
r e do den
o o S tu
a n i@ this
j e br use
Answer: The
z ( adNumber tofoOccurrences
8. Click
A i and then click the Monitoring Templates link (top left).
zOK,
i
a9.n Select any Oracle-provided template that interests you in the Monitoring Templates list, and
e b r then click Edit. Can you edit Oracle-provided templates?
D j Answer: No
10. Select another Oracle-provided template and then click Delete. Can you delete Oracle-
provided templates?
Answer: No

Chapter 4 - Page 4
Practice 4-2: Creating a Monitoring Template
Overview
In this practice, you use the Create Like functionality to create your own monitoring template for
a host. You name the template My Host template with CPU in I/O Wait % thresholds of
1 and 30. You want alerts to trigger and clear in about 10 minutes.
Assumptions
You are logged in to Enterprise Manager Cloud Control as the emadmin user and have
navigated to Enterprise > Monitoring > Monitoring Templates.
You reviewed the “Administer Monitoring Templates” demonstration or have the equivalent
navigation knowledge.
Tasks n se
1. On the Monitoring Templates page, select “Oracle Certified Template for Host targets”lic
e
and select Create Like from the Actions menu.
a b le
2. Enter My Host template as Name and, optionally, change the description s f erread: “This
to
is based upon the Oracle Certified Template for Host targets.” ran
3. Click the Metric Thresholds tab. o n -t
4. In the Load section, select CPU in I/O Wait % and s click
n Edit (pencil) icon.
a the
h e ฺ
a dSuggestion
5. Before you specify your threshold values, use the ) Threshold
z practice.
of the page to adjust (if needed) the values ฺofdthis u i on the bottom part
o o n t G Click Select Targets and select

the host01.example.com host.
o r ed tude
@ o sS
r a n e thi
i
d j eb o us
(a t
i z
n i Az
b ra
D j e

Chapter 4 - Page 5
6. The results are automatically displayed. Assume that, based on these results, you decide to
set the Warning Threshold to 1 and the Critical Threshold to 5.
7. Confirm that the Number of Occurrences is set to 2, because the Collection Schedule is
set to Every 5 Minutes and you want alerts to trigger and clear in about 10 minutes.
8. Click Continue.
9. You should receive the information message, “The settings have been modified but not
n se
saved to the repository. You can make further changes to the settings and click on the OK
button to save the data.” Click OK to save My Host template in the management lic e
ble
repository.
fe r a
10. Confirm that your newly created monitoring template appears in the list of monitoring
ans
templates.
n - t r
with “host” in the name. a no
Hint: Sort by Owner and you should see your template listed first, or search for templates
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 4 - Page 6
Practice 4-3: Comparing and Applying a Monitoring Template
Overview
When your new template is created, compare the monitoring settings of your template with a
target and then apply this template, so that Cloud Control will automatically monitor the
managed target with your customized settings.
Note: Comparing a Monitoring Template is just an example to show you the workflow. In your
own organization, you might use this functionality for ad-hoc comparison of a template against a
target that is not part of an administration group.
Assumptions
You are logged in to Enterprise Manager Cloud Control as the emadmin user and have
navigated to Enterprise > Monitoring > Monitoring Templates.
n se
Tasks
lic e
1. Select the newly created My Host template and click Compare Settings. ble
2. On the Compare Monitoring Template My Host template: General page, click Add. fe r a
ans
3. Select the host01.example.com target and click Select.
n - t r
4. Click Continue to initiate the comparison.
a no
5.
h as deฺ
Note the red values and the Diffs icon. The icons are explained at the bottom of the page.
The change in the collection frequency will affect a number of metrics. If you are working
)
o ฺ dz t Gui
with a small window, you might need to scroll to see both your template and the target
values.
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D
6. Click Apply Template.

Chapter 4 - Page 7
7. Confirm that the Apply Option is set to “Template will only override metrics that are common
to both template and target,” select the host01.example.com target, leave the rest of the
selections as default, and click OK.
You should receive a success message. Temporarily, you might see a 1 in the Pending
Apply Operation column for your template.
8. Refresh the page until you see 0 in this column, which indicates that your monitoring
template is applied to the target and Cloud Control will automatically monitor this agent
target with your customized settings.
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 4 - Page 8
Practice 4-4: Comparing Metric Settings
Overview
In this practice, you compare the host metric “CPU in I/O Wait (%)” of the em12.example.com
host to the host01.example.com host. Which host shows a higher wait time?
Assumptions
Tasks
1. Navigate to Targets (global menu) > Hosts and click the host01.example.com link.
2. Navigate to Host (drop-down) > Monitoring > All Metrics.
3. In the left navigation tree, expand the Load node and click CPU in I/O Wait (%). The metric
n se
details appear on the right.
lic e
4. Click Compare Targets.
ble
5. In the Select Targets dialog box, select the em12.example.com host, and click Select.
fe r a
6. The Metric Value History graph now shows values for both hosts. Which host shows a ans
higher wait time? n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D
Answer: In this example, the em12.example.com host. (Your answer may be different.)
7. Return to the Enterprise Summary page.

Chapter 4 - Page 9
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 4 - Page 10
n se
lic e
ble
fe r a
ans
n - t r
forno
s
ha Hosts
Managing eฺ
ฺ d z) Guid
d o oChaptern5t
o r e tude
@ o sS
r a n e thi
i
d j eb o us
(a t
zi z
n i A
e b ra
D j
Practices for Lesson 5: Managing Hosts

Chapter 5 - Page 1
Practices Overview
In these practices, you will perform tasks that involve your host targets. There are often multiple
ways in which to reach a particular page. This activity guide shows only one of them to avoid
redundancy.
a. On a Linux system, Yet another Setup Tool (YaST), a Linux operating system setup
and configuration tool, must be installed in order to administer the host OS directly from
the Cloud Control console. You must verify that this has been done by navigating and
viewing the Default System Run Levels. This task is a prerequisite for other activities.
b. Next, you answer a list of questions that you received via various emails. (This practice
has no effect on the following activities, so choose to answer the questions that will be
most relevant for you after this course.)
c. Lastly, execute Linux OS commands and use a file editor remotely on a managed host. n se
This task has no effect on the following activities. Execute the practice if this task is lic e
relevant for you after this course. ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 5 - Page 2
Practice 5-1: Verifying YaST
Overview
In this practice, you verify a host configuration of Yet another Setup Tool (YaST), a Linux
operating system setup and configuration tool, so that you can administer the host OS directly
from the Cloud Control console. You test access by navigating and viewing the Default System
Run Levels.
Note: This practice is a prerequisite for other course activities.
Assumptions
• You are logged in to Enterprise Manager Cloud Control as the emadmin user.
• You reviewed the “Install YaST” demonstration or have the equivalent knowledge.
Tasks n se
1. First, test if YaST is installed by performing the following tasks: lic e
ble
a. Navigate to Targets (global menu) > Hosts.
fe r a
b. On the Hosts overview page, click the host01.example.com link.
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
c. (
On the
d to
ahost01.example.com home page, navigate to Host > Administration >
i z
zDefault System Run Level.
n i A
e b ra d. If Enterprise Manager returns the “Required Installations” page, it means that YaST is
not yet installed. You can access this functionality only by performing the YaST and
D j EM Wrapper installation. This is the message you would get, included here for
reference only:
After a successful installation of YaST, you would return to Enterprise Manager and
click Finish as shown above for reference.

Chapter 5 - Page 3
2. In the Oracle training environment, you do not need to access the URL and download the
YaST software. YaST is already installed on the host01 host. In a production environment,
be sure to coordinate with the system administrator so that the correct YaST packages are
installed for your system.
3. On the System Services page, click the Default System Run Level link. n se
4. Next, specify the host credentials. Most likely there is no defined Named Credential for the lic e
host01 host specifically. So far, you should have defined only a host credential for ble
accessing the database on host01. fe r a
ans
a. On the “Specify the host credentials” page, select New to create a new Host
n - t r
Credential.
a
b. Enter Username oracle and for Password enter its password.
no
c. Save As NC_HOST01_ORACLE. This will cause ) h asConfirm
the d e ฺ Password field to be
dz t Gu i
ฺ
displayed; enter the oracle user’s password.
o
d. Select Set As Preferred Credential
r e do and dselect
en Normal Host Credentials from the
oo s St
select list that is then displayed. u
e. Click OK. @
ni e thi
r a
5. A processing page
d jebwill
informationathrough t
the o
s while the OS executes the task and provides you with the
appear
u
Enterprise Manager interface. You then see the Default System
z (
i A zi
Run Level page.
b ran
D j e

Chapter 5 - Page 4
6. Review the information on this page. What is the current System Run Level for this host?
(Full multiuser mode with network)
“Run level” defines the state of the machine after a boot. Level 3 starts the system normally.
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 5 - Page 5
Practice 5-2: Monitoring Hosts
Overview
In this practice, you answer a list of monitoring questions that you received via various emails.
This practice has no effect on the following activities, so choose to answer the questions that
will be most relevant for you after this course.
Note: Your values may be different than the ones displayed here.
Tip: If you wish to answer all of them, you might not want to do it sequentially. As in real life, the
questions jump between topics.
1) What is the status of your host targets?
2) How many incidents are reported for each target?
3) What is the Average Compliance Score?
4) What is the CPU Utilization %?
n se
5) What is the Memory Utilization %?
lic e
6) How many host targets are monitored? ble
7) Are all related targets available? fe r a
ans
8) View the network utilization information on the host01.example.com host. Is your
n - t r
read or write rate higher?
9) How large is the file system for the em12.example.com host?a no
10) Which network services can you administer from ) h athes em12.example.com
d e ฺ host?
z u i
o ฺd tonGthe em12.example.com host.
11) Determine the CPUs of your latest configuration
o
12) What is the Availability (%) of r e
the
u d en
dhost01.example.com host?
o o S t
13) What is the operating system on which the host is running?
a n is
i@on thethhost01.example.com
14) What is the agent
e b r name
s e host?
15) How many u
dj“targetstowith status” do you have?
( a
z iz
Assumptions
A
r a niare logged in to Enterprise Manager Cloud Control as the emadmin user.
You
b
Dje You reviewed the following demonstrations or have the equivalent navigation knowledge:
• Monitor and Manage All Hosts
• Monitor an Individual Host
• Administer a Linux Host
Tasks
1. What is the status of your host targets?
Navigate to Targets (global menu) > Hosts. (All hosts are up.)
The screenshot below is used to provide answers to this and subsequent questions.

Chapter 5 - Page 6
2. How many incidents are reported for each target? (One or zero incidents)
3. What is the Average Compliance Score? (Unavailable)
4. What is the CPU Utilization %? (3.86 and 0.95)
5. What is the Memory Utilization %? (70.51 and 57.8)
6. How many host targets are monitored? (2 hosts)
7. Are all related targets available? (Yes)

Navigate to Targets > Hosts > host01.example.com > Host (drop-down) > Related
Targets.
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 5 - Page 7
8. View a few additional key metrics. What is the network utilization for the
host01.example.com host? Is the read or write rate higher?
If you are not already on the host01.example.com pages, use History >
host01.example.com or navigate to Targets > Hosts > host01.example.com (Write
rate is higher in this example).
n se
lic e
ble
fe r a
ans
n - t r
a no
h a s etoฺHost > Monitoring >
9. What are the Program Resource Utilization metrics? Navigate
Program Resource Utilization and review the total
d zSize. id
) CPU uUtilization, Max CPU
Utilization, and Max Resident Memory
o o ฺ tG
d e n
o ore Stud
a n i@ this
j e br use
z ( ad to
A i
zlarge
10. iHow is the file system for the em12.example.com host? (41.22 GB in this example)
ra n
j e b If you are not already on the em12.example.com pages, use History >
D em12.example.com or navigate to Targets > Hosts > em12.example.com.

Chapter 5 - Page 8
11. Which network services can you administer from the host01.example.com host?
If you are not already on the host01.example.com pages, use History >
host01.example.com or navigate to Targets > Hosts > host01.example.com then
Host (drop-down) > Net Services Administration > Administer (drop-down) (Listeners,
Directory Naming, Local Naming, Network Profile, File Location, Group Copy of Network
Config Files)
n se
lic e
ble
fe r a
ans
n - t r
a no
as deIfฺyou are not already on the
12. Determine the CPUs of your latest configuration onhhost01.
)
host01.example.com pages, use History ฺ G ui
d>zhost01.example.com or navigate to
o t
o thenenHost (drop-down) > Configuration >
d(Intel
Targets > Hosts > host01.example.com
o r
Last Collected > Hardware > CPUs.e d 2 Duo in this example)
tuCore
o S
a n i@ this
j e br use
z ( ad to
i A zi
b ran
D j e
Note that your environment may show slightly different hardware specifications.

Chapter 5 - Page 9
13. What is the Availability (%) of the host01 host? (100%)
Click the “i” icon next to the host name host01.example.com. This screenshot also
applies to the next few questions.
14. What is the operating system on which the host01.example.com host is running?
n se
(Oracle Linux Server Release 6.3)
lic e
15. What is the agent name on the host01.example.com host? ble
(host01.example.com:3872) fe r a
ans
16. How many “targets with status” do you have in your enterprise?
n - t r
corner. a no
Navigate to Enterprise > Summary and observe the Targets with Status in the top-left
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 5 - Page 10
Practice 5-3: Working Remotely in the Host OS
Overview
In this practice, you execute Linux OS commands and use a file editor remotely on a managed
host. (Again, this task has no effect on the following activities. Execute the practice if this task is
relevant for you after this course.)
Assumptions
You reviewed the following demonstrations or have the equivalent navigation knowledge:
• Monitor and Manage All Hosts (Executing OS command section)
• Use the Remote File Editor
Tasks n se
lic e
1. In this first task, you execute a Linux command remotely.
ble
a. If you are not already on the host01.example.com pages, use History >
fe r a
host01.example.com or navigate to Targets (Global menu) > Hosts and click the
ans
host01.example.com link.
n - t r
no
b. Click the Host drop-down, and then click Execute Host Command.
a
) h as deฺ
c. A Preferred Credential should already be set up for this host, namely oracle. If not,
o ฺ dz t Gui
select the Named radio button and use the credential named NC_HOST01_ORACLE.
d. Click OK.
r e do den
o S tu
e. Note at the bottom of the Execute Host Command page that you can switch from single
o
target to multiple targets mode. In this task, you execute the following commands only
a n i@ this
on the host01.example.com host. Enter ls
e br use
/u01/app/oracle/product/agent12c in the Command field and click Execute.
j
z (ad to
i A zi
ran
j e b
D
The result is displayed in the output field (The content of your directory may be
different).

Chapter 5 - Page 11
2. For the next task, you use the Remote File Editor to correct a typographical error in a file on
the host01.example.com host. The cs_oms.txt file is in the /home/oracle/labs
directory.
a. On the host01.example.com pages, navigate to Host > Remote File Editor.
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
e b r
b. If prompted, select e
NC_HOST01_ORACLE
s as your Named Credential and click OK. Or
j
allow thedPreferred
t o u
Credential oracle to be used.
a
z ( use the flashlight icon to navigate to the /home/oracle/labs directory and
i
c. Either
z
n i A select the cs_oms.txt file, or enter the path and file name in the File Name field:
ra /home/oracle/labs/cs_oms.txt. Click Continue.
D jeb

Chapter 5 - Page 12
d. Fix the error in the word “probably” by adding the letter “o.” Click Save and then OK.
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 5 - Page 13
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 5 - Page 14
n se
lic e
ble
fe r a
ans
n - t r
forno
s eฺ
ha Groups
Managing
ฺ d z) Guid
d o oChaptern6t
o r e tude
@ o sS
r a n e thi
i
d j eb o us
(a t
zi z
n i A
e b ra
D j
Practices for Lesson 6: Managing Groups

Chapter 6 - Page 1
Practices Overview
In these practices, you manage groups.
1. Create a privilege-propagating group for your database instance, named
PPG_DB_GROUP. You want to explicitly assign targets to this group. Which group type
do you select?
2. Assign an Oracle-provided monitoring template to the PPG_DB_GROUP group.
3. Create a second group that does not propagate privileges when new targets are added.
4. Test the PPG_DB_GROUP as the DB_ADMIN user.
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 6 - Page 2
Practice 6-1: Creating a Privilege-Propagating Group
Overview
In this practice, you create a privilege-propagating group named PPG_DB_GROUP for your
database instance. You want to explicitly assign targets to this group. Which group type do you
select?
Assumptions
Tasks
1. First, you will discover an additional database that will be part of a group you create in this
exercise session. Because it is recommended that repository databases are managed
targets in Cloud Control, you will add the repository database to your managed system. n se
Databases are automatically discovered on a host that has an agent running on it. In your lic e
setup, the OMS and the repository reside on the same host and an agent was automatically ble
installed when the OMS was installed. fe r a
a. Navigate to Setup > Add Target > Auto Discovery Results and click the Targets on ans
Hosts tab to view the targets discovered on the repository host. n - t r
a no
b. Select the em12rep.example.com database instance and click Promote.
h as deฺ
c. In the Databases table, check the row for em12rep.example.com
) and click
Configure. dz t Gu i
o ฺ
o dbsnmp.
d. Enter the Monitor Password ford
r e user
u d en
e. Click “Test Connection” o too t
test the monitoring connection and look for the
Information dialog box:i @ “The i s S
connection test was successful.” Click OK to dismiss the
a n t h
j e br account
Information dialog box.
u se is used by Cloud Control, specifically the management
z (
agent,
afordtarget discovery
Note: The dbsnmp
to and monitoring Oracle databases. This user is referred to as
i
n i Azthe database monitoring credentials. By default, the dbsnmp account is locked in most
ra databases. In your environment, dbsnmp has been unlocked.
D jeb f. Click Save to return to the Promote Target: Results page.
g. Ensure that the database em12rep.example.com and its listener,
LISTENER_em12.example.com, are both selected and then click Next.
h. Click Save to promote the discovered targets to monitored targets. You will be
presented with a dialog box showing that the promotion is being processed, and finally
a Confirmation dialog box showing Saving Targets - Completed
Successfully.
i. Dismiss the Confirmation dialog box by clicking Close.
j. Navigate to Target > Databases and view by Search List. The repository database
em12rep.example.com should now be listed under the monitored databases.
Refresh the page until the status of the database shows as Up.
2. Create the DB_ADMIN user.
a. Navigate to Setup > Security > Administrators.
b. Click Create and enter the following values: DB_ADMIN as the Name, and as
Password your choice of password for user DB_ADMIN. Make a note of this password!

Chapter 6 - Page 3
You will need it later! Enter DEFAULT as the Password Profile and optionally you can
enter a Description as shown in the screenshot.
n se
lic e
ble
fe r a
ans
Note the Super Administrator box is NOT selected. Click Next.
n - t r
c. no
On the “Create Administrator DB_ADMIN: Roles” page, select the following roles:
a
EM_ALL_VIEWER, EM_USER (already selected), and PUBLIC (already selected).
Then click Next.
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D
d. On the “Create Administrator DB_ADMIN: Target Privileges” page, select the View any
Target privilege.
e. Scroll down to the Target Privileges section and click Add.
f. On the “Search and Add: Targets” page, select Database Instance as Target Type.

Chapter 6 - Page 4
g. Click Select All and then the Select button to add both database instances under
Target Privileges.
n se
lic e
ble
fe r a
h. In the Target Privileges section, click the Edit icon in the Manage Target Privilege ans
Grants column for the first database instance. n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D i. On the “Create Administrator DB_ADMIN: Target Privileges” page, select Full (in
addition to the already selected View) privilege and click Continue.
j. Scroll to the Target Privileges section again. Click the Manage Target Privilege
Grants edit icon for the orcl.example.com database instance.
k. Back on the “Create Administrator DB_ADMIN: Target Privileges” page, select Full (in
addition to the already selected View) privilege and click Continue.
l. Back on the “Create Administrator DB_ADMIN: Target Privileges” page, click Next.
m. Review the resource privileges and accept the defaults. Click Next.
n. Review your DB_ADMIN definitions and click Finish. You receive a confirmation that
the DB_ADMIN user has been created.
3. Create a group.
a. Navigate to Targets > Groups and click Create. The drop-down shows three types:
Group, Dynamic Group, and Administration Group. You want to explicitly assign
targets to this group. Which group type do you select?

Chapter 6 - Page 5
Possible answer: You select “Group,” because Cloud Control assigns targets based on
target properties for administration groups.
b. On the “Add Target, Create Group” page, enter PPG_DB_GROUP in the Name field.
c. Select Privilege Propagation Enabled and specify your time zone.
d. In the Members section, click Add By Criteria.
e. On the “Add Targets By Defining Criteria” page, ensure that only your two database
instances are selected (deselect any others), and then click Select.
n se
lic e
a b le
f. Back on the Create Privilege Propagating Group page, click the Charts tab.
s f er
g. Review and accept the default charts. Then click the Columns tab.an
h. Optionally, shorten the Abbreviations to customize your group o n -tr and dashboard.
page
i. Click the Dashboard tab. a n
j. Enter 2 as Refresh Frequency (minutes).
) h as deฺ
k. Click the Access tab.
o ฺ dz t Gui
l. On the Group Access page, click e o
dAdd. en
r u d
m. On the “Search and Select
@ ooAdministrator
s S t or Role” page, select DB_ADMIN and click
Select.
r a ni e thi
n. Click the Edit
j bManageuTarget
ePrivileges s Privilege Grants for DB_ADMIN and select Full in the
d
Edit Target
( o
a Groupt page’s Access
page. Click Continue to return to the Create Privilege
i z
Propagating
z tab.
A
b rani
D j e
o. Click OK to create your privilege-propagating group.

p. You receive a confirmation dialog box indicating the PPG_DB_GROUP has been added.
Click OK to close the information dialog box.
4. Assign an Oracle-provided monitoring template to the PPG_DB_GROUP group.
a. Navigate to Enterprise (global menu) > Monitoring > Monitoring Templates.
b. If the Oracle-provided templates are not displayed, check the “Display Oracle Certified
Templates” option and then click Go .

Chapter 6 - Page 6
c. Select the Oracle Certified-Enable Database Security Configuration Metrics
monitoring template for the Database Instance target type and click Compare
Settings.
Hint: Search for “database security” to quickly find the template
n se
d. Click Add to add a destination target. lic e
ble
e. On the “Search and Select: Targets” page select the PPG_DB_GROUP group and click
fe r a
Select.
ans
Hint: Filter by Target Type Group.
n - t r
f. Click Continue.
a no
g.
as deฺ
You will be presented with a Confirmation page that the Compare Template Settings
) h
dz t Gui
job has been submitted. Click OK to view the job results from the Job Run page. You
ฺ
may need to refresh the Job Run page to see the results if the job is still running.
o
h. do den
On the Job Run page, click the Different link for either database in the group to see
r e
o o tu
the differences with the template.
S
i. n i@ this
The “Compare Monitoring Template” page should show a lot of metrics with
a
j e br use
differences. Click Back to return to the Job Run page.
j.
iz (ad to
Click Apply template.
A z
k. Click Add and select the PPG_DB_GROUP, and click Select.
rani Hint: Filter by Target Type Group.

j e b l. Verify the Apply option selected is “Template will only override metrics that are
D common to both template and target” and click OK.
m. You receive a confirmation message.

Chapter 6 - Page 7
Practice 6-2: Creating a Second Group
Overview
In this practice, you create a second group that does not propagate privileges when new targets
are added. Use the Create Like functionality to facilitate your task.
Assumptions
Tasks
1. To create a second group, navigate to Targets (global menu) > Groups.
2. Select the PPG_DB_GROUP and click Create Like.
3. Enter DB_GROUP in the Name field and deselect Privilege Propagation.
n se
4. Click OK to create your second group.
lic e
5. Click OK to dismiss the informational message indicating your DB_GROUP has been
ble
created.
fe r a
6. Note the different Group Type icons, which distinguish a “Group” from a “Privilege
ans
Propagating Group.”
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 6 - Page 8
Practice 6-3: Testing the Group
Overview
In this practice, you test the PPG_DB_GROUP group as the DB_ADMIN user. You will see that
your restriction is effective, that you cannot perform host configuration tasks.
Assumptions
Tasks
1. To test as a different user, first log out as the emadmin user.
2. Log in as the DB_ADMIN user with the password you selected at creation time.
3. The first time you log in to Enterprise Manager Could Control, the “Select Enterprise
Manager Home” page is displayed. In your role as Enterprise Manager Administrator for e
databases, select the Databases home page.
e n s
4. To confirm that you cannot configure hosts as the DB_ADMIN user: e lic
a. Click Targets (global menu) > Hosts. r a bl
s fe
b. Select one of the hosts and click Configure.
c. As expected, you receive an error message. - t r an
no n
a
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
d. Acknowledge j e bther errorubyseclicking OK.
(
e. Log out
z adof Enterprise
to Manager Cloud Control.
5.
n Azini again as the emadmin user.
iLog
ra
D jeb

Chapter 6 - Page 9
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 6 - Page 10
n se
lic e
ble
fe r a
ans
n - t r
Managing
h s
a Systems
e ฺ and
) i d
ฺdz t Gu
oServices
r e do Chapter
d en7
oo s St u
@
ni e thi
r a
d j eb o us
(a t
zi z
n i A
e b ra
D j
Practices for Lesson 7: Managing Systems and Services

Chapter 7 - Page 1
Practices Overview
In your organization, you might have customized applications that you want to monitor with
Enterprise Manager. To practice the workflow for such a task, these practices allow you to:
1. Review existing systems and services and answer the following questions (choose the
ones that are relevant for you):
• What is the status of the Daily Maintenance job?
• When was the Daily Maintenance job last executed?
• Is there a Beacon job that tests availability? If yes, what is its frequency?
• Are there any jobs for which information is not available?
• What is the name of the Management Service for the OMS and OMR?
n se
• Which OMS applications does it include?
lic e
• What is this service a member of?
ble
• What are the service levels over the last seven days for each of the services
fe r a
displayed on the Enterprise Manager Dashboard?
ans
• To which system do they belong? n - t r
• a no
Use the Services Overview page to determine which service is monitored by a
beacon.
) h as deฺ
2. Create a sample system named MY_SYSTEM.
o ฺ dz t Gui
3. Optionally, create a Generic Service
r e dtheonamed d en based onand
MY_SERVICE select the MY_SYSTEM
oo youSwant
system to host the service. Define t u
availability a system.
4. Establish access to ani@ applicationis to monitor.
r a n t h
You create an b
j e additional
u seits availability
generic service, called MY_WEB_SERVICE, for a web
( a d
transaction type and
t o
define based on a Service Test.
A z iz assume
5. Then, that you do not have access to a browser so you have to create a web
rani transaction manually and enable it.
j e b
D

Chapter 7 - Page 2
Practice 7-1: Reviewing Existing Systems and Services
Overview
In this practice, you review systems and services, which Enterprise Manager defined for you. If
you are already familiar with them, you can skip this practice.
Note: Your screenshots may display different results.
Assumptions
Tasks
1. To review existing systems, such as the OMS and Repository System, navigate to Setup >
Manage Cloud Control > Repository.
2. View information about the DBMS jobs to answer the questions that follow. n se
lic e
a. Examine the Repository Scheduler Jobs Status section. The screenshot below is
ble
used to answer the questions that follow. Your answers may vary from the example
fe r a
shown.
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b b. What is the status of the EM Daily Maintenance job? (Up)
D c. Is there a Beacon job that tests availability? (Yes, Beacon Service Availability)
d. Are there any jobs for which information is not available? (No)
3. Click the Management Services and Repository link located at the top left. What is the
name of the Management Service in use?
(em12.example.com:4889_Management_Service)
4. Click the Management Service in Use link. Which OMS applications does the
Management Service include?
(em12.example.com:4889_Management_Service_CONSOLE and
em12.example.com:4889_Management_Service_PBS)
5. Click the "i" icon.

Chapter 7 - Page 3
What is this service a member of? (Management Services and Repository, Management
Servers)
6. Click the Management Services and Repository link to return.

7. Navigate to Targets (global menu) > Services. n se
8. To which system do they belong? (View the System column: Management Services and lic e
Repository) ble
9. Optionally, review any other services that interest you. fe r a
ans
10. Navigate to Targets (global menu) > Services. Which service is monitored by a beacon?
n - t r
(EM Console Service)
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 7 - Page 4
Practice 7-2: Creating a System
Overview
In this practice, you create a test system called MY_SYSTEM, with target members from your
database target. Assume that the system is located in Vienna. This system will be used in the
following practices.
Assumptions
Tasks
1. Navigate to Targets > Systems.
2. Select Add > Generic System from the drop-down list.
n se
3. On the “Create Generic System: General” page enter the following values. Be sure to
expand “System Properties” and scroll down to access all of the fields. lic e
ble
Field Name Value
fe r a
Name ans
MY_SYSTEM
n - t r
Comment
no
Test system
a
Privilege Propagating System Not Selected
) h as deฺ
Contact dz name>
<your
ฺ G ui
Lifecycle Status d o
o Testent
e tud
or SFinancials
Line of Business o
a n i@ this Vienna
Location
j e br use
Time Zone
( a d to Vienna (CET)
z
4. In the z
iMembers section (middle of the page), click Add.
n i A
bra following target members. Then click Select.
5. Order by host name or search for host01, hold down the Ctrl key, and select and add the
Dje
6. Select the “Include targets that selected members directly depend on” check box and then
click Next.
7. On the “Create Generic System: Define Associations” page, select Show associations
automatically detected by Enterprise Manager if no associations are displayed. Review
the list and click Next.
8. On the “Create Generic System: Availability Criteria” page, select Any Of The Key
Members. Move the host01.example.com (Host) and host01.example.com:3872
(Agent) to the Key Members list. Click Next.
9. Accept the Oracle-suggested charts and click Next.

Chapter 7 - Page 5
10. Review your definitions and click Finish. You receive a confirmation message that your
system was created and you see the system MY_SYSTEM with a status of “Up” (green).
11. Click the MY_SYSTEM link in the Name column and review your MY_SYSTEM home page.
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 7 - Page 6
Practice 7-3: Creating a Generic Service
Overview
In this optional practice, you create a System Based Generic Service named MY_SERVICE and
select the MY_SYSTEM system to host the service.
Assumptions
Tasks
1. Navigate to Targets (global menu) > Services.
2. Select Generic Service – System Based from the Create drop-down list.
3. On the “Create Generic Service: General” page, enter MY_SERVICE in the Name field and
n se
click Next.
lic e
4. Select the previously created MY_SYSTEM and click Select and then Submit. You should
ble
receive a confirmation message and the new service shows on the Services page.
fe r a
Why did the Create Generic Service wizard not request to add beacons for your service
ans
creation?
n - t r
no
Answer: Because your Service is defined based on a system. Its status will be derived from
a
the system status.
) h as deฺ
5.
MY_SERVICE link. o ฺ dz t Gui
Optionally, review your new MY_SERVICE service home page by drilling down into the
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 7 - Page 7
Practice 7-4: Monitoring a Web Application
Overview
In this practice, you create a web application and define its availability based on a Service Test.
You will also create a new beacon that will be used to perform the availability test.
Assumptions
Tasks
1. For this practice to work correctly, you need to make sure the WebLogic Administration
page is accessible from a browser. However, you do not need to log in to WebLogic
Administration.
a. Open a new browser tab or window and enter a URL similar to the following: n se
https://<hostname>.<domain>:7102/console lic e
In your environment, navigate to: https://em12.example.com:7102/console ble
fe r a
b. Most probably, you receive a This Connection is Untrusted message and you need
ans
to add a security exception. Click I Understand the Risks.
n - t r
c. At the bottom of the page, click Add Exception.
a no
d. In the Add Security Exception pop-up window, click Get Certificate.
) h as deฺ
e. Confirm that “Permanently store this exception” is selected in your training environment
ฺ dz t Gui
and click Confirm Security Exception.
o
r e do den
f. The WebLogic Server Administration console appears. There is no need to log in as
the weblogic user. o o S tu
n i@ this
g. Return to your Cloud Control console window.
a
2. br use
A “beacon” is a function of the management agents that allows you to remotely monitor a
j e
(ad to
service. A beacon is defined as a Cloud Control target and executes tests at regular
z
i A zi
intervals. A service is considered available if the test executes successfully on at least one
key beacon.
ran When monitoring a web application, you may use existing beacons or create new ones. For
j e b this practice, you will use an existing beacon and create an additional one as well. It is
D recommended that you create only one beacon per host or agent.
a. Navigate to the Targets > All Targets page and sort the targets by target types. Note
an existing beacon “EM Management Beacon” and drill down to see its details. Note
the following: its status is Up, it resides on host em12.example.com (the OMS host),
and it monitors the “EM Console Service” as a key beacon. This beacon is created by
default.
b. To create a new beacon, from the Setup menu, select Add Target, then select Add
Targets Manually.
c. On the Add Targets Manually page, select Add Targets Declaratively by specifying
Target Monitoring Properties
d. Select Beacon from the Target Type drop-down list, select
host01.example.com:3872 Monitoring Agent, and click Add Manually.
e. On the Beacons: Create Beacon page, enter Rio Beacon as the name, leave the
other fields as default, and click OK.

Chapter 7 - Page 8
f. Click the Refresh button until you see the status is up. It may take some time for the
status to be up.
3. Navigate to Targets > Services, click Create, and select the Generic Service – Test
Based option.
4. Enter MY_WEB_SERVICE in the Name field, leave the default time zone, and then click
Next.
5. The “Create Generic Service: Service Test” page changes depending on the Test Type that
you choose. Leave Web Transaction as the Test Type (default) and enter or confirm the
following values and then click Next:
Field Value
Name WLConsole
Description (optional) WebLogic Administration Console
n se
Collection Frequency
(minutes)
5
lic e
ble
Basic Single URL https://em12.example.com:7102/console
fe r a
6. On the “Create Generic Service: Beacons” page, click Add. ans
7. Select the Rio Beacon and EM Management Beacon on the Select Beacons page (or n - t r
a no
Select All) and click Select. Back on the Create Generic Service: Beacons page, verify that
both the beacons are added. Click Next.
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
8. Optionally, you can
j e brclick Verify
u s eService Test, review the test results, and click Continue
ad
and then Next.
z ( to
9. Review
A z i the entire page and click Finish.
b ra10.niThe web application is successfully added. The status shows “Pending.” After a little while,
it should change automatically to “Up.” Refresh the page to see the new status. This
D j e Service derives its status based on the tests performed by the key beacons.

Chapter 7 - Page 9
Practice 7-5: Creating and Testing a Web Transaction
Overview
In this practice, you manually create a web transaction, enable it and then verify that it works.
In this practice, the assumption is that you do not have access to an Internet Explorer browser;
therefore, you have to create a transaction manually.
Assumptions
You opened a browser with a URL similar to the following:
https://<hostname>.<domain>:7102/console, for example:
https://em12.example.com:7102/console. The WebLogic Server Administration console is
displayed. Initially, there is no need to log in.
n se
Tasks lic e
1. Navigate to Targets (global menu) > Services. ble
fe r a
2. Click MY_WEB_SERVICE.
ans
3. The MY_WEB_SERVICE home page is displayed. To create a transaction, click main
n - t r
4. a no
target menu Generic Service > Administration > Service Tests and Beacons.
To create a new transaction, select the Test Type Web Transaction and click Add.
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 7 - Page 10
5. You see a message stating that Microsoft Internet Explorer is required for some operations.
In this practice, the assumption is that you do not have access to the Internet Explorer
browser; therefore, you have to create a transaction manually. Specify the transaction
name as BrowseWLConsole for the Service Test. Scroll down and click Create to create
the steps of the transaction.
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
6. Define Step 1: br se
j e u
ad 1 in the
a. Enter Step
z ( to Name field.
i the URL of the WebLogic Server Administration console home page in the URL
i Az
b. Enter
ran field: https://em12.example.com:7102/console
D jeb c. Review the default values and click Continue.

Chapter 7 - Page 11
7. Under Steps, click Insert After and add the second step.
n se
lic e
8. Define the second step: ble
a. Enter Step 2 in the Name field. fe r a
ans
b. Enter the URL of the WebLogic Server Administration Console home page
https://em12.example.com:7102/console/login/LoginForm.jsp in the n - t r
URL field. a no
c. h as deฺ
Select POST from the HTTP Method drop-down list.
)
d. dz t Gui
Click Show for POST Data, and enter the following string:
o ฺ
o
dpassword> enis the password for the weblogic user
j_username=weblogic&j_password=<weblogic user password>
e
r u d
where <weblogic user
@ oo s St
e. Click Continue.
r anisection
9. Scroll again to thebSteps e thi click Insert After.
10. Define the a d jestep. to us
third
and
i z (Step 3 in the Name field.

a. zEnter
n i A
b. Enter the WebLogic Server Administration Console Log Out URL in the URL field:
b ra
D j e To obtain the URL, you can log in to the WebLogic Server Administration console as
the weblogic user, move the cursor over Log Out, right-click, click Copy Link
Location to copy the URL from the Log Out link, and then paste it in the URL field in the
Cloud Control console.
It should be:
https://em12.example.com:7102/console/jsp/common/warnuserlockheld.jsp
c. Verify that GET is selected from the HTTP Method drop-down list.
d. Click Continue.

Chapter 7 - Page 12
11. To create the Service Test, click OK to save these steps. You should receive a confirmation
message:
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
n
ra12.
j e b The web transaction is successfully saved. The next step is to enable the web transaction.
To do so, select the BrowseWLConsole transaction and click the Enable button.
D
13. You should receive a confirmation. To make this service test a key service test, select the
check box in the Key Service Test column. Click Change Key Tests.
Again, you should receive a confirmation: “The key tests have been updated
successfully.”

Chapter 7 - Page 13
14. Verify that the service tests (WLConsole and BrowseWLConsole) are working.
a. Select BrowseWLConsole and click Verify Service Test.
b. There are no test results initially. Select one of the beacons and then click Perform
Test.
c. Scroll horizontally to review all the results.
d. Repeat steps a-c for the WLConsole by selecting it from the drop-down menu under
Service Test on that same page.
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 7 - Page 14
n se
lic e
ble
fe r a
ans
n - t r
forno
Practices a Lesson 8: Using
s eฺ
ha System
the Job
ฺ d z) Guid
d o oChaptern8t
o r e tude
@ o sS
r a n e thi
i
d j eb o us
(a t
zi z
n i A
e b ra
D j
Practices for Lesson 8: Using the Job System

Chapter 8 - Page 1
Practices Overview
In these practices, you will perform tasks with the Enterprise Manager Job system. The third
practice depends on completing the first one.
• Create and edit a job that runs a SQL script immediately.

• Create a job that runs a host command. You want the job to list a path and directory
content (pwd ; ls) each day at 8:00 AM on all your hosts. The job name is My OS
Job. Change the suggested time to something that enables you to see the job run
while you are working on this practice.
• Use the Create Like functionality to create a second SQL job that should be executed
for two database instances. Perform this task only if you have time.
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 8 - Page 2
Practice 8-1: Creating and Executing a Simple SQL Job
Overview
In this practice, you create and edit a job that runs a SQL script immediately. (The steps are
divided into “create” and “edit” only for training purposes.)
Create a simple job called MY SQL Job that runs a SQL script against the Enterprise Manager
Repository. Save the job to the Job Library. Then edit the job to modify the credentials, provide
access, and execute the job.
Assumptions
Tasks
1. Navigate to Enterprise (global Menu) > Job > Library. n se
2. Expand the Create Library Job drop-down list and review the different types of jobs that lic e
Enterprise Manager supports. ble
fe r a
3. Select SQL Script and click Go.
ans
4. On the General tabbed page, enter MY SQL JOB in the Name field and, optionally, Run a
n - t r
simple SQL query in the Description field.
a no
5. To add a target, click Add.
) h as deฺ
dz t Gui
6. Ensure that the Target Type is Database Instance, then select the target database
orcl.example.com, and click Select. o ฺ
7. e do den
You should see your database listed in the Target section. Now click the Parameters tab.
r
8. o o S tu
Enter the following query in the SQL Script box:
n s
i@ thiUSED_SPACE,
r a
SELECT TABLESPACE_NAME,
b s e TABLESPACE_SIZE,
a d je to u
USED_PERCENT FROM SYS.DBA_TABLESPACE_USAGE_METRICS;
z i z(
n iA
ra
D jeb
9. Click Save to Library.

10. You should see a confirmation message indicating that the job was created.
11. To edit your job, select the MY SQL JOB job on the Job Library page (radio button
selection) and click Edit.
Note that drilling into the job name from the confirmation message will allow you to only
view the new job, not view and edit.
12. Click the Credentials tab.
13. The credentials you created earlier (NC_DB_SYS and NC_HOST_ORACLE) are target
specific, but Job credentials must be global and can be created here. Create new database
credentials for the SYS user with the SYSDBA role and save them as NC_DB_SYS_GLOBAL.

Chapter 8 - Page 3
Create new host credentials for the oracle user with Run Privilege None and save them
as NC_HOST_ORACLE_GLOBAL.
14. Click the Schedule tab and confirm that the Type is “One Time (Immediately).”
15. Click the Access tab and give Full Access Level to the SYS and SYSTEM users. Also note
the E-Mail Notification for Owner section; emails were set.
n se
lic e
ble
fe r a
ans
16. Click Save to Library. You should see a Confirmation message.
n - t r
no
17. Select the newly created job and click Submit to execute your job.
a
again, to confirm submission. ) h as deฺ
18. On the “Submit ‘SQL Script’ Job From Library Job ‘MY SQL JOB’” page, click Submit
o ฺ dz t Gui
19. You should receive a message that your job was created successfully. Note that the job
r e do den
system adds a “.” (period) and a digit to your job name. Click this job name link. Your job
o tu
run should be displayed with the status Succeeded. If its status is Running, click Go to
o S
a n i@ this
refresh the job information until the status is Succeeded.
j e br use
20. Click the Show link in the Details column.
(ad to
21. The Output Log is displayed.
z
i A zi
22. Optionally, review both the View Complete Log and the Log Report. The navigator may
provide faster access than going through the menus.
ran
j e b
D

Chapter 8 - Page 4
Practice 8-2: Creating and Executing OS Jobs
Overview
In this practice, you create a job that runs a host command. You want the job to list a path and
directory content (pwd ; ls) each day at 8:00 AM on all your hosts. The job name is My OS
Job.
Tip: You want to change the time to something that enables you to see the job run while you
are working on this practice.
Assumptions
Tasks
1. Navigate to Enterprise (global Menu) > Job > Library. n se
2. Confirm that “OS Command” is selected in the Create Library Job drop-down list and click lic e
ble
Go.
fe r a
3. On the “Create ‘OS Command’ Library Job – General” tabbed page, enter My OS Job in the
ans
Name field and, optionally, List path and directory content in the Description
n - t r
field. Confirm that the Target Type is Host.
4. To add targets, click Add. a no
) h as deฺ
5. On the “Search and Select: Targets” page, click Select All, and then click the Select
button.
o ฺ dz t Gui
r e do den
6. You should see your two hosts listed in the Target section. Now click the Parameters
subtab. o o S tu
n i@ this
7. Confirm that the Command Type is Single Operation and enter pwd ; ls in the Command
a
field.
j e br use
(ad to
Tip: If you are unsure why these two commands can be executed as a single operation,
z
i A zi
select Help > Enterprise Manager Help, search on “Specifying a Single Operation,” and
review the topics with “Managing Jobs” as Source.
ran
j e b 8. Click the Credentials tab.
D 9. Provide the existing NC_HOST_ORACLE_GLOBAL as Named Host credentials.
10. Click the Schedule tab, decide if you want to create a One Time job or a repeating one.
This Activity Guide describes the Repeating job. Enter the following values (or adjust them
to your training environment):
Description Choices or Values
Frequency Type By Days
Repeat Every 1 Days
Time Zone Recommendation: Select the time zone of your host
computer.

Chapter 8 - Page 5
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
11. Click the Access tab. ni@
a t h is
12. Give Full Access b
e r to theseSYSMAN user.
Level
d j t o u
z( a
A z i
a n i
e b r
D j
13. Click Save to Library, and then submit the job. Note that the job is scheduled to run on
both hosts. You will be able to check its output only after the next execution.
Hint: If you want to see the output right away, edit the schedule to run Immediately
before you submit the job.

Chapter 8 - Page 6
Practice 8-3: Creating and Executing a Multi-Target Job
Overview
In this optional practice, you use the Create Like functionality to create a second SQL job, which
should be executed for two database instances. Perform this task only if you have time.
Assumptions
• You completed the first of these practice tasks, which creates the MY SQL JOB job.
Tasks
1. Navigate to Enterprise > Job > Library.
2. Select “My SQL Job” and click Create Like.
3. On the “Create ‘SQL Script’ Library Job” page, enter My multi database target job
n se
in the Name field and Run a simple SQL query on multiple targets in the
lic e
Description field.
ble
4. Click Add and then Select to add the em12rep.example.com database instance as a
fe r a
target. A best practice is to define groups and use them here, so that instead of individual
ans
assignment of hundreds or thousands of databases, you need to assign only one group.
n - t r
Click Select.
a no
5. Click Save to Library.
) h as deฺ
dz t Gui
6. Select MY MULTI DATABASE TARGET JOB and click Submit.
7. o ฺ
On the “Submit ‘SQL Script’ Job From Library Job ‘MY MULTI TARGET JOB’” page, click
Submit.
r e do den
8. o o S tu
Click the job run link in the confirmation box. (You may see the jobs Scheduled, Running, or
Succeeded).
a n i@ this
9. br use
Click Go or the Refresh icon (top right) or turn on auto-refresh until the job runs have
j e
Succeeded.
z (ad to
i A zi
ran
j e b
D

Chapter 8 - Page 7
10. Click Show All Details to expand both output logs.
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 8 - Page 8
n se
lic e
ble
fe r a
ans
n - t r
forno
s eฺ
ha Incidents
Managing
ฺ d z) Guid
d o oChaptern9t
o r e tude
@ o sS
r a n e thi
i
d j eb o us
(a t
zi z
n i A
e b ra
D j
Practices for Lesson 9: Managing Incidents

Chapter 9 - Page 1
Practices Overview
In these practices, you will use Incident Manager to administer incidents. First, you intentionally
introduce an error by stopping the listener on the host01 host so that Enterprise Manager
produces an availability incident.
Then you find and resolve the incident. You start by gaining an overview, then select an
incident, perform some administration tasks, and drill down into the incident details, including
the guided resolution.
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 9 - Page 2
Practice 9-1: Preparing an Incident
Overview
In this practice, you intentionally introduce an error by stopping the listener on the host01 host
so that Enterprise Manager produces an availability incident.
Assumptions
You are logged in to Enterprise Manager Cloud Control as the emadmin.
Tasks
Before using the Incident Manager, create an availability incident as a training example.
1. Open a terminal window on the host01 host by double-clicking the terminal icon (on your
Dom0 desktop) and enter the following commands: e
e n s
lic
$ ssh oracle@host01
oracle@host01's password:
ble
fe r a
[oracle@host01 ~]$ . oraenv
ans
ORACLE_SID = [oracle] ? orcl n - t r
a no
) h as deฺ
[oracle@host01 ~]$ lsnrctl stop
o ฺ dz t Gui
r e do den
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 13-NOV-2014 03:25:21
o o S tu
i@ this
Copyright (c) 1991, 2014, Oracle. All rights reserved.
a n
j e br use
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host01.example.com)(PORT=1521)))
( ad to
The command completed successfully
z
i
i Az[oracle@host01 ~]$ exit
a2.n Navigate to Enterprise > Summary.
b r
D je Under Incidents, you should see at least one fatal incident. If not, refresh the page until you
see it.
Note that the number or type of incidents you see on your system may vary slightly from
what you see above. But you must see at least one fatal incident under availability as
marked above.

Chapter 9 - Page 3
Practice 9-2: Finding and Resolving an Incident
Overview
In this practice, you find and resolve an incident in your data center. You could just start on the
Enterprise Summary page by clicking a specific digit, which will give you an incident view filtered
by that category and type.
In this practice, your workflow is different (just for training purposes). You start by gaining an
overview, then select an incident, perform some administration tasks, and drill down into the
incident details, including the guided resolution.
Assumptions
• You completed the previous practice, which caused Enterprise Manager to create a
backup incident. n se
• You reviewed the following demonstrations or have the equivalent navigation lic e
knowledge: ble
− Incident Management Overview fe r a
ans
− Creating an Incident Management View
n - t r
− Viewing Incident Details
a no
) h as deฺ
Tasks
o ฺ dz t Gui
1. To gain an overview over all incidents, e o
dnavigate etonEnterprise > Monitoring > Incident
r u d
Manager.
@ oo s St
r a ni ofeinterest
2. Optionally, review any topics
t hi in the Getting Started section.
3. Look for the fatal
j b
eincident. If s
u it is not yet displayed, refresh the page until Enterprise
Manager has
( danalyzed o
t from the one
alook differentthe target down issue and created the incident. Most likely, your
screen
z i zwill below, depending on what other incidents may have
A
ani
triggered.
e b r
D j
4. When you highlight an incident on the list, the incident details are displayed at the bottom
part of the page. Click the Collapse Pane icon located right center to have more
space for working with the incident details. At any time, you can click Restore Pane and the
incident list reappears.
How you will work with the administration of incidents in your organization depends, of
course, on your business rules. The following is just an example that assumes the
collaboration of several administrators.

Chapter 9 - Page 4
5. To perform incident administration tasks, click Acknowledge.
Note the changes: The button disappears, the Last Comment is updated, and the user is
assigned as Owner.
6. Click Add Comment.

n se
7. On the Add Comment page, enter Starting research and click OK.
lic e
ble
8. Click refresh page to see the changes.
fe r a
9. Click Manage.
ans
10. On the Manage page, select Work in Progress as Status and click OK.
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D
11. Click refresh page to see the changes.

Chapter 9 - Page 5
12. Normally, you would bring up a Down target as quickly as possible, but for training
purposes assume that you first want to view the topology to see the effect of this Down
target. So, click View Topology (under Guided Resolution). You can view dependent
targets and their details by hovering over the target to display a tool tip and then on the
chevrons in that tool tip:
n se
lic e
ble
fe r a
ans
n - t r
a no
13. On the Oracle Listeners home page, you could restart
h s listener
athe e ฺ by selecting Oracle
Listener > Control > Startup/Shutdown. )
z Gui
dIncident d
However, for training purposes, return to the o ฺ t Manager by navigating to Enterprise
othe Restore/Collapse
> Monitoring > Incident Manager.eUse d d e n pane icons to adjust the
layout of the page, if needed. oo
r t u
i @ i s S
14. Under “My open incidents
r a n e th Select the same “The listener is down” incident
and problems”,
and click Restart b s the bottom, under Guided Resolution)
d j e Listener
o u(at
15. On the Net ( aServices t
Administration: Host Login page, select the NC_HOST01_ORACLE
z
zi credentials and click Login.
named
i A
b ra16.n On the Start/Stop: LISTENER page, confirm that Start is selected as Operation and click
OK.
D j e 17. A processing window may appear, which should be followed by a Confirmation and the
listener displaying a status of Up. This may take a few minutes to appear.
18. Assume that the rules in your organization require you to set the incident status to Closed
and that your username is stored in the OMR. Navigate again to Enterprise > Monitoring
> Incident Manager page and adjust the layout if desired. By default, only open incidents
are displayed.
19. Click the Search icon with the magnifying glass, then select Show closed only, and click
Get Results. Scroll down to see the results of the search.
20. To confirm that the incident is correctly closed, click “The listener is up” summary and
confirm that the emadmin username is displayed as Owner.
In your environment, you may notice other incidents; it depends on the availability of
various components at that point in time.
21. If needed, click Refresh Page to see the changes.

22. Log out of the Oracle Enterprise Manager console.

Chapter 9 - Page 6
n se
lic e
ble
fe r a
ans
n - t r
forno
s ฺ
ha andeProvisioning
Patching
ฺ d z) Guid
d o oChaptern10t
o r e tude
@ o sS
r a n e thi
i
d j eb o us
(a t
zi z
n i A
e b ra
D j
Practices for Lesson 10: Patching and Provisioning

Chapter 10 - Page 1
Practices Overview
In these practices, you will learn how to automate provisioning and patching of software in your
data center. To use the Oracle-provided “Patch Oracle Database” Deployment Procedure in
offline mode, you need to fulfill the following requirements:
• Set up and configure the software library.

• Set My Oracle Support to “offline.”
• Upload the updates (metadata) file.
• Review the “Refresh From My Oracle Support” job in offline mode.
• Download the patch files to a known location and upload them to the software library.
Prerequisites for configuring a software library storage location are available storage space and
setting appropriate host credentials. n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 10 - Page 2
Practice 10-1: Preparing for Offline Patching
Overview
In this practice, you perform one-time steps to prepare your environment for offline patching:
• Set the Normal Host Credentials and the Privileged Host Credentials for the host
you are patching.
• Verify the default software storage location, default_loc, which points to an area
with sufficient available storage space.
• Configure offline patching.
• Upload metadata updates file and run the “Refresh From My Oracle Support”
job.
Note: This job is also needed in offline mode, because it computes patch
recommendations.
n se
Completing this practice is a prerequisite for practice 10-2, “Patching Offline.” lic e
ble
Assumptions
fe r a
You are logged in to Enterprise Manager Cloud Control as the emadmin user. ans
n - t r
Tasks
a no
) h as library,
1. A prerequisite for patching is having a configured software
d e ฺ a storage area for your
dthezsoftware
software. In your lab environment, a software library was u i configured with
already
o
appropriate space. The user that configured ฺ
oone OMS t G library, emadmin, has view
privileges on all the OMSs (in your e d e n
or Stud to Setup > Provisioning and Patching >
case, on the em12 host).
To check the existing Softwareo Library, navigate
Software Library.
a n i@ this
j e br uand
a. Select default_loc sethen click Actions > Check Accessibility.
( ad receivetoa confirmation.
b. You should
z
i A zi
b ran
D j e
c. Optionally, you can click Show in the Associated Entities column to view many
predefined entity associations. When you are finished reviewing the associated
entities, click Cancel.

Chapter 10 - Page 3
2. Take a look at the Patches and Updates page to see the current state of your patching.
Navigate to Enterprise > Provisioning and Patching > Patches & Updates. Note that
your system is set up for Offline patching and there are currently no patch
recommendations for your system.
n se
lic e
ble
3. To set up your patching, navigate to Setup > Provisioning and Patching > Offline
fe r a
Patching.
ans
On the Offline Patching page:
n - t r
a. Confirm that the Connection is Offline.
a no
) h as deฺ
b. In the Offline case, the up-to-date patch recommendations must be downloaded
dz t Gui
separately and made available to this system. The updates have already been
ฺ
downloaded and saved in your environment. Select Browse and navigate to
o
/home/oracle/labs/updates.
r e do den
o
c. Select the em_catalog.zip S tuUpload.
o and click
a n i@ this
d. You shouldje br a usuccess
receive se message such as this:
z ( ad to
i
n i Az
ra
D jeb
A dedicated job called “Refresh From My Oracle Support” is scheduled by default to
run periodically to extract information from the metadata file and display it in the Cloud
Control console. Click the “Refresh From My Oracle Support” link to view the job details.
Refresh periodically to view its up-to-date status. The job does not actually connect to MOS
in this mode, but it computes patch recommendations based on the data uploaded to the
repository.

Chapter 10 - Page 4
e. Refresh the Job Run: MOS REFRESH page until you see the Succeeded status.
Hint: Turn on auto-refresh.
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
d
f. Optionally, click Show All Details, and then
ฺ z click G ui Complete Log to review the
View
o nt loaded.
o parsedeand
entire Output Log. The XML files are
d
e d
r andtuPatching > Patches & Updates to view the
othe
4. Navigate to Enterprise > Provisioning
recommended updates based @ oon s S information.
uploaded
i i
an se th link.
r
a. Click the All Recommendations
b
a d je to u
z i z(
n i A
b ra
D j e
b. Review patches recommended for each target.

c. To filter the patches, you can select one of the categories from the drop-down menu.
Select the Security option only and then click the magnifying glass to search.
Note the recommended security patches.

Chapter 10 - Page 5
Practice 10-2: Patching Offline
Overview
Offline mode does not require network connectivity to My Oracle Support (MOS). In this
practice, you perform offline patching steps:
1) Upload a patch into the software library.
2) Apply the uploaded patch via a patch plan, which defines deployment details. A
patching wizard guides you through the steps.
Assumptions
You are logged in to Enterprise Manager Cloud Control as the emadmin user. You completed
Practice 10-1: Preparing for Offline Patching.
Tasks n se
1. It is recommended that before you patch, the EM Target Patchability Report is run, to lic e
analyze your targets and make sure they are “patchable.” ble
fe r a
a. Navigate to Enterprise > Provisioning and Patching > Patches & Updates.
ans
b. Expand the Patching Quick Links region and locate the Target Patchability Report.
n - t r
a no
) haissrunidimmediately
c. Click the Target Patchability Report. Thezreport eฺ and the results
ฺ d u
are displayed.
d o o
e n tG
o ore Stud
a n i@ this
j e br use
z ( ad to
i
n i Az
ra
D jeb
2. To perform any patching tasks in Cloud Control, you need to set up Named Credentials for
normal operating system user accounts (in your case oracle) and Named Credentials for
privileged user accounts (root). If you do not have access to either Oracle software owner
account or root account, then you can use Privilege Delegation. Privilege Delegation is a
framework that allows you to use either Sudo or PowerBroker to perform an activity with the
privileges of another user (usually locked accounts).
Ideally, these named credentials are saved as Preferred Credentials for your hosts. In
general, Preferred Credentials can be set up per target type by setting up Default Preferred
Credentials, in which case each target of that type inherits that credential. Or you can
define a specific credential for each target of that type.
In this practice, you set up Normal and Privileged credentials for a Host type.

Chapter 10 - Page 6
a. Assume that you do not have root privileges to your target. Navigate to Setup >
Security > Privilege Delegation
n se
lic e
ble
fe r a
ans
n - t r
b. no
You will be patching the host01.example.com host, so select to Edit the settings for
a
this host.
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D
c. Select Sudo and enter the sudo command: /usr/bin/sudo -u %RUNAS%

%COMMAND%
d. Review the parameters and click Save.
e. To set or confirm preferred host credentials, navigate to Setup > Security > Preferred
Credentials.
f. On the Preferred Credentials page, select Host and click Manage Preferred
Credentials.
g. On the Host Preferred Credentials page, under the Target Preferred Credentials
table, check if the Normal Host Credentials is set for host01.example.com. It
should have been set to NC_HOST01_ORACLE in a previous practice. If it is not set, set
it now to oracle and the password for the oracle user.

Chapter 10 - Page 7
h. Highlight the row Privileged Host Credentials for host01.example.com and click
Set.
i. Set the Default Privileged Host Credential to a new credential oracle as shown
below; then click Test and Save.
n se
lic e
ble
A success message should be displayed at the top of the page. fe r a
ans
3. When working on Offline mode, patches must be pre-saved in a known location. A patch
administrator would have to connect to https://support.oracle.com and download all patches n - t r
of interest for your environment. a no
4. h as deฺ
In your environment, one patch was downloaded to be used for this practice: Patch
)
o ฺ dz t Gui
19303936: DATABASE PATCH SET UPDATE 12.1.0.2.1 (OCT2014). This patch
r e do den
contains one archive file, p19303936_121020_Linux-x86-64.zip and a metadata file:
o
p19303936_121020_American.txt.
o S tu
a n i@ this
Note that along with most patches, you must have saved in the Software Library a copy of
j e br use
the latest OPatch (saved as a patch itself under Universal Installer). In your environment,
you have OPatch patch of version 12.1.0.1.5 for Oracle software
(ad to
releases 12.1.0.x (OCT 2014), saved as files p6880880_121010_Linux-x86-
z
i A zi
64.zip and p6880880_121010_American.txt.
ran The next step is to make these patches available to Cloud Control from their current
j e b location /home/oracle/labs/offline_patch/ to the Software Library.
D a. To upload and save a patch in the software library, navigate to Enterprise >
Provisioning and Patching > Saved Patches.
b. Click Upload to upload a new patch to the software library. On Upload a Patch, select
the following:
− Browse for the patch ZIP file: /home/oracle/labs/offline_patch/
p6880880_121010_Linux-x86-64.zip
− Browse for the patch metadata file: /home/oracle/labs/offline_patch/
p6880880_121010_American.txt
Click Upload. Look for the success message at the top of the window.

Chapter 10 - Page 8
c. Repeat the step above for the next patch. Click Upload to upload a new patch to the
software library. On Upload a Patch, select the following:
− Browse for the patch ZIP file: /home/oracle/labs/offline_patch/
p19303936_121020_Linux-x86-64.zip
− Browse for the patch metadata file: /home/oracle/labs/offline_patch/
p19303936_121020_American.txt
Click Upload. Look for the success message at the top of the window.
5. To perform a patching task, you add a patch to a plan.
6. Navigate to Enterprise > Provisioning and Patching > Patches & Updates.
a. In the Patch Recommendations section, click All Recommendations and note the
patch you just downloaded is one of the patches recommended to be applied.
Click the Patch Name 19303936 to view patch details and select to Add to Plan >
Add to New.
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
b. Enter a name for your plan, o S tu
o12db_oct_update, and then click Create Plan.
c. At the top right ofathe i @ i s
n page,e athconfirmation message states that the plan has been
created. Click b r
ethis patch
the link s Plan to see the details. Note the plan automatically
View
d j t o u
z ( a
associates with the orcl.example.com target because it is the only target
A
in
z i your system this patch applies to.
an i d. Review the step defaults on pages Step 1 and Step 2, clicking Next to move between
e b r steps. Then, under Deployment Options (Step 3), select the patching to be In Place.
Dj
e. Retain the default for the Where to Stage section. Then, under Oracle Home
Credentials select to Override and Specify for: Each

Chapter 10 - Page 9
f. Next, assign credentials for each home (in your case a single home) to the ones
previously created for the Host target, as shown below:
Note that you would be able to create Normal and Privileged Credentials during this
step, if they were not created ahead of time. However, it is more typical to separate
these duties. For example, a Security or Super Administrator may handle the
credentials while Patch Designers or Patch Operators can create and apply patches.
g. Click Next to accept all other defaults and advance to Step 4: Validation. Click n se
Analyze. It should take a few minutes. Click the arrow symbol to view details: lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
e o thereeare
dthat n no issues to be resolved. Optionally,
h. When analysis completes, ensure
r u d
oo Results
you can click Show Detailed
@ s S tto view more details of the analysis. Click Next
when done.
r a ni e thi
d j eb o us
(a t
i z
n i Az
ra
D jeb
i. On the “Review and Deploy” page, click Deploy.

j. Acknowledge steps to be performed and click Submit, to run Immediately.
7. This is a Deployment Procedure and its details are displayed on the Procedure Activity
page. This task should take anywhere between 15 to 30 minutes. When it completes, click
the Show Detailed Results link to view the details.

Chapter 10 - Page 10
Note that the plan now becomes locked because the patches were deployed. To apply
these patches on a new set of targets you must save this plan as a template. You can do
this directly from the Review and Deploy page after successful deployment, by clicking on
the Save as Template link.
8. During the patching task, your instructor might suggest additional activities, such as viewing
the “Perform Out-of-Place Database Patching” demonstration and answering related
questions:
a. The demonstration mentions several tests that are performed for you. Which one is the
most important for your organization?
b. True or False: Before starting the patching operation, you can specify the new Oracle
Home. It can be validated only after creation.
c. True or False: While patches are applied to a new Oracle Home, the original one is not
affected by this operation.
d. True or False: The switching from the original to the new Oracle Home occurs during a
n se
regular maintenance window.
lic e
If you want to review the detailed steps later, you can do so by clicking the Status link.
ble
Navigate to Enterprise > Provisioning and Patching > Patches & Updates. In the Plans
fe r a
section, you see the status of your patch plan.
ans
Also note that the Oracle Home that hosts the target that you just patched,
n - t r
no
OraDB12Home1_1_host01.example.com, shows the applied patch.
a
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

n se
lic e
ble
fe r a
ans
n - t r
forno
s eฺ
ha Configurations
Managing
ฺ d z) Guid
d o oChaptern11t
o r e tude
@ o sS
r a n e thi
i
d j eb o us
(a t
zi z
n i A
e b ra
D j
Practices for Lesson 11: Managing Configurations

Chapter 11 - Page 1
Practices Overview
In these practices, you will view, compare, and search the configuration information in the OMR
to monitor and manage your enterprise configuration:
1. View the installed OS packages and their version numbers under Operating System
Components.
2. View the configuration history and use the topology viewer.
3. Compare your host configuration with another host configuration.
4. Search for Oracle products installed in Oracle Homes.
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 11 - Page 2
Practice 11-1: Viewing Configuration Details
Overview
In this practice, you view the installed OS packages and their version numbers under Operating
System Components.
Assumptions
Tasks
1. Navigate to Enterprise > Configuration > Inventory and Usage Details.
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D You see the configuration information for your hosts : Summarized information on the top
part of the page and hosts details at the bottom.
2. In the Selection Details:Hosts section, click the em12.example.com host link.
Cloud Control navigates to the em12.example.com host home page.
3. From the host home page, navigate to Host > Configuration > Last Collected.
4. On the Latest Configuration page, click any hardware or operating system node that
interests you. For example, review the installed OS packages and their version numbers
under Operating System Components (or the CPUs).
5. Also, click the Actions drop-down menu to see additional navigation aids.

Chapter 11 - Page 3
Practice 11-2: Viewing Configuration History and Topology
Overview
In this optional practice, you view the configuration history and use the topology viewer.
Assumptions
Tasks
1. Navigate to the em12.example.com host page.
2. On the host home page, navigate to Host > Configuration > History.
If there were any configuration changes, this page displays all the configuration changes
that occurred on the host during the last seven days. You can change the date parameters
to view changes over a longer period of time. n se
lic e
3. Navigate to Host > Configuration > Topology and select Used By in the View menu.
ble
fe r a
ans
n - t r
a no
h s eฺ
azoom
4. The topology map may be too small to read. Use)the
d z u d to enlarge it.
islider
5. Click the arrow toggle at the bottom-right o
o ฺ G
to display at miniature topology map, which assists
d
e tud
with navigation. Optionally, click Display > Tablee n
(top right) and expand the Host target to
o
o sS
view the configuration in the table
r
format.
@
n e thi
i
r a
d j eb o us
(a t
i z
n i Az
b ra
D j e

Chapter 11 - Page 4
6. The Configuration Topology page is displayed with the node expanded.
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 11 - Page 5
Practice 11-3: Comparing Configurations
Overview
In this practice, you compare your host configuration with another host configuration. The
Compare Wizard allows you to compare various types of current or saved configurations with
one or more current or saved configurations.
Assumptions
Tasks
1. To compare configurations, navigate to Enterprise > Configuration > Compare.
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D
2. On the “Compare Configurations: First Configuration” page, select Host as Target Type and
then click Search.
3. Select host01.example.com and click Next.
4. On the “Compare Configurations: Comparison Configurations” page, click Add
Configurations.
5. On the “Search and Select Configurations” page, confirm that the Target Type is Host and
click Search.
6. Select em12.example.com and click OK.
7. Click Next.
8. Accept the Default Host Comparison Template, review any Template Settings that may
interest you, and then click Next.
9. Click Next on the “Compare Configurations: Schedule and Notify” page to accept defaults.
10. Click Submit on the “Compare Configurations: Review and Submit” page.

Chapter 11 - Page 6
11. A job run begins: “Comparison – In Progress” is displayed while the job runs. It will take a
few minutes to complete. You may opt to close the progress dialog box and monitor the job
from the Job > Activity page.
12. Click the Different link when the job completes.
13. The page shows detailed results of the target properties, the hardware, and the operating
system comparison for the two host configurations.
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 11 - Page 7
Practice 11-4: Searching Configurations
Overview
In this practice, you search for Oracle products installed in Oracle Homes.
Assumptions
Tasks
1. To search configurations, navigate to Enterprise > Configuration > Search.
2. A number of searches are already predefined for you. Sort by Target Type and examine the
Oracle Home type searches available. Select Search Oracle Products installed in Oracle
Homes and click Run.
3. The Edit/Run Search page is displayed. n se
lic e
Note that you can save configuration searches by clicking Save As and providing a name.
ble
The search results are shown at the bottom of the page.
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 11 - Page 8
n se
lic e
ble
fe r a
ans
n - t r
forno
s eฺ
ha Compliance
Managing
ฺ d z) Guid
d o oChaptern12t
o r e tude
@ o sS
r a n e thi
i
d j eb o us
(a t
zi z
n i A
e b ra
D j
Practices for Lesson 12: Managing Compliance

Chapter 12 - Page 1
Practices Overview
In these practices, you learn about monitoring and managing compliance with business rules.
Many compliance rules are predefined in Cloud Control. You can also define your own rules.
Compliance rules are grouped together in “compliance standards,” which you can assign to a
specific target type. After being assigned, compliance is evaluated when there is a configuration
change. Compliance standards can be grouped together in “compliance frameworks,” which can
span multiple target types.
You will work as a super administrator in these practices. By default, the emadmin user has
access to the Compliance Framework tabbed page, because it is a Super Administrator. A
summary of the tasks:
• View predefined compliance framework, standards, rules, and rule details. If you are
already familiar with compliance objects, how to search and review them, then consider n se
Practice 12-1 optional and continue with Practice 12-2, “Using Compliance Standards.” lic e
• Create a new compliance standard called My Storage BP for DB, based on Storage ble
Best Practices For Oracle Database. Assign both of your database instances to this fe r a
compliance standard. Then view the compliance evaluation results. ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 12 - Page 2
Practice 12-1: Reviewing Predefined Compliance Objects
Overview
In this practice, you view predefined compliance framework, standards, rules, and rule details. If
you are already familiar with compliance objects, how to search and review them, then consider
this part 12-1 optional. (Continue with 12-2, “Using Compliance Standards.”)
Assumptions
• You reviewed the “Oracle Enterprise Manager 12c: Use and Report on Out-of-Box
Compliance Standards” under the Oracle Enterprise Manager 12c: Lifecycle
Management Demos or have the equivalent navigation knowledge.
Tasks n s e
lic
1. To review predefined compliance objects, navigate to Enterprise > Compliance > Library.
e
l e
btabbed
2. The Compliance Library has several tabbed pages. On the Compliance Frameworks
e r a
page, select a framework that interests you, and click Show Details.
The example shows the Oracle Generic Compliance Framework. tran
sf
n on-
s a
h a d e ฺ
)
dz t Gu i
o ฺ
r e do den
o o S tu
a n i@ this
j e br use
z ( ad to
i A zi
b ran
D j e
3. Expand the hierarchy nodes several levels and review the descriptions; then click Done.
4. Click the Compliance Standards tab. There are quite a few standards, each for a specific
target type.
5. Review the predefined standards and then select Storage Best Practices For Oracle
Database (which is applicable to the Database Instance target type) and then click Show
Details. This standard checks for proper storage settings in order to avoid space and
performance problems.

Chapter 12 - Page 3
6. Expand the hierarchy nodes if necessary until you can click Default Temporary
Tablespace Set to a System Tablespace to view its description.
7. Review any other descriptions that may interest you, and then click Done.
8. Click the Compliance Standard Rules tab.
n se
9. Because there are many rules, use the Search functionality for finding the previously
lic e
viewed Default Temporary Tablespace Set to a System Tablespace. Click the
ble
fe r a
icon to expand the Search options.
ans
10. Enter %tablespace% as Rule and click Search.
n - t r
no
11. Select Default Temporary Tablespace Set to a System Tablespace, applicable to
a
Database Instance, and click Show Details.
) h as deฺ
dz t Gui
12. Scroll to review all details including the SQL Source of how this rule is checked in the data
dictionary.
o ฺ
r e do den
o o S tu
a n i@ this
13. Click Done when
j e byour finishureviewing
se the rule details.
z ( ad to
i A zi
n
bra
Dje

Chapter 12 - Page 4
Practice 12-2: Using Compliance Standards
Overview
In this practice, you create a new compliance standard, called My Storage BP for DB, based
on Storage Best Practices For Oracle Database. Assign both of your database instances to
this compliance standard. Then view the compliance evaluation results.
Assumptions
Tasks
1. To assign compliance standards to your database instances, navigate to Enterprise >
Compliance > Library.
2. Click the Compliance Standards tabbed page, and then expand the Search field. n se
3. Select Database Instance from the Applicable To drop-down menu, enter the keyword lic e
storage and click Search. ble
fe r a
4. Because you want to ensure that there are no unexpected changes coming from predefined
ans
standards (which may be updated in the future), you create your own set. Highlight Storage
Best Practices for Oracle Database and click Create Like. n - t r
5. a
Enter My Storage BP for DB as Name and click Continue.
no
6. Click Save and OK in the Information window.
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z ( ad to
i
n i Az
ra
D jeb
7. Select My Storage BP for DB and click Associate Targets.

8. To associate targets, click Add.
9. In the “Search and Select: Targets” window, multi-select (Shift + select) the
orcl.example.com and em12rep.example.com database instances and click the Select
button.
10. Read the Association Confirmation message and click Yes, then OK.
11. Click Yes to confirm association.
12. You should receive the information that the compliance standard is submitted for
processing. Click OK.

Chapter 12 - Page 5
13. To evaluate the compliance standards, navigate to Enterprise > Compliance > Results.
14. Question: What is the compliance score for storage best practices in each database? Click
a digit under Target Evaluations.
In this example, the average is 99%. Yours may differ.

15. On the Compliance Results page, drill down to discover why the compliance standard is not
100%.
a. Highlight the name and click Show Details.
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
iz (ad to
A z
ranib. Then click the Violations tab.
j e b c. The database does not conform to the compliance standard rule as recommended by
D Oracle Corporation. Click the Violations tab to find out. Here is an example of possible
violations:

Chapter 12 - Page 6
n se
lic e
ble
fe r a
ans
n - t r
Producing
h s
a and e ฺ Using EM
) i d
ฺdz t Gu
oReports
r e do Chapter
d en13
oo s St u
@
ni e thi
r a
d j eb o us
(a t
zi z
n i A
e b ra
D j
Practices for Lesson 13: Producing and Using EM Reports

Chapter 13 - Page 1
Practices Overview
In these practices, you will first review the Oracle-provided reports and answer the following
question: Can Oracle-provided reports be modified?
Then, you execute the Availability History report for one of your targets. Change the time period
to the last seven days.
Next, you create a report using the Create Like functionality. The report definition that you use is
Availability History (Target).
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 13 - Page 2
Practice 13-1: Reviewing and Running Oracle-Provided Reports
Overview
In this practice, you review the Oracle-provided reports and execute the Availability History
report for one of your targets. Change the time period to the last seven days.
Assumptions
Tasks
1. Navigate to Enterprise (global menu) > Reports > Information Publisher Reports.
2. Review all the reports provided by Oracle.
3. Can they be modified? (No)
n se
4. Scroll to the Monitoring section (about halfway down) and click the Availability History
lic e
(Target) report. Or, you may search by Type and select Host.
ble
5. Click the icon to select one of your targets (for example, a database, or host target). The
fe r a
example in the solutions uses a host target, host01.example.com. Your results will vary
ans
if you choose a different target type. Click Select. Then click Continue.
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 13 - Page 3
6. Review the report.
n se
lic e
ble
fe r a
ans
n - t r
7.
no
On the “Information Publisher Reports – Availability History (Target)” page, click Set Time
Period. a
8. h as deฺ
On the Set Time Period page, select your Time Zone.
)
9. ฺ dz t Gui
In the “From Current Time” drop-down list, select Last 7 Days. Click Continue.
o
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 13 - Page 4
10. Note that the time period and any time-sensitive information is automatically updated.
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b
D

Chapter 13 - Page 5
Practice 13-2: Creating a Report with Information Publisher
Overview
Background: Suppose you have a host that you are managing and you want to have a report
that displays availability history and open alerts for your host. While looking at the Oracle-
provided reports, you notice that Availability History (Target) closely matches your needs. You
realize that you can perform a “Create Like,” use the information already displayed in the report,
and add the Open Alerts information to achieve the report you want. You also want to share this
information with the DB_ADMIN administrator.
In this practice, you create a report using the Create Like functionality. The report definition that
you use is Availability History (Target). Name the report: My Availability History and
Outstanding Alerts. Add the Open Alerts information, which shows all severities, to this report.
Ensure that this report is run using the target privileges of the report owner. Then modify the
report layout to the Dashboard style and allow access to the DB_ADMIN administrator. (You
n se
might also want to test access as the DB_ADMIN administrator.)
lic e
ble
Assumptions
fe r a
ans
n - t r
Tasks
a no
1. Navigate to Enterprise (global menu) > Reports > Information
h a s eฺPublisher Reports.
2. Select the Availability History (Target) reportzunder
d u id and click Create Like.
) Monitoring
ฺ t G Alerts. Accept the existing
3. Enter the Title as My Availability Historyoand Outstanding
o
category and subcategory, or create d
your own. e n
e tud an appropriate description.
Enter
o r
o and senter
4. Select Use the specified target
i @ i S em12.example.com in the Target field (or use
r an this
the flashlight icon to select
e th
host).
5. Select the Runje b
report using s
u target privileges of the report owner (EMADMIN) check
a d t o
box.
z i z(
n i A
b ra
D j e
6. Click the Elements tab.

7. Click Add to add a new element.
8. On the “Add Element” page, select Open Alerts and then click Continue.
9. Click the Set Parameters icon for the Open Alerts element.

Chapter 13 - Page 6
10. Enter Outstanding Alerts in the Header field. Make sure that Inherit Target is selected
under Targets. Select all severities to display under Options. Click Continue.
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
(
11. Click Preview
z adto see what
to your report looks like so far.
A
12. iClick
i
zReturn to Create Report Definition at the bottom left of the page.
n
bra13. You want to change the layout to a different style.
Dje 14. Click the General tab and expand Options, if needed.
15. Select Dashboard as Visual Style and click Preview.
16. Click your browser’s Back button to return to the Create Report Definition page.
17. Click the Access tab and then click Add.
18. Select DB_ADMIN and click the Select button.
19. Now, click OK to save your own report definitions in the OMR.

Chapter 13 - Page 7
20. You should receive a success message and be able to find your report on the Information
Publisher Reports page.
21. Optionally, test report access:

a. Log out as the emadmin user.
b. Log in to Enterprise Manager as the DB_ADMIN user.
c. Navigate to Enterprise (global menu) > Reports > Information Publisher Reports.
d. Enter My in the Title field and click Go.
e. Your report should be listed.
n se
lic e
ble
fe r a
ans
n - t r
a no
) h as deฺ
o ฺ dz t Gui
r e do den
o o S tu
a n i@ this
j e br use
z (ad to
i A zi
ran
j e b f. Log out as the DB_ADMIN user.
D

Chapter 13 - Page 8

Using Oracle Enterprise Manager Cloud Control 12c: to use this Student Guideฺ

Uploaded by

Copyright:

Available Formats

Using Oracle Enterprise Manager Cloud Control 12c: to use this Student Guideฺ

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Using Oracle Enterprise Manager Cloud Control 12c: to use this Student Guideฺ

Uploaded by

Copyright:

Available Formats

What is the purpose of the document?

What is the purpose of the document?

What are some of the key features of Oracle Enterprise Manager Cloud Control 12c discussed in the document?

What are some of the key features of Oracle Enterprise Manager Cloud Control 12c discussed in the document?

Unauthorized reproduction or distribution prohibitedฺ Copyright© 2016, Oracle and/or its affiliatesฺ

Daniela Hansell Disclaimer

Srividya Rameshkumar Trademark Notice

Practice 1-1: Checking the Virtual Machines (VMs) .......................................................................................1-3

Copyright © 2015. Oracle and/or its affiliates. All rights reserved.

Using Oracle Enterprise Manager Cloud Control 12c Table of Contents

Practice 10-1: Preparing for Offline Patching .................................................................................................10-3

Copyright © 2015. Oracle and/or its affiliates. All rights reserved.

Using Oracle Enterprise Manager Cloud Control 12c Table of Contents

Copyright © 2015, Oracle and/or its affiliates. All rights reserved.

Reference Material for All Practices

Copyright © 2015, Oracle and/or its affiliates. All rights reserved.

Reference Material for All Practices

Your classroom PC vncuser/vnctech

Copyright © 2015, Oracle and/or its affiliates. All rights reserved.

Reference Material for All Practices

Copyright © 2015, Oracle and/or its affiliates. All rights reserved.

Reference Material for All Practices

Copyright © 2015, Oracle and/or its affiliates. All rights reserved.

Practices for Lesson 1: Introduction

Copyright © 2015, Oracle and/or its affiliates. All rights reserved.

Practices for Lesson 1: Introduction

Copyright © 2015, Oracle and/or its affiliates. All rights reserved.

Practices for Lesson 1: Introduction

Copyright © 2015, Oracle and/or its affiliates. All rights reserved.

Practices for Lesson 1: Introduction

ran 64 bytes from em12.example.com (192.0.2.101): icmp_seq=2 ttl=64 time=0.092 ms

D jeb 64 bytes from em12.example.com (192.0.2.101): icmp_seq=3 ttl=64 time=0.085 ms

--- em12.example.com ping statistics ---

Copyright © 2015, Oracle and/or its affiliates. All rights reserved.

Practices for Lesson 1: Introduction

oracle 2880 1 0 10:27 ? 00:00:02 ora_pmon_em12rep

SQL> select name, log_mode from v$database;

Copyright © 2015, Oracle and/or its affiliates. All rights reserved.

Practices for Lesson 1: Introduction

n i AzStopping Oracle Management Server...

Oracle Enterprise Manager Cloud Control 12c Release 4

Copyright © 2015, Oracle and/or its affiliates. All rights reserved.

Practices for Lesson 1: Introduction

Oracle Enterprise Manager Cloud Control 12c Release 4

D Upload URL: https://em12.example.com:4903/empbs/upload

WLS Domain Information

Oracle Management Server Information

BI Publisher is not configured to run on this host.

Copyright © 2015, Oracle and/or its affiliates. All rights reserved.

Practices for Lesson 1: Introduction

j e b Agent Process ID : 3499

Copyright © 2015, Oracle and/or its affiliates. All rights reserved.

Practices for Lesson 1: Introduction

Agent is Running and Ready

i A z/u01/app/oracle/product/12.1.0/dbhome_1/bin/tnslsnr LISTENER -inherit

b ran oracle 4393 3463 0 11:51 pts/0 00:00:00 grep lsnr

Practices for Lesson 1: Introduction

Copyright © 2015, Oracle and/or its affiliates. All rights reserved.

Practices for Lesson 1: Introduction