GoldenGate 12.2 Patch 17030189 required Integrated trail format RELEASE 12.2 or later

EXTRACT Abending With OGG-02912 (Doc ID 2091679.1)

Alternate script prvtlmpg.plb (included in the Oracle GoldenGate installation directory) to the mining database to work around this limitation.

$ ll prv*
-rw-r-----. 1 oracle oinstall 1272 Dec 28  2010 prvtclkm.plb
-rw-r-----. 1 oracle oinstall 9487 May 27  2015 prvtlmpg.plb
-rw-r-----. 1 oracle oinstall 3263 May 27  2015 prvtlmpg_uninstall.sql

The other option in this (more...)

Create GoldenGate 12.2 Manager

I typically don’t like to see WARNING if I can help it.

Goldengate 12c has some security features to allow/prevent unauthorized access.

Be careful. Incorrect IPADDR or PROG is used will prevent Pump Extract delivery to target server.

$ tail -100 ggserr.log
2016-05-22 12:25:07  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start mgr.
2016-05-22 12:25:07  WARNING OGG-01877  Oracle GoldenGate Manager for Oracle, mgr.prm:  Missing explicit accessrule  (more...)

Create GoldenGate 12.2 Wallet

So what’s different from this post versus other posts? I share my mistakes with you.

Did you know there was a DEFAULT domain? If you didn’t, neither did I and only found out by using

info credentialstore

alter credentialstore add user ggs_admin alias ggs_admin domain admin
USERIDALIAS ggs_admin DOMAIN admin

alter credentialstore add user ggs_admin alias ggs_admin

$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0. (more...)

SQLcl New Version and Other Big Stuff

I’ve been meaning to write about SQLcl for quite some time now – a lot is happening in the SQLcl world – but I hadn’t had the chance due to my very busy schedule.

Since some bigger things had happened recently, I feel it is a good opportunity to write about it. I promise to take some time to write (and maybe even video) some guides for SQLcl in the near future.

Okay, enough with (more...)

Video : Indexing JSON Data in Oracle Database 12c

Following on from last week’s post, today’s video is about indexing JSON data in Oracle Database 12c.

If videos aren’t your thing, you might want to read these articles, which the videos are based on.

The cameo in this video (more...)

Oracle Audit Control part 3 – OS files

Just realized that I wrote a follow-up to Part 2 2 years ago and never posted it! So here’s the stripped-out key facts to round off auditing control a bit more:

Deleting O/S audit files is, like, totally necessary. In Oracle 12C (12.1), they are created by default as AUDIT_SYS_OPERATIONS defaults to TRUE now, so you are going to be filling up your AUDIT_FILE_DEST whether you realized it or not.

