В последнее время многие клиенты переходят на новые версии БД Oracle, конкретно я имею ввиду : 12.2.0.1, 18c (aka 12.2.0.2), 19c (aka 12.2.0.3). При этом столкнулся с ситуацией, когда Oracle Cloud Control 13cR2, не может продолжать штатный мониторинг обновленный базы. База постоянно "висит" в статусе "Metric Evaluation Error", либо "Availability Evaluation Error".
Причина и решение описаны в данном документе: 2507084.1.
Причина:
Incompatible combination
With 13.2.1.0.0 db plugin we cannot monitor 18C database.
Решение:
To monitor 18C DB as a Managed Target in 13.2.0.0.0 EM version, we need to have the latest DB plugin-in 13.2.2.0 to deployed on oms & agent servers.
For more details about certification combination please refer 406906.1
Шаги по обновлению DB Plug-in 13.2.1 --- 13.2.2:
1. Backup OMS database.
2. Backup OMS Application.
3. Connect and sync:
cd /u01/app/oracle/middleware/bin
./emcli login -username=sysman
./emcli sync
+++
Synchronized successfully
+++
4. Import Catalog:
Login to OMS as SYSMAN:
Setup -> Provisioning and Patching -> Offline Patching -> select Offline
Setup -> Extensibility -> Self Update -> click on "Plug-in" and then "Check for Updates" button
Downloaded following file: https://updates.oracle.com/Orion/Download/download_patch/p9348486_112000_Generic.zip
Import the catalog file to Enterprise Manager:
./emcli import_update_catalog -file=/home/oracle/dba/patches/p9348486_112000_Generic.zip -omslocal
+++++
Successfully uploaded the Self Update catalog to Enterprise Manager. Use the Self Update Console to view and manage updates.
Time taken for import catalog is 01:50.247.
+++++
5. Import updated plug-ins:
Login to OMS as SYSMAN:
Setup -> Extensibility -> Self Update -> Plug-in -> Search Description "Oracle Database" -> Choose 13.2.2.0 -> Download
./emcli import_update -omslocal -file=/home/oracle/dba/patches/p25602622_112000_Generic.zip
+++++
Processing update: Plug-in - Enterprise Manager for Oracle Database provides comprehensive management for Oracle Database and related targets such as Real Application Cluster, Automatic Storage Management (ASM) etc.
Successfully uploaded the update to Enterprise Manager. Use the Self Update Console to manage this update.
+++++
6. Deploy new plug-in
Setup -> Extensibility -> Plug-in -> "Databases" folder -> Mark "Oracle Database" -> Deploy On "Management Servers" -> Next
-> Next -> "Have you backed up the repository and configuration of first management server?" and click Next -> Deploy
Monitor deployment in following way:
./emctl status oms -details
7. Check new plug-in version installed on OMS:
./emcli login -username=sysman
./emcli list_plugins_on_server
+++++
...
Plug-in Name Plugin-id Version [revision]
Oracle Cloud Framework oracle.sysman.cfw 13.2.1.0.0
Oracle Database oracle.sysman.db 13.2.2.0.0 <======= New DB Plugin Version
Oracle Fusion Middleware oracle.sysman.emas 13.2.1.0.0
Systems Infrastructure oracle.sysman.si 13.2.1.0.0
Oracle Exadata oracle.sysman.xa 13.2.1.0.0
+++++
8. Agent Plug-in update:
Setup -> Extensibility -> Plug-in -> "Databases" folder -> Mark "Oracle Database" -> Deploy On "Management Agent" -> Continue
-> Choose list of server where Agent needs to be updates and then click "Continue" -> Next -> Deploy
9. Check Agent DB Plug-in new version:
./emctl listplugins agent -type all
+++++
Oracle Enterprise Manager Cloud Control 13c Release 2
Copyright (c) 1996, 2016 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
oracle.sysman.oh 13.2.0.0.0 /u01/app/middleware/agent/agent_13.2.0.0.0/plugins/oracle.sysman.oh.agent.plugin_13.2.0.0.0
oracle.sysman.si 13.2.1.0.0 /u01/app/middleware/agent/agent_13.2.0.0.0/plugins/oracle.sysman.si.agent.plugin_13.2.1.0.0
oracle.sysman.db 13.2.2.0.0 /u01/app/middleware/agent/agent_13.2.0.0.0/plugins/oracle.sysman.db.agent.plugin_13.2.2.0.0 <======== New DB Plugin Version
oracle.sysman.xa 13.2.1.0.0 /u01/app/middleware/agent/agent_13.2.0.0.0/plugins/oracle.sysman.xa.discovery.plugin_13.2.1.0.0
oracle.sysman.emas 13.2.1.0.0 /u01/app/middleware/agent/agent_13.2.0.0.0/plugins/oracle.sysman.emas.discovery.plugin_13.2.1.0.0
oracle.sysman.si 13.2.1.0.0 /u01/app/middleware/agent/agent_13.2.0.0.0/plugins/oracle.sysman.si.discovery.plugin_13.2.1.0.0
oracle.sysman.oh 13.2.0.0.0 /u01/app/middleware/agent/agent_13.2.0.0.0/plugins/oracle.sysman.oh.discovery.plugin_13.2.0.0.0
oracle.sysman.db 13.2.2.0.0 /u01/app/middleware/agent/agent_13.2.0.0.0/plugins/oracle.sysman.db.discovery.plugin_13.2.2.0.0 <======== New DB Plugin Version
+++++
Источники:
2507084.1
https://docs.oracle.com/cd/E73210_01/EMADM/GUID-ECA444F6-88B3-436D-8B96-F65581AD2E2E.htm#GUID-5DF33C50-59DD-4187-B769-D66E886EC1BB