John Jeffries' Oracle 11g Gotchas

Books

• Oracle GoldenGate 11g Implementer's Guide

  More than just a step-by-step guide, this book goes way beyond the manual, offering examples, tips, and tricks that are all discussed in detail. Supporting diagrams, illustrations, and screenshots promote understanding and enhance the overall reading experience.

  Title
  Oracle GoldenGate 11g Implementer's Guide

  
  
  

  Title
  Also available on Kindle!

• Articles

  • RAC

    Article	PDF
    Configuring an Active Passive RAC Environment
    Making permissions on EMC PowerPath devices persistent for CRS on Enterprise Linux
    Overcoming OPatch Issues when Patching RAC Environments

  • Streams

    Article	PDF
    Overcoming LOGMINER OUT-OF-MEMORY in Oracle Streams
    Reinstantiating Schema Replication with Oracle Streams Downstream Capture
    Reinstate Oracle Streams Schema Replication following Database Incomplete Recovery
    Making Oracle Streams Fly
    Resolving archived log file gaps in Streams DSC
    Procedure to clear stuck Downstream Real-time Mine processes

  • 11g New Features

    Article	PDF
    Avoid the confusion surrounding Automatic Memory Management
    The Flashback Data Archive Performance Issue
    Recreating the Physical Standby Database after recovery of the Primary Database
    Using RMAN to restore a database to another server in an ASM environment
    Procedure to ROLLBACK FORCE Pending in-doubt Transactions
    Cannot Start CRS 11gR2 Due to ASM Startup Failure?

  • GoldenGate

    Article	PDF
    Defining Multiple Replicat Processes to Increase GoldenGate Performance
    Creating a GoldenGate Exception Handler to Trap and Log Oracle Errors
    Considerations for Designing a GoldenGate Solution
    Troubleshooting - Using the GoldenGate LOGDUMP Utility
    Improving GoldenGate Replicat Data Throughput

  • Active Data Guard

    Article	PDF
    Recovering from a Failed Data Guard Broker Switchover
    Overcoming Performance Degradation on Primary DB when Standby DB Unavailable