[NOTE: In theory, this (more...)

The Digital Hotel Key

Generally, I’m not in favor of consolidating important stuff onto my phone, e.g. credit cards, etc. because if I lose my phone, I’ll lose all that stuff too.

However, I’ve been waiting to try out a digital hotel key, i.e. using my phone to unlock my hotel room. Only a few hotels and hotel chains have this technology in place, and recently, I finally stayed at one that does, the Hilton San Jose.

Much (more...)

EM13c Monitoring Non-Oracle Databases

This last week I presented at Great Lakes Oracle Conference, (GLOC16) and the discussion on monitoring of non-Oracle databases came up while we were on the topic of management packs, how to monitor usage and what ones were required to monitor non-Oracle databases.  I didn’t realize how confusing the topic could be until I received an email while in on layover in Chicago and relaying what (more...)

Joining to a pipelined table function and “left correlation”


A pipelined table function may be called from regular SQL using the TABLE collection expression, e.g.

FROM   TABLE(my_pipelined_function('ABC','DEF'));

where ‘ABC’ and ‘DEF’ are the inputs to the function.

What if you want to call the function repeatedly for several sets of inputs, e.g. testing the function for a variety of values? If those inputs are stored in a table somewhere, it ought to be as easy (more...)

Optimizer-Features unterschiedlicher Oracle-Versionen vergleichen

Nigel Bayliss stellt im Blog der Oracle Optimizer Entwicklung ein nützliches Skript vor, mit dessen Hilfe man die Optimizer Features unterschiedlicher Oracle Releases vergleichen kann. Das Skript legt diverse Hilfstabellen an und greift auf v$session_fix_control, sys.x$ksppi und sys.x$ksppcv zu, für die man demnach Lesezugriff benötigt. Kann man natürlich auch von Hand machen, aber ein passendes Skript macht dergleichen komfortabler.

LittleArduinoProjects#203 Homopolar Motor

What happens when electric fields cut across magnetic fields? A force is generated, and the homopolor motor is the classic demonstration.

As always, all notes, schematics and code are in the Little Electronics & Arduino Projects repo on GitHub.

Oracle DBA en SQL Celebration Day June 7th, 2016

On Tuesday, June 7th, 2016 the Dutch Oracle Usergroup (OGh) will organize the Oracle DBA…

RMAN-06172 when restoring a controlfile and dNFS is not turned on

Oracle EE on Linux x86-64.

I got a really surprising error message today when setting up a new data guard standby database.
I created a standby controlfile as usual and placed it on a common NFS share accessible also to the new data guard host:

SQL> alter database create standby controlfile as '/nfs/install/oemdb/cf2.f';

Database altered.

Now, on a new node I tried to restore that controlfile, but got a really (more...)

ORAchk / EXAchk questions

Yesterday I wrote a post on the ORAchk / EXAchk plug-in in Enterprise Manager Cloud Control 13c, and I promised I would write another post that would cover some of the more frequently asked questions we’ve been receiving on the plug-in. That’s what this post in, so the rest of the post will be in a Q&A sort of format.

Question: What are the benefits of EXAchk integration with the Enterprise Manager compliance framework i. (more...)

cloud control won’t start!

Hot on the heels of the db block corruption i then get this (same server) - not sure it's directly related but could well be...

[oracle@ccserver ~]$ emctl start oms 
Oracle Enterprise Manager Cloud Control 13c Release 1 
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved. 
Starting Oracle Management Server... 
WebTier Successfully Started 
Oracle Management Server Could Not Be Started 
Check EM Server log file for details: /oracle/gc_inst/user_projects/domains/GCDomain/servers/EMGC_OMS1/logs/EMGC_OMS1.out 
Oracle Management Server (more...)

Battle of the Mountain – Camerig 2016

Battle of the Mountain – Camerig 2016

Battle of the Mountain teamVoor de eerste keer in het bestaan van deze blog wil ik jullie vragen om mij te sponsoren in de strijd tegen ALS. Je bijdrage gaat dan naar internationaal genetisch onderzoek naar ALS met behulp van Data Mining. Als prestatie van mijn kant staat daar deelname in een cycling challenge – Battle of the Mountain op de Camerig – tegenover waarover je hieronder meer kan lezen.


Amyotrofische (more...)

Big Data SQL Quick Start. Data types – Part8.

Today I'm going to share one of the easiest way to improve overall Big Data SQL performance. Big Data SQL is the complex system, which contains two main pieces - Database and Hadoop. Each system has own datatypes - Oracle RDBMS and Java. Every time when you query data from Oracle RDBMS you do data conversion. Data... [Read More]

Messed-Up App of the Day: Tables of Numbers

Quick, which database is the biggest space consumer on this system?Database Total Size Total Storage-------------------- --------------- ---------------SAD99PS 635.53 GB 1.24 TBANGLL 9.15 TB 18.3 TBFRI_W1 2.14 TB ... [Read More]

Messed-Up App of the Day: Tables of Numbers

Quick, which database is the biggest space consumer on this system?
Database                  Total Size   Total Storage
-------------------- --------------- ---------------
SAD99PS 635.53 GB 1.24 TB
ANGLL 9.15 TB 18.3 TB
FRI_W1 2.14 TB 4.29 TB
DEMO 6.62 TB 13.24 TB
H111D16 7.81 TB 15.63 TB
HAANT 1.1 TB 2.2 TB
FSU 7.41 TB 14.81 TB
BYNANK 2.69 TB 5.38 TB

Block corruption!

After a couple of weeks off my first day back was a little surprising. I got an ORA-1578 block corruption error for the first time in years. This was on our new system hosted in Azure, whether the fact this is on Azure and this has somehow caused the corruption in the way the VM etc is set up i don't know but it's certainly something to keep an eye on.

Anyway the error from (more...)