EM 12c, EM 13c: How to Verify the Plugins Deployed on the Enterprise Manager Cloud Control OMS and Agent

 EM 12c, EM 13c: How to Verify the Plugins Deployed on the Enterprise Manager Cloud Control OMS and Agent

There are three methods to determine the plugins installed with the EM OMS.

1. Using the emcli command

Log in to the emcli utility by executing the following command from the OMS <ORACLE_HOME>/bin directory

$ ./emcli login -username=sysman

 
Sync the emcli with the repository:

$ ./emcli sync

 
Execute the list plugins commands:

$ ./emcli list_plugins_on_server

Example:

> ./emcli list_plugins_on_server

OMS name is wccaloem01.wcmbp.pri:4889_Management_Service

Plug-in Name                                 Plugin-id                     Version [revision]

Oracle Cloud Framework                       oracle.sysman.cfw             13.3.1.0.0

Oracle Database                              oracle.sysman.db              13.3.1.0.0

Oracle Fusion Middleware                     oracle.sysman.emas            13.3.1.0.0

Systems Infrastructure                       oracle.sysman.si              13.3.1.0.0

Oracle Exadata                               oracle.sysman.xa              13.3.1.0.0

2. From the repository database

Login to repository database as SYSMAN user and execute the following query:

SQL> SELECT epv.plugin_id, epv.version FROM em_plugin_version epv, em_current_deployed_plugin ecp WHERE epv.plugin_type NOT IN ( 'BUILT_IN_TARGET_TYPE' , 'INSTALL_HOME') AND ecp.dest_type='2' AND epv.plugin_version_id = ecp.plugin_version_id;

Sample Output:

PLUGIN_ID            VERSION

-------------------- --------------------------------

oracle.sysman.cfw    13.3.1.0.0

oracle.sysman.emas   13.3.1.0.0

oracle.sysman.si     13.3.1.0.0

oracle.sysman.db     13.3.1.0.0

oracle.sysman.xa     13.3.1.0.0

6 rows selected.

3. From OEM Console

1. Login to OEM console
2. Navigate to Setup --> Extensibility --> Plug-ins
3. Highlight the required plugin, from the Actions menu, click on "Information"
4. In the page displayed, click on "Management Servers" tab, look for the plugin version in column "Currently Deployed Plug-in Version

There are also three methods for determining the plugins installed with the 12.1.0.1 Management Agent:

1. Using the emcli command

Log in to the emcli utility by executing the following command from the OMS <ORACLE_HOME>/bin directory

$ ./emcli login -username=sysman

Sync the emcli with the repository:

$ ./emcli sync

 

Execute the list plugins commands: 

$ ./emcli list_plugins_on_agent -agent_names="<agent hostname:port>"

 

2. Using the emctl command ( As Agent Install User)

<AGENT_HOME>/bin> ./emctl listplugins agent

Example:

 ./emctl listplugins agent

 

Note that the same commands will apply to retrieving similar information from the EM 13c Cloud Control OMS and Agent.

3. From OEM Console

1. Login to OEM console
2. Navigate to Setup --> Extensibility --> Plug-ins
3. Highlight the required plugin, from the Actions menu, click on "Information"
4. In the page displayed, click on "Management Agents" tab, look for the plugin version in column "Plug-in Version on Management Agent"

ORACLE DOC ID - 1431103.1

Autonomous Database

 

Autonomous Database (Points)

Oracle Cloud Infratstructure Blogs and Vidoes

 Oracle Cloud Reference Blogs and Videos 

Blogs:

• The Official Oracle Cloud Infrastructure blog
• Richard Garsthagen’s Oracle Cloud Blog
• Vittorio Garbuglio’s Fastcloud Blog
• Combined 28 Oracle APAC Employees’s RedThunder blog
• Rodrigo Jorge (Infrastructure Principle/Sr Oracle DBA@Accenture) – Oracle Tips and Guides
• Martin Berger’s OCI and DB Blog
• Waslley Souza’s Blog about OCI, IOT, Deep Learning, mobile
• Cloud Computing Recipes -Hands-on recipes for Oracle Cloud Infrastructure and Google Cloud Platform
• That Finnish Guy on Cloud, Database and Automation
• Javier Muhueta’s blog (enterprise architect@Oracle) about OCI, mainly from a Developer / Container perspective
• Best Practices from Oracle Development’s A‑Team
• change_on_install … an oracle blog – by Borys Neselovskyi (OPITZ CONSULTING)
• Mythics Blog – Blog by the cloud experts at Mythics (Oracle Partner)
• Select All From MySQL – MySQL (often on OCI) blog from Andrew Grimo
• Hussain’s Oracle Administration Blog
• Alex’s Seriously pretty looking Cloudness blog with great info OCI
• Want to cook OCI / Terraform recipes, for sure check out Martin’s foggykitchen.com
• Oracle’s famous Principal Sales Consultant Guillermo’s iaasgeek.com
• The OCI Knowledge base by Ben Dali (Solutions Architect@Oracle)
• Pedro Moreno’s (Customer using the Oracle Cloud) Nikel in the Cloud Blog.

