Dataguard : Controlling PDB Replication in Data Guard Environments

 

 

With the wider adoption of Oracle container databases and the impending de-support of non-container database coming with Oracle Database 20c, it is well worth considering how this will impact your standby databases and Disaster Recovery (DR) environments.
The good news is that overall, the principle of standby databases has not changed significantly but there are a few key points that need to be understood to manage standby databases in the multi-tenant architecture effectively. There also a few new features that will help with standby database management.

First, let's consider that all Pluggable databases in a container share the same instance components

Background Processes
Shared and Process memory (SGA/PGA)

Online and archive redo logs

So, bearing those in mind, how do we protect a pluggable database (PDB) with a Standby database? For the most part, as we did before with a few key clarifications:

The database role is defined at the container level; Individual pluggable databases (PDBs) do not have their own roles.
The database role is changed by issuing DDL at the container level; all PDB's change at the same time.
ALTER DATABASE RECOVER MANAGED STANDBY functions only in the root container; it is not allowed in a PDB.
The ALTER PLUGGABLE DATABASE [OPEN|CLOSE] SQL statement is supported on the standby, provided you have already opened the root container.
The ALTER PLUGGABLE DATABASE RECOVER statement is not supported on the standby. (Standby recovery is always at the CDB level.)
 A Standby container database does not have to have standby PDB's for all PDB's in the primary container.
 
 
 
 
 
 
 
 
 
 
Create Standby Container

Let's walk through a quick example. Once we have our primary container setup with the PDB's we can start thinking about setting up a standby container database.

When using Multi-tenant, the standby is setup at the container level and then all PDB's are protected if you choose them to be. So first we need to set up the CDB with a standby, mostly as we did with non CDB:

--> Enable Force Logging Mode
--> Configure the Primary Database to Receive Redo Data
--> Set Primary Database Initialization Parameters (log_archive_dest_2 etc)
--> Enable Archiving
--> Create a Backup Copy of the Primary Database Data Files
--> Create a Control File for the Standby Database
--> Create a Parameter File for the Standby Database
--> Copy Files from the Primary System to the Standby System
--> Set Up the Environment to Support the Standby Database
--> Copy password file to standby Oracle Home
--> Configure and start new Container listener
--> Update tnsnames on both nodes & verify connectivity:
        --> From Primary node: sqlplus sys@CDB2 as sysdba
        --> From Standby node: sqlplus sys@CDB1 as sysdba


DB creation method
For Non CDB
dbca -silent -createDuplicateDB -gdbName cdb2 -primaryDBConnectionString 192.168.45.101:1521/cdb1 -sid cdb1 -createAsStandby -dbUniqueName cdb2

For CDB databases


--> Start the Physical Standby Database (nomount)

    > Restore the backup
    > rman target /
    > restore standby controlfile from '/Location.ctl';
    > alter database mount;
    > restore database;


--> sqlplus / as sysdba

    Start Standby log apply    
        ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
    Verify the Physical Standby Database Is Performing Properly
        SELECT ROLE, THREAD#, SEQUENCE#, ACTION FROM V$DATAGUARD_PROCESS;
    Verify PDB Status
    So now we have a standby container DB let's check on the PDB's

    set lines 100
    column name format a20
    SELECT name, open_mode FROM v$pdbs;
    
    NAME                 OPEN_MODE
    -------------------- ----------
    PDB$SEED             MOUNTED
    PDB1                 MOUNTED

    PDB2                 MOUNTED         

    PDB3                 MOUNTED 

    PDB4                 MOUNTED

  

  SQL> SELECT DB_UNIQUE_NAME, OPEN_MODE, DATABASE_ROLE from v$database;

    DB_UNIQUE_NAME                 OPEN_MODE            DATABASE_ROLE
    ------------------------------ -------------------- ----------------
    CDB2                         MOUNTED              PHYSICAL STANDBY


    SELECT name, open_mode FROM v$pdbs;

    NAME                  OPEN_MODE
    --------------------  ----------
    PDB$SEED              READ ONLY
    PDB1                  MOUNTED

    PDB2                  MOUNTED

    PDB3                  MOUNTED

   

    

Note that the PDB Name matches the primary PDB Name (PDB1)

. Adding additional PDB's

Given the fact the role is set at the container level, we cannot add a distinct PDB to the standby container without it already having an associated Primary PDB in the Primary CDB. When we add a Primary PDB, we can select at that point whether it is protected by a standby or not. Note that we can also add/remove the standby out with this operation as indeed we did above.

Adding a new PDB to the primary container with a standby (seed)
This can be done in one step by either creating a new database or cloning from an existing PDB

SQL > CREATE PLUGGABLE DATABASE TESTPDB2 ADMIN USER PDMADMIN IDENTIFIED BY ******* STANDBYS=('CDB2');

This is great as it creates a new PDB (Based on the seed database) and also creates a standby database in the standby container

Adding a new PDB to the primary container with a standby (Clone)
SQL> CREATE PLUGGABLE DATABASE TESTPDB3 FROM PDB1 STANDBYS=('CDB2');

Again, we get a new Primary and standby in one statement very cool!

Switchover between Primary and Standby
We do not do this very often but when building a new database, it is a good idea to switch over the roles to ensure that the archivelogs can be sent and applied between the DR and primary sites. As mentioned earlier, this is done at the container database level, and all PDB's are switched.

Verify that the primary database can be switched to the standby role.
PRIMARY CDB
ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;
STARTUP MOUNT;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;


--> NEW PRIMARY (CDB2)

ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN;
ALTER DATABASE OPEN;
ALTER PLUGGABLE DATABASE ALL OPEN;

Switch Back using the same process as above.

Convert to snapshot standby
Snapshot standby is a really great feature of Dataguard and can be used for reporting databases, DR tests, production destructive testing, etc so let’s make sure it still works in 19c! Again, this is done at the Container level with all PDB's affected.

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
ALTER DATABASE CONVERT TO SNAPSHOT STANDBY;
ALTER DATABASE OPEN;

So, all in all, yes it works largely the same way except that it is all done at container level so all PDB's are converted to snapshot standby at the same time. 

 

 

--> For Specifice pluggable database  :

STANDBYS Clause (12.1.0.2)
The STANDBYS clause of the CREATE PLUGGABLE DATABASE statement was introduced in 12.1.0.2 to allow us to indicate which standby databases should protect the new PDB being created. The syntax is as follows.

