\PLSQL\instantclient_11_2
listener.ora
# listener.ora Network Configuration File: E:\software\PLSQL\instantclient_11_2\listener.ora# Generated by Oracle configuration tools.LISTENER =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 本机)(PORT = 1521))))ADR_BASE_LISTENER = E:\oracle11\app\dell
tnsnames.ora
# tnsnames.ora Network Configuration File: D:\sofeware\PLSQL\instantclient_11_2\tnsnames.ora# Generated by Oracle configuration tools.WMSDB =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.201)(PORT = 1521)))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = TMSDB)))TMSDB =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.201)(PORT = 1521)))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = TMSDB)))LISXIAOBIN =(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1520))ORACLR_CONNECTION_DATA =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)))(CONNECT_DATA =(SID = CLRExtProc)(PRESENTATION = RO)))LISTENER_ORCL =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.201)(PORT = 1521))LISTENER_WMS =(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))LISTENER_WMSDB =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.201)(PORT = 1521))LISTENER_TMSDB =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.201)(PORT = 1521))ORCL =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.201)(PORT = 1521)))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = orcl)))TMSDB127.0.0.1 =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = TMSDB)))
\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN
listener.ora
# listener.ora Network Configuration File: F:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(SID_NAME = CLRExtProc)(ORACLE_HOME = E:\app\Administrator\product\11.2.0\dbhome_1)(PROGRAM = extproc)(ENVS = "EXTPROC_DLLS=ONLY:E:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")))#LISTENER =# (DESCRIPTION_LIST =# (DESCRIPTION =#(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))#(ADDRESS = (PROTOCOL = TCP)(HOST = 本机)(PORT = 1521))# )# )(SID_DESC = (GLOBAL_DBNAME = TMSDB) (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1) (SID_NAME = TMSDB) ) )ADR_BASE_LISTENER = F:\app\Administrator
tnsnames.ora
# tnsnames.ora Network Configuration File: F:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora# Generated by Oracle configuration tools.TMSDB =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 本机)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = TMSDB)))ORACLR_CONNECTION_DATA =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)))(CONNECT_DATA =(SID = CLRExtProc)(PRESENTATION = RO)))
链接：/shangshan/p/6359880.html
oracle无监听程序的解决方法（PLSQL）Oracle ORA12514 监听程序当前无法识别连接描述符中请求的服务...
