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

以plsql通过客户端连接oracle的时候,客户端和oracle服务端各有两分tnsnames.ora,和listener.ora,两者的内容要保持一致
阅读更多

真心求教:oracle ora-12504:tns 监听程序connect_data未获得service _name

12-03

搞了好久了,都快烦死了!!![img=http://forum.csdn.net/PointForum/ui/scripts/csdn/Plugin/003/onion/22.gif][/img]rn[color=#FF0000]总是出现oracle ora-12504:tns 监听程序在connect_data中未获得service _name[/color]rnrnsqlplus能正常使用oracle,而且各种服务都已开。rnwin7 64位使用plsql,[b]64位的服务端[/b](G:\program\database\oracle11g\product\11.2.0\dbhome_1),[b]32位的客户端[/b](G:\program\database\oracle11g\product\instantclient_11_2)rn环境变量: TNS_ADMIN=G:\program\database\oracle11g\product\instantclient_11_2;rn NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBKrnpath中包含有G:\program\database\oracle11g\product\instantclient_11_2;G:\program\database\oracle11g\product\11.2.0\dbhome_1\bin;rn[code=text]# listener.ora Network Configuration File: G:\program\database\oracle11g\product\11.2.0\dbhome_1\network\admin\listener.orarn# Generated by Oracle configuration tools.rnrnSID_LIST_LISTENER =rn (SID_LIST =rn (SID_DESC =rn (SID_NAME = CLRExtProc)rn (ORACLE_HOME = G:\program\database\oracle11g\product\11.2.0\dbhome_1)rn (PROGRAM = extproc)rn (ENVS = "EXTPROC_DLLS=ONLY:G:\program\database\oracle11g\product\11.2.0\dbhome_1\bin\oraclr11.dll")rn )rn )rnrnLISTENER =rn (DESCRIPTION_LIST =rn (DESCRIPTION =rn (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))rn (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))rn )rn )rnrnADR_BASE_LISTENER = G:\program\database\oracle11grnrn[/code][code=text]# tnsnames.ora Network Configuration File: G:\program\database\oracle11g\product\11.2.0\dbhome_1\network\admin\tnsnames.orarn# Generated by Oracle configuration tools.rnrnLISTENER_ORCL =rn (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))rnrnrnORACLR_CONNECTION_DATA =rn (DESCRIPTION =rn (ADDRESS_LIST =rn (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))rn )rn (CONNECT_DATA =rn (SID = CLRExtProc)rn (PRESENTATION = RO)rn )rn )rnrnORCL =rn (DESCRIPTION =rn (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))rn (CONNECT_DATA =rn (SERVER = DEDICATED)rn (SERVICE_NAME = orcl.16.1.149)rn )rn )rnrn[/code]rn

没有更多推荐了,返回首页