CREATE PLUGGABLE DATABASE ... STANDBYS={('cdb_name', 'cdb_name', ...) | NONE | ALL [EXCEPT ('cdb_name', 'cdb_name', ...)]}
Here are some examples of the usage.

STANDBYS clause omitted : The pluggable database is protected by all standby databases.
STANDBYS=NONE : The pluggable database is not protected on any of the standby databases.
STANDBYS=ALL : The pluggable database is protected on all of the standby databases.
STANDBYS=ALL EXCEPT ('cdb1_stby_1','cdb1_stby_2') : The pluggable database is protected by all standby databases, except those with a DB_UNIQUE_NAME of 'cdb1_stby_1' and 'cdb1_stby_2'.
STANDBYS=('cdb1_stby_1') : The pluggable database is only protected by the standby database with a DB_UNIQUE_NAME of 'cdb1_stby_1'.
Create a new pluggable database on the primary database, which won't be protected by any standby database

--> Create a new pluggable database on the primary database, which won't be protected by any standby database

-- Primary
CREATE PLUGGABLE DATABASE pdb2  ADMIN USER pdb_admin IDENTIFIED BY Password1  STANDBYS=NONE;
ALTER PLUGGABLE DATABASE pdb2 OPEN;

-- Primary
COLUMN name FORMAT a30
SELECT name, open_mode, recovery_status FROM   v$pdbs ORDER BY 1;

NAME                           OPEN_MODE  RECOVERY
------------------------------ ---------- --------
PDB$SEED                       READ ONLY  ENABLED
PDB1                           READ WRITE ENABLED
PDB2                           READ WRITE ENABLED

-- Standby
COLUMN name FORMAT A30
SELECT name, open_mode, recovery_status FROM   v$pdbs ORDER BY 1;

NAME                           OPEN_MODE  RECOVERY
------------------------------ ---------- --------
PDB$SEED                       MOUNTED    ENABLED
PDB1                           MOUNTED    ENABLED
PDB2                           MOUNTED    DISABLED


We only have a single standby database, so we could achieve the same result by excluding it using the DB_UNIQUE_NAME along with ALL EXCEPT as shown below.

-- Primary

-- Remove the PDB.
ALTER PLUGGABLE DATABASE pdb2 CLOSE;
DROP PLUGGABLE DATABASE pdb2 INCLUDING DATAFILES;

-- Recreate it using ALL ACCEPT.
CREATE PLUGGABLE DATABASE pdb2  ADMIN USER pdb_admin IDENTIFIED BY Password1  STANDBYS=ALL EXCEPT ('cdb2');
ALTER PLUGGABLE DATABASE pdb2 OPEN;


-- Primary
-- Remove the PDB.
ALTER PLUGGABLE DATABASE pdb2 CLOSE;
DROP PLUGGABLE DATABASE pdb2 INCLUDING DATAFILES;

-- Recreate it with one of these.
CREATE PLUGGABLE DATABASE pdb2  ADMIN USER pdb_admin IDENTIFIED BY Password1;

CREATE PLUGGABLE DATABASE pdb2  ADMIN USER pdb_admin IDENTIFIED BY Password1  STANDBYS=ALL;

CREATE PLUGGABLE DATABASE pdb2  ADMIN USER pdb_admin IDENTIFIED BY Password1  STANDBYS=('cdb2');

-- Open it.
ALTER PLUGGABLE DATABASE pdb2 OPEN;

--> Remove the new PDB before trying the examples in the following section.

ENABLED_PDBS_ON_STANDBY Parameter (12.2)

The ENABLED_PDBS_ON_STANDBY initialisation parameter was introduced in this form in 12.2 to control which pluggable databases are protected by a specific standby database. The parameter can be set on a primary or standby database, but it is only used by standby databases. Here are some examples of how the parameter might be used with wildcard and exclusions.

"*" : All PDBs are protected.
"PDB1", "PDB2" : Only pluggable databases called "PDB1" and "PDB2" are protected.
"PDB*" : Only pluggable databases with a name beginning with "PDB" are protected.
"*", "-PDB*" : All pluggable databases are protected, except those with a name beginning with "PDB".
"*", "-PDB1" : All pluggable databases are protected, except if the name is "PDB1".
On the standby database we issue the following command to prevent a pluggable database called PDB2 from being replicated to the standby database. All other PDBs will be protected as normal.

--> Standby
ALTER SYSTEM SET enabled_pdbs_on_standby="*", "-PDB2";
On primary database create pluggable databases called PDB2 and PDB3.

--> Primary
CREATE PLUGGABLE DATABASE pdb2   ADMIN USER pdb_admin IDENTIFIED BY Password1;
ALTER PLUGGABLE DATABASE pdb2 OPEN;

CREATE PLUGGABLE DATABASE pdb3   ADMIN USER pdb_admin IDENTIFIED BY Password1;
ALTER PLUGGABLE DATABASE pdb3 OPEN;

status of the pluggable databases on both the primary and standby databases.

--> Primary
COLUMN name FORMAT A30

SELECT name, open_mode, recovery_status
FROM   v$pdbs
ORDER BY 1;

NAME                           OPEN_MODE  RECOVERY
------------------------------ ---------- --------
PDB$SEED                       READ ONLY  ENABLED
PDB1                           READ WRITE ENABLED
PDB2                           READ WRITE ENABLED
PDB3                           READ WRITE ENABLED

SQL>


--> Standby
COLUMN name FORMAT A30

SELECT name, open_mode, recovery_status
FROM   v$pdbs
ORDER BY 1;

NAME                           OPEN_MODE  RECOVERY
------------------------------ ---------- --------
PDB$SEED                       MOUNTED    ENABLED
PDB1                           MOUNTED    ENABLED
PDB2                           MOUNTED    DISABLED
PDB3                           MOUNTED    ENABLED

SQL>
As expected, the pluggable database called PDB2 is not protected by the standby database.

To clean up, remove the new pluggable databases and reset the ENABLED_PDBS_ON_STANDBY parameter on the standby database.

-- Primary
ALTER PLUGGABLE DATABASE pdb2 CLOSE;
DROP PLUGGABLE DATABASE pdb2 INCLUDING DATAFILES;
ALTER PLUGGABLE DATABASE pdb3 CLOSE;
DROP PLUGGABLE DATABASE pdb3 INCLUDING DATAFILES;

-- Standby
ALTER SYSTEM SET enabled_pdbs_on_standby="*";

Key Differences in 19c

