Warning: Creating default object from empty value in /home/customer/www/gavinsoorma.com/public_html/wp-content/themes/specular/admin/inc/class.redux_filesystem.php on line 29
Oracle 11g | Oracle DBA – Tips and Techniques
News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Diagnosing and Repairing Failures with 11g Data Recovery Advisor

  • Posted by Gavin Soorma
  • On July 12, 2012
  • 0 Comments
The 11g Data Recovery Advisor is part of the 11g database health checking framework and diagnoses persistent data failures and not only presents options to repair and fix the problem but also can execute the repair and recovery process at our request. The Repair Advisor can take away lot of the stress associated with peforming […]
Read More
 

Using the oracle-validated RPM to install Oracle 11g on Linux

  • Posted by Gavin Soorma
  • On October 4, 2011
  • 0 Comments
I recently came across this OTN article How I Simplified Oracle Database Installation on Oracle Linux. I tried out the procedure listed by the author and thought I’d share this with those who may not be aware of this note and must say thanks to the author Ginny Henningsen. When I have tried to install […]
Read More
 

Passing the 11g Oracle Certified Master (OCM) Exam – some thoughts

  • Posted by Gavin Soorma
  • On February 22, 2011
  • 7 Comments
I recently passed the 11g Oracle Certified Masters Upgrade Exam and am now an 11g OCM in addition to the 10g OCM. I had to sign a Non Disclosure Agreement (NDA) while taking the exam, so unfortunately I will not be able to divulge too many details about the exam, but would like to share […]
Read More
 

11g Upgrade Workshop and some upgrade lessons learnt

  • Posted by Gavin Soorma
  • On December 10, 2010
  • 0 Comments
As a large number of the Oracle community would I guess be in the process of upgrading to 11g (Release 2 and its patch is already available), I am including some presentations taken from the 11g Upgrade Workshop which was conducted by Oracle Corp staff members Roy Swonger & Mike Dietrich. The workshop was highly […]
Read More
 

Upgrading from 10g to 11g Release 2 with a physical standby database

  • Posted by Gavin Soorma
  • On December 8, 2010
  • 0 Comments
This note details the procedure for upgrading a 10.2.0.2 database running on a Windows 2003 Server platform to an Oracle 11g Release 2 database on the same platform using the Database Upgrade Assistant. Addtional steps are shown in this note which deals with how to perform the upgrade of the Data Guard Physical Standby database […]
Read More
 

Some more 11g Grid Control Installation and Configuration Notes

  • Posted by Gavin Soorma
  • On October 29, 2010
  • 3 Comments
Some time back I had posted a few notes on the 11g Grid Control installation and configuration. 11g Grid Control Installation Tips and Solutions 11g Enterprise Manager Grid Control Installation Overview I would like to highlight an extremely good resource on all things related to the 11g Grid Control setup including the WebLogic and Agent […]
Read More
 

Downgrading a failed 11g Upgrade – the easy way

  • Posted by Gavin Soorma
  • On September 17, 2010
  • 1 Comments
One of the best practices before performing any database upgrade is to take a full backup before we start the upgrade process just in case the upgrade fails and we want to then restore the previous version. In many cases owing to the size of the database, we are constrained both by time as well […]
Read More
 

Purging trace and dump files with 11g ADRCI

  • Posted by Gavin Soorma
  • On September 2, 2010
  • 3 Comments
In previous versions of Oracle prior to 11g, we had to use our own housekeeping scripts to purge the udump, cdump and bdump directories. In Oracle 11g, we now have the ADR (Automatic Diagnostic Repository) which is defined by the diagnostic_dest parameter. So how are unwanted trace and core dump files cleaned out in 11g […]
Read More
 

Cloning an 11g Oracle Home

  • Posted by Gavin Soorma
  • On June 30, 2010
  • 2 Comments
This note describes the process of cloning an Oracle Home – in this case we are cloning a 11g Release 2 Oracle Home from source machine linux01 to target machine linux02. On source (linux01) ORACLE_HOME location is : /u01/app/oracle/product/11.2.0/dbhome_1 Go to directory on source machine one level higher and tar the db_home1 directory and all […]
Read More
 

11g Data Guard Broker DGMGRL Configuration quick steps

  • Posted by Gavin Soorma
  • On March 19, 2010
  • 2 Comments
