ALL POSTS

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 files destination, the metric notifies DBA for all databases at once. I decided to create…

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 import data. After much troubleshooting, I eventually found the problem to be related to a…

EM CLI with Scripting Option in EM12cR3

The new release of #EM12c came with advanced EM CLI, providing interactive and script modes to enhance the standard command line functionality. EM CLI includes Jython interpreter and all verbs presented as functions, which allows the use of verb arguments as parameters. Managing several thousand targets in one of Pythian’s client environments and having different…

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 abound, and we need to cherry pick some interesting ones to delve into. There are…

Log Buffer #327, A Carnival of the Vanities for DBAs

Nelson Mandela, The Madiba, said: ” There is nothing like returning to a place that remains unchanged to find the ways in which you yourself have altered.” Bloggers return to their blogs to experience the same charming thing, and database bloggers are no different. Enjoy this edition of Log Buffer.

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 a week we have had 91 articles from 47 authors regarding this release. For me,…

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 is to practice restore. — Øyvind Isene (@OyvindIsene) July 1, 2013 I couldn’t find a…

Page 38 of 274« First...102030...3637383940...506070...Last »