Latest Posts

Enterprise Manager 13cR2 – How to apply Patch 23094292: WLS PATCH SET UPDATE

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 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 server stage directory /u00/app/oracle/stage.


Set the ORACLE_HOME variable to the directory where the Oracle Enterprise Manager 13cR2 is located. In my example the EM13cR2 is installed in directory /u00/app/oracle/product/em13cr2.

Stop running Oracle Enterprise Manager 13c

Apply Patch 23094292: WLS PATCH SET UPDATE

Go to the extracted patch set directory:

Apply the patch:

You can ignore the warning message, it’s because OPatch has to rollback a previous installed patch.

Start Oracle Enterprise Manager 13c


Like the patches which were released for Weblogic / Enterprise Manager before, the installation was very smooth. There were no problems and the EM13cR2 started well after the patch apply.

OTN 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 past in cases like „Dear DBA, I have dropped a table in my development environment, please….“. And there are still many developers outside which don’t know about this feature.

Sure, in 12c we can recover a table fully automated from a backup. But sometimes we don’t want to spend too much time for problems like a dropped table. And sometimes we want to keep it simple.


I do not often participate in the OTN forums, but for the future I will try to reserve some time for this great platform. It’s worth it.

Regards, Martin

Connect 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 Settingsbackup_service_step_00






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 you want to backup to the Oracle cloud from the database target page. Configure Oracle Cloud Backup Service.


The first time when you run the configuration, you need to enter your host credentials for the host where the database is running which you want to configure. Use the username which has installed the database software, or you can use a named credential. Be sure that the server where the backup has to be configured has access to the internet.

After submit, a deployment procedure configures the Oracle Database Backup Service on the server. The Oracle Database Backup Service module will be installed on server.



The deployment procedure copies the tape library for the Oracle Database Backup Service into the $ORACLE_HOME/lib and creates a wallet in $ORACLE_HOME/dbs/opc with the cloud certficates. Bot components are required to use the service.

The EM13c view after the successful deployment. To verify the configuration, press the Test Oracle Cloud Backup Button.


All backups into the Oracle Cloud have to be encrypted, the test run too.


Backup test succeeded.


Execute  RMAN Backup

Now you are able to backup an Oracle database with RMAN into the Oracle Cloud. Schedule a backup.


Schedule a customized backup


On the backup settings page, scroll down to set the encryption mode. You can choose between the wallet and the password method. For more information how to configure a wallet for a backup, take a look at my blog post here: Encrypt RMAN Backups for the Oracle Cloud with a Keystore.

As reminder, database backups with target Oracle Cloud have to be encrypted locally. Otherwise the backup job fails. Activate the checkbox for the password method and set/confirm the password. Next.


Select the Oracle Cloud as destination. Below you can see the used RMAN parameter. Oracle uses the file like a tape driver. Next.


Schedule the execution. Next.


Now you can submit the job or use the syntax in the RMAN script box.


The Backup Management Page shows the Oracle Cloud as Media



The Oracle Database Backup Service is fully integrated in the Oracle Enterprise Manager 13c and it works fine. The EM deploys you  the Oracle backup module on the target servers, once deployed, the configuration can be used for every other database which runs on the same target host as configured.

For more information about the Oracle Database Backup Service, take a look in the documentation here: