12th Day of #Cloud: Thoughts

12 Days of #Cloud: Day 12 After playing with Oracle Database Cloud Service (DBaaS) for past several days, I have mixed feeling. I like quite a lot of features and the amount of automation went into the product. For example, creating an RAC instance and creating a Data Guard instance by picking a check box […]

A Recipe for Summoning the RBO Monster (even in Oracle 12c): On Delete Cascade, Function-Based Index and Missing Table Statistics

The last version of Oracle in which CHOOSE was officially supported as an OPTIMIZER_MODE parameter value was 9.2.
This is what the documentation of Oracle 9.2 says about it:

The optimizer chooses between a cost-based approach and a rule-based approach based on whether statistics are available.
If the data dictionary contains statistics for at least one of the accessed tables, then the optimizer uses a cost-based approach and optimizes with a goal (more...)

Additional new content SOA & BPM Partner Community


· New Features in Oracle SOA Suite 12.2.1 Written by SOA architect and Oracle ACE Associate Sandra Flores, this article presents an overview of key new features in Oracle SOA Suite 12.2.1. Read the article.

· Where is SOA Going? Oracle ACE Director Luis Weir and ACEs Rolando Carrasco and Arturo Viveros, the authors of Oracle API Management 12c Implementation (Packt Publishing) share their insight on the evolution of service oriented (more...)

Happy New Year 2017

Wishing everyone a very happy and prosperous 2017. May all your dreams come true and …..


Work Hard, Stay Positive !!

Cheers !!

Filed under: Oracle

"ORA-16047 – DGID mismatch between destination setting and target database" while configuring dataguard.

While setting up dataguard configuration you may encounter ORA-16047 - DGID mismatch between destination setting and target database.

From alert.log on primary database:

LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
Sat Dec 31 08:29:30 2016
FAL[server, ARC3]: Error 16047 creating remote archivelog file 'sauxmes'
FAL[server, ARC3]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance auxmes - Archival Error. Archiver continuing.
Error 16047 for archive log file (more...)

12 Days of #Cloud: Exploring #DBaaS with Data Guard

12 Days of #Cloud: Day 11 After a few failed attempts, I was successful in creating a Data Guard DBaaS Instance. Since I was playing with a trial account, the resources were limited. I guess when I had another database running, there is not much storage left to create two instances in Data Guard configuration. […]

Investigating IO performance on Amazon EC2

I published a blog post called “Investigating IO Performance on Amazon RDS for Oracle” recently, and soon after posting it I received several questions asking if IO worked the same way on EC2 instances. My immediate though was it did, mostly because RDS for Oracle is basically an EC2 instance with Oracle Database on top of it, where the configuration is fully managed by Amazon. But as always, it’s better to test than (more...)

Xmas day -150 hits. What is wrong with the world

Yes, very tongue in cheek. I know everyone does not celebrate Xmas.

I was still surprised though. This is what was viewed

Best wishes for 2017 to all my readers.


Loading Data into Oracle Cloud ERP R10 using the new LoadAndImportData operation by Angelo Santagata



As part of Oracle ERP cloud release 10 a new SOAP function has been made available to our customers which greatly simplifies the loading of ERP data using the batch oriented SOAP Services.

This article aims to give the reader, details of this new SOAP Service and how it helps in loading data files into Oracle ERP cloud.

Assuming the input file has been already produced, loading the data into Oracle ERP cloud service (more...)

Oracle INSTRB, INSTRC, INSTR2, and INSTR4 Function with Examples

In this article, I’ll explain what all of the variations of the INSTR function (INSTRB, INSTRC, INSTR2 and INSTR4) do, and show you some examples Purpose of the Oracle INSTR2, INSTR4, INSTRB, and INSTRC Functions These INSTR functions are variations of the basic INSTR function, which searches inside a string for a substring, and returns […]

Opening a web link from your MAF app in the device browser app

We've recently received a few inquiries about how to display a web link in a MAF app that will open in the device’s browser app when the user taps on it.

It seems that some teams have been relying on a side effect of whitelisting to circumvent the default MAF behaviour, which is to display the contents of the web link directly in the current WebView.  In earlier releases of MAF, if you did not (more...)

