Yesterday I wanted to apply a brand new patch to customer’s Enterprise Manager 13cR2 OMS running on Linux. First I updated the OMSPatcher as described here: How to upgrade the 13.1 Cloud Control OMSPatcher to latest version of OMSPatcher (Doc ID 2135028.1). This update was easy. Download, transfer, unzip and copy the OMSPatcher files to the Enterprise Manager ORACLE_HOME directory. Then the patch apply results in an error. OMSPatcher is based on OPatch, he needs an update too. We need a new OPatch Version This was error message for patch apply with omspatcher when I executed the apply command. [Dec 1, 2016 10:17:38 AM] Prerequisite check “CheckMinimumOPatchVersion” failed. The details are: The OPatch being used has version 13.8.0.0.0 while the…
Read MoreAuthor: Martin Berger
Oracle 12.2 – New Features I like – Part 1: Multitenant “Hot Clones”
I like the Oracle Multitenant architecture which was introduced in 12.1. But the concept to clone a source database to multiple copies in a small step had one big problem. In Oracle 12.1, to clone a pluggable database the source database had to be in state read-only. In 12.2 is it not longer necessary to set the source pluggable database in state read-only, the source database has not to be modified to create a clone. Oracle calls it in the documentation “Hot Clone”. Link to the official Oracle documentation: https://docs.oracle.com/database/122/ADMIN/creating-and-removing-pdbs-with-sql-plus.htm#ADMIN13584 Here is a clone of the pluggable database PDB1 into PDB2 in the Oracle Database Cloud Service. Verify existing Pluggable Databases and States – PDB1 is in state READ-WRITE SQL>…
Read MoreEnterprise Manager 13cR2 – How to apply Patch 23094292: WLS PATCH SET UPDATE 12.1.3.0.160719
My fresh EM13cR2 installation showed me that there is a patch for the Weblogic environment available. This patch was released in July 2016: Patch Patch 23094292: WLS PATCH SET UPDATE 12.1.3.0.160719. This patchset has included 157 fixes and is a generic one. The patch is marked in My Oracle Support as recommended. OPatch has no to be updated. This patch is not an online patch, you have to shut down your running EM13cR2 server. This blog post describes the apply of the Weblogic patch set update in an Enterprise Manager 13cR2 environment running on a Oracle Linux server. Prepare Patch Set Update on EM13c Server The patch file has to be extracted. I have copied to file to my EM13cR2…
Read MoreOTN Appreciation Day: The Recyclebin
Tim Hall has initiated in his blog the OTN Appreciation Day, this is my contribution to this nice idea. My favorite database feature is not rocket since, not high available, it is very basic. It is the recyclebin. Since seven years I am working as teacher for Oracle architecture trainings for my company where new DBAs can learn the basics of an Oracle RDBMS. In this training, the participants have very different knowledge about a database. Some are working for years with the database and are here for a refresh, and some are newbies. But in every class there is one guy, who is wondering about the recyclebin functionality. This functionality has saved us a lot of time in the…
Read MoreConnect your Enterprise Manager 13cR2 with the Oracle Database Backup Service
In EM13cR1, it was the first time when the Oracle Database Backup Service was integrated . In Release 2 the configuration menu was extended, a storage container can be defined now e.g. for a better organization and overview of the backups. This blog post shows you how to configure the Oracle Database Backup Service in Enterprise Manager 13cR2 and how to prepare a database for a cloud backup. All you need is the Oracle Database Backup Service, a trial works too. Configure Service Settings Enter your domain and login information. Optional: Set a backup container. A backup container is an organiziation unit like a subdirectory on a server. Configure the Database Select the database which…
Read More