My Oracle Support Banner

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.

Symptoms

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:

 

  


NOTE:

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)))]

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.