Monthly Archive: May 2016

Enterprise Manager 13c – How to apply p23095307: enterprise manager for oms plugins 13.1.1.0.160429

Author: Martin Berger 17. May 2016

Patch 23095307 is the newest system patch for the Enterprise Manager 13c family. This patch will be applied with the new patch tool OMSPatcher (see blog post http://dbakevlar.com/2016/05/em13c-applying-system-patches-with-the-oms-patcher from @dbakevlar for details). To apply this patch, the OMS has to be stopped.

Prerequisites

OMS 13.1.0.0.0
OMSPatcher 13.6.0.0.1 – I have installed it in directory /u00/app/oracle/product/em13cr1/OMSPatcher
URL / Username / Password from your EM13c Weblogic AdminServer (emctl status oms -details)
Patch 23095307 is unzipped and available in a local directory, in my case it’s in /u00/app/oracle/stage

oracle@solothurn:/u00/app/oracle/product/em13cr1/OMSPatcher/ [oms13101] ./omspatcher version
OMSPatcher Version: 13.6.0.0.1
OPlan Version: 12.1.0.2.2
OsysModel build: Wed Oct 14 06:21:23 PDT 2015
OMSPatcher succeeded.

oracle@solothurn:/u00/app/oracle/product/em13cr1/OMSPatcher/ [oms13101] ./omspatcher version

OMSPatcher Version: 13.6.0.0.1

OPlan Version: 12.1.0.2.2

OsysModel build: Wed Oct 14 06:21:23 PDT 2015

OMSPatcher succeeded.

The newest OMSPatcher can be downloaded according the My Oracle Support Note How to upgrade the OMSPatcher to latest version of OMSPatcher (Doc ID 2135028.1)

Patch Verification

For the verification you don’t have to shutdown the OMS. Be sure that your ORACLE_HOME is set to the EM13c installation directory.

oracle@solothurn:/u00/app/oracle/product/em13cr1/OMSPatcher/ [oms13101] export ORACLE_HOME=/u00/app/oracle/product/em13cr1

oracle@solothurn:/u00/app/oracle/product/em13cr1/OMSPatcher/ [oms13101] ./omspatcher apply /u00/app/oracle/stage/23095307 -analyze
OMSPatcher Automation Tool
Copyright (c) 2015, Oracle Corporation.  All rights reserved.

OMSPatcher version : 13.6.0.0.1
OUI version        : 13.6.0.0.0
Running from       : /u00/app/oracle/product/em13cr1
Log file location  : /u00/app/oracle/product/em13cr1/cfgtoollogs/omspatcher/opatch2016-05-16_05-13-21AM_1.log

OMSPatcher log file: /u00/app/oracle/product/em13cr1/cfgtoollogs/omspatcher/23095307/omspatcher_2016-05-16_05-13-24AM_analyze.log

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

WARNING: Could not apply the patch "23092170" because the "oracle.sysman.ssa.oms.plugin with version 13.1.1.0.0" core component of the OMS or the plug-in for which the patch is intended is either not deployed or deployed with another version in your Enterprise Manager system.

Configuration Validation: Success

Running apply prerequisite checks for sub-patch(es) "23030182 23030179 23030173" and Oracle Home "/u00/app/oracle/product/em13cr1"...
Sub-patch(es) "23030182 23030179 23030173" are successfully analyzed for Oracle Home "/u00/app/oracle/product/em13cr1"

Running rollback prerequisite checks for patch(es) "22589347 22823175 22823156" and Oracle Home "/u00/app/oracle/product/em13cr1"...
Sub-patch(es) "22589347 22823175 22823156" are successfully analyzed for Oracle Home "/u00/app/oracle/product/em13cr1"

Complete Summary
================
All log file names referenced below can be accessed from the directory "/u00/app/oracle/product/em13cr1/cfgtoollogs/omspatcher/2016-05-16_05-13-21AM_SystemPatch_23095307_1"

Prerequisites analysis summary:
-------------------------------
The following sub-patch(es) are rollbackable:

             Featureset                  Sub-patches                                                       Log file
             ----------                  -----------                                                       --------
  oracle.sysman.top.oms   22589347,22823175,22823156   22589347_22823175_22823156_opatch2016-05-16_05-14-59AM_3.log


The following sub-patch(es) are applicable:

             Featureset                  Sub-patches                                                       Log file
             ----------                  -----------                                                       --------
  oracle.sysman.top.oms   23030182,23030179,23030173   23030182_23030179_23030173_opatch2016-05-16_05-14-41AM_2.log

The following sub-patches are incompatible with components installed in the OMS system:
23092170
--------------------------------------------------------------------------------
The following warnings have occurred during OPatch execution:
1)  Could not apply the patch "23092170" because the "oracle.sysman.ssa.oms.plugin with version 13.1.1.0.0" core component of the OMS or the plug-in for which the patch is intended is either not deployed or deployed with another version in your Enterprise Manager system.
--------------------------------------------------------------------------------
OMSPatcher Session completed with warnings.
Log file location: /u00/app/oracle/product/em13cr1/cfgtoollogs/omspatcher/23095307/omspatcher_2016-05-16_05-13-24AM_analyze.log

