Importing into the Autonomous Data Warehouse using Oracle Data Pump

Introduction This post details the steps required to import into the Autonomous Data Warehouse (ADW) using the Oracle Data Pump Import utility on Oracle Cloud Infrastructure (OCI). Versions OCI Compute    Oracle-Linux-7.6-2018.11.19-0 Instant Client for Linux x86-64 (64-bit) ADW DB   SQL Developer Assumptions An Oracle Cloud […]

Machine Learning with Oracle Database Advanced Analytics

TL;DR: Oracle DB + Oracle Data Mining + Oracle R Enterprise = Database Advanced Analytics (OAA) The Database Advanced Analytics option allows running Machine Learning algorithms within the database itself. The on-prem flavor of OAA is available as part of database Enterprise Edition 12c and upward releases. In OPC, OAA is available as part of […]

Adding Web Service Trusted Certificates to a Wallet in Oracle Database Cloud Service

Introduction This post documents how to add trusted TLS/SSL certificates to an Oracle Database as a Service (DBaaS) wallet. It uses an example of an Oracle Business Intelligence Cloud Service (BICS) REST API call to Delete Cached Data as documented in REST APIs for Oracle BI Cloud Service. This call is issued from PL/SQL and […]

Oracle GoldenGate: Network Apply to SQL Server

Introduction Oracle GoldenGate (OGG) best practices dictate that the OGG Apply process run on the target database server. However, there are instances where this configuration is not practical. In this article we shall discuss a solution where OGG Apply may be configured on a mid-tier server and apply data over a network to a remote SQL […]

Integrating Oracle Project Cloud with Documents Cloud Service using REST APIs and business object-level security.

Introduction Oracle Documents Cloud Service (DCS) enables collaboration through rich set of social and mobile-optimized features. Customers often come across requirements to integrate DCS to Oracle Applications cloud. Such integration improves productivity by taking advantage of features of DCS Service. In this post, let’s take a look at integrating Project Management Cloud, a part of Oracle […]

How to emulate 10g Adapter start/stop behaviour by manipulating the InboundThreadCount parameter

Introduction In 10g, there was a mechanism for suppressing consumption of messages at the Adapter level. That mechanism can not be used in 11g. But there is a way… Main Article The way to do this is to set the InboundThreadCount in the appropriate MBean to zero. This will effectively suppress consumption of messages – […]

Oracle GoldenGate: Heterogeneous Database Initial Load Using Oracle GoldenGate

Introduction Many times when working with customers, we hear “We were told never to use Oracle GoldenGate (OGG) to do initial loads, so how do we load our non-Oracle data to Oracle?” It is true that native database utilities can be used to make copies of large databases faster than OGG in a homogeneous (like-to-like) […]

A convenience method for closing multiple resources

Introduction Ensuring that resources (e.g. database connections) are properly closed to avoid leaks can make your code cumbersome. This article offers a simplification for this issue. Main Article As with all things Java, it’s often best to show by example. So that’s exactly what I’m going to do. The example that we’ll work with is […]

Oracle GoldenGate: Using the GGSCI !, History, and FC Commands

Introduction The Oracle GoldenGate Command Interpreter (GGSCI) contains three commands that can be used to reduce the amount of typing required to interact with the product. These commands come in handy when troubleshooting, monitoring, and configuring large environments; or if, like myself, you are QWERTY keyboard challenged. This article discusses the function and use of […]

Oracle GoldenGate: Using Macros

Introduction Oracle GoldenGate (OGG) Macros provide functionality for sharing parameters or other run-time configuration settings across multiple components and externalizing complex configuration settings in order to streamline parameter file contents. In this article we shall discuss how to create a Macro Library and access specific Macros via the OGG Group parameter file. Main Article A […]

How to secure Web Services exposed by OAAM Server (oaam_server)

At the end it turned out very simple but I had spent long time in configuring security (authentication and authorization) for Web Services exposed by OAAM 11gR2, thought about writing a blog post on it. For native integration, OAAM Server (oaam_server) exposes Web Services. For the enterprise deployment, security of Web Services would be mandatory.  […]

