AskTom and formatting

There’s an interesting “debate” going on under AskTom at the moment.  It’s hardly cause for major concern, but anyone is welcome to add their thoughts as comments to this blog post.  (Naturally, if your comments agree with my opinion, then that’s great.  If your comments don’t agree, then I’ll post them and ignore them Smile – ah the joys of being a blog owner)

So here’s the issue.  When we are posting (more...)

Top 8 Strategies to Thrive at Oracle OpenWorld

Yes! It’s that time of the year again when we start planning for the premier Oracle OpenWorld. So let’s get right into it! Read more here – Top 8 Strategies to Thrive at Oracle OpenWorld . . . . . . Realted article – Advanced Sessions at Oracle OpenWorld 2015 . . .

The post Top 8 Strategies to Thrive at Oracle OpenWorld appeared first on VitalSoftTech.

Arise from the flashback ashes……

If you're read some of my older stories on this blog you'll know I've had some interesting battles with flashback over the past couple of years... don't get me wrong i think it's (arguably) the best feature introduced over the past 10 years (i'm talking about all the different flavours of flashback with that comment).

Today i hit a whole series of random errors discovered a minor  new (well new to me) syntax to a (more...)

Database system target in pending status for standby database in OEM 12c

That’s not really a problem but annoying issue I had with OEM 12c. Once a standby database is promoted, the database system for the same is showing as metric collections error OR Status Pending.

The standby database doesn’t need its own system since it will join the primary database system. The solution is to associate the standby database with the primary system and then remove the standby database system.

For example – we’ve got primary (more...)

All Flash Arrays: Where’s My Capacity? Effective, Usable and Raw Explained


What’s the most important attribute to consider when you want to buy a new storage system? More critical than performance, more interesting than power and cooling requirements, maybe even more important than price? Whether it’s an enterprise-class All Flash Array, a new drive for your laptop or just a USB flash key, the first question on anybody’s mind is usually: how big is it?

Yet surprisingly, at least when it comes to All Flash Arrays, (more...)

Fun with array fetch

I’ve lost track of the number of times I’ve worked with systems that didn’t run brilliantly because every database operation was the “row at a time” methodology.  Typically you see hundreds of routines (either in the database in PL/SQL) or further up the chain in C#, Java etc, and the “alarm bells” start ringing in my head when all of those routines are prefixed with “GET_” and the input parameter looks like a primary (more...)

Cloud Control : Some minor issues (fixed)

em-12cSince the upgrade to Cloud Control, we’ve been having a couple of issues, mostly around EMCLI.

Some of our databases use Service Guard, so you don’t know which node they are running on. Rather than having an agent per package, we have one on each node. One of my colleagues wrote a little script to check which node the instance is running on, and relocate it if it has moved. This (more...)

El Crap-itan

In the comments from yesterday’s post, Jonathan Roden mentioned the release of El Capitan. At that point, I hadn’t even heard about it. :) Being the naive idiot I am, I jumped head long into it.

The download was about 3G, which didn’t take too long. The upgrade itself took quite a while. That included one failure. During the installation, the system rebooted, as it said it would, and I thought it was over, but it was (more...)


I’m a bit of a dinosaur when it comes to how long I’ve been using Oracle.  But you should never stop learning.  That’s why I’m participating in a cool OpenWorld session in a few weeks, all about the modern technologies and frameworks that can now be used to build awesome applications on top of the Oracle database.  Come along – you’ll see some exciting stuff.  This session is all about modern (more...)

Critical Background Processes in Oracle Database 12c

There are several background processes running when you start Oracle Database 12c instance. Here is an example from one of the instances.    ora_acms_bt9prod1  ora_lreg_bt9prod1 ora_p00w_bt9prod1  ora_aqpc_bt9prod1  ora_m000_bt9prod1  ora_p00x_bt9prod1  ora_asmb_bt9prod1  ora_mark_bt9prod1  ora_p00y_bt9prod1  ora_cjq0_bt9prod1  ora_mman_bt9prod1  ora_p00z_bt9prod1  ora_ckpt_bt9prod1  ora_mmnl_bt9prod1  ora_ping_bt9prod1  ora_dbrm_bt9prod1  ora_mmon_bt9prod1  ora_pmon_bt9prod1  ora_dbw0_bt9prod1  ora_o000_bt9prod1  ora_ppa6_bt9prod1  ora_dbw1_bt9prod1  ora_p000_bt9prod1  ora_ppa7_bt9prod1  ora_dbw2_bt9prod1  ora_p001_bt9prod1  ora_psp0_bt9prod1  ora_dbw3_bt9prod1  ora_p002_bt9prod1  ora_pxmn_bt9prod1  ora_dbw4_bt9prod1 […]