OMSPatcher completed with warnings.

oracle@solothurn:/u00/app/oracle/product/em13cr1/OMSPatcher/ [oms13101] export ORACLE_HOME=/u00/app/oracle/product/em13cr1

oracle@solothurn:/u00/app/oracle/product/em13cr1/OMSPatcher/ [oms13101] ./omspatcher apply /u00/app/oracle/stage/23095307 -analyze

OMSPatcher Automation Tool

OMSPatcher version : 13.6.0.0.1

OUI version : 13.6.0.0.0

Running from : /u00/app/oracle/product/em13cr1

Log file location : /u00/app/oracle/product/em13cr1/cfgtoollogs/omspatcher/opatch2016-05-16_05-13-21AM_1.log

OMSPatcher log file: /u00/app/oracle/product/em13cr1/cfgtoollogs/omspatcher/23095307/omspatcher_2016-05-16_05-13-24AM_analyze.log

Please enter OMS weblogic admin server URL(t3s://solothurn.trivadistraining.com:7102):>

Please enter OMS weblogic admin server username(weblogic):>

Please enter OMS weblogic admin server password:>

WARNING: Could not apply the patch "23092170" because the "oracle.sysman.ssa.oms.plugin with version 13.1.1.0.0" core component of the OMS or the plug-in for which the patch is intended is either not deployed or deployed with another version in your Enterprise Manager system.

Configuration Validation: Success

Running apply prerequisite checks for sub-patch(es) "23030182 23030179 23030173" and Oracle Home "/u00/app/oracle/product/em13cr1"...

Sub-patch(es) "23030182 23030179 23030173" are successfully analyzed for Oracle Home "/u00/app/oracle/product/em13cr1"

Running rollback prerequisite checks for patch(es) "22589347 22823175 22823156" and Oracle Home "/u00/app/oracle/product/em13cr1"...

Sub-patch(es) "22589347 22823175 22823156" are successfully analyzed for Oracle Home "/u00/app/oracle/product/em13cr1"

Complete Summary

================

All log file names referenced below can be accessed from the directory "/u00/app/oracle/product/em13cr1/cfgtoollogs/omspatcher/2016-05-16_05-13-21AM_SystemPatch_23095307_1"

Prerequisites analysis summary:

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

The following sub-patch(es) are rollbackable:

Featureset Sub-patches Log file

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

oracle.sysman.top.oms 22589347,22823175,22823156 22589347_22823175_22823156_opatch2016-05-16_05-14-59AM_3.log

The following sub-patch(es) are applicable:

Featureset Sub-patches Log file

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

oracle.sysman.top.oms 23030182,23030179,23030173 23030182_23030179_23030173_opatch2016-05-16_05-14-41AM_2.log

The following sub-patches are incompatible with components installed in the OMS system:

23092170

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

The following warnings have occurred during OPatch execution:

1) Could not apply the patch "23092170" because the "oracle.sysman.ssa.oms.plugin with version 13.1.1.0.0" core component of the OMS or the plug-in for which the patch is intended is either not deployed or deployed with another version in your Enterprise Manager system.

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

OMSPatcher Session completed with warnings.

Log file location: /u00/app/oracle/product/em13cr1/cfgtoollogs/omspatcher/23095307/omspatcher_2016-05-16_05-13-24AM_analyze.log

OMSPatcher completed with warnings.

