Informatica无法连接Docker中Oracle数据库的问题求助

在Informatica预安装阶段，遇到无法连接Docker中运行的Oracle数据库的问题，缺乏相关经验无法定位根源，求有类似经验的人提供解决方案。

起初以为是本机未配置tnsnames.ora导致，配置完成后CMD可正常连接，但Informatica仍无法成功连接。尝试了两种自定义JDBC URL：

jdbc:informatica:oracle:TNSNamesFile=PATHPATHPATH\tnsnames.ora;TNSServerName=XE

以及：

jdbc:informatica:oracle://localhost:1521;ServiceName=xe

均连接失败。

Docker中的Oracle配置 #

listener.ora #

SID_LIST_LISTENER = (SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/product/21c/dbhomeXE)
(PROGRAM = extproc)
) )

LISTENER = (DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
) )

tnsnames.ora #

XE = (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
) )

LISTENER_XE = (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))

XEPDB1 = (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XEPDB1)
) )

EXTPROC_CONNECTION_DATA = (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
) )

sqlnet.ora #

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT, HOSTNAME)

本机（含Oracle 11g及待安装Informatica）配置 #

tnsnames.ora #

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

sqlnet.ora #

SQLNET.AUTHENTICATION_SERVICES = (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

以下操作可正常执行：

sqlplus INFA_DOM/INFA_DOM@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=xe)))

tnsping (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=XE))) 10

tnsping xe

但执行以下命令时失败：

tnsping -T C:\Oracle\Win64\product\11.2.0\client_2\network\admin\tnsnames.ora xe 10

返回：

Used parameter files:
C:\Oracle\Win64\product\11.2.0\client_2\network\admin\sqlnet.ora

TNS-03505: Failed to resolve name

恳请各位提供解决方案。

内容的提问来源于stack exchange，提问作者shoshana00