This note describes the commands used to create a Data Guard broker configuration using the command line dgmgrl interface. This can also be done via the Enterprise Manager Grid Control GUI as well and the assumption is that there is a Physical Standby database in place and redo transport and redo apply have already been […]
Read More
 1

Create Standby Database using 11g DUPLICATE FROM ACTIVE DATABASE

  • Posted by Gavin Soorma
  • On March 17, 2010
  • 2 Comments
Purpose This note explains the procedure of creating a Physical Standby database using 11g RMAN DUPLICATE FROM ACTIVE DATABASE feature which is now available in 11g Release 1 onwards. This enables us to create a physical standby database without having to take a backup of the primary database as a prerequisite step. Environment Primary Database […]
Read More
 

Oracle 11g External Tables to store results of OS commands

  • Posted by Gavin Soorma
  • On March 16, 2010
  • 1 Comments
In Oracle 11g, we can now use external tables to not only display data stored in flat files outside the database, but also store the result of any command executed at the OS level – for example in this case we have a shell script which basically runs the ‘uptime’ command and we then run […]
Read More
 

11g Optimizer Plan Stability

  • Posted by Gavin Soorma
  • On January 25, 2010
  • 0 Comments
One of the critical aspects of any database upgrade is to ensure optimizer plan stability where tried and tested execution plans are not altered in any way by the Oracle optimizer after a database upgrade has taken place. One of the 11g new features which is SQL Plan Management and SQL Plan baselines enables us […]
Read More
 

11g ASM rolling upgrade from 11.1.0.6 to 11.1.0.7

  • Posted by Gavin Soorma
  • On December 15, 2009
  • 0 Comments
In Oracle 11g, we can now do rolling upgrades of the ASM instanaces in a RAC cluster configuration. In this example shown below, one of the ASM instances is being upgraded to 11.1.0.7 while the other instance is still running on version 11.1.0.6. While the ASM software is being upgraded, client connections to the RAC […]
Read More
 

11.1.0.6 Clusterware upgrade to 11.1.0.7

  • Posted by Gavin Soorma
  • On December 10, 2009
  • 0 Comments
The following screenshots are taken from a RAC Clusterware upgrade from 11.1.0.6 to 11.1.0.7 on AIX 64 bit platform. We encountered an issue related to Bug 8925669: ROOT111.SH 0509-150 DEPENDENT MODULE LIBTTSH11.SO COULD NOT BE LOADED. I have provided the workaround we used in this case and which did work for us. The last screen […]
Read More
 

Duplicate from active database – ASM Primary to ASM Standby

  • Posted by Gavin Soorma
  • On December 8, 2009
  • 0 Comments
In my earlier post 11g Standby Database Creation Without Any RMAN Backups I had illustrated how to create a standby database using the 11g Active Duplication feature which enabled us to create a standby database without any backup taken of the primary database. In this case it was a ASM Primary and a non ASM […]
Read More
 

11g Standby database creation without any RMAN backups

  • Posted by Gavin Soorma
  • On December 4, 2009
  • 1 Comments
Quick steps to set up a 11g Standby database with Active Data Guard using the Active Duplication feature available in 11g where we can create a standby database without having to take a backup on the primary database. Datafiles are copied over the network. Primary machine – OATU036 Standby machine – DROU036 Database Name – […]
Read More
 

11g RMAN Virtual Private Catalog

  • Posted by Gavin Soorma
  • On December 1, 2009
  • 0 Comments
In Oracle 11g, we can grant restricted access to the RMAN catalog to some users so that they can only access a limited set of databases that are registered in the RMAN catalog. This is done by creating a Virtual Private Catalog which in turn will grant a particular user read/write access to only that […]
Read More
 

11g Flashback Data Archive – Part One

  • Posted by Gavin Soorma
  • On November 6, 2009
  • 1 Comments
Businesses are increasingly realizing the immense value that historical data can provide to help them understand market trends and customer behaviour as well. Further, many regulatory and compliance policies like SOX and BASEL-2 mandate retention of historical data. Until now, this unfortunately involved application rewrites,administration overheads or costly third-party software solutions. Total Recall or the […]
Read More
 

11g Release 2 Grid Infrastructure Installation

  • Posted by Gavin Soorma
  • On October 23, 2009
  • 0 Comments
Let us have a look at the installation screenshots of 11g Release 2 on a Red Hat Linux platform. Currently the 11g R2 software has only been released for the Linux platform with release dates for other platforms like Solaris and AIX set for sometime end October to mid November. There are quite a few […]
Read More