DBA Lounge

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…

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…

Training from a MySQL DBA’s Perspective

I’ve been pondering the next step in my training path; what do I want to learn or improve upon? You see, here at Pythian we’re encouraged to be the masters of our own progress. If you’re ever lucky enough to be on my side of the Pythian fence, you will see that there are provisions…

Exchange Server 2010 with Oracle Workflow Mailer

Almost all Oracle E-Business Suite DBAs will run into this problem if they are using exchange server as their Workflow IMAP server. Workflow is a important component of Oracle E-Business Suite, and its mailer component adds a biggest oracle EBS feature of inbound mail processing of workflow approval and rejection email replies from end users….

Amazon Elastic Load Balancer with Oracle E-Business Suite

This blog post outlines a couple of issues we faced in our Oracle E-Business consulting group when configuring Amazon Elastic Load Balancer with Oracle E-Business Suite 11i. The current IT industry trend is to virtualize all servers, and Oracle E-Business Suite servers are no exception. Among current cloud operators, Amazon Cloud infrastructure is a favorite…

How to Install Oracle 12c RAC: A Step-by-Step Guide

Okay, back to school folks, back to school :). As with any new product, our long learning journey starts with an installation on a sandbox environment. To get you up to speed with Oracle 12c RAC and let you focus on important stuff (e.g. features research), I have put together detailed step-by-step installation instructions. You…

Update on Home Learning Lab – Hyper-V

This is an update on my “Setting up a home learning lab” post. I have recently decided to upgrade the host OS on my desktop to Windows 8 Professional so I could check out Hyper-V as a virtualization platform and get to know Windows 8 better. Windows Server 2012 would have been my first choice,…

Managing Oracle on Windows: Where’s my Oratab?

If you manage Oracle on Windows, you probably have wondered why it is so difficult to work out which Oracle instances are running and which ORACLE_HOMEs they use. On Unix or Linux, this is a very simple task.  Oracle services and their ORACLE_HOMEs are listed in the oratab file, located in /etc/ on most platforms…

Page 4 of 67« First...23456...102030...Last »