Database Objects Creation Sequence Could Impact Oracle GoldenGate DDL Replication

Introduction The way in which a schema is set up and objects are created in the source and target environments could impact Oracle GoldenGate DDL replication. This is illustrated by the example in this document. Main Article For Oracle GoldenGate (OGG) DDL replication to work correctly, the source and target schemas should be identical. Sometimes even […]

Oracle GoldenGate database Schema Profile check script for Oracle Database

Introduction This script is intended to query the database by schema to identify current configuration and identify any unsupported data types or types that may need special considerations for Oracle GoldenGate in an Oracle environment   Main Article The complete script can found on the Oracle Support site as document ID:1296168.1     All content […]

Adding and removing WebCenter Content cluster nodes

If you follow the Enterprise Deployment Guide, Fusion Middleware High Availability guide, or the support technote onexample steps for installing a multi node cluster of WebCenter Content 11g, they all cover establishing a multi node cluster using …

Idoc Script Plug-in for Notepad++

For those of you that caught it in an earlier post, Arnoud Koot wrote a great Idoc Script plug-in for Notepad++.  Well, he’s back at it and has written an update for 11g!

[Read More] 

Protecting a WebCenter app with OAM 11g

Last year I wrote an article on OAM and ADF Applications with Anonymous access. This week I did some work with another A-Team guy building on that previous work.The new requirement was that the customer wanted two different portions of the app to be pr…

Problems with hosts file and “TNS:could not resolve the connect identifier specified”

If you update your hosts file as I described in a recent post to disassociate with your host name you may get an error when you try to spin up anything using the database “TNS:could not resolve the connect identifier specified”.

This is not technically a middleware problem – it’s a problem with the database. But if you’re like me you’re probably not a database expert and won’t know how to fix it.

So here’s how to fix it… First the symptom:
You can use sqlplus to connect to the database with a valid username and password (e.g. system/ABcd1234) works, but if you add the at sign and the SID (e.g. system/ABcd1234@orcl) things go sideways.

Like so:

[oracle@idm11g ~]$ . /usr/local/bin/oraenv
ORACLE_SID = [oracle] ? orcl
The Oracle base for ORACLE_HOME=/home/oracle/database/product/11.2.0/dbhome_1 is /home/oracle/database
[oracle@idm11g ~]$ sqlplus system/ABcd1234

SQL*Plus: Release Production on Wed Jun 1 14:52:14 2011

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> Disconnected from Oracle Database 11g Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@idm11g ~]$
[oracle@idm11g ~]$ sqlplus system/ABcd1234@orcl

SQL*Plus: Release Production on Wed Jun 1 14:52:17 2011

Copyright (c) 1982, 2009, Oracle. All rights reserved.

ORA-12154: TNS:could not resolve the connect identifier specified

to fix it: 1. Find your tnsnames.ora (mine’s in /home/oracle/database/product/11.2.0/dbhome_1/network/admin/tnsnames.ora) and cat/more/less it. It will look something like this:

# tnsnames.ora Network Configuration File: /home/oracle/database/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

2. Copy the part starting with “(ADDRESS =” through the closing paren. In my case that’s “(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))” 3. run “sqlplus / as sysdba”

4. type in

alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))' scope=both;

make sure you update that line to reflect the contents of your tnsnames.ora file.

You may want to reboot to make sure everything works the next time you start the VM, but that’s not actually necessary.

Hope this helps someone!

Installing Oracle XE database on 64-bit Ubuntu

After many years, I took a fresh look at Ubuntu, and I found it to be great!  So naturally, I wanted to install Oracle XE database to play around with.  But this comes as a 32-bit rpm.  What to do? … Continue reading

Free space in Oracle tablespaces

I occasionally want to know what tablespaces I have defined, how big they are and how much free space is available. Thanks to Praveen at for providing the following query, which makes this information available easily. set pages 999; … Continue reading