ORA-12514

来源：互联网发布：电信网络重构编辑：程序博客网时间：2024/04/30 17:42

1.oracle11g部署问题（3）之ORA-12514:TNS:监听程序当前无法识别连接描述符中请求的服务

找到listener.ora监听文件，具体位置：D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora

# listener.ora Network Configuration File: D:\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 = D:\app\Administrator\product\11.2.0\dbhome_1)      (PROGRAM = extproc)      (ENVS = "EXTPROC_DLLS=ONLY:D:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")    )<span style="color:#FF6666;">#-----------------------------------------   (SID_DESC =     (GLOBAL_DBNAME = orcl)     (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)     (SID_NAME = orcl)   ) #-----------------------------------------</span>  )LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))    )    (DESCRIPTION =      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.30.26)(PORT = 1521))    )  )ADR_BASE_LISTENER = D:\app\Administrator

添上以上的红色部分即可：

然后再通过客户端Net configuration Assistant去配置本地网络服务名配置即可，会看到测试通过

2.如果是无监听程序：可以参考如下，

SID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =      (SID_NAME = CLRExtProc)      (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)      (PROGRAM = extproc)      (ENVS = "EXTPROC_DLLS=ONLY:D:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")    )     (SID_DESC =      (GLOBAL_DBNAME = ORCL)      (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)      (SID_NAME = ORCL)     )  )

今天上班遇到一个问题，也报这个错误：最后发现是自己的服务关了之后没有开，也报这样的错误。

然后问题OK。

0 0