How to Patch Oracle Database on the Oracle Cloud

I was waiting the latest PSU for Oracle Database on the Oracle Database Cloud Service, and today I noticed that it’s available. So let’s see how we can update our Oracle Databases in the cloud.

First we go to the database home to see if any updates is available. As you can see, in the administration box, there is an available patch. We click on it to see the details of (more...)

When local partitions….aren’t

Let’s say I’ve got a partitioned table, and because New Year’s eve is coming around, I certainly don’t want to be called out at 12:01am because I forgot to add the required partition for the upcoming year Smile.

Since 11g, I can sleep easy at night by using the INTERVAL partition scheme. Here’s my table

SQL> create table t ( x date, y int )
  2  partition by range ( x )
  3  interval ( numtoyminterval(1,'MONTH'))

Android app icons and splash screens in JET hybrid apps

If you are using Oracle JET to develop hybrid mobile apps and recently updated to Cordova CLI v6.4.0, you may have noticed that your custom app icons and splash screens are not being included in your app when deployed to Android devices.

This is a known issue with Cordova Android v6.0.0 that has been addressed in the recent v6.1.0 release.  To upgrade to this version, follow these steps: 

  1. Change (more...)

12 Days of #Cloud: Backup #DBaaS to Cloud Container

12 Days of #Cloud: Day 10 In a previous post, I talked about enabling backups on a #DBaaS instance where backups were disabled when the instance was created. Today I show you how to create a database with Cloud Backup enabled at the time of creating the instance. To store backups on the Oracle Cloud, […]

SLOB 2.3 Data Loading Failed? Here’s a Quick Diagnosis Tip.

The upcoming SLOB 2.4 release will bring improved data loading error handling. While still using SLOB 2.3, users can suffer data loading failures that may appear–on the surface–to be difficult to diagnose.

Before I continue, I should point out that the most common data loading failure with SLOB in pre-2.4 releases is the concurrent data loading phase suffering lack of sort space in TEMP. To that end, here is an example of (more...)

NetBeans Git Client for JET Versioning and Oracle Developer Cloud Service

I should say I'm happy with how NetBeans Git client works. It offers good performance and resolves conflicts pretty well.

It shows a list of pending changes and also changes colour for changed file name:

Changes can be committed into local repository through informative wizard:

File changes are displayed in very clear way, easy to understand them:

All local changes can be pushed to Oracle Developer Cloud Service Git (or other repository):

Select a branch (more...)

Fixing Popular Posts Margin on Blogger

I use the Blogger platform for this blog, and I recently added the "Popular Posts" widget to the sidebar. Unfortunately it did not display correctly, with the first character or two of each blog post title being lost and chopped off, as if the whole thing had been shifted to the left for some reason. Here is how I fixed it to display properly.

After a lot of reading up on HTML and (more...)

Oracle Linux 12cR2 Preinstall Package

I was doing some clean Oracle Linux 6 and 7 installs today and look what I noticed in the yum repository for OL6.

Available Packages
oracle-database-server-12cR2-preinstall.x86_64 1.0-1.el6 public_ol6_latest
oracle-rdbms-server-11gR2-preinstall.x86_64 1.0-13.el6 public_ol6_latest
oracle-rdbms-server-12cR1-preinstall.x86_64 1.0-14.el6 public_ol6_latest

And for OL7.

Available Packages
oracle-database-server-12cR2-preinstall.x86_64 1.0-2.el7 ol7_latest
oracle-rdbms-server-11gR2-preinstall.x86_64 1.0-4.el7 ol7_latest
oracle-rdbms-server-12cR1-preinstall.x86_64 1.0-5.el7 ol7_latest

A quick look at the repos and it first (more...)

The Oracle Applications User Experience (OAUX) team has loads of new content that we’re eager to share

clip_image002The Oracle Applications User Experience (OAUX) team has loads of new content that we’re eager to share. Beginning with Oracle Voice, Oracle’s platform on Forbes.com, Group Vice President Jeremy Ashley describes in a recent post how Oracle is addressing specific HCM trends and issues in our cloud application services while keeping that “suite” perspective. What else did we write about in the past month?