ORA-12504：TNS：监听程序在CONNECT_DATA中未获得SERVICE_NAME

来源：互联网发布：淘宝介入后怎么撤销编辑：程序博客网时间：2024/05/16 09:01

现象描述：

分析：报错时tnsnames.ora文件的配置为：

# tnsnames.ora Network Configuration File: D:\DevInstall\Oracle11gR2\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora# Generated by Oracle configuration tools.ORACLR_CONNECTION_DATA =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))    )    (CONNECT_DATA =      (SID = CLRExtProc)      (PRESENTATION = RO)    )  )<span style="color:#ff0000;">ORCL</span> =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (<span style="color:#ff0000;">SERVICE_NAME = orcl</span>)    )  )

解决办法：

# tnsnames.ora Network Configuration File: D:\DevInstall\Oracle11gR2\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora# Generated by Oracle configuration tools.ORACLR_CONNECTION_DATA =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))    )    (CONNECT_DATA =      (SID = CLRExtProc)      (PRESENTATION = RO)    )  )ORCL =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = orcl)    )  )<span style="color:#ff0000;">192.168.11.201 =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.11.201)(PORT = 1521))    )    (CONNECT_DATA =      (SERVICE_NAME = orcl)    )  )</span>

0 3