Tag: DBA Lounge

Database 12c: What’s New with Data Pump? Lots.

Oracle Data Pump appeared with release 10gR1 and has been a best friend for Oracle techs ever since. It offers so much more than traditional export/import, but do not let it detract you from its predecessors for even a second. This article offers an introduction to some of the new stuff in 2cR1.

Read More >

Oracle Database 12c: Network Recovery in RMAN

Over the past 8 months, I have had the pleasure of working on a soon-to-be-released update for our popular Beginner’s Guide for Oracle Database 12c. Many of the new 12c features have fascinated me and my peers. I have thirsted in particular for the following handful of rman enhancements that are bundled with Database 12c…

Read More >

SLOB2 Kick start

A few of my friends asked me to assist them with getting up to speed with SLOB2 testings. I have decided to publish this quick blog post and give people to a few hints. Additional Scripts Here are some of…

Read More >

OEM Notification on Generated Trace Files

The predefined metric “Dump Area Used (%)” can monitor space consumption for dump destination of oracle database. However, it just triggers on percentage occupied, and if there are several databases on the host using the same file system for trace…

Read More >

Connection Resets When Importing from Oracle with Sqoop

I’ve been using Sqoop to load data into HDFS from Oracle. I’m using version 1.4.3 of Sqoop, running on a Linux machine and using the Oracle JDBC driver with JDK 1.6. I was getting intermittent connection resets when trying to…

Read More >

Configuring OID 11.1.1.6 Connector in OIM 11.1.2

Configuring OID 11.1.1.6 connector in OIM 11.1.2 for direct provisioning: There is a big change in the way direct provisioning is done from OIM (Oracle Identity manager) to OID (Oracle Internet Directory) using OIM 11.1.2 connectors.

Read More >

“Thou Shalt Configure MAXDOP For SharePoint 2013” Is No Longer Needed

Last year I started to get involved in the SharePoint community, particularly the SharePoint Saturday events. As a SQL Server DBA, I thought that SharePoint administrators needed to have a fair understanding of the underlying database because it is the…

Read More >

SQL for Pattern Matching in Oracle 12c

Oracle 12c is out! And with it, a myriad of new features that we’ll be learning and playing with in the months and years to come. Paraphrasing Iggy Fernandez’s blog: “So many Oracle manuals, so little time…” The new features…

Read More >

My First Five Minutes with Oracle Database 12c

As many of you know, Oracle Database 12cR1 was released last week, and it did something that I haven’t seen before from an Oracle database release: it caused a blogging storm. According to Steve Karam a.k.a Oracle Alchemist, in less than…

Read More >

Duplicate Database from Active Database — Just Works!

My friend Øyvind Isene suggested that I store a DUPLICATE RMAN script that works in a safe place in this tweet. @yvelik Me too, then I store the script in a safe place :-) Duplicate jobs reminds me how important it…

Read More >