Database Solutions

  Introduction So far, we’ve explored Kerberos authentication in standalone Oracle instances, RAC, and Exadata. But enterprise environments rarely stop at the database layer. Replication tools like Oracle GoldenGate and middleware platforms such as WebLogic or Fusion Applications also need secure, passwordless authentication. This part of the series explains how to extend Kerberos authentication to GoldenGate and middleware, ensuring end-to-end compliance and operational resilience. Step 1: Why Extend Kerberos Beyond the Database? GoldenGate Replication : Extract and Replicat processes often run unattended. Passwordless Kerberos authentication eliminates stored credentials. Middleware Integration : Application servers (WebLogic, Fusion) connect to Oracle databases. Kerberos ensures SSO alignment with enterprise identity management. Audit Compliance : Auditors expect consistent authentication across all tiers, not just the database. Step 2: Kerberos Setup for GoldenGate GoldenGat...

Upgrade Instructions for Oracle GoldenGate for Oracle Database  These instructions contain steps for upgrading to Oracle GoldenGate 12.1.2 for Oracle Database.  1. Upgrade Instruction  To upgrade:  1. (Source system) The new Extract might need to start processing from the normal recovery checkpoint, rather than the bounded recovery checkpoint, if the first record of the oldest open transaction at the time that you stop Extract is in a log that is not on the system. Use the following command in GGSCI to determine the oldest archive log that you might need to restore when Extract starts. The Recovery Checkpoint field shows the oldest log needed for recovery.   GGSCI> INFO EXTRACT group, SHOWCH You have two options:    You can restore the archives back to, and including, the one shown in the recovery checkpoint shown with INFO EXTRACT.   You can clear out the long-running transactions that apply to the Extract that you are upgrading....

 This Blog contains a summary of the environment, and a detailed list of steps used to create the Oracle GoldenGate CRS resources for HA in an Oracle RAC environment.  This procedure creates multiple CRS resources for Oracle GoldenGate. The following are the resources: 1.      Resource for a dedicated VIP (one per cluster) for remotely communicating with the active node in the cluster running Oracle GoldenGate a.      Called “ggvip” 2.      Resource for controlling the Oracle GoldenGate Manager process (mgr) a.      CRS will only check and start/stop the Oracle GoldenGate Manager process                                                i.    ...