1Z0-997-25 Question 151
Single answerYour organization is migrating a 3 TB Oracle Database from on-premises to an Oracle Cloud Infrastructure (OCI) DB System with minimal downtime requirements. You have configured Oracle GoldenGate for real-time replication and installed a dedicated GoldenGate hub on a Compute instance in OCI. The Extract process on the on-premises side keeps abending with an error indicating it cannot connect to the target manager process on the OCI GoldenGate hub. You have verified that the GoldenGate manager port is open in the hub� VCN security rules. Which action should you take next to troubleshoot and resolve the connectivity issue so that replication can proceed?
- A
Enable and verify routing through your DRG or VPN connection, ensuring your on-premises network can reach the GoldenGate hub� manager port over the configured private IP range.
- B
Disable the manager port altogether on the GoldenGate hub and use default ephemeral ports for data flow between on-premises and OCI.
- C
Reconfigure the GoldenGate Extract process to write data files locally on the on-premises server and manually transfer them to OCI Object Storage.
- D
Restart the GoldenGate Extract on the on-premises side with elevated privileges using the OS administrator user instead of the GoldenGate user.
Show answer and explanation
Correct answer: A
Explanation
Oracle GoldenGate real-time replication between on-premises environments and OCI commonly requires secure network connectivity via a direct route (e.g., IPSec VPN, FastConnect, or a DRG). Verifying that all routing, firewall, and security settings are correctly configured is essential. Following Oracle documentation (for example, Oracle GoldenGate and OCI networking best practices) ensures that the on-premises environment can communicate over the correct ports and subnets in OCI so that the Extract and Manager processes can synchronize without errors.
- A. Correct.
Correct: Even if the manager port is open within the OCI VCN's security list, you must ensure that traffic can route from on-premises to OCI. Typically, this requires proper configuration of a dynamic routing gateway (DRG) or a VPN/FastConnect setup and matching route rules/firewall rules on both ends. Verifying that your on-premises network can reach the private IP range of the OCI instance is critical for GoldenGate to succeed.
- B. Incorrect.
Incorrect: Completely disabling the manager port on the GoldenGate hub is not a valid approach for real-time replication. The manager port is essential for coordinating replication processes and ephemeral ports alone cannot replace this functionality.
- C. Incorrect.
Incorrect: Manually transferring files to Object Storage defeats the purpose of real-time replication. This approach might be used in offline or batch migrations, but would not meet minimal downtime goals for continuous data replication.
- D. Incorrect.
Incorrect: Restarting the Extract process with elevated privileges does not address the underlying network routing issue. GoldenGate can typically run under a specific GoldenGate user with proper privileges, and this does not solve connectivity problems between the on-premises network and OCI.