1
2
3
4
5
6
7
8
9
10
11
12
listener.ora:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = vmorcl19)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)
1
2
3
4
5
6
7
8
tnsnames.ora:
orcl19 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = vmorcl19)(PORT = 1521))
)
(CONNECT_DATA = (SID = orcl19)(GLOBAL_DBNAME = orcl19))
)
1
2
3
4
5
6
7
8
9
10
tnsnames.ora:
ORCL19 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = vmorcl19)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl19)
)
)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
TNS Ping Utility for 64-bit Windows: Version 19.0.0.0.0 - Production on 01-MAI-2022 16:06:38
Copyright (c) 1997, 2019, Oracle. All rights reserved.
Parameterdateien verwendet:
C:\Oracle\network\admin\sqlnet.ora
Adapter TNSNAMES zur Aufl÷sung des Alias verwendet
Verbindungsversuch mit (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = vmorcl19)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl19)))
OK (60 ms)
OK (20 ms)
OK (30 ms)
OK (20 ms)
OK (10 ms)
OK (20 ms)
OK (30 ms)
OK (20 ms)
2022-05-08T11:39:12 MarkusH1. Auf der Clientseite musste ich in tnsnames.ora die IP-Addresse des Hosts angeben. Mit dem Hostnamen funktioniert es nicht.