That’s Me

Gavin Soorma
  • Oracle Certified Professional
    • 7.3, 8i, 9i,10g, 11g
  • 11i Apps DBA OCP
    •
  • 10g RAC OCE
    •
  • Certified GoldenGate Implementation Specialist
    •
  • 10g OCM
    •
  • 11g OCM
    •

    Feedback

    1,650,000 hits

    Thanks A MILLION for your support!

    Please send me your valuable feedback and suggestions

    Cloning an 11g Oracle Home

    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 sub-directories

    linux01:$ pwd

    linux01:$ /u01/app/oracle/product/11.2.0

    linux01:$ tar -cvf 11gr2.tar dbhome_1

    On Target (linux02)

    Read the rest of this post …

    How to clone the Oracle software

    June 30th, 2010 | Tags: , , | Category: Administration, Oracle 11g | 2 comments

    Some more RMAN Recovery Scenarios

    I have added a few more RMAN recovery scenarios which I have come across recently and may be faced by others – so thought I’d share those with the community.

    The first relates to a case where we need to create a replica of a production database on a test or development environment and we are not able to use the RMAN DUPLICATE DATABASE command because there is no network connectivity between the production and the test servers. This is very possible in cases where due to security restrictions production is on an isolated network from test or dev or there may be firewall rules in place which prevent the RMAN auxiliary channel connections (required for the duplicate) from working.

    Further, we may be faced with a situation where for some kind of testing, we need the target database to be in sync with the source production database to a point

    Continue reading Some more RMAN Recovery Scenarios

    June 25th, 2010 | Tags: , , , | Category: Administration, Backup and Recovery | 11 comments

    Using GoldenGate for real time data integration - SQL Server 2005 to Oracle 11g

    I would like to share a simple test case which explains how we can use GoldenGate to replicate data between a Microsoft SQL Server 2005 source and an Oracle 11g target database on a Red Hat Linux platform.

    We can use a number of third party tools as well as Oracle’s SQL Developer to generate scripts to convert SQL Server DDL into Oracle compliant DDL – I will try and cover this conversion aspect in a future post.

    In this case, I have created the table in the Oracle 11g database using the following CREATE TABLE statement. Note that while the column names are the same, the data types are different and to cater for this difference in the data types in both databases, we have to create a data definitions file.

    Let as assume we have a DEPT table in the AdventureWorks database in the HumanResources schema.

    The structure of the table in

    Continue reading Using GoldenGate for real time data integration – SQL Server to Oracle 11g

    June 20th, 2010 | Tags: , , , | Category: Administration, GoldenGate | 7 comments