OGG Studion Can't Establish Remote Connection
(Doc ID 2117358.1)
Last updated on MARCH 19, 2019
Applies to:Oracle GoldenGate Studio - Version 12.2 and later
Information in this document applies to any platform.
When trying to create a remote connection in GoldenGate Studio using service name and put something like
'jdbc:oracle:thin:@<HOST>:<PORT>/<SERVICE_NAME>' into URL, the following error is returned:
sql to the data store from the os. This connection works just fine.
Also if we replace 'jdbc:oracle:thin:@<HOST>:<PORT>/<SERVICE_NAME>' ---> 'jdbc:oracle:thin:@<HOST>:<PORT>:<SERVICE_NAME>' then it works.
But both options must work. Moreover 'jdbc:oracle:thin:@:@<HOST>:<PORT>/<SERVICE_NAME>' is the only possible URL for pluggable database.
See the observation in the logs. Where does it take 'localhost'? We have specified the real hostname '<HOST>' in the connection string but OGG Studio replaces it with 'localhost'.
2016-01-25 13:57:08.421 NOTIFICATION New data source:[<USER>/<PASSWORD>@jdbc:oracle:thin:@(description=(address=(host=localhost)(protocol=tcp)(port=<PORT>))(connect_data=(service_name=<SERVICE_NAME>)(server=dedicated)))]
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document