Creating an ASM duplicate database from a non-ASM database

Posted by Gavin Soorma
On April 30, 2010
0 Comments

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 […]

Posted by Gavin Soorma
On April 28, 2010
5 Comments

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 […]

Posted by Gavin Soorma
On April 20, 2010
20 Comments

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 […]

EM Grid Control and High Availability

Posted by Gavin Soorma
On April 12, 2010
0 Comments

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 […]

Posted by Gavin Soorma
On April 9, 2010
2 Comments

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 […]

Posted by Gavin Soorma
On April 6, 2010
6 Comments

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 […]

Posted by Gavin Soorma
On April 1, 2010
0 Comments

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 […]

Posted by Gavin Soorma
On April 1, 2010
1 Comments

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 […]

News

Creating an ASM duplicate database from a non-ASM database

11g Enterprise Manager Grid Control Installation Overview

DBA Monitoring Menu

EM Grid Control and High Availability

RMAN KEEP FOREVER, KEEP UNTIL TIME and FORCE commands

Using @http command with SQL*PLUS

Using the AWR History Tables to compare performance – Part 2

Using the AWR History Tables to compare performance – Part 1