Mastering Oracle Enterprise Manager 13c

Discover the Oracle Enterprise Manager architecture, from the web-based console and managed targets to the management agent, service, and repository, and explore plugins, dashboards, auto discovery, and Oracle Management Cloud.

Explore how Oracle Enterprise Manager components—OMS, repository, cloud control console, agents, and plugins—interact behind a load balancer to monitor and manage databases and hosts.

Download and install all software to set up lab, including Oracle VirtualBox with extension pack, Oracle Linux, Oracle 19 C database software, SSH tools, Xming, and Oracle Enterprise Manager 13.5.

Configure Oracle VirtualBox to create a Linux VM named oms one with 6 gb RAM and 100 gb disk, configure host-only and bridged networks, install Oracle Linux, discuss offline transfers.

Install Oracle Linux 7.9 on a configured VM by attaching the ISO, selecting advanced GUI installation, then configure storage, networking, and prerequisite RPMs for Oracle Enterprise Manager 13c.

Connect to Linux server from Windows using Winscp, locate the IP with ifconfig, copy Oracle Enterprise Manager and RDBMS files into /software, then prepare to install on the target system.

Configure the Linux operating system for OEM installation by creating directory structures and an Oracle user, installing the pre-installed rpm, and setting kernel parameters and port ranges.

Configure the operating system by creating the Oracle base and home directories, repository, oms, agent, and inventory directories; create the Oracle user and groups, set passwords, and apply ownership recursively.

Install and verify Oracle database pre-installed 19 package, ensure 32- and 64-bit packages and kernel parameters, port ranges 9000-65500, set SELinux to permissive, and disable the firewall for OEM installation.

Install Oracle 19c rdbms by setting up a session with X11 forwarding, unzip the software to Oracle home, run the installer, and create a repository database for Oracle enterprise manager.

Configure the listener with net utility and start it, then create the repository database via DBCA, setting Oracle home, environment variables, and a custom Ora data path with archiving.

Learn OEM port requirements and bidirectional ping, including agent port 3872, upload ports 4903 and 4889, ssh 22, and console ports 7803 and 7101, with http/https options.

Install Oracle Enterprise Manager 13c on Linux by configuring prerequisites, running the advanced installer, managing plugins and software library, and validating the console and agent status.

Learn to start and stop the Oracle management server (OMS) and OEM stack, and verify the agent, database, and listener status to keep all components running.

Learn to navigate the Oracle Enterprise Manager 13c console, connect to the OEM URL, and use the Enterprise, Target, and Setup menus to monitor targets, manage incidents, and perform provisioning.

Explore the Oracle Enterprise Manager 13c database dashboard, viewing managed databases, alerts, incident manager events, metrics, and tuning recommendations; manage administration, security, availability, and cloning or migration tasks.

Install the agent on a host via the OEM console or silent mode, ensure host file entries and ports between the OMS server and agent, then deploy and verify heartbeat.

Install Oracle enterprise manager 13c agents in silent mode by preparing prerequisites, including ports and host file, creating a deployment image, deploying via a response file, and starting the agent.

Decommission an agent in Oracle Enterprise Manager 13c from the console by removing it from the repository and host, using credentials and the background job.

Identify OEM agents and decommission an agent from the command line. Run the agent uninstall from the agent home, then delete the target in the repository with MCI login.

Promote Oracle home and databases to Oracle Enterprise Manager 13c using auto discovery, configure auto discovery, test connection, and verify targets promote status.

Learn to add a target manually in OEM by selecting the host, choosing listener as the target type, and entering properties like listener name and port 1521.

Create and manage production target groups in Oracle Enterprise Manager 13c by grouping on premise and cloud targets, updating target properties, and applying incident rules.

Learn to remove targets from Oracle Enterprise Manager 13c monitoring, including database targets and listeners, using the targets menu, target type, and remove option.

Enable monitoring for Oracle Enterprise Manager 13c targets by configuring per-target metrics and collection settings, adjusting thresholds and intervals, and applying monitoring templates to groups of targets.

Create, customize, and apply monitoring templates in Oracle Enterprise Manager 13c by configuring metric templates for databases, setting thresholds, and applying to multiple targets.

Navigate the incident manager to monitor events, view unassigned incidents, associate events with incidents, and configure incident rules and notifications to assign, acknowledge, and close issues.

Configure Oracle Enterprise Manager 13c mail server to send incident email alerts by setting the sender identity and outgoing SMTP details (host, port 465, username, password) with SSL, then test.

Create incident rules to automate alerts in Oracle Enterprise Manager 13c, using rule sets and out-of-box rules, define actions like email notifications or tickets, and apply rules to specific targets.