Sayan Malakshinovможно добавить описание этого удаленного лиснера на любом сервере, где есть lsnrctl и получить удаленно:
Описание не обязательно. Можно обращаться по endpoint: host:port:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
[grid@rac1 ~]$ lsnrctl services rac2:1522
LSNRCTL for Linux: Version 21.0.0.0.0 - Production on 29-AUG-2021 09:30:54
Copyright (c) 1991, 2021, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=1522)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM2", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "+ASM_DATA" has 1 instance(s).
Instance "+ASM2", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "+ASM_FRA" has 1 instance(s).
Instance "+ASM2", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "+ASM_GRID" has 1 instance(s).
Instance "+ASM2", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "c91e318ab94d6b86e0530101a8c0ac91" has 1 instance(s).
Instance "racdb2", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "c9b1f372993737d0e0530101a8c01948" has 1 instance(s).
Instance "o21c2", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "c9b28390cdcf25eee0530101a8c0e4ca" has 1 instance(s).
Instance "o21c2", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "c9b284a4b92e5ecde0530201a8c08358" has 1 instance(s).
Instance "o21c2", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "c9b285ae84b86206e0530201a8c0c02b" has 1 instance(s).
Instance "o21c2", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "cab048af549d1398e0530101a8c0ec6c" has 1 instance(s).
Instance "racdb2", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "o21c" has 1 instance(s).
Instance "o21c2", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "o21cXDB" has 1 instance(s).
Instance "o21c2", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: rac2.example.com, pid: 11394>
(ADDRESS=(PROTOCOL=tcp)(HOST=rac2.example.com)(PORT=19717))
Service "pdb1" has 1 instance(s).
Instance "o21c2", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "pdb2" has 1 instance(s).
Instance "o21c2", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "pdb3" has 1 instance(s).
Instance "o21c2", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "racdb" has 1 instance(s).
Instance "racdb2", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "racdbXDB" has 1 instance(s).
Instance "racdb2", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: rac2.example.com, pid: 11894>
(ADDRESS=(PROTOCOL=tcp)(HOST=rac2.example.com)(PORT=25437))
Service "racdb_pdb1" has 1 instance(s).
Instance "racdb2", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
The command completed successfully
Вячеслав ЛюбомудровЕсли уж кто и открывает удаленный доступ, то защищает паролем
Это было в старых версиях.
Данная функциональность
deprecated в 11.2 :
авторIn Oracle Database 11g Release 2 (11.2), the password feature is being deprecated.
Desupported в 12.1
По теме топика, не совсем то, но со стороны БД из самого близкого V$LISTENER_NETWORK. Oracle, например, использует данную view в
REST API .
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
SQL> select * from v$listener_network;
NETWORK TYPE VALUE CON_ID
---------- -------------------- ---------------------------------------------------------------------------------------------------- ----------
LOCAL LISTENER (ADDRESS=(PROTOCOL=TCP)(Host=rac1.example.com)(Port=1522)) 1
REMOTE LISTENER (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.21)(PORT=1521))) 1
REMOTE LISTENER (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.22)(PORT=1521))) 1
REMOTE LISTENER (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.23)(PORT=1521))) 1
SERVICE NAME o21c 1
SERVICE NAME pdb1 1
SERVICE NAME pdb2 1
SERVICE NAME pdb3 1
