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, please see My Oracle Support Note 1576588.1. Oracle recommends using Oracle REST Data Services instead. Oracle REST Data Service is the future – so let’s go to the future. Installation Steps Installation and Configuration Oracle Application Express 5.1.1 Installation and…
Read MoreCategory: Oracle Tools
DATABASE 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 on.log Connecting to database…OK catconInit failed, exiting Please refer to MOS Note 1609718.1 and/or the invocation log /u00/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_45548440_2017_04_02_08_39_35/sqlpatch_invocation.log for information on how to resolve the above errors. SQL Patching tool complete on Sun Apr 2 08:39:36 2017 The solution was…
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 Client for Real Aplication Testing. The good old import export tools is included too. This is very nice. For example, if you want to load application log files with SQL*Loader into the database which are located on a separate server,…
Read MoreOPatch 13.9 in EM13c – Say Goodbye to Unzip, Copy & Paste
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 MoreOracle 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 More