As you can see, there is a WARNING in the output that a sub-patch is incompatible with the oracle.sysman.ssa.oms.plugin version 13.1.1.0.0. The SSA.OMS plugin is a plugin for the cloud self service zone. The patch 23092170 is the EM Cloud Plugin Bundle Patch 13.1.1.0.160429. I don’t have installed the cloud plugin during the installation of the EM13 because we don’t use it, now the OMSPatcher wants this plugin.

Installation of the missing Plugins

To resolve the warning, I have installed the two missing plugins. The Oracle Cloud Application plugin requires the Oracle Virtualization plugin first. Attention: If you install the plugins on the Oracle Management Server, the OMS will be restarted during plugin installation process.

The Oracle Virtualization Plugin

plugin_virtualization

The Oracle Cloud Application Plugin

plugin_cloud

OMSPatcher Re-Analyze

Now the analyze job runs without any warnings or errors. I have removed some lines in the output for better reading.

oracle@solothurn:/u00/app/oracle/product/em13cr1/OMSPatcher/ [oms13101] ./omspatcher apply /u00/app/oracle/stage/23095307 -analyze
OMSPatcher Automation Tool
Copyright (c) 2015, Oracle Corporation.  All rights reserved.

OMSPatcher version : 13.6.0.0.1
OUI version        : 13.6.0.0.0
Running from       : /u00/app/oracle/product/em13cr1
Log file location  : /u00/app/oracle/product/em13cr1/cfgtoollogs/omspatcher/opatch2016-05-16_05-44-30AM_1.log

OMSPatcher log file: /u00/app/oracle/product/em13cr1/cfgtoollogs/omspatcher/23095307/omspatcher_2016-05-16_05-44-34AM_analyze.log

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

Configuration Validation: Success

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

The following sub-patch(es) are rollbackable:

             Featureset                  Sub-patches                                                       Log file
             ----------                  -----------                                                       --------
  oracle.sysman.top.oms   22589347,22823175,22823156   22589347_22823175_22823156_opatch2016-05-16_05-45-23AM_3.log


The following sub-patch(es) are applicable:

             Featureset                           Sub-patches                                                                Log file
             ----------                           -----------                                                                --------
  oracle.sysman.top.oms   23030182,23030179,23030173,23092170   23030182_23030179_23030173_23092170_opatch2016-05-16_05-45-10AM_2.log



Log file location: /u00/app/oracle/product/em13cr1/cfgtoollogs/omspatcher/23095307/omspatcher_2016-05-16_05-44-34AM_analyze.log

OMSPatcher succeeded.

oracle@solothurn:/u00/app/oracle/product/em13cr1/OMSPatcher/ [oms13101] ./omspatcher apply /u00/app/oracle/stage/23095307 -analyze

OMSPatcher Automation Tool

OMSPatcher version : 13.6.0.0.1

OUI version : 13.6.0.0.0

Running from : /u00/app/oracle/product/em13cr1

Log file location : /u00/app/oracle/product/em13cr1/cfgtoollogs/omspatcher/opatch2016-05-16_05-44-30AM_1.log

OMSPatcher log file: /u00/app/oracle/product/em13cr1/cfgtoollogs/omspatcher/23095307/omspatcher_2016-05-16_05-44-34AM_analyze.log

