The Oracle RMAN backup encryption is necessary if you want to backup your database into the Oracle cloud. In Oracle 12c, you have three methods available to encrypt an Oracle RMAN backup: with a passphrase with a master encryption key hybrid with a passphrase and an encryption key On docs.oracle.com, the basic setup is described here: https://docs.oracle.com/en/cloud/paas/db-backup-cloud/csdbb/configuring-encryption-backups.html#GUID-4A1F5CF5-7EAF-4D71-9B7F-B46412F552CE In this blog post, I show you how to configure your database environment with a master encryption key and a keystore. I use…
Read MoreCategory: 12c
Install and Configure Oracle Application Express with Oracle REST Data Services and Apache Tomcat
In this article I will show you how you can install and configure Oracle Application Express (APEX) and the Oracle REST Data Service (ORDS), which is running on an Apache Tomcat application server. In previous installations I used the Oracle HTTP server and the extenstion mod_plsq. But this does not work anymore with the newest Oracle HTTP server version. In the Oracle Application Express Installation Guide is written: mod_plsql is deprecated as of Oracle HTTP Server 12c (12.1.3). For more information,…
Read MoreDATABASE PATCH SET UPDATE 12.1.0.2.170117 apply fails – catconInit failed, exiting
Last weekend was patchday. The goal was to apply the patch 24732082 (DATABASE PATCH SET UPDATE 12.1.0.2.170117) to a 12.1.0.2 database on AIX. The OPatch precheck returned no error and OPatch apply was ok. The problem was the post step, the datapatch command failed with the message catconInit failed, exiting. oracle@srvaix101:/u00/app/oracle/product/12.1.0.2/dbhome_1/OPatch/ [STRSP01] ./datapatch -verbose SQL Patching tool version 12.1.0.2.0 Production on Sun Apr 2 08:39:35 2017 Copyright (c) 2012, 2016, Oracle. All rights reserved. Log file for this invocation: /u00/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_45548440_2017_04_02_08_39_35/sqlpatch_invocati…
Read MoreOracle Data Pump with the 12.2.0.1.0 Instant Client for Linux x86-64
From the Oracle Database 12c Release 2 (12.2) New Features Guide: Adding Oracle Data Pump and SQL*Loader Utilities to Instant Client This feature adds SQL*Loader, expdp, impdp, exp, and imp to the tools for instant client. Now you can run these utilities on machines that do not have a complete Oracle Database installation. The newest release of the Oracle Instant Client for Linux x86-64 has an additional package called Tools. This package contains Data Pump, SQL*Loader and the Workload Replay…
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…
Read More