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

    Database Monitoring Menu is now available for HP UX

    Sometime back I had released a useful Unix menu driven database monitoring tool and had made it available for the Linux, Solaris and AIX operating systems.

    Here is a link to the original post.

    I have got numerous requests to do something similar for the HP UX platform, so here is the new database monitoring menu for HP UX which can be downloaded and installed.

    Please follow the instructions carefully and they are basically very simple to adopt.

    1) Untar the dbamenu.tar file in a directory where you have the appropriate read/write permissions.

    oracle@inpsit1:/home/oracle/ tar -xvf dbamenu.tar
    x dbamenu/dba_assist.sh, 2392 bytes, 5 tape blocks
    x dbamenu/dba_main.sh, 2568 bytes, 6 tape blocks
    x dbamenu/dbinfo.sh, 1443 bytes, 3 tape blocks
    x dbamenu/dbinfo.sql, 2989 bytes, 6 tape blocks
    x dbamenu/dbinfo9.sql, 2757 bytes, 6 tape blocks
    x dbamenu/dbmon_menu.sh, 49253 bytes, 97 tape blocks
    x dbamenu/machine.sh, 1720 bytes, 4 tape blocks
    x dbamenu/menu.log, 467 bytes, 1 tape blocks
    x dbamenu/monitor_passwd, 8 bytes, 1

    Continue reading Database Monitoring Menu is now available for HP UX

    April 29th, 2011 | Tags: , , , | Category: Administration | Leave a comment

    Upgrading 10g ASM to 11gR2 ASM

    This note describes the procedure of upgrading the 10g ASM to 11g Release 2 ASM on an HP UX 64 bit platform.

    The procedure of upgrading the ASM in 11g R2 is a bit different to the procedure used to upgrade ASM to 11.1.0.6 or 11.1.0.7.

    In 11g R2, ASM is now included as part of the 11gR2 Grid Infrastructure software and we use ASMCA GUI tool to administer ASM and not the DBCA which we used in 10g.

    Also, it should be noted that an Oracle 10g database can still connect to and use the 11g ASM disk groups.

    We can define the ASM as well as database compatibility levels via attributes of the ASM disk groups as we see in the note.

    Download the note ……

    April 28th, 2011 | Tags: , , , | Category: Administration, Oracle 11g release 2 | One comment

    Handling GoldenGate Exceptions and Errors with REPERROR

    We can use the REPERROR parameter in the Replicat parameter file to control the way that the replication process responds to or handles any errors encountered in any of the DML statements which it is trying to process.

    We can use the keyword DEFAULT to set a global response for all errors except those for which explicit REPERROR statements have been specified.

    In the example we will see how we are handling the ORA-00001: unique constraint violated error using an exception handler specified via the REPERROR (-1, EXCEPTION) clause of the Replicat parameter file.

    By default, if the replicat process encounters any error condition it will abend.

    The example shows how by using an exception handler, replicat process does not abend, but handles the exceptions appropriately and continues processing.

    If we have a primary key defined on both the source and target tables and if a unique key violation does happen, then neither the

    Continue reading Handling GoldenGate Exceptions and Errors with REPERROR

    April 15th, 2011 | Tags: , , | Category: GoldenGate | Leave a comment

    Customizing GoldenGate processing using SQLEXEC and GETVAL

    Let us see how we can use the SQLEXEC parameter of GoldenGate to execute both an SQL query as well as a stored procedure and then using the @GETVAL function, we can populate a column in the target database which is not present on the source table.

    Using a simple example to illustrate this, let us suppose we have two tables – one a lookup table called COUNTRY_CODES which has the country_name and country_id columns and another table called CUSTOMERS which only has the country_id column.

    We would like to customize the GoldenGate processing and also display the country_name along with the country_id in the CUSTOMERS table itself on the target database.

    Let us look at two ways of doing this – one using a SQL query and the other case where we use a stored procedure and pass a parameter to the stored procedure.

    Case 1 – using SQL Query

    Here we

    Continue reading Customizing GoldenGate processing using SQLEXEC and GETVAL

    April 12th, 2011 | Tags: , , , | Category: GoldenGate | Leave a comment

    Using GoldenGate EVENTACTIONS to customize processing

    Oracle Goldengate has an event marker system which enables the GoldenGate processes to perform some defined action when a specific event occurs which is recorded in the trail file.

    The event record is a record will trigger the event action and this is specified using the FILTER or WHERE clause in the TABLE statement of an Extract parameter file or the MAP statement of a Replicat parameter file. It can also be specified using an SQLEXEC query or a stored procedure.

    In the same Extract or Parameter file in which we specified the event record, we will use the EVENTACTIONS keyword to specify what action is to be taken by the process.

    EVENTACTIONS could be specified via the keywords like IGNORE, DISCARD, ABORT, STOP, SHELL, TRACE, LOG which denote what actions should be taken now that the specified record criteria has been met.

    Please refer to the Chapter ‘Customizing Oracle GoldenGate Processing” (page 276)

    Continue reading Using GoldenGate EVENTACTIONS to customize processing

    April 5th, 2011 | Tags: , , , | Category: GoldenGate | Leave a comment