I am now a pilot!

Dear readers,

Last week, I passed my private pilot oral exam and flight test called a checkride and now have my private pilot license!

The checkride was challenging and intense but I had a great experience and learned a lot about myself and from the awesome examiner in Santa Rosa.

(more...)

Big Data Interview with OTN from Oracle Open World 2013


Below is my interview with the Oracle Technology Network on Big Data from this year's Oracle OpenWorld conference:


Big Data Interview at Oracle Open World

OOW 2013 Review


Dear readers,
This year was quite an exciting yet different OOW 2013 conference. Before the conference, I attended the Oracle ACE Director briefing with Oracle product management to learn the inside scoop before the show for new products. We then had a nice dinner thanks to the Oracle ACE program (more...)

Oracle 12c New Feature: How to backup pluggable databases


Oracle 12c introduced the new multi-tenant feature called Pluggable Databases (PDB). We will show how to take a backup of the pluggable database components in this post.


Setup for RMAN with Oracle 12c


In order to use the Oracle 12c Recovery Manager (RMAN) utility for pluggable database backups, you need (more...)

Oracle 12c Installation on Oracle Linux 6


Dear readers, I decided to finally get around to installing Oracle 12c (12.1.0) on Oracle Linux 6 today. One key difference is the increased disk space requirements from 11g to 12c for the basic database configuration. I recall that 11gR2 requires almost 4GB of disk storage space. Now, (more...)

Software Defined Networks (SDN)

One hot topic that I would like to discuss today is that of software defined networks (SDN) in respect to Oracle and other database platforms. Key vendors that provide core technologies around this area are provided by VMware, Redhat, and Oracle. First let us cover the basics of SDN.

VMWare (more...)

Oracle 12c New Features and Release

Oracle 12c has been released this month and this is the biggest news since Oracle 11g came out some time back.

Below are some new features:


Oracle cloning
Oracle PDB
Oracle RAC and ASM enhancements
Oracle security enhancements

Oracle 12c New Features


As an Oracle RAC expert, the deployment features (more...)

Oracle RAC Timezone woes and solution


Recently had a timezone issue with an Oracle 11gR2 RAC cluster. Even though I had set the host time and date, for some reason it did not get propagated to the Oracle RAC configuration.

There are couple of ways to set timezone for an Oracle 11.2 RAC cluster. First (more...)

Migrating single instance Oracle 11g database to Oracle 11gR2 RAC and ASM

Recently over the past few years, I've been involved with customer engagements to migrate legacy single instance environmnents to Oracle 11gR2 RAC and ASM. In this post, I will detail out the high level steps on how to perform this for ERP environments with SAP and Oracle. I will spend (more...)

First solo flight and my quest to become a private pilot for fun!

This year I started my journey to accomplish a childhood dream of earning my private pilot license to have the freedom and skill to fly aircraft in my free time. This past week I completed my first solo flight successfully at KPAO airport in Palo Alto! It was exciting when (more...)

NoCOUG Events for April and May 2013

As the new conference director for the Northern California Oracle User Group (NoCOUG), we have many exciting events planned for the Oracle user community. Next week, on April 16th we have a meetup for cloud computing with Oracle technology at the Hacker Dojo in Mountain View, CA: http://www.meetup.com/Northern-California-Oracle-Users-Group/events/112651522/? (more...)

End of 2012

Year in review As we end 2012, in closing I have not posted much due to work and many activities wrapping up the year. My new Oracle R12 EBS book is available and ready for folks to learn the tips and tricks for Oracle R12 Financials from Oracle Press. Each year I pursue a new goal and try to master or improve a skill or ability. This keeps me sharp and motivated and happy. Last year, I learned to scuba dive. Right now, I am learning to fly! My goal by 2013 is to pass my checkride and obtain my (more...)

Quick tip: Cloning Oracle 11gR2 RAC node in Oracle VM 3.0.3

Oracle VM 3.0.3 Server and Manager provide you with the ability to clone virtual machines quickly and easily. However, as of yet, there is not live hot clone facility available. The Oracle RAC VM must be powered off before you perform the clone operation.

There are two options available for cloning within Oracle VM: simple clone and advanced clone. Simple clone takes a quick snapshot of the VM to be copied to the new clone. Advanced provides you with the ability to create a custom clone process based on a menu driven GUI that you can create based (more...)