The process of flashing back a physical standby to a point in time that was captured on the primary is simplified by automatically replicating restore points from primary to the standby. See Replicating Restore Points from Primary to Standby.
When flashback or point-in-time recovery is performed on the primary database, a standby that is in mounted mode can automatically follow the same recovery procedure performed on the primary.
DML operations can be performed on Active Data Guard standby instances by transparently redirected to and run on the primary database.
Changes in Oracle Database Release 18c
These are the changes in Oracle Data Guard Concepts and Administration for Changes in Oracle Database Release 18c, Version 18.1.

The database buffer cache state is now maintained on an Oracle Active Data Guard standby during a role change
Global temporary tables can now be dynamically created on an Oracle Active Data Guard standby database
A new view V$DATAGUARD_PROCESS (which replaces V$MANAGED_STANDBY) provides information that can be queried to verify that redo is being transmitted from the primary database and applied to the standby database.
Database nologging has been extended with two new modes: Standby Nologging for Load Performance and Standby Nologging for Data Availability.
A standby database can now be refreshed over the network using one RMAN command, RECOVER STANDBY DATABASE.

Oracle Enterprise Manager 13c Release 4 Update 6 (13.4.0.6) - Patching OMS

 


Note: This blog post describes how to apply the RU on an Oracle Enterprise Manager 13 Release 4 Oracle Management Server which is running on an Oracle Linux 7.6 machine. Applying the RU for agents is not part of of this blog post. For agent patching please visit readme of Patch 31767864: Oracle Enterprise Manager 13c Release 4 Platform Update 5 (13.4.0.6) for Oracle Management Agent.

The RU for the Oracle Management Server is generic and the compressed patch file has the size of 985.6 MB. Useful links for this Release Update like contained fixes and improvements:

Patch 31767864: Oracle Enterprise Manager 13c Release 4 Update 6 (13.4.0.6) for Oracle Management Service
Enterprise Manager 13.4 Master Release Update List (Includes Plug-ins) (Doc ID 2647078.1)
blogs.oracle.com – Oracle Enterprise Manager 13c Release 4 Update 6 (13.4.0.6) Is Now Available!

OMSPatcher Prerequisites
OMSPatcher has to be version 13.9.4.1.0 for Enterprise Manager 13.4.0.0.0 – let’s verify it on my OEM environment:

$ export ORACLE_HOME=/opt/app/oracle/middleware_134/

[oracle@localhost31767864]$ $ORACLE_HOME/OMSPatcher/omspatcher version
OMSPatcher Version: 13.9.4.2.0
OPlan Version: 12.2.0.1.16
OsysModel build: Thu Oct 25 18:18:12 PDT 2018

OMSPatcher succeeded.
[oracle@localhost31767864]$



Transfer and extract Release Update
The RU is extracted in the stage directory on the OEM server:

[oracle@localhost31767864]$ ls /tmp/.zip
/tmp/p19999993_134000_Generic.zip  
/tmp/p31767864_134000_Generic.zip
[oracle@localhost31767864]$




Pre-Check
Run the pre-check to analyze the existing Oracle Enterprise Manager system.

$ cd /u01/app/oracle/stage/31767864
[oracle@localhost 31767864]$ $ORACLE_HOME/OMSPatcher/omspatcher apply -analyze
OMSPatcher Automation Tool
Copyright (c) 2017, Oracle Corporation.  All rights reserved.


OMSPatcher version : 13.9.4.2.0
OUI version        : 13.9.4.0.0
Running from       : /opt/app/oracle/middleware_134
Log file location  : /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/opatch2020-09-25_05-18-02AM_1.log

OMSPatcher log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/31767864/omspatcher_2020-09-25_05-18-11AM_analyze.log

