News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Creating an ASM duplicate database from a non-ASM database

  • Posted by Gavin Soorma
  • On April 30, 2010
  • 0 Comments
  • ASM, duplicate, non-asm
Here are some simple steps we can take to clone or create a duplicate database from a non-ASM file system to an ASM file system. 1) create a static listener.ora entry on target machine (SID_DESC = (GLOBAL_DBNAME = dupdb) (ORACLE_HOME = /u01/oracle/product/10.2.0/db_1) (SID_NAME = dupdb) ) 2) add a tns alias on the source machine […]
Read More
 

11g Enterprise Manager Grid Control Installation Overview

  • Posted by Gavin Soorma
  • On April 28, 2010
  • 5 Comments
  • 11g EM Grid Control, middleware, web logic
Last week on the 23rd of April, Oracle has announced availability of 11g EM Grid Control on the Linux x86 and the Linux x86-64 platforms. I am attaching a document which has the screen shots of the installation process. There are some differences in the install process as well as prerequisites as compared to the […]
Read More
 

DBA Monitoring Menu

  • Posted by Gavin Soorma
  • On April 20, 2010
  • 20 Comments
  • monitoring menu, shell script menu
I have written a simple Unix shell script driven menu which contains SQL scripts which covers most common day to day DBA activity tasks related to monitoring and performance tuning. Once installed in a central location, we canconnect to any database in our enterprise and monitor it from one interface. We can also connect to […]
Read More
 3

EM Grid Control and High Availability

  • Posted by Gavin Soorma
  • On April 12, 2010
  • 0 Comments
  • additional management server, EM Grid Control, EM Grid Control high availability, EM grid control repository
A question often asked is can we use Oracle Data Guard as a high availibility option for the EM Grid Control Repository database. The repository database contains information on all the targets, the jobs configured, alerts and notification history etc. It has a lot of very valuable information and can be deemed as a fairly […]
Read More
 

RMAN KEEP FOREVER, KEEP UNTIL TIME and FORCE commands

  • Posted by Gavin Soorma
  • On April 9, 2010
  • 2 Comments
  • force, keep forever, keep until time, obsolete, retain
The KEEP FOREVER option in 11g has been improved over what was available in Oracle 10g from the point of view that in 11g, only the archivelogs which are required to keep the online backup consistent are retained. In Oracle 10g we could roll forward this backup taken with the KEEP FOREVER option allowing point […]
Read More
 

Using @http command with SQL*PLUS

  • Posted by Gavin Soorma
  • On April 6, 2010
  • 6 Comments
  • @http
By using the SQL*PLUS ‘@http’ command, we can access scripts that are located in a central repository – in this case residing on a machine where the 10g Oracle Apache Http Server is running. Rather than have local copies of SQL scripts residing on all the client machines, we can store them in one location […]
Read More
 

Using the AWR History Tables to compare performance – Part 2

  • Posted by Gavin Soorma
  • On April 1, 2010
  • 0 Comments
  • awr, awr history, dba_hist
In the Part 1 of this post, we saw how we can use the AWR history tables to compare the top wait events between two different time periods. We will now use the history tables to track and identify problem SQL statements. Suppose we have been informed that there was a I/O performance issue early […]
Read More
 

Using the AWR History Tables to compare performance – Part 1

  • Posted by Gavin Soorma
  • On April 1, 2010
  • 1 Comments
  • awr, dba_hist, dba_hist_system_event
Using the DBA_HIST AWR history tables, we can compare the top wait events between different days or different time periods. Let us assume that we find that batch jobs which are executed at night particularly between 1 and 2 AM are experiencing performance issues. In this case we are comparing performance of a particular database […]
Read More