Please enter OMS weblogic admin server URL(t3s://solothurn.trivadistraining.com:7102):>

Please enter OMS weblogic admin server username(weblogic):>

Please enter OMS weblogic admin server password:>

Configuration Validation: Success

...

Prerequisites analysis summary:

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

The following sub-patch(es) are rollbackable:

Featureset Sub-patches Log file

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

oracle.sysman.top.oms 22589347,22823175,22823156 22589347_22823175_22823156_opatch2016-05-16_05-45-23AM_3.log

The following sub-patch(es) are applicable:

Featureset Sub-patches Log file

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

oracle.sysman.top.oms 23030182,23030179,23030173,23092170 23030182_23030179_23030173_23092170_opatch2016-05-16_05-45-10AM_2.log

Log file location: /u00/app/oracle/product/em13cr1/cfgtoollogs/omspatcher/23095307/omspatcher_2016-05-16_05-44-34AM_analyze.log

OMSPatcher succeeded.

The problem is solved, the system is ready to patch.

Patch apply

Before you apply the patch, you have to stop the OMS. Then you can apply it.

oracle@solothurn:~/ [oms13101] $ORACLE_HOME/bin/emctl stop oms
Oracle Enterprise Manager Cloud Control 13c Release 1
Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.
Stopping Oracle Management Server...
Oracle Management Server Successfully Stopped
Oracle Management Server is Down
JVMD Engine is Down
oracle@solothurn:/u00/app/oracle/product/em13cr1/OMSPatcher/ [oms13101] ./omspatcher apply /u00/app/oracle/stage/23095307
OMSPatcher Automation Tool
Copyright (c) 2015, Oracle Corporation.  All rights reserved.

oracle@solothurn:~/ [oms13101] $ORACLE_HOME/bin/emctl stop oms

Oracle Enterprise Manager Cloud Control 13c Release 1

Stopping Oracle Management Server...

Oracle Management Server Successfully Stopped

Oracle Management Server is Down

JVMD Engine is Down

oracle@solothurn:/u00/app/oracle/product/em13cr1/OMSPatcher/ [oms13101] ./omspatcher apply /u00/app/oracle/stage/23095307

OMSPatcher Automation Tool

I have removed some output. if you want to have the full output, you can download it HERE.

oracle@solothurn:/u00/app/oracle/product/em13cr1/OMSPatcher/ [oms13101] ./omspatcher apply /u00/app/oracle/stage/23095307
OMSPatcher Automation Tool
Copyright (c) 2015, Oracle Corporation.  All rights reserved.


OMSPatcher version : 13.6.0.0.1
OUI version        : 13.6.0.0.0
Running from       : /u00/app/oracle/product/em13cr1
Log file location  : /u00/app/oracle/product/em13cr1/cfgtoollogs/omspatcher/opatch2016-05-16_05-47-25AM_1.log

OMSPatcher log file: /u00/app/oracle/product/em13cr1/cfgtoollogs/omspatcher/23095307/omspatcher_2016-05-16_05-47-29AM_deploy.log

Please enter OMS weblogic admin server URL(t3s://solothurn.trivadistraining.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) "23030182 23030179 23030173 23092170" and Oracle Home "/u00/app/oracle/product/em13cr1"...
Sub-patch(es) "23030182 23030179 23030173 23092170" are successfully analyzed for Oracle Home "/u00/app/oracle/product/em13cr1"

Running rollback prerequisite checks for patch(es) "22589347 22823175 22823156" and Oracle Home "/u00/app/oracle/product/em13cr1"...
Sub-patch(es) "22589347 22823175 22823156" are successfully analyzed for Oracle Home "/u00/app/oracle/product/em13cr1"

To continue, OMSPatcher will do the following:
[Patch and deploy artifacts]   : De-register MRS artifact "swlib";
                                 De-register MRS artifact "swlib";
                                 De-register MRS artifact "swlib";
                                 De-register MRS artifact "procedures";
                                 De-register MRS artifact "procedures";
                                 De-register MRS artifact "procedures";
                                 De-register MRS artifact "procedures";
                                 De-register MRS artifact "procedures";
...


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

De-registering service "swlib" with register file "/u00/app/oracle/product/em13cr1/plugins/oracle.sysman.db.oms.plugin_13.1.1.0.0/metadata/swlib" for plugin id as "oracle.sysman.db"...

De-registering service "swlib" with register file "/u00/app/oracle/product/em13cr1/plugins/oracle.sysman.db.oms.plugin_13.1.1.0.0/metadata/swlib/dbprovision/dbprov" for plugin id as "oracle.sysman.db"...

...

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


All log file names referenced below can be accessed from the directory "/u00/app/oracle/product/em13cr1/cfgtoollogs/omspatcher/2016-05-16_05-47-25AM_SystemPatch_23095307_1"

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

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

                                Featureset   Sub-patches                                       Log file
                                ----------   -----------                                       --------
    oracle.sysman.db.oms.plugin_13.1.1.0.0      22823156   22823156_rollback2016-05-16_05-49-23AM_4.log
    oracle.sysman.si.oms.plugin_13.1.1.0.0      22589347   22589347_rollback2016-05-16_05-50-41AM_6.log
  oracle.sysman.emas.oms.plugin_13.1.1.0.0      22823175   22823175_rollback2016-05-16_05-50-27AM_5.log


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

                                Featureset   Sub-patches                                      Log file
                                ----------   -----------                                      --------
    oracle.sysman.db.oms.plugin_13.1.1.0.0      23030182    23030182_opatch2016-05-16_05-50-48AM_7.log
    oracle.sysman.si.oms.plugin_13.1.1.0.0      23030173    23030173_opatch2016-05-16_05-51-14AM_9.log
  oracle.sysman.emas.oms.plugin_13.1.1.0.0      23030179    23030179_opatch2016-05-16_05-51-03AM_8.log
   oracle.sysman.ssa.oms.plugin_13.1.1.0.0      23092170   23092170_opatch2016-05-16_05-51-26AM_10.log

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

The following artifact(s) have been successfully deployed:

                           Artifacts                                                                    Log file
                           ---------                                                                    --------
                           MRS-swlib                            emctl_deregister_swlib_2016-05-16_05-48-27AM.log
                           MRS-swlib                            emctl_deregister_swlib_2016-05-16_05-48-37AM.log
                           MRS-swlib                            emctl_deregister_swlib_2016-05-16_05-48-45AM.log
                      MRS-procedures                       emctl_deregister_procedures_2016-05-16_05-48-50AM.log
                      MRS-procedures                       emctl_deregister_procedures_2016-05-16_05-48-55AM.log
                      MRS-procedures                       emctl_deregister_procedures_2016-05-16_05-48-59AM.log
                      MRS-procedures                       emctl_deregister_procedures_2016-05-16_05-49-04AM.log
                      MRS-procedures                       emctl_deregister_procedures_2016-05-16_05-49-09AM.log
...
              MRS-default_collection                 emctl_register_default_collection_2016-05-16_05-57-34AM.log
              MRS-default_collection                 emctl_register_default_collection_2016-05-16_05-57-38AM.log
              MRS-default_collection                 emctl_register_default_collection_2016-05-16_05-57-45AM.log
              MRS-default_collection                 emctl_register_default_collection_2016-05-16_05-57-51AM.log
              MRS-default_collection                 emctl_register_default_collection_2016-05-16_05-57-55AM.log
              MRS-default_collection                 emctl_register_default_collection_2016-05-16_05-58-00AM.log
              MRS-default_collection                 emctl_register_default_collection_2016-05-16_05-58-05AM.log
              MRS-default_collection                 emctl_register_default_collection_2016-05-16_05-58-19AM.log
              MRS-default_collection                 emctl_register_default_collection_2016-05-16_05-58-23AM.log
                   MRS-systemStencil                      emctl_register_systemStencil_2016-05-16_05-58-31AM.log
                   MRS-systemStencil                      emctl_register_systemStencil_2016-05-16_05-58-35AM.log
         MRS-OracleCertifiedTemplate            emctl_register_OracleCertifiedTemplate_2016-05-16_05-58-39AM.log
         MRS-OracleCertifiedTemplate            emctl_register_OracleCertifiedTemplate_2016-05-16_05-58-43AM.log
         MRS-OracleCertifiedTemplate            emctl_register_OracleCertifiedTemplate_2016-05-16_05-58-47AM.log
         MRS-OracleCertifiedTemplate            emctl_register_OracleCertifiedTemplate_2016-05-16_05-58-51AM.log
                MRS-CfwServiceFamily                   emctl_register_CfwServiceFamily_2016-05-16_05-58-55AM.log


Log file location: /u00/app/oracle/product/em13cr1/cfgtoollogs/omspatcher/23095307/omspatcher_2016-05-16_05-47-29AM_deploy.log

OMSPatcher succeeded.

100

101

102

103

104

105

106

107

108

109

110

oracle@solothurn:/u00/app/oracle/product/em13cr1/OMSPatcher/ [oms13101] ./omspatcher apply /u00/app/oracle/stage/23095307

OMSPatcher Automation Tool

OMSPatcher version : 13.6.0.0.1

OUI version : 13.6.0.0.0

Running from : /u00/app/oracle/product/em13cr1

Log file location : /u00/app/oracle/product/em13cr1/cfgtoollogs/omspatcher/opatch2016-05-16_05-47-25AM_1.log

OMSPatcher log file: /u00/app/oracle/product/em13cr1/cfgtoollogs/omspatcher/23095307/omspatcher_2016-05-16_05-47-29AM_deploy.log

Please enter OMS weblogic admin server URL(t3s://solothurn.trivadistraining.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) "23030182 23030179 23030173 23092170" and Oracle Home "/u00/app/oracle/product/em13cr1"...

Sub-patch(es) "23030182 23030179 23030173 23092170" are successfully analyzed for Oracle Home "/u00/app/oracle/product/em13cr1"

Running rollback prerequisite checks for patch(es) "22589347 22823175 22823156" and Oracle Home "/u00/app/oracle/product/em13cr1"...

Sub-patch(es) "22589347 22823175 22823156" are successfully analyzed for Oracle Home "/u00/app/oracle/product/em13cr1"

To continue, OMSPatcher will do the following:

[Patch and deploy artifacts] : De-register MRS artifact "swlib";

De-register MRS artifact "swlib";

De-register MRS artifact "procedures";

...

Do you want to proceed? [y|n]

User Responded with: Y

De-registering service "swlib" with register file "/u00/app/oracle/product/em13cr1/plugins/oracle.sysman.db.oms.plugin_13.1.1.0.0/metadata/swlib" for plugin id as "oracle.sysman.db"...

De-registering service "swlib" with register file "/u00/app/oracle/product/em13cr1/plugins/oracle.sysman.db.oms.plugin_13.1.1.0.0/metadata/swlib/dbprovision/dbprov" for plugin id as "oracle.sysman.db"...

...

Complete Summary

================

All log file names referenced below can be accessed from the directory "/u00/app/oracle/product/em13cr1/cfgtoollogs/omspatcher/2016-05-16_05-47-25AM_SystemPatch_23095307_1"

Patching summary:

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

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

Featureset Sub-patches Log file

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

oracle.sysman.db.oms.plugin_13.1.1.0.0 22823156 22823156_rollback2016-05-16_05-49-23AM_4.log

oracle.sysman.si.oms.plugin_13.1.1.0.0 22589347 22589347_rollback2016-05-16_05-50-41AM_6.log

oracle.sysman.emas.oms.plugin_13.1.1.0.0 22823175 22823175_rollback2016-05-16_05-50-27AM_5.log

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

Featureset Sub-patches Log file

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

oracle.sysman.db.oms.plugin_13.1.1.0.0 23030182 23030182_opatch2016-05-16_05-50-48AM_7.log

oracle.sysman.si.oms.plugin_13.1.1.0.0 23030173 23030173_opatch2016-05-16_05-51-14AM_9.log

oracle.sysman.emas.oms.plugin_13.1.1.0.0 23030179 23030179_opatch2016-05-16_05-51-03AM_8.log

oracle.sysman.ssa.oms.plugin_13.1.1.0.0 23092170 23092170_opatch2016-05-16_05-51-26AM_10.log

Deployment summary:

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

The following artifact(s) have been successfully deployed:

Artifacts Log file

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

MRS-swlib emctl_deregister_swlib_2016-05-16_05-48-27AM.log

MRS-swlib emctl_deregister_swlib_2016-05-16_05-48-37AM.log

MRS-swlib emctl_deregister_swlib_2016-05-16_05-48-45AM.log

MRS-procedures emctl_deregister_procedures_2016-05-16_05-48-50AM.log

MRS-procedures emctl_deregister_procedures_2016-05-16_05-48-55AM.log

MRS-procedures emctl_deregister_procedures_2016-05-16_05-48-59AM.log

MRS-procedures emctl_deregister_procedures_2016-05-16_05-49-04AM.log

MRS-procedures emctl_deregister_procedures_2016-05-16_05-49-09AM.log

...

MRS-default_collection emctl_register_default_collection_2016-05-16_05-57-34AM.log

MRS-default_collection emctl_register_default_collection_2016-05-16_05-57-38AM.log

MRS-default_collection emctl_register_default_collection_2016-05-16_05-57-45AM.log

MRS-default_collection emctl_register_default_collection_2016-05-16_05-57-51AM.log

MRS-default_collection emctl_register_default_collection_2016-05-16_05-57-55AM.log

MRS-default_collection emctl_register_default_collection_2016-05-16_05-58-00AM.log

MRS-default_collection emctl_register_default_collection_2016-05-16_05-58-05AM.log

MRS-default_collection emctl_register_default_collection_2016-05-16_05-58-19AM.log

MRS-default_collection emctl_register_default_collection_2016-05-16_05-58-23AM.log

MRS-systemStencil emctl_register_systemStencil_2016-05-16_05-58-31AM.log

MRS-systemStencil emctl_register_systemStencil_2016-05-16_05-58-35AM.log

MRS-OracleCertifiedTemplate emctl_register_OracleCertifiedTemplate_2016-05-16_05-58-39AM.log

MRS-OracleCertifiedTemplate emctl_register_OracleCertifiedTemplate_2016-05-16_05-58-43AM.log

MRS-OracleCertifiedTemplate emctl_register_OracleCertifiedTemplate_2016-05-16_05-58-47AM.log

MRS-OracleCertifiedTemplate emctl_register_OracleCertifiedTemplate_2016-05-16_05-58-51AM.log

MRS-CfwServiceFamily emctl_register_CfwServiceFamily_2016-05-16_05-58-55AM.log

Log file location: /u00/app/oracle/product/em13cr1/cfgtoollogs/omspatcher/23095307/omspatcher_2016-05-16_05-47-29AM_deploy.log

OMSPatcher succeeded.

Patch successfully applied

The patch is applied, the OMS can be started again. I don’t know why the patch needs the plugins. My understanding from the plugins is to have a small installation, and only the components which will be used should be configured. And at this point, personally I would expect only an INFORMATION that some components are not installed so they not will be patched and not a WARNING.

The OMSPatcher is a new tool for the EM13c patching, maybe there are some improvements in one of the next releases.

EM13c Cloud Control, Oracle Tools, TrivadisContent

Oracle Database Backup Service Configuration – java.net.UnknownHostException

Author: Martin Berger 7. May 2016

In all the trials in the Oracle cloud in the past, I used the same syntax below to configure the Oracle Database Backup Service on my local servers. Last week I have decided to order the Service via shop.oracle.com. Now I am an official owner of an Oracle cloud account with a CSI :-). But back to my problem, after my account was created I got the mail with the configuration details. So far so good. Then I tried to configure the OPC package as always:

oracle@bern:/u00/app/oracle/stage/ [ORCL] java -jar opc_install.jar -serviceName <my-storage> -identityDomain <my-identitydomain> -opcId '<my-username>'  -opcPass '<my-password>' -walletDir $ORACLE_BASE/opc_wallet -libDir $ORACLE_HOME/lib -configFile $ORACLE_BASE/admin/ORCL/opc_config/opcORCL.ora
Oracle Database Cloud Backup Module Install Tool, build 2016-02-04
java.net.UnknownHostException: <my-identitydomain>.storage.oraclecloud.com
        at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:178)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
        at java.net.Socket.connect(Socket.java:579)
        at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:625)
        at sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:160)
        at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
        at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
        at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
        at sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:275)
        at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:371)
        at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
        at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:933)
        at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
        at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1301)
        at sun.net.www.protocol.https.HttpsURLConnectionImpl.getInputStream(HttpsURLConnectionImpl.java:254)
        at oracle.backup.opc.install.OpcConfig.testConnection(OpcConfig.java:235)
        at oracle.backup.opc.install.OpcConfig.doOpcConfig(OpcConfig.java:204)
        at oracle.backup.opc.install.OpcConfig.main(OpcConfig.java:197)