Youtube Channels:

• The official Oracle Cloud Infrastructure Channel
• Oracle Learning Library – OCI Foundation
• Oracle Learning Library – OCI Level 100 Training
• OC-Blog Youtube channel by Richard Garsthagen
• ORA Tube – Oracle Cloud PaaS [Unofficial] by John Greene
• [Unofficial] Oracle Cloud Fundamentals Training videos by Deepak Brahmbhatt
• Machine Learning with Oracle OCI by Jeroen Kloosterman
• Ramkumar Swaminathan’s OCI demo and training videos
• Vittorio’s FastCloud Channel with OCI Demo and instruction videos
• Todd’s channel recursivecodes with some great Howto OCI videos.

Ref- https://www.oc-blog.com/

Oracle Autonomous Database

 

Oracle Autonomous Database

 

Completed Database Automation

• ·        Provisioning
• ·        Scale-up and Scale-out
• ·         Tuning
• ·         Security and Patching
• ·         Fault Tolerance

 

Uses Machine Learning plus advanced and Proven Technologies.

• ·         RAC
• ·         Dataguard
• ·         Database Vault
• ·         Parallel SQL
• ·         In-Memory
• ·         Multitenant

 

Mission Critical, Simple, Low Risk, Low Cost

DEPLOYMENT OPTIONS

·         SHARED Exadata Infrastructure (Get Results Fast)

·         Dedicated Exadata Infrastructure (Rethink IT) -exclusive Hardware

Autonomous Database: SHARED Infrastructure

Primary Goals (Benefits)

Easy :-

• ·         Oracle Automates and Manages Everything.
• ·         Deployment, life cycle, software updates etc.
• ·         Customer simply chooses database compute, storage, and region.

Elastic:-

• ·         Low Minimum Size – 1 OCPU
• ·         Low Minimum time commitment – 1 hour
• ·         Automatically scales Online for true pay-per use

 

Autonomous Database: - Dedicated Infrastructure

Primary Goals (Benefits)

Provides your own Database cloud running on dedicated Exadata Infrastructure

Runs all your databases- any size, scale, or criticality.

Customizable Isolation

·         Isolates workloads using separate Exadata Machines, Virtual Machines or Container Databases.

Customizable Operational Policies

·         Control provisioning, updates, availability, and density.

Oracle Autonomous Database -What and How ?

 

1.      Provision à Rapidly and easily creates Mission-critical databases.

-         Creates Exadata (cloud Infrastructure)

-         RAC (scale-out databases)

-         Active Data Guard standby

2.      Secure -> Protects data from all external and internal threats

-         Apply security updates online,

-         Prevents admin snooping with DB Vault

-         Encrypts all data.

3.      Manage – Automates all Infrastructure and all database Maintenance

-         Patches all software online

-         Tunes settings

-         Performs all OS and SYSDBA operations

-         Diagnoses errors

4.      Protect- Recoers froms any failure without downtime

-         Autmates backup,restore,application transparent failover within cluster or to remote standby.

5.      Secure – Scales online for highest performance and lowest cost

-         Instant,automatic,online scaling of compute and storage enables true pay-per-use

-         Optimize -Optimally runs workloads without human direction.

-         Automatically optimizes,data formats ,indexes, parallelism and plans for each workload.

6.      Optimize – Optimally runs workloads without human direction

Automatically optimizes,data formats,indexes,parallelism and plans for each workload

 

 

 

Autonomous Database Dedicated -Primary Benefits

Dedicated Network Architecture

Autonomous Database -Cloud @customer Primary Benefits

Autonomous DB feature Comparison

Managing and maintaining Autonomous Database

Connecting to Autonomous Database

 

 

Autonomous Database – REST APIs

Autonomous Database -Using OCI-CLI

Autonomous Database -Using OCI-CLI Requirements

 

Autonomous Database -Auto-Index Creation is Inherently Better

Automatic Indexing

Oracle Data Safe

Security Zones of control

Autonomous Database Tools (Development Environment)

 

 

OPTIONS AND CONSIDERATIONS FOR MIGRATING TO ADB’s

Migration to Autonomous Database

Autonomous Migration Methods Overview

Autonomouns :- Database Migration Service