OUG Ireland : Day 1

I arrived at the Gresham Hotel, registered and went straight down to the first session of the day…

First up was Maria Colgan presenting, “What to Expect from Oracle Database 12c”, a quick romp through the cool features in Oracle 12c (12.1 and 12.2). The room was full so I had to listen form the corridor, with my head occasionally popping round the door to see the screen. Maria’s sessions are always great (more...)

Upgrade of Oracle GI to Oracle Steps

Just noting down the high level steps which were performed for the Upgrade of Oracle GI to Oracle on RHEL 64bit Linux.

Create a backup of 11G GI HOME as root user:

. oraenv <<< +ASM
 sudo su -
cd /oracle/backup
tar -cvf backup_GI.tar /u01/grid/product/
tar -cvf backup_inventory.tar  /var/opt/ora/oraInventory/

Stop all DB instances and listener

run the GI 12c runInstaller in silent mode (more...)

OUG Ireland : The Journey Begins

There is something about early starts that get me so nervous I can’t sleep properly. As a result I was awake before my 05:00 alarm, which gave me plenty of time to get ready. That¬†was good because I hadn’t packed up laptop bag, which was also acting as my overnight bag. ūüôā

The taxi ride to the airport was pretty standard, but I did have a conversation about Roza Bal in Kashmir.

I only had hand (more...)

min/max Upgrade

A question came up on the OTN database forum a little while ago about a very simple query that was taking different execution paths on two databases with the same table and index definitions and similar data. In one database the plan used the “index full scan (min/max)” operation while the other database used a brute force “index fast full scan” operation.

In most circumstances the starting point to address a question like this is (more...)

12cR2 tightens up ORA-01841 for zero year ANSI dates, but not for Oracle SQL syntax

In moving some more code from an 11gR2 database to a 12cR2 database, I found another change where a piece of code that works in 11gR2 doesn’t compile in 12cR2.

In this instance a view was being created with a projected date column which used the ANSI DATE syntax. Here is a simplified test script:

SELECT date '0000-01-01' date_col
FROM dual


PURGEOLDEXTRACTS Not Purging Trail Files

The best part of playing poker is misreading the hand and won.

Well, today this applied to help troubleshoot a Goldengate issue.
Granted it might not be the root cause but it did solve the issue for the time being.


1. Goldengate version 10.4

2. mgr process started with uid vs username

$ id -a
uid=19208(ggsuser) gid=1601(dba) groups=1601(dba)

$ ps -ef|grep ./mgr
19208    18576     1  0 16:05 ?        00:00:00 ./mgr 

3. dirdat is  (more...)

Using Delphix to support Oracle upgrade

I’m working on upgrading a very buggy unpatched¬† Oracle database to a fully patched version. I’m using Delphix to support the upgrade and it has been a big help so far. This is on the HP-UX 11.31 Itanium platform.

The great thing about using Delphix to support an upgrade is that my very first pass through the upgrade scripts was with a full-sized clone of production. In (more...)

Scheduler (DBMS_SCHEDULER) Enhancements in Oracle Database 12.2

Since its release in 10gR1, Oracle have consistently added neat functionality to the “new” scheduler with every database release. Yes, I still call it the new scheduler and you would be surprised how many people still insist on using DBMS_JOB rather than switching to DBMS_SCHEDULER.

Oracle Database 12c Release 2 (12.2) is no exception to this pattern, as once again we have some new stuff to play with.

Iceland is Awesome….and Colder than Utah

I ended up speaking at two events this last week. ¬†Now if timezones and flights weren’t enough to confuse someone, I was speaking at both an Oracle AND a SQL Server event- yeah, that’s how I roll these days.

Utah Oracle User Group, (UTOUG)

I arrived last Sunday in Salt Lake, which is just a slightly milder weather and more conservative version of Colorado, to speak at UTOUG’s (more...)

Working with Oracle Documentation