Could not authenticate to Oracle Database Cloud Backup Module

oracle@bern:/u00/app/oracle/stage/ [ORCL] java -jar opc_install.jar -serviceName <my-storage> -identityDomain <my-identitydomain> -opcId '<my-username>' -opcPass '<my-password>' -walletDir $ORACLE_BASE/opc_wallet -libDir $ORACLE_HOME/lib -configFile $ORACLE_BASE/admin/ORCL/opc_config/opcORCL.ora

Oracle Database Cloud Backup Module Install Tool, build 2016-02-04

java.net.UnknownHostException: <my-identitydomain>.storage.oraclecloud.com

at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:178)

at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)

at java.net.Socket.connect(Socket.java:579)

at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:625)

at sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:160)

at sun.net.NetworkClient.doConnect(NetworkClient.java:180)

at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)

at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)

at sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:275)

at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:371)

at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)

at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:933)

at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)

at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1301)

at sun.net.www.protocol.https.HttpsURLConnectionImpl.getInputStream(HttpsURLConnectionImpl.java:254)

at oracle.backup.opc.install.OpcConfig.testConnection(OpcConfig.java:235)

at oracle.backup.opc.install.OpcConfig.doOpcConfig(OpcConfig.java:204)

at oracle.backup.opc.install.OpcConfig.main(OpcConfig.java:197)