Please enter OMS weblogic admin server URL(t3s://localhost.localdomain.com:7102):>
Please enter OMS weblogic admin server username(weblogic):> weblogic
Please enter OMS weblogic admin server password:>




Configuration Validation: Success


Running apply prerequisite checks for sub-patch(es) "31661036,30851102,31661078,31661173,31661020,31661186,31661089,31812958,31661157,31661124,31661194,31661066,31187567" and Oracle Home "/opt/app/oracle/middleware_134"...
Sub-patch(es) "31661036,30851102,31661078,31661173,31661020,31661186,31661089,31812958,31661157,31661124,31661194,31661066,31187567" are successfully analyzed for Oracle Home "/opt/app/oracle/middleware_134"


Complete Summary
================


All log file names referenced below can be accessed from the directory "/opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-18-02AM_SystemPatch_31767864_1"

Prerequisites analysis summary:
-------------------------------

The following sub-patch(es) are applicable:

             Featureset                                                                                                            Sub-patches                                                                                                                                                 Log file
             ----------                                                                                                            -----------                                                                                                                                                 --------
  oracle.sysman.top.oms   31661036,30851102,31661078,31661173,31661020,31661186,31661089,31812958,31661157,31661124,31661194,31661066,31187567   31661036,30851102,31661078,31661173,31661020,31661186,31661089,31812958,31661157,31661124,31661194,31661066,31187567_opatch2020-09-25_05-18-09AM_1.log



Log file location: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/31767864/omspatcher_2020-09-25_05-18-11AM_analyze.log

OMSPatcher succeeded.
[oracle@localhost 31767864]$


[oracle@localhost 31767864]$ $ORACLE_HOME/bin/emcli login -username=sysman
Enter password

Login successful
[oracle@localhost 31767864]$ $ORACLE_HOME/bin/emcli sync
Synchronized successfully
[oracle@localhost 31767864]$







[oracle@localhost 31767864]$ $ORACLE_HOME/bin/emcli list_plugins_on_server
OMS name is localhost.localdomain.com:4889_Management_Service
Plug-in Name                                 Plugin-id                     Version [revision]

Apache Tomcat                                oracle.em.satc                13.2.1.0.0
Oracle Audit Vault and Database Firewall     oracle.em.savf                13.4.1.0.0
Microsoft Active Directory                   oracle.em.smad                13.1.1.0.0
Microsoft IIS                                oracle.em.smis                13.1.1.0.0
Zero Data Loss Recovery Appliance            oracle.sysman.am              13.4.1.0.0
Oracle Big Data Appliance                    oracle.sysman.bda             13.4.1.0.0
Oracle Cloud Framework                       oracle.sysman.cfw             13.4.1.0.0
Cloud Services Management                    oracle.sysman.csm             13.4.1.0.0
Oracle Database                              oracle.sysman.db              13.4.1.0.0
Oracle Fusion Middleware                     oracle.sysman.emas            13.4.1.0.0
Oracle Consolidation Planning and Chargeback oracle.sysman.emct            13.4.1.0.0
Oracle Fusion Applications                   oracle.sysman.emfa            13.4.1.0.0
Oracle Siebel                                oracle.sysman.empa            13.4.1.0.0
Oracle ORAchk Healthchecks                   oracle.sysman.orhc            13.4.1.0.0
Systems Infrastructure                       oracle.sysman.si              13.4.1.0.0
Oracle Storage Management Framework          oracle.sysman.smf             13.4.1.0.0
Oracle Cloud Application                     oracle.sysman.ssa             13.4.1.0.0
Oracle Virtual Infrastructure                oracle.sysman.vi              13.4.1.0.0
Oracle Virtualization                        oracle.sysman.vt              13.4.1.0.0
Oracle Exadata                               oracle.sysman.xa              13.4.1.0.0

[oracle@localhost 31767864]$




[oracle@localhost 31767864]$ $ORACLE_HOME/bin/emctl stop oms
Oracle Enterprise Manager Cloud Control 13c Release 4
Copyright (c) 1996, 2020 Oracle Corporation.  All rights reserved.
Stopping Oracle Management Server...
Oracle Management Server Successfully Stopped
Oracle Management Server is Down
JVMD Engine is Down

[oracle@localhost 31767864]$ $ORACLE_HOME/OMSPatcher/omspatcher apply
OMSPatcher Automation Tool
Copyright (c) 2017, Oracle Corporation.  All rights reserved.


OMSPatcher version : 13.9.4.2.0
OUI version        : 13.9.4.0.0
Running from       : /opt/app/oracle/middleware_134
Log file location  : /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/opatch2020-09-25_05-34-17AM_1.log

OMSPatcher log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/31767864/omspatcher_2020-09-25_05-34-25AM_deploy.log

Please enter OMS weblogic admin server URL(t3s://localhost.localdomain.com:7102):>
Please enter OMS weblogic admin server username(weblogic):>
Please enter OMS weblogic admin server password:>



Configuration Validation: Success


Running apply prerequisite checks for sub-patch(es) "31661036,30851102,31661078,31661173,31661020,31661186,31661089,31812958,31661157,31661124,31661194,31661066,31187567" and Oracle Home "/opt/app/oracle/middleware_134"...
Sub-patch(es) "31661036,30851102,31661078,31661173,31661020,31661186,31661089,31812958,31661157,31661124,31661194,31661066,31187567" are successfully analyzed for Oracle Home "/opt/app/oracle/middleware_134"

To continue, OMSPatcher will do the following:
[Patch and deploy artifacts]   : Apply sub-patch(es) [ 30851102 31187567 31661020 31661036 31661066 31661078 31661089 31661124 31661157 31661173 31661186 31661194 31812958 ]
                                 Apply RCU artifact with patch "/opt/app/oracle/middleware_134/.omspatcher_storage/31661020_Sep_8_2020_04_05_17/original_patch";
                                 Apply RCU artifact with patch "/opt/app/oracle/middleware_134/.omspatcher_storage/31661186_Sep_8_2020_04_34_27/original_patch";
                                 Apply RCU artifact with patch "/opt/app/oracle/middleware_134/.omspatcher_storage/31661124_Sep_8_2020_04_34_31/original_patch";
                                 Apply RCU artifact with patch "/opt/app/oracle/middleware_134/.omspatcher_storage/31661089_Sep_8_2020_04_34_33/original_patch";
                                 Apply RCU artifact with patch "/opt/app/oracle/middleware_134/.omspatcher_storage/30851102_Mar_31_2020_23_23_05/original_patch";
                                 Apply RCU artifact with patch "/opt/app/oracle/middleware_134/.omspatcher_storage/31661036_Sep_8_2020_04_34_39/original_patch";
                                 Apply RCU artifact with patch "/opt/app/oracle/middleware_134/.omspatcher_storage/31187567_May_25_2020_02_46_02/original_patch";
                                 Apply RCU artifact with patch "/opt/app/oracle/middleware_134/.omspatcher_storage/31661157_Sep_8_2020_04_34_53/original_patch";
                                 Apply RCU artifact with patch "/opt/app/oracle/middleware_134/.omspatcher_storage/31661194_Sep_8_2020_04_35_23/original_patch";
                                 Apply RCU artifact with patch "/opt/app/oracle/middleware_134/.omspatcher_storage/31661066_Sep_8_2020_04_36_14/original_patch";
                                 Apply RCU artifact with patch "/opt/app/oracle/middleware_134/.omspatcher_storage/31661173_Sep_8_2020_04_35_00/original_patch";
                                 Apply RCU artifact with patch "/opt/app/oracle/middleware_134/.omspatcher_storage/31661078_Sep_8_2020_04_35_35/original_patch";
                                 Apply RCU artifact with patch "/opt/app/oracle/middleware_134/.omspatcher_storage/31812958_Sep_8_2020_04_35_38/original_patch";
                                 Register MRS artifact "commands";
                                 Register MRS artifact "procedures";
                                 Register MRS artifact "swlib";
                                 Register MRS artifact "targetType";
                                 Register MRS artifact "storeTargetType";
                                 Register MRS artifact "default_collection";
                                 Register MRS artifact "omsPropertyDef";
                                 Register MRS artifact "jobTypes";
                                 Register MRS artifact "systemStencil";
                                 Register MRS artifact "gccompliance";
                                 Register MRS artifact "discovery";
                                 Register MRS artifact "OutOfBoxRole";
                                 Register MRS artifact "SecurityClassManager";
                                 Register MRS artifact "CredstoreMetadata";
                                 Register MRS artifact "assoc";
                                 Register MRS artifact "EcmMetadataOnlyRegistration";
                                 Register MRS artifact "derivedAssocs"


Do you want to proceed? [y|n]
y
User Responded with: Y

Applying sub-patch(es) "30851102,31187567,31661020,31661036,31661066,31661078,31661089,31661124,31661157,31661173,31661186,31661194,31812958"
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/opatch/opatch2020-09-25_05-34-24AM_1.log

/*

Updating repository with RCU reference file "/opt/app/oracle/middleware_134/.omspatcher_storage/31661020_Sep_8_2020_04_05_17/original_patch"

Updating repository with RCU reference file "/opt/app/oracle/middleware_134/.omspatcher_storage/31661186_Sep_8_2020_04_34_27/original_patch" for plugin home "/opt/app/oracle/middleware_134/plugins/oracle.sysman.vt.oms.plugin_13.4.1.0.0"

Updating repository with RCU reference file "/opt/app/oracle/middleware_134/.omspatcher_storage/31661124_Sep_8_2020_04_34_31/original_patch" for plugin home "/opt/app/oracle/middleware_134/plugins/oracle.sysman.emct.oms.plugin_13.4.1.0.0"

Updating repository with RCU reference file "/opt/app/oracle/middleware_134/.omspatcher_storage/31661089_Sep_8_2020_04_34_33/original_patch" for plugin home "/opt/app/oracle/middleware_134/plugins/oracle.sysman.am.oms.plugin_13.4.1.0.0"

Updating repository with RCU reference file "/opt/app/oracle/middleware_134/.omspatcher_storage/30851102_Mar_31_2020_23_23_05/original_patch" for plugin home "/opt/app/oracle/middleware_134/plugins/oracle.sysman.vi.oms.plugin_13.4.1.0.0"

Updating repository with RCU reference file "/opt/app/oracle/middleware_134/.omspatcher_storage/31661036_Sep_8_2020_04_34_39/original_patch" for plugin home "/opt/app/oracle/middleware_134/plugins/oracle.sysman.emas.oms.plugin_13.4.1.0.0"

Updating repository with RCU reference file "/opt/app/oracle/middleware_134/.omspatcher_storage/31187567_May_25_2020_02_46_02/original_patch" for plugin home "/opt/app/oracle/middleware_134/plugins/oracle.sysman.bda.oms.plugin_13.4.1.0.0"

Updating repository with RCU reference file "/opt/app/oracle/middleware_134/.omspatcher_storage/31661157_Sep_8_2020_04_34_53/original_patch" for plugin home "/opt/app/oracle/middleware_134/plugins/oracle.sysman.xa.oms.plugin_13.4.1.0.0"

Updating repository with RCU reference file "/opt/app/oracle/middleware_134/.omspatcher_storage/31661194_Sep_8_2020_04_35_23/original_patch" for plugin home "/opt/app/oracle/middleware_134/plugins/oracle.sysman.si.oms.plugin_13.4.1.0.0"

Updating repository with RCU reference file "/opt/app/oracle/middleware_134/.omspatcher_storage/31661066_Sep_8_2020_04_36_14/original_patch" for plugin home "/opt/app/oracle/middleware_134/plugins/oracle.sysman.db.oms.plugin_13.4.1.0.0"

Updating repository with RCU reference file "/opt/app/oracle/middleware_134/.omspatcher_storage/31661173_Sep_8_2020_04_35_00/original_patch" for plugin home "/opt/app/oracle/middleware_134/plugins/oracle.sysman.ssa.oms.plugin_13.4.1.0.0"

Updating repository with RCU reference file "/opt/app/oracle/middleware_134/.omspatcher_storage/31661078_Sep_8_2020_04_35_35/original_patch" for plugin home "/opt/app/oracle/middleware_134/plugins/oracle.sysman.emfa.oms.plugin_13.4.1.0.0"

Updating repository with RCU reference file "/opt/app/oracle/middleware_134/.omspatcher_storage/31812958_Sep_8_2020_04_35_38/original_patch" for plugin home "/opt/app/oracle/middleware_134/plugins/oracle.sysman.cfw.oms.plugin_13.4.1.0.0"

Registering service "commands" with register file "/opt/app/oracle/middleware_134/sysman/metadata/commands/swlib_commands.xml" for plugin id as "core"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_commands_2020-09-25_06-05-50AM.log


Registering service "commands" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.vt.oms.plugin_13.4.1.0.0/metadata/commands/commands.xml" for plugin id as "oracle.sysman.vt"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_commands_2020-09-25_06-05-58AM.log


Registering service "commands" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.db.oms.plugin_13.4.1.0.0/metadata/commands/commands.xml" for plugin id as "oracle.sysman.db"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_commands_2020-09-25_06-06-06AM.log


Registering service "procedures" with register file "/opt/app/oracle/middleware_134/sysman/metadata/procedures/internalsdk/PatchOracleHome.xml" for plugin id as "core"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_procedures_2020-09-25_06-06-14AM.log


Registering service "procedures" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.am.oms.plugin_13.4.1.0.0/metadata/procedures/AmCopyToTapeJob.xml" for plugin id as "oracle.sysman.am"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_procedures_2020-09-25_06-06-22AM.log


Registering service "procedures" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.xa.oms.plugin_13.4.1.0.0/metadata/procedures/ExaAnalyticsExport.xml" for plugin id as "oracle.sysman.xa"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_procedures_2020-09-25_06-06-31AM.log


Registering service "procedures" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.db.oms.plugin_13.4.1.0.0/metadata/procedures/MigrateSIDBToGoldImageOH.xml" for plugin id as "oracle.sysman.db"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_procedures_2020-09-25_06-06-40AM.log


Registering service "procedures" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.ssa.oms.plugin_13.4.1.0.0/metadata/procedures/DBAASDP.xml" for plugin id as "oracle.sysman.ssa"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_procedures_2020-09-25_06-06-57AM.log


Registering service "swlib" with register file "/opt/app/oracle/middleware_134/sysman/metadata/swlib/multioms" for plugin id as "core"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_swlib_2020-09-25_06-07-06AM.log


Registering service "swlib" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.db.oms.plugin_13.4.1.0.0/metadata/swlib/dbconsolidation" for plugin id as "oracle.sysman.db"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_swlib_2020-09-25_06-07-20AM.log


Registering service "targetType" with register file "/opt/app/oracle/middleware_134/sysman/metadata/targetType/oldVersions/host/13.4.0.v/13.4.0.5/host.xml" for plugin id as "core"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_targetType_2020-09-25_06-07-41AM.log


Registering service "targetType" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.vt.oms.plugin_13.4.1.0.0/metadata/targetType/oracle_vcamachine.xml" for plugin id as "oracle.sysman.vt"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_targetType_2020-09-25_06-08-28AM.log


Registering service "targetType" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.am.oms.plugin_13.4.1.0.0/metadata/targetType/oracle_dblra.xml" for plugin id as "oracle.sysman.am"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_targetType_2020-09-25_06-08-36AM.log


Registering service "targetType" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.emas.oms.plugin_13.4.1.0.0/metadata/targetType/oracle_coherence_node.xml" for plugin id as "oracle.sysman.emas"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_targetType_2020-09-25_06-08-46AM.log


Registering service "targetType" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.xa.oms.plugin_13.4.1.0.0/metadata/targetType/oracle_exadata.xml" for plugin id as "oracle.sysman.xa"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_targetType_2020-09-25_06-09-06AM.log


Registering service "targetType" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.si.oms.plugin_13.4.1.0.0/metadata/targetType/virtualization/oracle_si_virtual_platform_map.xml" for plugin id as "oracle.sysman.si"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_targetType_2020-09-25_06-09-22AM.log


Registering service "targetType" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.si.oms.plugin_13.4.1.0.0/metadata/targetType/pdu_hw/oracle_si_pdu.xml" for plugin id as "oracle.sysman.si"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_targetType_2020-09-25_06-10-09AM.log


Registering service "targetType" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.db.oms.plugin_13.4.1.0.0/metadata/targetType/cluster.xml" for plugin id as "oracle.sysman.db"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_targetType_2020-09-25_06-11-29AM.log


Registering service "targetType" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.emfa.oms.plugin_13.4.1.0.0/metadata/targetType/fusion_apps_pf_common.xml" for plugin id as "oracle.sysman.emfa"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_targetType_2020-09-25_06-18-10AM.log


Registering service "storeTargetType" with register file "/opt/app/oracle/middleware_134/sysman/builtinplugins/oracle.sysman.emrep/metadata/targetType/oracle_emrep.xml" for plugin id as "core"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_storeTargetType_2020-09-25_06-18-36AM.log


Registering service "storeTargetType" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.vt.oms.plugin_13.4.1.0.0/metadata/targetType/oracle_vcamachine.xml" for plugin id as "oracle.sysman.vt"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_storeTargetType_2020-09-25_06-18-47AM.log


Registering service "storeTargetType" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.am.oms.plugin_13.4.1.0.0/metadata/targetType/oracle_dblra.xml" for plugin id as "oracle.sysman.am"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_storeTargetType_2020-09-25_06-18-55AM.log


Registering service "storeTargetType" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.emas.oms.plugin_13.4.1.0.0/metadata/targetType/oracle_coherence_node.xml" for plugin id as "oracle.sysman.emas"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_storeTargetType_2020-09-25_06-19-03AM.log


Registering service "storeTargetType" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.xa.oms.plugin_13.4.1.0.0/metadata/targetType/oracle_exadata.xml" for plugin id as "oracle.sysman.xa"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_storeTargetType_2020-09-25_06-19-11AM.log


Registering service "storeTargetType" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.si.oms.plugin_13.4.1.0.0/metadata/targetType/virtualization/oracle_si_virtual_platform_map.xml" for plugin id as "oracle.sysman.si"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_storeTargetType_2020-09-25_06-19-20AM.log


Registering service "storeTargetType" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.db.oms.plugin_13.4.1.0.0/patched_metadata/13.4.1.0.0/targetType/31661066/oracle_cloud_adw.xml" for plugin id as "oracle.sysman.db"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_storeTargetType_2020-09-25_06-19-36AM.log


Registering service "storeTargetType" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.emfa.oms.plugin_13.4.1.0.0/patched_metadata/13.4.1.0.0/targetType/31661078/fusion_apps_pf_common.xml" for plugin id as "oracle.sysman.emfa"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_storeTargetType_2020-09-25_06-19-50AM.log


Registering service "default_collection" with register file "/opt/app/oracle/middleware_134/sysman/metadata/default_collection/host.xml" for plugin id as "core"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_default_collection_2020-09-25_06-20-00AM.log


Registering service "default_collection" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.vt.oms.plugin_13.4.1.0.0/metadata/default_collection/oracle_vcamachine.xml" for plugin id as "oracle.sysman.vt"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_default_collection_2020-09-25_06-20-30AM.log


Registering service "default_collection" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.am.oms.plugin_13.4.1.0.0/metadata/default_collection/oracle_dblra.xml" for plugin id as "oracle.sysman.am"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_default_collection_2020-09-25_06-20-37AM.log


Registering service "default_collection" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.emas.oms.plugin_13.4.1.0.0/metadata/default_collection/oracle_coherence_node.xml" for plugin id as "oracle.sysman.emas"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_default_collection_2020-09-25_06-20-47AM.log


Registering service "default_collection" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.xa.oms.plugin_13.4.1.0.0/metadata/default_collection/oracle_exadata.xml" for plugin id as "oracle.sysman.xa"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_default_collection_2020-09-25_06-21-01AM.log


Registering service "default_collection" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.si.oms.plugin_13.4.1.0.0/metadata/default_collection/virtualization/oracle_si_virtual_platform_map.xml" for plugin id as "oracle.sysman.si"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_default_collection_2020-09-25_06-21-12AM.log


Registering service "default_collection" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.db.oms.plugin_13.4.1.0.0/metadata/default_collection/oracle_pdb.xml" for plugin id as "oracle.sysman.db"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_default_collection_2020-09-25_06-22-29AM.log


Registering service "default_collection" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.emfa.oms.plugin_13.4.1.0.0/metadata/default_collection/fusion_apps_pf_common.xml" for plugin id as "oracle.sysman.emfa"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_default_collection_2020-09-25_06-24-05AM.log


Registering service "omsPropertyDef" with register file "/opt/app/oracle/middleware_134/sysman/metadata/omsProperties/definition/ConsolePropDefinition.xml" for plugin id as "core"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_omsPropertyDef_2020-09-25_06-24-30AM.log


Registering service "omsPropertyDef" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.xa.oms.plugin_13.4.1.0.0/metadata/omsProperties/definition/oracle.sysman.xa.xml" for plugin id as "oracle.sysman.xa"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_omsPropertyDef_2020-09-25_06-24-39AM.log


Registering service "omsPropertyDef" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.db.oms.plugin_13.4.1.0.0/metadata/omsProperties/definition/DBPropDefinition.xml" for plugin id as "oracle.sysman.db"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_omsPropertyDef_2020-09-25_06-24-47AM.log


Registering service "jobTypes" with register file "/opt/app/oracle/middleware_134/sysman/metadata/jobTypes/core/PropagateTarget.xml" for plugin id as "core"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_jobTypes_2020-09-25_06-24-56AM.log


Registering service "jobTypes" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.vt.oms.plugin_13.4.1.0.0/metadata/jobTypes/AddKubeNodePool.xml" for plugin id as "oracle.sysman.vt"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_jobTypes_2020-09-25_06-25-07AM.log


Registering service "jobTypes" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.emas.oms.plugin_13.4.1.0.0/metadata/jobTypes/LogMgmtArchiveLogConfig.xml" for plugin id as "oracle.sysman.emas"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_jobTypes_2020-09-25_06-25-18AM.log


Registering service "jobTypes" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.db.oms.plugin_13.4.1.0.0/metadata/jobTypes/ADBTransfer.xml" for plugin id as "oracle.sysman.db"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_jobTypes_2020-09-25_06-25-27AM.log


Registering service "jobTypes" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.emfa.oms.plugin_13.4.1.0.0/metadata/jobTypes/UpdateFADynamicProps.xml" for plugin id as "oracle.sysman.emfa"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_jobTypes_2020-09-25_06-25-40AM.log


Registering service "systemStencil" with register file "/opt/app/oracle/middleware_134/sysman/builtinplugins/oracle.sysman.emrep/metadata/systemStencil/emSystemStencil.xml" for plugin id as "core"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_systemStencil_2020-09-25_06-25-49AM.log


Registering service "systemStencil" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.vt.oms.plugin_13.4.1.0.0/metadata/systemStencil/oracle_vcamachine.xml" for plugin id as "oracle.sysman.vt"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_systemStencil_2020-09-25_06-25-57AM.log


Registering service "systemStencil" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.am.oms.plugin_13.4.1.0.0/metadata/systemStencil/oracle_dblra.xml" for plugin id as "oracle.sysman.am"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_systemStencil_2020-09-25_06-26-06AM.log


Registering service "systemStencil" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.xa.oms.plugin_13.4.1.0.0/metadata/systemStencil/oracle_exadata_grid.xml" for plugin id as "oracle.sysman.xa"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_systemStencil_2020-09-25_06-26-13AM.log


Registering service "systemStencil" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.db.oms.plugin_13.4.1.0.0/patched_metadata/13.4.1.0.0/systemStencil/31187594/rac_database.xml" for plugin id as "oracle.sysman.db"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_systemStencil_2020-09-25_06-26-21AM.log


Registering service "systemStencil" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.emfa.oms.plugin_13.4.1.0.0/metadata/systemStencil/fusion_apps_pf_common.xml" for plugin id as "oracle.sysman.emfa"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_systemStencil_2020-09-25_06-26-30AM.log


Registering service "gccompliance" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.db.oms.plugin_13.4.1.0.0/metadata/gccompliance/stig.xml" for plugin id as "oracle.sysman.db"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_gccompliance_2020-09-25_06-26-39AM.log


Registering service "discovery" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.db.oms.plugin_13.4.1.0.0/metadata/discovery/db_discovery.xml" for plugin id as "oracle.sysman.db"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_discovery_2020-09-25_06-27-29AM.log


Registering service "OutOfBoxRole" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.emct.oms.plugin_13.4.1.0.0/metadata/security/OutOfBoxRoles/cat_roles.xml" for plugin id as "oracle.sysman.emct"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_OutOfBoxRole_2020-09-25_06-27-38AM.log


Registering service "SecurityClassManager" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.emct.oms.plugin_13.4.1.0.0/metadata/security/SecurityClass/chargeback_consolidation_security_class.xml" for plugin id as "oracle.sysman.emct"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_SecurityClassManager_2020-09-25_06-27-47AM.log


Registering service "CredstoreMetadata" with register file "/opt/app/oracle/middleware_134/sysman/metadata/security/CredstoreMetadata/federationMetadata.xml" for plugin id as "core"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_CredstoreMetadata_2020-09-25_06-27-56AM.log


Registering service "assoc" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.vt.oms.plugin_13.4.1.0.0/metadata/assoc/allowed_pairs.xml" for plugin id as "oracle.sysman.vt"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_assoc_2020-09-25_06-28-04AM.log


Registering service "EcmMetadataOnlyRegistration" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.vt.oms.plugin_13.4.1.0.0/metadata/snapshot/oracle_vcamachine_ecm.xml" for plugin id as "oracle.sysman.vt"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_EcmMetadataOnlyRegistration_2020-09-25_06-28-13AM.log


Registering service "derivedAssocs" with register file "/opt/app/oracle/middleware_134/plugins/oracle.sysman.am.oms.plugin_13.4.1.0.0/metadata/derivedAssocs/am_assoc_rules.xml" for plugin id as "oracle.sysman.am"...
Please monitor log file: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1/emctl_register_derivedAssocs_2020-09-25_06-28-22AM.log

*/
Complete Summary
================


All log file names referenced below can be accessed from the directory "/opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/2020-09-25_05-34-17AM_SystemPatch_31767864_1"

Patching summary:
-----------------

Binaries of the following sub-patch(es) have been applied successfully:

                        Featureset                                                                                                            Sub-patches                                                                                                                                                 Log file
                        ----------                                                                                                            -----------                                                                                                                                                 --------
  oracle.sysman.top.oms_13.4.0.0.0   30851102,31187567,31661020,31661036,31661066,31661078,31661089,31661124,31661157,31661173,31661186,31661194,31812958   30851102,31187567,31661020,31661036,31661066,31661078,31661089,31661124,31661157,31661173,31661186,31661194,31812958_opatch2020-09-25_05-34-24AM_1.log

Deployment summary:
-------------------

The following artifact(s) have been successfully deployed:

                        Artifacts                                                               Log file
                        ---------                                                               --------
                              SQL                rcu_applypatch_original_patch_2020-09-25_05-56-24AM.log
                              SQL                rcu_applypatch_original_patch_2020-09-25_06-01-12AM.log
                              SQL                rcu_applypatch_original_patch_2020-09-25_06-01-35AM.log
                              SQL                rcu_applypatch_original_patch_2020-09-25_06-02-11AM.log
                              SQL                rcu_applypatch_original_patch_2020-09-25_06-02-32AM.log
                              SQL                rcu_applypatch_original_patch_2020-09-25_06-02-53AM.log
                              SQL                rcu_applypatch_original_patch_2020-09-25_06-03-15AM.log
                              SQL                rcu_applypatch_original_patch_2020-09-25_06-03-34AM.log
                              SQL                rcu_applypatch_original_patch_2020-09-25_06-03-55AM.log
                              SQL                rcu_applypatch_original_patch_2020-09-25_06-04-17AM.log
                              SQL                rcu_applypatch_original_patch_2020-09-25_06-04-48AM.log
                              SQL                rcu_applypatch_original_patch_2020-09-25_06-05-09AM.log
                              SQL                rcu_applypatch_original_patch_2020-09-25_06-05-30AM.log
                     MRS-commands                      emctl_register_commands_2020-09-25_06-05-50AM.log
                     MRS-commands                      emctl_register_commands_2020-09-25_06-05-58AM.log
                     MRS-commands                      emctl_register_commands_2020-09-25_06-06-06AM.log
                   MRS-procedures                    emctl_register_procedures_2020-09-25_06-06-14AM.log
                   MRS-procedures                    emctl_register_procedures_2020-09-25_06-06-22AM.log
                   MRS-procedures                    emctl_register_procedures_2020-09-25_06-06-31AM.log
                   MRS-procedures                    emctl_register_procedures_2020-09-25_06-06-40AM.log
                   MRS-procedures                    emctl_register_procedures_2020-09-25_06-06-57AM.log
                        MRS-swlib                         emctl_register_swlib_2020-09-25_06-07-06AM.log
                        MRS-swlib                         emctl_register_swlib_2020-09-25_06-07-20AM.log
                   MRS-targetType                    emctl_register_targetType_2020-09-25_06-07-41AM.log
                   MRS-targetType                    emctl_register_targetType_2020-09-25_06-08-28AM.log
                   MRS-targetType                    emctl_register_targetType_2020-09-25_06-08-36AM.log
                   MRS-targetType                    emctl_register_targetType_2020-09-25_06-08-46AM.log
                   MRS-targetType                    emctl_register_targetType_2020-09-25_06-09-06AM.log
                   MRS-targetType                    emctl_register_targetType_2020-09-25_06-09-22AM.log
                   MRS-targetType                    emctl_register_targetType_2020-09-25_06-10-09AM.log
                   MRS-targetType                    emctl_register_targetType_2020-09-25_06-11-29AM.log
                   MRS-targetType                    emctl_register_targetType_2020-09-25_06-18-10AM.log
              MRS-storeTargetType               emctl_register_storeTargetType_2020-09-25_06-18-36AM.log
              MRS-storeTargetType               emctl_register_storeTargetType_2020-09-25_06-18-47AM.log
              MRS-storeTargetType               emctl_register_storeTargetType_2020-09-25_06-18-55AM.log
              MRS-storeTargetType               emctl_register_storeTargetType_2020-09-25_06-19-03AM.log
              MRS-storeTargetType               emctl_register_storeTargetType_2020-09-25_06-19-11AM.log
              MRS-storeTargetType               emctl_register_storeTargetType_2020-09-25_06-19-20AM.log
              MRS-storeTargetType               emctl_register_storeTargetType_2020-09-25_06-19-36AM.log
              MRS-storeTargetType               emctl_register_storeTargetType_2020-09-25_06-19-50AM.log
           MRS-default_collection            emctl_register_default_collection_2020-09-25_06-20-00AM.log
           MRS-default_collection            emctl_register_default_collection_2020-09-25_06-20-30AM.log
           MRS-default_collection            emctl_register_default_collection_2020-09-25_06-20-37AM.log
           MRS-default_collection            emctl_register_default_collection_2020-09-25_06-20-47AM.log
           MRS-default_collection            emctl_register_default_collection_2020-09-25_06-21-01AM.log
           MRS-default_collection            emctl_register_default_collection_2020-09-25_06-21-12AM.log
           MRS-default_collection            emctl_register_default_collection_2020-09-25_06-22-29AM.log
           MRS-default_collection            emctl_register_default_collection_2020-09-25_06-24-05AM.log
               MRS-omsPropertyDef                emctl_register_omsPropertyDef_2020-09-25_06-24-30AM.log
               MRS-omsPropertyDef                emctl_register_omsPropertyDef_2020-09-25_06-24-39AM.log
               MRS-omsPropertyDef                emctl_register_omsPropertyDef_2020-09-25_06-24-47AM.log
                     MRS-jobTypes                      emctl_register_jobTypes_2020-09-25_06-24-56AM.log
                     MRS-jobTypes                      emctl_register_jobTypes_2020-09-25_06-25-07AM.log
                     MRS-jobTypes                      emctl_register_jobTypes_2020-09-25_06-25-18AM.log
                     MRS-jobTypes                      emctl_register_jobTypes_2020-09-25_06-25-27AM.log
                     MRS-jobTypes                      emctl_register_jobTypes_2020-09-25_06-25-40AM.log
                MRS-systemStencil                 emctl_register_systemStencil_2020-09-25_06-25-49AM.log
                MRS-systemStencil                 emctl_register_systemStencil_2020-09-25_06-25-57AM.log
                MRS-systemStencil                 emctl_register_systemStencil_2020-09-25_06-26-06AM.log
                MRS-systemStencil                 emctl_register_systemStencil_2020-09-25_06-26-13AM.log
                MRS-systemStencil                 emctl_register_systemStencil_2020-09-25_06-26-21AM.log
                MRS-systemStencil                 emctl_register_systemStencil_2020-09-25_06-26-30AM.log
                 MRS-gccompliance                  emctl_register_gccompliance_2020-09-25_06-26-39AM.log
                    MRS-discovery                     emctl_register_discovery_2020-09-25_06-27-29AM.log
                 MRS-OutOfBoxRole                  emctl_register_OutOfBoxRole_2020-09-25_06-27-38AM.log
         MRS-SecurityClassManager          emctl_register_SecurityClassManager_2020-09-25_06-27-47AM.log
            MRS-CredstoreMetadata             emctl_register_CredstoreMetadata_2020-09-25_06-27-56AM.log
                        MRS-assoc                         emctl_register_assoc_2020-09-25_06-28-04AM.log
  MRS-EcmMetadataOnlyRegistration   emctl_register_EcmMetadataOnlyRegistration_2020-09-25_06-28-13AM.log
                MRS-derivedAssocs                 emctl_register_derivedAssocs_2020-09-25_06-28-22AM.log


Log file location: /opt/app/oracle/middleware_134/cfgtoollogs/omspatcher/31767864/omspatcher_2020-09-25_05-34-25AM_deploy.log

OMSPatcher succeeded.

[oracle@localhost~]$ $ORACLE_HOME/bin/./emctl getversion oms
Oracle Enterprise Manager Cloud Control 13c Release 4
Copyright (c) 1996, 2020 Oracle Corporation.  All rights reserved.
       Oracle Enterprise Manager Cloud Control OMS 13c Release 4
[oracle@localhost~]$ $ORACLE_HOME/OPatch/opatch lsinventory | grep Platform
Patch description:  "Oracle Enterprise Manager 13c Release 4 Platform Update 6 (13.4.0.6) for Oracle Management Service"
[oracle@localhost~]$

 

 From GUI -- About Clod control