Hi,
I've just installed 18.3 client on Windows 10 to connect to 12.1 database (Oracle Linux). TNSPING, SQLDEVELOPER, SQLPLUS and TOAD connect to my database just fine using TNS:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 15.131.148.129)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = ecs01)))
OK (140 msec)
I need to convert my database to Unicode, so started c:\Program Files\Oracle\18.0.0 client\dmu\dmuW64.exe but it refuses to connect with the message:
29.21:04:31:176;P062;I;10009 The JDBC URL used for the connection attempt is: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=15.131.148.129)(PORT=1521))(CONNECT_DATA=(UR=A)(SERVICE_NAME=ecs01)))
29.21:04:31:177;P062;S;10005 Encountered an error while connecting to database: IO Error: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond, Authentication lapse 0 ms.
I found a note that DMU requires Java SE Development Kit so installed ver. 8u181 and newest = 10.0.2 (Oracle client contains JDK 1.8.0_171 but I've installed additional versions in parallel). The problem with DMU's connectivity persists.
Can you help me find the missing piece?
Can I make DMU to use TNSNAMES?
Thanks,
Przemek.