Oracle.DataAccess.Client.OracleException ORA-12154: TNS: 无法解析指定的连接标识符 oracle连接不了 报ORA-12154：TNS：无法解析...
\u6211\u7684oracle\u51fa\u73b0ORA-12154: TNS: \u65e0\u6cd5\u89e3\u6790\u6307\u5b9a\u7684\u8fde\u63a5\u6807\u8bc6\u7b26\u4f5c\u4e3aORACLE\u6570\u636e\u5e93\u7684\u5f00\u53d1\u4eba\u5458\uff0c\u5f88\u591a\u90fd\u78b0\u5230\u8fc7\u201cORA-12154: TNS: \u65e0\u6cd5\u89e3\u6790\u6307\u5b9a\u7684\u8fde\u63a5\u6807\u8bc6\u7b26\u201d\u7684\u95ee\u9898\u3002
\u95ee\u9898\u573a\u666f\u63cf\u8ff0\uff1a
\u670d\u52a1\u5668\u7aef\u7248\u672c\uff1aoracle 10.2.0.10
\u5ba2\u6237\u7aef\u7248\u672c\uff1aoracle 10.2.0.10
\u5ba2\u6237\u7aef\u5f00\u53d1\u5de5\u5177\uff1aPL/SQL Developer
\u901a\u8fc7\u5ba2\u6237\u7aef\u6765\u8fde\u63a5\u670d\u52a1\u5668\uff0c\u5176\u4e3b\u8981\u6587\u4ef6\u5c31\u662f\u901a\u8fc7\u5ba2\u6237\u7aef\u7684tnsnames.ora\u6765\u914d\u7f6e\uff0c\u5728\u539f\u6587\u4ef6\u7684\u57fa\u7840\u4e0a\u589e\u52a0\uff1a
SID\u522b\u540d =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SERVER_IP)(PORT = 1521))
)
(CONNECT_DATA =
(SID = SID_NAME)
)
)
\u4f8b\uff1a
dev_db =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.168.10.5)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ora10)
)
)
\u901a\u8fc7PL/SQL Developer\u8fde\u63a5dev_db\u65f6\uff0c\u62a5\u201cORA-12154: TNS: \u65e0\u6cd5\u89e3\u6790\u6307\u5b9a\u7684\u8fde\u63a5\u6807\u8bc6\u7b26\u201d\u3002\uff08\u8fd9\u4e2a\u95ee\u9898\u4ee5\u524d\u4e5f\u78b0\u5230\u8fc7\uff0c\u4f46\u89e3\u51b3\u65b9\u6cd5\u4e0d\u592a\u4e00\u6837\uff0c\u56e0\u5177\u4f53\u7684\u95ee\u9898\u4e0d\u592a\u4e00\u6837\u3002\uff09
\u6211\u5c06\u81ea\u5df1\u77e5\u9053\u7684\u4e00\u4e9b\u89e3\u51b3\u65b9\u6cd5\u8bf4\u4e00\u4e0b\uff1a
1.\u5148\u68c0\u67e5\u670d\u52a1\u5668\u7aef\u7684\u76d1\u542c\u670d\u52a1\u662f\u5426\u6253\u5f00\uff0c\u5982\u679c\u6ca1\u6709\u6253\u5f00\u8bf7\u542f\u52a8\u5176\u76d1\u542c
\u3000\u5ba2\u6237\u7aef:tnsping
\u670d\u52a1\u5668Linux\u4e0b:
\u3000\u3000\u3000\u3000\u3000#>lsnrctl status \u67e5\u770b\u76d1\u542c\u72b6\u6001
\u3000\u3000\u3000\u3000\u3000#>lsnrctl start\u3000\u542f\u52a8\u76d1\u542c
2.\u901a\u8fc7Sql Plus\u8fde\u63a5\u4e00\u4e0b\u8bd5\u8bd5\uff0c\u5982\u679cSql Plus\u8fde\u63a5\u80fd\u6210\u529f\uff0c\u90a3\u5c31\u8bf4\u660e\u4f60\u7684tnsnames.ora\u5185\u5bb9\u6709\u9519\u8bef
\u6211\u7684\u95ee\u9898\u5c31\u5728\u522b\u540ddev_db\u524d\u9762\u6709\u4e00\u4e2a\u7a7a\u683c\uff0c\u8fd9\u4e2a\u53ef\u4ee5\u901a\u8fc7\u6587\u672c\u7f16\u8f91\u5668(Edit Plus,UE\u7b49)\u6765\u67e5\u770b\u662f\u5426\u6709\u7a7a\u683c\uff0c\u53ea\u8981\u6709\u7a7a\u683c\u90a3\u5c31\u80af\u5b9a\u662f\u4e0d\u884c\u7684\uff0c\u800c\u4e14\u5982\u679c\u90a3\u6bb5\u5185\u5bb9\u662f\u51fa\u73b0\u5728\u6587\u4ef6\u7684\u4e2d\u95f4\u7684\u8bdd\uff0c\u5c06\u5bfc\u81f4\u8be5\u6587\u4ef6\u91cc\u6240\u6709\u76f8\u5e94\u7684\u8fde\u63a5\u522b\u540d\u90fd\u4e0d\u6210\u529f\uff0c\u5982\u679c\u662f\u5728\u6700\u540e\u9762\u5c31\u53ea\u6709\u5176\u81ea\u8eab\u8fde\u63a5\u522b\u540d\u4e0d\u80fd\u6210\u529f\uff0c\u5176\u4ed6\u8fde\u63a5\u522b\u540d\u8fd8\u662f\u80fd\u8fde\u63a5\u6210\u529f\u3002\uff08\u6ce8\uff1a\u6211\u7684tnsnames.ora\u914d\u7f6e\u4e86\u591a\u4e2a\u6570\u636e\u5e93\u5b9e\u4f8b\u7684\u8fde\u63a5\uff0c\u6240\u6709\u624d\u6709\u591a\u4e2a\u8fde\u63a5\u522b\u540d\u3002\uff09
\u5982\uff1a
\u7a7a\u683cdev_db =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.168.10.5)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ora10)
)
)
3.\u5982\u679c\u786e\u4fdd\u4f60\u7684tnsnames.ora\u5185\u5bb9\u6ca1\u6709\u9519\u8bef\uff0c\u90a3\u8bf7\u5c06%ORACLE_HOME%\product\10.2.0\db_1\NETWORK\ADMIN\u76ee\u5f55\u4e0b\u7684\u6240\u6709\u6587\u4ef6\u5220\u4e86\uff0c\u7136\u540e\u91cd\u65b0\u8fde\u63a5\uff0c\u4e00\u822c\u5c31\u80fd\u89e3\u51b3\u4e86\u3002
\u8bf4\u660e\u4e00\u4e0b\uff1a\u90a3\u4e2a\u76ee\u5f55\u91cc\u7684\u6587\u4ef6\u662f\u5728\u4f60\u5efa\u7acb\u8fde\u63a5\u7684\u65f6\u5019\u52a8\u6001\u751f\u6210\u7684\uff0c\u4e0d\u8981\u6015\u5220\u4e86\u4f1a\u6709\u95ee\u9898
4.\u8fdb\u5165PLSQL Developer\u7684\u4e3b\u754c\u9762,\u5728\u767b\u5f55\u754c\u9762\u9009\u62e9\u53d6\u6d88\u5373\u4e0d\u767b\u5f55\u8fdb\u5165\u4e3b\u754c\u9762\uff0c\u7136\u540e\u9009\u62e9\u83dc\u5355Tools(\u5de5\u5177)-Preferences(\u9996\u9009\u9879)\uff0c\u5728\u8bbe\u7f6e\u7a97\u53e3\u4e2d\uff0c\u9009\u62e9Oracle-Connection(\u8fde\u63a5)\uff0c\u5bf9\u5e94\u8bbe\u7f6e\u7a97\u53e3\u4e2d\uff0c\u627e\u5230Oracle Home(Oracle\u4e3b\u76ee\u5f55)\uff0c\u9009\u62e9\u4f60\u672c\u5730\u6240\u5b89\u88c5\u5ba2\u6237\u7aef\u7684\u7248\u672c\uff0c\u4fdd\u5b58\u8bbe\u7f6e\uff0c\u7136\u540e\u91cd\u65b0\u542f\u52a8PLSQL Developer\uff0c\u8fd9\u65f6\u5c31\u53ef\u4ee5\u6b63\u5e38\u767b\u5f55\u4e86\u3002
\u6253\u5f00client\u5b89\u88c5\u76ee\u5f55\u4e0bnetwork->admin\u4e0b\u7684tnsnames.ora\u6587\u4ef6
\u5185\u5bb9\u5982\u4e0b\uff1a
# tnsnames.ora Network Configuration File: F:/oracle/product/10.2.0/client_2/NETWORK/ADMIN/tnsnames.ora # Generated by Oracle configuration tools.
abc =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.9)(PORT = 1521)))(CONNECT_DATA =(SID = orcl)(SERVER = DEDICATED)))
127.0.0.1_LOCALLOST =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = Locallost)(PORT = 1521)))(CONNECT_DATA =(SID = 127.0.0.1)(SERVER = DEDICATED)))
ORCL_LOCALHOST =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = Localhost)(PORT = 1521)))(CONNECT_DATA =(SID = orcl)(SERVER = DEDICATED)))
\u628a\u7ea2\u8272\u5b57\u4f53\u90e8\u5206\uff0c\u62f7\u8d1d\u5230\u670d\u52a1\u5668\u7aef\u7684\u5b89\u88c5\u76ee\u5f55\u4e0bnetwork->admin\u4e0b\u7684tnsnames.ora\u6587\u4ef6\u3002\u5982\u4e0b\u6240\u793a\uff1a
# tnsnames.ora Network Configuration File: F:/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools.
ORCL =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 74B5853F2D1648B)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = orcl)))
abc =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.9)(PORT = 1521)))(CONNECT_DATA =(SID = orcl)(SERVER = DEDICATED)))
EXTPROC_CONNECTION_DATA =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)))
\u4fee\u6539\u540e\uff0c\u53d1\u73b0\u53ef\u4ee5\u8fde\u63a5\u6570\u636e\u5e93\u4e86\u3002
Oracle Database\uff0c\u53c8\u540dOracle RDBMS\uff0c\u6216\u7b80\u79f0Oracle\u3002\u662f\u7532\u9aa8\u6587\u516c\u53f8\u7684\u4e00\u6b3e\u5173\u7cfb\u6570\u636e\u5e93\u7ba1\u7406\u7cfb\u7edf\u3002\u5b83\u662f\u5728\u6570\u636e\u5e93\u9886\u57df\u4e00\u76f4\u5904\u4e8e\u9886\u5148\u5730\u4f4d\u7684\u4ea7\u54c1\u3002\u53ef\u4ee5\u8bf4Oracle\u6570\u636e\u5e93\u7cfb\u7edf\u662f\u76ee\u524d\u4e16\u754c\u4e0a\u6d41\u884c\u7684\u5173\u7cfb\u6570\u636e\u5e93\u7ba1\u7406\u7cfb\u7edf\uff0c\u7cfb\u7edf\u53ef\u79fb\u690d\u6027\u597d\u3001\u4f7f\u7528\u65b9\u4fbf\u3001\u529f\u80fd\u5f3a\uff0c\u9002\u7528\u4e8e\u5404\u7c7b\u5927\u3001\u4e2d\u3001\u5c0f\u3001\u5fae\u673a\u73af\u5883\u3002\u5b83\u662f\u4e00\u79cd\u9ad8\u6548\u7387\u3001\u53ef\u9760\u6027\u597d\u7684 \u9002\u5e94\u9ad8\u541e\u5410\u91cf\u7684\u6570\u636e\u5e93\u89e3\u51b3\u65b9\u6848\u3002
ORACLE\u6570\u636e\u5e93\u7cfb\u7edf\u662f\u7f8e\u56fdORACLE\u516c\u53f8(\u7532\u9aa8\u6587)\u63d0\u4f9b\u7684\u4ee5\u5206\u5e03\u5f0f\u6570\u636e\u5e93\u4e3a\u6838\u5fc3\u7684\u4e00\u7ec4\u8f6f\u4ef6\u4ea7\u54c1\uff0c\u662f\u76ee\u524d\u6700\u6d41\u884c\u7684\u5ba2\u6237/\u670d\u52a1\u5668(CLIENT/SERVER)\u6216B/S\u4f53\u7cfb\u7ed3\u6784\u7684\u6570\u636e\u5e93\u4e4b\u4e00\u3002\u6bd4\u5982SilverStream\u5c31\u662f\u57fa\u4e8e\u6570\u636e\u5e93\u7684\u4e00\u79cd\u4e2d\u95f4\u4ef6\u3002ORACLE\u6570\u636e\u5e93\u662f\u76ee\u524d\u4e16\u754c\u4e0a\u4f7f\u7528\u6700\u4e3a\u5e7f\u6cdb\u7684\u6570\u636e\u5e93\u7ba1\u7406\u7cfb\u7edf\uff0c\u4f5c\u4e3a\u4e00\u4e2a\u901a\u7528\u7684\u6570\u636e\u5e93\u7cfb\u7edf\uff0c\u5b83\u5177\u6709\u5b8c\u6574\u7684\u6570\u636e\u7ba1\u7406\u529f\u80fd;\u4f5c\u4e3a\u4e00\u4e2a\u5173\u7cfb\u6570\u636e\u5e93\uff0c\u5b83\u662f\u4e00\u4e2a\u5b8c\u5907\u5173\u7cfb\u7684\u4ea7\u54c1;\u4f5c\u4e3a\u5206\u5e03\u5f0f\u6570\u636e\u5e93\u5b83\u5b9e\u73b0\u4e86\u5206\u5e03\u5f0f\u5904\u7406\u529f\u80fd\u3002\u4f46\u5b83\u7684\u6240\u6709\u77e5\u8bc6\uff0c\u53ea\u8981\u5728\u4e00\u79cd\u673a\u578b\u4e0a\u5b66\u4e60\u4e86ORACLE\u77e5\u8bc6\uff0c\u4fbf\u80fd\u5728\u5404\u79cd\u7c7b\u578b\u7684\u673a\u5668\u4e0a\u4f7f\u7528\u5b83\u3002
Oracle\u6570\u636e\u5e93\u6700\u65b0\u7248\u672c\u4e3aOracle Database 12c\u3002Oracle\u6570\u636e\u5e9312c \u5f15\u5165\u4e86\u4e00\u4e2a\u65b0\u7684\u591a\u627f\u79df\u65b9\u67b6\u6784\uff0c\u4f7f\u7528\u8be5\u67b6\u6784\u53ef\u8f7b\u677e\u90e8\u7f72\u548c\u7ba1\u7406\u6570\u636e\u5e93\u4e91\u3002\u6b64\u5916\uff0c\u4e00\u4e9b\u521b\u65b0\u7279\u6027\u53ef\u6700\u5927\u9650\u5ea6\u5730\u63d0\u9ad8\u8d44\u6e90\u4f7f\u7528\u7387\u548c\u7075\u6d3b\u6027\uff0c\u5982Oracle Multitenant\u53ef\u5feb\u901f\u6574\u5408\u591a\u4e2a\u6570\u636e\u5e93\uff0c\u800cAutomatic Data Optimization\u548cHeat Map\u80fd\u4ee5\u66f4\u9ad8\u7684\u5bc6\u5ea6\u538b\u7f29\u6570\u636e\u548c\u5bf9\u6570\u636e\u5206\u5c42\u3002\u8fd9\u4e9b\u72ec\u4e00\u65e0\u4e8c\u7684\u6280\u672f\u8fdb\u6b65\u518d\u52a0\u4e0a\u5728\u53ef\u7528\u6027\u3001\u5b89\u5168\u6027\u548c\u5927\u6570\u636e\u652f\u6301\u65b9\u9762\u7684\u4e3b\u8981\u589e\u5f3a\uff0c\u4f7f\u5f97Oracle\u6570\u636e\u5e9312c \u6210\u4e3a\u79c1\u6709\u4e91\u548c\u516c\u6709\u4e91\u90e8\u7f72\u7684\u7406\u60f3\u5e73\u53f0\u3002
（1）Oracle服务器没有装好(一般不建议重装，因为Oracle卸载不完全是没法重装的)
（2）TNS没有配置
现在本文给出解决方案：
现在先测试一下tns是否可以ping，成功的界面大致如下
这里写图片描述
（1）在oracle安装路径的tns配置文件里添加如下代码
# tnsnames.ora Network Configuration File: d:\Oracle\product\10.2.0\client_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)
其中orcl是我的数据库名称，这个需要根据需要配置
绛旓細鎴戞兂浣犳槸鎯冲仛涓」鐩惂锛屾垜涔嬪墠鍋氳繃鍑犱釜锛屼綘鐪嬬湅鏈夋病鏈変綘鐢ㄧ殑鐫鐨勩
绛旓細1銆丮icrosoft Access 2010锛堟暟鎹簱绠＄悊绯荤粺锛氱敤鏉ュ垱寤烘暟鎹簱鍜岀▼搴忔潵璺熻釜涓庣鐞嗕俊鎭級锛2銆丮icrosoft Excel 2010锛堟暟鎹鐞嗙▼搴忥細鐢ㄦ潵鎵ц璁＄畻銆佸垎鏋愪俊鎭互鍙婂彲瑙嗗寲鐢靛瓙琛ㄦ牸涓殑鏁版嵁锛夛紱3銆丮icrosoft InfoPath Designer 2010锛堢敤鏉ヨ璁″姩鎬佽〃鍗曪紝浠ヤ究鍦ㄦ暣涓粍缁囦腑鏀堕泦鍜岄噸鐢ㄤ俊鎭級锛4銆丮icrosoft InfoPath Filler 20...
绛旓細Microsoft Office Acce Microsoft Office Access(鍓嶅悕 Microsoft Access)鏄敱寰蒋鍙戝竷鐨勫叧鑱斿紡鏁版嵁搴撶鐞嗙郴缁熴傚畠缁撳悎浜 Microsoft Jet Database Engine 鍜 鍥惧舰鐢ㄦ埛鐣岄潰涓ら」鐗圭偣,鏄 Microsoft Office 2007 鐨勬垚鍛樹箣涓銆 Assess鑳藉瀛樺彇 Access/Jet銆丮icrosoft SQL Server銆Oracle,鎴栬呬换浣 ODBC 鍏煎鏁版嵁搴撳唴鐨勮祫鏂欍傜啛缁...
绛旓細Microsoft Office Acce Microsoft Office Access(鍓嶅悕 Microsoft Access)鏄敱寰蒋鍙戝竷鐨勫叧鑱斿紡鏁版嵁搴撶鐞嗙郴缁熴傚畠缁撳悎浜 Microsoft Jet Database Engine 鍜 鍥惧舰鐢ㄦ埛鐣岄潰涓ら」鐗圭偣,鏄 Microsoft Office 2007 鐨勬垚鍛樹箣涓銆 Assess鑳藉瀛樺彇 Access/Jet銆丮icrosoft SQL Server銆Oracle,鎴栬呬换浣 ODBC 鍏煎鏁版嵁搴撳唴鐨勮祫鏂欍傜啛缁...
绛旓細Microsoft Office Acce Microsoft Office Access(鍓嶅悕 Microsoft Access)鏄敱寰蒋鍙戝竷鐨勫叧鑱斿紡鏁版嵁搴撶鐞嗙郴缁熴傚畠缁撳悎浜 Microsoft Jet Database Engine 鍜 鍥惧舰鐢ㄦ埛鐣岄潰涓ら」鐗圭偣,鏄 Microsoft Office 2007 鐨勬垚鍛樹箣涓銆 Assess鑳藉瀛樺彇 Access/Jet銆丮icrosoft SQL Server銆Oracle,鎴栬呬换浣 ODBC 鍏煎鏁版嵁搴撳唴鐨勮祫鏂欍傜啛缁...
