Connect to Oracle Database
Learn how to create a connection to an Oracle Database to use as a source or target.
Before you begin
Ensure that you:
- Review how OCI GoldenGate connects to your sources and targets.
- Depending on your Oracle GoldenGate version:
- Unlock the GGADMIN user in Autonomous Database.
- Configure the required policies to enable secure Vault and Secrets access, such as use secrets, use vaults, and read secret-bundles. For more information, see Minimum recommended policies.
Create the connection
Known issues
Network timeout affects database connections using private endpoints.
If you're using a private endpoint to connect to a database, then you may encounter network timeouts when starting or stopping Extract processes.
Workaround: You can do one of the following:
- Apply the latest patches from your deployment details page. In the Deployment Information section, under GoldenGate, for Version, click Upgrade.
- If you're unable to apply the latest patches at this
time, you can update the connection string to include
EXPIRE_TIME=1
. By default, you may have an EZ connection string in Oracle GoldenGate. This connection string needs to be updated in the Oracle GoldenGate Credential to a long connection string as follows:<username>@//<hostname>:1521/<service_name> <username> @(DESCRIPTION = (EXPIRE_TIME=1)(ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp)(PROTOCOL = TCP)(Host = <hostname>)(Port = 1521))) (CONNECT_DATA = (SERVICE_NAME = <service_name>)))
SCAN Proxy doesn't support TLS
While OCI GoldenGate supports Oracle Single Client Access Name (SCAN) hosts and IPs, the SCAN proxy does not support TLS.
Workaround: You can connect to a RAC database using the Database Node IP.