When I open Oracle documentation to look for something, people usually raise their eyebrows (almost as they do when I open sqlplus). Most of them simply say: “What do you need the documentation for? Just open google and search”. Even though googling stuff usually works, I actually like the documentation (in some aspects at least). … Continue reading Working with Oracle Documentation


One of the difficulties with trouble-shooting is that’s it very easy to overlook, or forget to go hunting for, the little details that turn a puzzle into a simple problem. Here’s an example showing how you can read a bit of an AWR report and think you’ve found an unpleasant anomaly. I’ve created a little model and taken a couple of AWR snapshots a few seconds apart so the numbers involved are going to be (more...)

MobaXterm 10.2

MobaXterm 10.2 has just been released.

The downloads and changelog are in the usual places.

The previous version (10.0) was pulled as it was getting false positives with some AV software. I’m glad to report this one doesn’t get flagged and installs fine!

Happy upgrading!



MobaXterm 10.2 was first posted on March 21, 2017 at 11:36 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal (more...)

End of an era …

Four years ago I wrote about a little volunteer project that my partner did.  A small association that provided outdoor experiences and facilities for kids with physical impairments needed a system to record member and volunteer details, plus a few other bits and pieces.  We built an Apex solution running on XE.  This week, they became part of a larger government initiative, and thus their Apex application was no longer needed and (more...)

adrci purging

I did not know this.

Is there a way to control Auto_Purge Frequency done by the MMON ? (Doc ID 1446242.1)

The automatic purge cycle is designed as follows.
(1) The first actual purge action will be 2 days after instance startup time
(2) The next automatic purge actions following this first purge is done once every 7 days

If you like to purge more often, then it will need to be done manually.

The (more...)

ADRCI Retention Policy and Ad-Hoc Purge Script for all Bases


As you know, since 11g we have a Automatic Diagnostic Repository (ADR). To better manage it, we also have a Command-line Interface, called ADRCI.
ADR contains all diagnostic information for database (logs, traces, incidents, problems, etc).


ADR Structure

View original post 349 more words

Refreshing VDB With Sales History Data

Now that I’ve loaded a ton of transactions and did a bunch of work load on my source database with the SH sample schema and Swingbench, I’ve noted how little impact to the databases using different cloud tools, (which will come in a few later posts) now I’m going to show you how easy it is to create a new VDB from all of this, WITH the (more...)

Log Buffer #507: A Carnival of the Vanities for DBAs

This Log Buffer edition covers Oracle, SQL Server and MySQL blog posts with a touch of Cloud.


Provisioning EBS on Oracle Cloud: Latest Enhancements

ORA-54002 when trying to create Virtual Column using REGEXP_REPLACE on Oracle 12cR2

Business rules, common sense and query performance

Problem with V$RECOVERY_AREA_USAGE view and FRA space not being reclaimed

Updated SQLcl: 2 New Commands, Bug Fixes, and 12cR2 Oh My!

SQL Server:

Windowing Functions: Tell me (more...)

neue DOAG Webseite ist online

Die neue DOAG Webseite ist Online.




Quick Check for Corrupt Block (file #, block #)

$ egrep -n '^Corrupt block relative dba| ^Reread of blocknum' alert.log| tail -50

124974:Corrupt block relative dba: 0x04c7d3be (file 12, block 312452)
124983:Reread of blocknum=312452, file=+DATA/db/datafile/db_data03.329.456465464. found valid data

124974|124983 are line number from alert.log

On reread found valid data, there is no need to proceed further since block has been validated to be . Typically, this occurs when there is a fractured block.

If you have doubts:
RMAN> backup validate check (more...)

benchmarking your disks


While at Delphix, we did a lot of storage benchmarking. The I/O response times of Delphix depends, as one would logically imagine, heavily on the underlying disks. Sure Delphix can cache a lot ( with 1 TB of ram and 3x compression that’s 3TB and that 3TB can be shared by 10 or a 100 copies being the equivalent to 30TB or 300TB of databases) but really there will always be important I/O coming (more...)