Skip to Main Content

GoldenGate Free

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

create database link for initial load uses wrong IP address for source DB

I have a compute instance on OCI with a source and a target database on it. The external subnet is being used by GoldenGate for connections. I use Network security groups for Access control. The creation of the database link is using the IP address that GoldenGate uses but this should be configurable in my opinion.

This is the resulting command:

CREATE DATABASE LINK DBLINK7 CONNECT TO GGADMIN IDENTIFIED BY "<password>" USING '1xx.2xx.7x.1xx:1521/upgr12c_to_19c.livelabs.oraclevcn.com'

I would have liked to be able to specify the internal IP address of the source database or even localhost here.

The result of the above command is ORA-39001: invalid argument value ORA-39200: Link name "DBLINK7" is invalid. ORA-12170: TNS:Connect timeout occurred

Comments

Artan Hajdari Feb 11 2025

Can someone help me in this case please

1 - 1

Post Details

Added on Nov 2 2023
0 comments
249 views