RAC and preventing Active Data Guard: My experiences
When you happen to have a customer that want’s to use Data Guard on Oracle RAC without a license for Active Data Guard then you might want to read this …
Category: DBA Oracle
SQL*Plus / SQL*Net Dead Connection Detection
November 28, 2014
Architecture, Database, Databases, DBA Oracle, Oracle, Oracle WebLogic Server, Platform Technology, Virtualization and Oracle VM
No Comments
Recently I came across the situation where I knew for a fact that my sessions to the database were dead because I pulled the power plug out of my application …
Sometimes the cause of a TNS error is ….
A couple of months ago one of my customers had a failed data ware house report. There was a ORA-12592 (TNS) error message generated. I turned out not to …
How to make a time consistent export dump using the expdp datapump utility
In those old days when there was the exp utility we made a time consistent export dump by using the consistent=y parameter. But today, in fact a couple of …
SQL> Select * From Alert_XML_Errors;
August 29, 2014
Database, Databases, DBA Oracle, Development Tools, Oracle, Software Development, SQL
No Comments
Once you are able to show the xml version of the alert log as data in database table Alert_XML, it would be nice to checkout the errors with accompanying …
SQL> Select * From Alert_XML;
By mapping an external table to some text file, you can view the file contents as if it were data in a database table. External tables are available since …
Sqlnet tracing during nightly hours…
A TNS error at night… Sometime ago my data warehouse colleague came to me with a TNS error. At night times he runs his batch jobs in order to …
Materialized views: fast refresh, complete refresh or recreate?
Have you ever wondered why it takes a century to completely refresh your materialized view? I did, so I did some testing. Recently I was asked to support a …
Oracle InMemory compared to indexing
In August 2014 Oracle released its RDBM 12.1.0.2 with a potentially useful and exiting new option: Database InMemory. Upon reading about it it became clear to me that this …
Cloud Control authorization with Active Directory
About 2 months ago I wrote an article about setting up user authentication in Cloud control, based on their account in the Active Directory. As promised, here is the …
Oracle Restart to autostart your oracle database, listener and services on linux.
Half a year ago, my colleague Remco wrote an article on auto starting the listener and the databases after a host reboot. As usual with Oracle, there are several …
Cloud Control: How a Camel can make you cross a Data Guard Mountain
July 9, 2014
Cloud, Database, Databases, DBA Oracle, Enterprise Manager, Oracle, Platform Technology
No Comments
In my recent post I already mentioned it a little bit: Integrating your manual Data Guard Broker configuration in OEM Cloud Control can become a sort of climbing a Mountain. …
How to add your Standby Cluster Database to Cloud Control
July 6, 2014
Cloud, Database, Databases, DBA Oracle, Enterprise Manager, Platform Technology
No Comments
The last few months I’ve been working with Oracle Data Guard, reading lots of manuals and (parts of) books, to make smart decisions and get a solid foundation. I consider …
Provisioning an Oracle 11g database VirtualBox VM with Vagrant and Puppet for dummies
Outline This post shows you how to setup an Oracle 11g database VM with the use of Vagrant and Puppet in straightforward steps. Anybody can execute this without knowledge …
Cloud Control authentication with Active directory
If your company is preferring Microsoft Active Directory as a source of truth (or at least you´re trying to) you should be using the AD as source for the …
The Performance-button on Oracle Warehouse Builder Design Center
Hereby a somewhat embarrasing story about a performance problem with an Oracle Warehouse Builder – database (11.2.0.3). Embarrasing, while it took too much time to figure out what was …
Fast delete of many files in LINUX and WINDOWS
One of my customers ( Oracle Database 11gR2 on LINUX ) never noticed the Oracle software LUN filling up until a “df -h” reported 97% used, wondered why, and …
A short guide to networking in Virtual Box with Oracle Linux inside.
This post is intended to be a dummy guide, best practices, or whatever you call it… about setting up a network while working with virtual boxes on a desk- …
Autostart your oracle database and listener on linux
Have you ever been wondering like me why DBCA doesn’t present you with the option, whilst creating your single instance database, to have it autostarted upon system boot? I …
Easy setup of the query_partition_clause of row_number() for dedup(lication)
![Easy setup of the query_partition_clause of row_number() for dedup(lication)]({"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"http:\/\/seattletimes.nwsource.com\/ABPub\/2012\/08\/02\/2018836700.jpg","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"} "Easy setup of the query_partition_clause of row_number() for dedup(lication)")
Finding and getting rid of duplicate records in a table is easy…. The row_number() over ( <query_partition_clause> <order_by_clause> ) analytic function is helpful in determining not only the number …
Configuring a private DNS server on Openfiler for use with Oracle RAC 12C on Virtual Boxes
December 30, 2013
AMIS, Architecture, Database, DBA Oracle, Oracle, Oracle 12, Virtualization and Oracle VM
No Comments
To build an Oracle 12C RAC database – on Virtual Boxes – there’s at least shared storage needed for ASM, and a DNS-server for the SCAN-addresses. Several methods can …
Where is my wallet – loosing the encryption master key in 11g db, compatibility in 12c
A while ago I configured an encrypted column in a table for a customer in database 11g. To achieve this, a wallet had to be created outside the database. …
The AMIS Summary of Oracle OpenWorld 2013 is available for download – 60-page white paper
Oracle OpenWorld is a monster event – 10Ks of attendees, thousands of sessions and 100Ks of private conversations that all help convey and define the message about Oracle’s strategy …
You consolidated your applications in one database, but now one application needs recovery…
Imagine this: You have consolidated you applications into one database (version 10gR2). You take a full backup every Tuesday and Thursday evening and an archivelog backup every few hours. …
Oracle Database 12c: XMLIndex Support for Hash Partitioning
XMLIndex support for Hash Partitioning is now also supported in Oracle 12c. In Oracle 11 there was already support for RANGE and LIST partitioning, but not yet for HASH …
15 juli – Oracle Database 12c revealed
Afgelopen dinsdag is Oracle Database 12c beschikbaar gekomen, de nieuwste generatie van de Oracle database. AMIS biedt Oracle professionals de eerste mogelijkheid om de vernieuwingen in Oracle Database 12c …
Oracle Database 12c: Export by View
A small enhancement, but what a golden nugget! At least that’s what I think. 😉 It is now possible in Oracle 12c to export data via a view. I …
Oracle Database 12c: DB Express – Sneak Peek
The new Database Express or DB Express database utility is different from the former DB Console. It is based on flash and “built-in” the database. To give you a …
Oracle Database 12c: Getting Started with DB Express
Oracle DB Express is the new replacement for Oracle DB Console in the Oracle 12c database. Here are some first steps to get started. Oracle DB Express makes use …
Oracle Database 12c: Oracle XMLDB is now Mandatory!
Is this one of my highlights? No not really, but it is a remarkable one. Oracle XMLDB functionality is now mandatory and can not be uninstalled. As mentioned in …
Understanding Storage, Masterclass by James Morle
Today was the first day of the two day Masterclass “Understanding Storage” by James Morle at AMIS. After having reserved my participation in this Masterclass on March 12th, the …
Hotsos Revisited 2013 – Presentatie materiaal
April 3, 2013
AMIS, Architecture, Big Data, Database, DBA Oracle, Development Tools, Oracle, Software Development, XML
No Comments
Hierbij nog dank voor allen die aanwezig waren bij de weer gevulde, informatieve & gezellige avond tijdens “Hotsos Revisited 2013”. Wij presentatoren hebben genoten van het ambiance. Hier ook …
Masterclass with Oracle ACE Director James Morle
AMIS is spending a lot of effort keeping our people up-to-date with the latest knowledge needed to help our customers the best way we can. Traditionally we also always …
Hotsos 2013 – Presentation material “Creating Structure in Unstructured Data”
Hereby, for those who want another look or for people to share, my presentation content “Creating Structure in Unstructured Data” given during the Hotsos 2013 Symposium on Monday morning. …
Hotsos 2013 – From Unstructured to Structured…
It has been a while that I have been attending Hotsos, although that is how it feels. In 2011 I flew to Hotsos to see, among others presentations from …
Hotsos Revisited 2013
January 28, 2013
AMIS, Architecture, Big Data, Database, DBA Oracle, Oracle, PL/SQL, XML
No Comments
Van 3 tot en met 7 maart vindt in Irving, Texas, het internationale Oracle performance Hotsos Symposium plaats. Dit jaar belooft het symposium een garantstelling voor inhoudelijk hoogstaande presentaties …
Basisregistraties Adressen en Gebouwen – Het importeren van Kadaster BAG data in een Oracle Database
Vorig jaar heb ik behoorlijk wat vragen gekregen over of er een tool was, een methodiek, om BAG data van het Nederlandse Kadaster in een Oracle database te krijgen …
How-to backup Oracle RAC 11gR2 Database with RMAN
RAC and single instance RMAN backup is similar, but… Backup of a 11gR2 RAC database is similar to that of a single instance 11gR2 database. There is an important …
AMIS vat Oracle OpenWorld samen in speciale whitepaper
Als sluitstuk van de jaarlijkse Oracle OpenWorld conferentie brengt AMIS een whitepaper uit. Een handzaam document waarin het volledige verhaal van Oracle OpenWorld 2012 is gebundeld. Een team van …
Configure FMW servers with Puppet
October 13, 2012
Architecture, Continuous Delivery, DBA Oracle, Development Tools, Java, Oracle WebLogic Server, SOA, Tools
No Comments
When you have many development servers or cloud servers which runs Oracle software and then you know that configuration management of those servers is very important and must be …