Upgrading Oracle VM 3.0.3 to latest patchset

Recently I had to upgrade an older version of Oracle VM 3.0 to the latest patch version to resolve some bugs in the initial releases of OVM 3.0. Below are the steps that I followed to perform the upgrade.


1. Download the patchset from Oracle Support (http://support.oracle.com)
2. Unzip the patch to the OVM Manager /tmp directory
3. backup config files for OVM Manager:

. Back up/copy the Oracle VM Manager configuration file located at:
# /u01/app/oracle/ovm-manager-3/.config

4. Mount the ISO image for the upgrade:

# mount -o loop V29654-01.iso /mnt
# cd /mnt
# (more...)

Uploading templates for OVM 3.0.3 to ftp server

Dear readers,

Its been a while since I've blogged due to many busy demands between work, finishing a new Oracle book and scuba diving. Recently, I setup a new Oracle VM 3.0.3 environment and the interface and tools have changed quite a bit since I last worked with OVM 2.2 version. One challenge is that now in OVM 3.0.3 you have to upload the VM templates via a web http or ftp server and no longer can you copy the Oracle VM templates over to the /OVS/seed_pool directory on the OVM server. In my case, (more...)

How to fix archive stuck error with Oracle 11gR2

Recently, I encountered an issue with Oracle R12 EBS environment unable to login to database tier with APPS schema with our Oracle 11gR2 database tier.

ORA-00257: archiver error. Connect internal only, until freed.

Sure enough, upon examination of the ADRCI alert.log entries, I found this:

* 2011-10-27 16:24:51.990 4265 krsh.c
ARC1: Error 19809 Creating archive log file to '+FRA'
*** 2011-10-27 16:24:51.990 2864 krsi.c
krsi_dst_fail: dest:1 err:19809 force:0 blast:1
DDE rules only execution for: ORA 312
----- START Event Driven Actions Dump ----
---- END Event Driven Actions Dump ----
----- START DDE Actions Dump (more...)

My review Oracle OpenWorld 2011

Dear readers,

Oracle OpenWorld 2011 was a fantastic event with many new product announcements including Oracle Public Cloud as well as Oracle Big Data Appliances along with Exalytics for Business Intelligence. Before the conference, I had the pleasure of attending the Oracle ACE Director briefing at Oracle HQ in Redwood Shores under NDA to learn of new developments at Oracle.

After the ACED briefing, I headed to San Francisco with my fellow Oracle ACE Director, Arup Nanda and we checked into the Hilton Hotel. The computers failed during checkin so we had the keep the patience of a saint which (more...)

OpenWorld 2011

Dear readers,

It is rapidly approaching time again for one of the best technical conferences, Oracle OpenWorld!

Come learn how to secure your Oracle database environment with new features at my session next week.

Session ID: 02180
Session Title: Lockdown: Secure Your Database in a Day
Room: Moscone South- 303
Date/Time: 10/4/11, 11:45-12:45

I will also be hosting a book signing after the event in the Oracle bookstore at OpenWorld. Hope to see everyone there.

Cheers,
Ben

Howto- Install Oracle 11g Grid Control Enterprise Manager (OEM) Server

With the new features for Oracle 11g Grid Control Enterprise Manager (OEM), it is valuable tool now for managing large Oracle environments. I recall from Oracle 9i OEM days that it was a buggy tool and back then years ago, I used SQL*Plus and command line tools. However, in 11gR1, OEM has emerged as an excellent monitoring tool. I still use command line tools most of the time but for monitoring, its a great product. With that said, let's get started in building a new Oracle11gR1 Grid Control Enterprise Manager (OEM) environment on Linux!

Preparation

OEM 11g Grid Control server (more...)

Oracle 11gR1 Grid Control Enterprise Manager Collection fails

Recently we had issue with Oracle 11g Enterprise Manager (OEM) Grid control failing to collect up to data host data with following error from Grid Control:



This was a cryptic error and after research, we found the solution in the following My Oracle Support:

Note: 271598.1
Grid Agent Configuration: Certain Operations from Grid Console Fail With 'ERROR: NMO Not Setuid-root (Unix-only)'

So, I performed the following steps to resolve the issue with Oracle 11g Grid Control:

./emctl stop agent
Oracle Enterprise Manager 11g Release 1 Grid Control 11.1.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation. All (more...)