Дело происходит на домашнем сервере с кучей виртуальных машин и (в том числе виндовом) доменом HELL.DOM.
Создана базулька,
SID=tpccw
SERVICE_NAME = tpccw.hell.dom,
HOST = oracle3.hell.dom
В двух tnsnames.ora (32 и 64 бита) на клиентской машинке:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
TPCCW =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle3.hell.dom)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = tpccw)
)
)
TPCCW.hell.dom =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle3.hell.dom)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = tpccw.hell.dom)
)
)
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
C:\HammerDB-4_3>tnsping tpccw
TNS Ping Utility for 64-bit Windows: Version 19.0.0.0.0 - Production on 02-MAR-2022 20:02:34
Copyright (c) 1997, 2019, Oracle. All rights reserved.
Used parameter files:
C:\oracle\product\19.3.0\client64\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3.hell.dom)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SID = tpccw)))
OK (20 msec)
C:\HammerDB-4_3>tnsping tpccw.hell.dom
TNS Ping Utility for 64-bit Windows: Version 19.0.0.0.0 - Production on 02-MAR-2022 20:04:10
Copyright (c) 1997, 2019, Oracle. All rights reserved.
Used parameter files:
C:\oracle\product\19.3.0\client64\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3.hell.dom)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = tpccw.hell.dom)))
OK (10 msec)
Более того, я с той же машины свободно подключаюсь к базе через Oracle SQL Developer. Что означает, что и с сетью, и с listener'ом всё в порядке.
Тем не менее, HammerDB упорно даёт мне ORA-12154.