Setting NUMWIDTH in PL/SQL Developer

This post is based on a problem I was asked to look at recently.
A colleague was using PL/SQL Developer to compare two tables in an Oracle 11 database. He was matching the rows on a key column then checking the corresponding values from a different column and reporting them if they did not match. His query returned almost 2000 rows but they appeared to have equal, not different values. Five people looked at (more...)

Adding Music to Code On Your Raspberry Pi

So as I prepare for next week, coaching with some other great folks with the Oracle Education Foundation using the Raspberry Pi, I wanted to add some fun music into my code to work with our motor mascot project.  To do so, you need a few things:

  1.  A small speaker with a 3.5 plugin to the Raspberry Pi.  I have a small, round, rechargeable one that I love.
  2. Have an FM radio station that streams (more...)

Submit an abstract for Georgia Oracle User Group (GaOUG) Tech Day 2016

In 2014, myself and a few other well known speakers in the Atlanta area were added to the board of directors for the Georgia Oracle User Group (GaOUG). With us being added to the Board of Directors, we initatied a rebranding of the user group from GOUSER to GaOUG in Feburary 2015, with much success. Then followed that event up with two quarterly events in April and July 2015, which proved to be an even (more...)

A New Version of an Old Trick

A long, long time ago, people started using the following SQL idiom:

with t as (select /*+ materialize */ …..)

select …. from t

If my memory serves me right, Jonathan Lewis was the first person whom I saw using this idiom. The use of that idiom was to speed create a global temporary table and reuse the query results, without having to re-execute query again. Here is an example:

SQL> set autotrace on


ORA-16038 ORA-19809 ORA-00312

Database startup fails:

ORA-16038: log one sequence 3144 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312 online log 1 thread 1 <path to redo log file>

In the alert.log:
ORA-16014 signalled during: ALTER DATABASE open …
ORA-19815: WARNING: db_recovery_file_dest_size of xxx bytes is 100.00% used, and has 0 remaining bytes available.

solution :

support id : Flash Recovery Area Full – Database Fails to Open ORA-16038 (Doc ID 337258.1)

VirtualBox, Oracle 12c and Macs

Just a quick comment about something I noticed while rebuilding a test VM on my Mac. There is a long lead up to this, so bear with me…


I use VirtualBox on three different host operating systems.

Mac : My main desktop is a Mac, so most of my tests are done using Oracle 12c on Oracle Linux 6 or 7, running under VirtualBox. Most of the VMs I use are quite old, but I (more...)

Using dynamic variables for shell scripting

So you may ask, why go through all the trouble?

Have you ever had to move scripts from one directories to another to find out the script is now broken?

This is due to the hard coding of the location for SQL script in the shell script.

When possible, I would like to separate shell / SQL scripts so they can be run individually and easier for debugging.

Don’t you hate it when copy/paste SQL (more...)

creating a pluggable database from an existing non-CDB Using the DBMS_PDB package

There are three ways of creating a pluggable database from an existing non-CDB:
• Using the DBMS_PDB package to generate metadata and then creating the pluggable database
• Data Pump (using the transportable tablespace feature)
• GoldenGate replication

Note :

When using the DBMS_PDB package to convert a non-CDB to a pluggable database, the non-CDB must be Oracle12c or higher.

Take care of your Non CDB and CDB chraceter set (more...)

VirtualBox 5.0.6

VirtualBox 5.0.6 has been released.

It’s a maintenance release. You can find the downloads and changelog in the usual places.

Happy upgrading!



VirtualBox 5.0.6 was first posted on October 3, 2015 at 2:31 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Oracle Database Developer Choice Awards-Every Vote Counts….

In case you haven’t heard about Oracle Database Developer Choice Awards already-this is the time to vote for the chosen finalists of various technology categories. These finalists are selected by a panel of Oracle ACE community members among the following 5 categories.

Steven Feuerstein has written about these awards here and also has published the list of the finalists.

So if you haven’t voted (more...)