Could not authenticate to Oracle Database Cloud Backup Module

The installer didn’t found the hostname where my backup location should be located. I tried to verify if the REST endpoint URL was available, it was ok:

storage_test_api

The output from the installer file without any parameter shows me no additional information:

oracle@bern:/u00/app/oracle/stage/ [ORCL] java -jar opc_install.jar
Oracle Database Cloud Backup Module Install Tool, build 2016-02-04
No arguments supplied
Usage: java -jar opc_install.jar
        -serviceName:    OPC Service Name
        -identityDomain: OPC Identity Domain
        -opcId:          OPC Username
        -opcPass:        OPC Password
        -walletDir:      Directory to store wallet
        -configFile:     File name of config file
        -libDir:         Directory to store library
        -libPlatform:    Platform of library to download
        -proxyHost:      HTTP proxy host
        -proxyPort:      HTTP proxy port
        -proxyId:        HTTP proxy username, if needed
        -proxyPass:      HTTP proxy password, if needed
        -container:      OPC container to store backups

oracle@bern:/u00/app/oracle/stage/ [ORCL] java -jar opc_install.jar

Oracle Database Cloud Backup Module Install Tool, build 2016-02-04

No arguments supplied

Usage: java -jar opc_install.jar

-serviceName: OPC Service Name

