如何使用SQL语句获取Oracle Server的TCP端口

据我所知,你不能。没有 select语句 你可以通过跑步来揭示这些信息。

在命令提示下,可以尝试 tnsping ,例如。

c:\Temp>tnsping xe

TNS Ping Utility for 64-bit Windows: Version 11.2.0.2.0 - Production on 06-STU-2
020 21:38:22

Copyright (c) 1997, 2014, Oracle.  All rights reserved.

Used parameter files:
C:\Users\lf\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = lflaptop)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE)))
OK (20 msec)                                                                             ----
                                                                                     here it is
c:\Temp>

或者,你可以问你的DBA,他们知道。