This post demonstrates how to apply Enterprise Manager Base Platform( EMBP) PSU patches onto OEM 13c.
The current latest OEM 13cR3( 13.3.0.0.0) PSU is “Oracle Enterprise Manager 13c Release 3 Patch Set Update 13.3.0.0.200414 for Oracle Management Service.
Read more of this content when you subscribe today.
While applying patches onto OEM 13c different components, OPatch or OMSPatcher will be used. It is the best practice to have the latest opatch and omspatcher installed before applying any patches.
This post demonstrates how to apply the latest OPatch and OMSPatcher utilities onto OEM 13cR3 ( 13.3.0.0.0 ) and OEM 13cR4 ( 13.4.0.0.0 )
As for now, the latest opatch and omspatcher version for OEM 13cR4 (13.4.0.0.0 ) are 13.9.4.2.4 and 13.9.4.1.0 respectively.
Read more of this content when you subscribe today.
Oracle Universal Installer ( OUI) is used to install/patch/upgrade Oracle software and database options.
Read more of this content when you subscribe today.
Oracle 19c GI ASM listener “ASMNET1LSNR_ASM_hostname” shows down on 13c OEM, but it is up and running actually.
[oracle@oemnode1 ~]$ emcli get_targets -targets="oracle_listener"|sort Status Status Target Type Target Name 0 Down oracle_listener ASMNET1LSNR_ASM_racnode1.virtuallab 0 Down oracle_listener ASMNET1LSNR_ASM_racnode2.virtuallab ... .. . Status Status Target Type Target Name
Read more of this content when you subscribe today.
$ emcli login -username=sysman -password=pass1234 Login successful
or
$ emcli login -username=sysman Enter password : Login successful
$ emcli logout Logout successful
$ emcli help $ emcli help login
emcli>help()
emcli>help('login')
$ emcli status Oracle Enterprise Manager 13c Release 2 EM CLI with Scripting option. ... .. .
emcli>status()
$ emcli sync Synchronized successfully
[oracle@oemnode1 ~]$ emcli get_target_types Display Target Type | Target Type | Is Composite (Y/N) ------------------------------------------------- | ------------------------------------------ | ------------------ ADF Business Components for Java | oracle_bc4j | N ASM Disk Group Component | asm_diskgroup_component | N ... .. . oracle_sdpmessagingdriver_xmpp | N ZPools | oracle_si_zpool_host | N ZPools | oracle_si_zpool_host_remote | N ZPools | oracle_si_zpool_zfssa | N webcenter_portal_app | webcenter_portal_app | N
$ emcli get_target_types -plugin=oracle.sysman.db Display Target Type | Target Type | Is Composite (Y/N) -------------------------------- | ------------------------| ------------------ ASM Disk Group Component | asm_diskgroup_component | N ASM IO Server | osm_ioserver | N ASM Proxy | osm_proxy | N Automatic Storage Management | osm_instance | N Cluster | cluster | Y Cluster ASM | osm_cluster | Y Cluster ASM Disk Group Component | casm_diskgroupcomponent | N Cluster Database | rac_database | Y Database Instance | oracle_database | N Database System | oracle_dbsys | Y Exadata Express Cloud Service | oracle_pdbexpress | N Far Sync Instance | oracle_farsync | N Global Data Services | gds_cloud | Y Global Data Services Pool | gds_pool | Y Global Service Manager | gds_gsm | N Listener | oracle_listener | N Oracle Cloud Database Service | oracle_cloud_dbcs | Y Oracle Database Service | oracle_dbservice | N Oracle High Availability Service | has | N Oracle Secure Backup Domain | osb_server | N Pluggable Database | oracle_pdb | N Schema Service | oracle_dbsvc | N
$ emcli get_target_properties -target_type="oracle_database" Comment Contact Cost Center Customer Service Identifier Department Downtime Contact Environment LifeCycle Status Line of Business Location Operating System Platform Site Target Version Target properties fetched successfully
$ emcli get_targets
[oracle@oemnode1 ~]$ emcli get_targets -targets="oracle_listener" Status Status Target Type Target Name ID 1 Up oracle_listener LISTENER_racnode2.virtuallab 1 Up oracle_listener LISTENER_SCAN3_racnode-cluster 0 Down oracle_listener ASMNET1LSNR_ASM_racnode2.virtuallab 1 Up oracle_listener LISTENER_racnode1.virtuallab 1 Up oracle_listener LISTENER_oemnode1 1 Up oracle_listener LISTENER_SCAN2_racnode-cluster 0 Down oracle_listener ASMNET1LSNR_ASM_racnode1.virtuallab 1 Up oracle_listener LISTENER_SCAN1_racnode-cluster 0 Down oracle_listener MGMTLSNR_racnode1.virtuallab
$ emcli get_unsync_alerts -target_type=host -target_name=racnide1 Total number of alerts to be synchronized = 0
$emcli create_blackout -name="DB_RAC_RACTEST_BLACKOUT" -reason="Mainteneance" -add_targets="RACTEST:rac_database" -schedule="duration:10"
$ emcli get_blackout_details -name="DB_RAC_RACTEST_BLACKOUT" Status Status ID Run Jobs Next Start Duration Reason Frequency Repeat Days Months Start Time End Time TZ Region TZ Offset Type Started 4 no 2019-12-02 14:00:20 10:00 Mainteneance once none none none 2019-12-02 03:00:20 2019-12-02 13:00:20 UTC +00:00 Blackout
$ emcli stop_blackout -name="DB_RAC_RACTEST_BLACKOUT" Blackout "DB_RAC_RACTEST_BLACKOUT" stopped successfully
$ emcli delete_blackout -name="DB_RAC_RACTEST_BLACKOUT" Blackout "DB_RAC_RACTEST_BLACKOUT" deleted successfully
$ emcli delete_target -name="racnode1:3872" -type="oracle_emd"
-delete_monitored_targets -async
Target "racnode1:3872:oracle_emd" deleted successfully
[oracle@oemnode1 ~]$ emcli list_plugins_on_agent \
-agent_names=racnode1.virtuallab:3872 -include_discovery
The Agent URL is https://racnode1.virtuallab:3872/emd/main/ -
Plug-in Name Plugin-id Version [revision]
Systems Infrastructure oracle.sysman.si 13.3.1.0.0
Oracle Home oracle.sysman.oh 13.3.0.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*
Oracle Database oracle.sysman.db 13.3.1.0.0*
Oracle Home oracle.sysman.oh 13.3.0.0.0*
Oracle Database oracle.sysman.db 13.3.1.0.0
* Indicates that the plug-in is a discovery plug-in.
[oracle@oemnode1 ~]$emcli list_plugins_on_agent -agent_names='agent,*node*'
[oracle@oemnode1 ~]$ emcli list_plugins_on_agent -all
emcli import_update -omslocal -file=p29555092_112000_Generic.zip
Transfer the downloaded file to any managed host in your environment, and run following command to import it to Enterprise Manager.
emcli import_update -host=<hostname> -file=p29555092_112000_Generic.zip <host credential options>
[oracle@oemnode1 ~]$ emcli import_update_catalog -file="/tmp/p9348486_112000_Generic.zip" -omslocal
[oracle@racnode1 ~]$ emctl listplugins agent
[oracle@oemnode1 ~]$ emcli deploy_plugin_on_server -plugin="oracle.sysman.db:13.3.2.0.0" -repo_backup_taken Enter repository DB sys password:
[oracle@oemnode1 ~]$ emcli get_plugin_deployment_status -plugin_id="oracle.sysman.db:13.3.2.0.0"
[oracle@oemnode1 ~]$ emcli deploy_plugin_on_agent \ -agent_names="racnode1.virtuallab:3872" \ -plugin="oracle.sysman.db:13.3.2.0.0" Agent side plug-in deployment is in progress Use "emcli get_plugin_deployment_status -plugin=oracle.sysman.db" to track the plug-in deployment status.
$ emctl start oms -bip_only Oracle Enterprise Manager Cloud Control 13c Release 4 Copyright (c) 1996, 2020 Oracle Corporation. All rights reserved. Starting BI Publisher Server only. Starting BI Publisher Server ... BI Publisher Server Successfully Started BI Publisher Server is Up
$ emctl status oms -bip_only Oracle Enterprise Manager Cloud Control 13c Release 4 Copyright (c) 1996, 2020 Oracle Corporation. All rights reserved. BI Publisher Server is Up
$ emctl stop oms -bip_only Oracle Enterprise Manager Cloud Control 13c Release 4 Copyright (c) 1996, 2020 Oracle Corporation. All rights reserved. Stopping BI Publisher Server... BI Publisher Server Successfully Stopped BI Publisher Server is Down
Make DBA Life Easy 