-identityDomain: OPC Identity Domain

-opcId: OPC Username

-opcPass: OPC Password

-walletDir: Directory to store wallet

-configFile: File name of config file

-libDir: Directory to store library

-libPlatform: Platform of library to download

-proxyHost: HTTP proxy host

-proxyPort: HTTP proxy port

-proxyId: HTTP proxy username, if needed

-proxyPass: HTTP proxy password, if needed

-container: OPC container to store backups

In the extracted opc_installer.jar file is a Java class file called OpcConfig.class. I used JD-GUI, a small Java decompiler, to take a look insight the Java class file. And at line 90 I found a new parameter which was not listed above – the -host.

opc_class

So why not try to install opc_installer.jar again and add this -host parameter?

oracle@bern:/u00/app/oracle/stage/ [ORCL] java -jar opc_install.jar -serviceName <my-storage> -identityDomain <my-identitydomain> -opcId '<my-username>'  -opcPass '<my-password>' -walletDir $ORACLE_BASE/opc_wallet -libDir $ORACLE_HOME/lib -configFile $ORACLE_BASE/admin/ORCL/opc_config/opcORCL.ora -host https://storage-<my-identitydomain>.storage.oraclecloud.com/v1/storage-<my-identitydomain><strong>
Oracle Database Cloud Backup Module Install Tool, build 2016-02-04</strong>
Oracle Database Cloud Backup Module credentials are valid.
Oracle Database Cloud Backup Module wallet created in directory /u00/app/oracle/opc_wallet.
Oracle Database Cloud Backup Module initialization file /u00/app/oracle/admin/ORCL/opc_config/opcORCL.ora created.
Downloading Oracle Database Cloud Backup Module Software Library from file opc_linux64.zip.
Downloaded 26933594 bytes in 14 seconds. Transfer rate was 1923828 bytes/second.
Download complete.

Oracle Database Cloud Backup Module Install Tool, build 2016-02-04</strong>

Oracle Database Cloud Backup Module credentials are valid.

Oracle Database Cloud Backup Module wallet created in directory /u00/app/oracle/opc_wallet.

Oracle Database Cloud Backup Module initialization file /u00/app/oracle/admin/ORCL/opc_config/opcORCL.ora created.

Downloading Oracle Database Cloud Backup Module Software Library from file opc_linux64.zip.

Downloaded 26933594 bytes in 14 seconds. Transfer rate was 1923828 bytes/second.

Download complete.

Et voilà – the Oracle Database Backup Service is now configured and ready to use. Time to start RMAN 🙂

DBaaS, Oracle Cloud, TrivadisContent