plsql登陆时报错ora-12154:tns:无法解析指定的连接标识符 oracle连接不了 报ORA-12154：TNS：无法解析...
plsql\u767b\u9646\u62a5ORA-12154\uff1aTNS\uff1a\u65e0\u6cd5\u89e3\u6790\u6307\u5b9a\u7684\u94fe\u63a5\u6807\u8bc6\u4f60\u5e94\u8be5\u6253\u5f00\u5b89\u88c5PL/SQL\u7684\u8def\u5f84\uff0c\u5728\u5b89\u88c5\u6587\u4ef6\u4e2d\u627e\u5230orclient \u8fd9\u4e2a\u6587\u4ef6\u5939\uff0c\u8fdb\u53bb\u4e4b\u540e\u6709tnsnames\u3002ora \u8fd9\u4e2a\u6587\u4ef6\uff0c\u89c1\u5230\u5f88\u591a\u5404\u4e0d\u540c\u6570\u636e\u5e93,
host="\u4f60\u672c\u673a\u7684IP \u6216\u8005 \u5c40\u57df\u7f51\u4e2d\u7684IP\u5730\u5740"
port \u4e00\u822c\u9ed8\u8ba41521
service_name="\u4f60\u8981\u8fde\u63a5\u7684\u6570\u636e\u5e93\u540d"
\u5f00\u5934\u7684db1\u6700\u597d\u4e0eservice_name\u540c\u540d
\u5e0c\u671b\u80fd\u5e2e\u52a9\u4f60
\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
用户名：xxx（如果是System用户，S要大写。）
密码：xxxx
数据库：你的ip地址：1521/你的数据库实例（你的监听里写的这个SYSTEM）
比如：192.168.1.164：1521/SYSTEM
连接为：Normal
不行的话运行：services.msc 打开服务，重启 OracleTNSxxx和OracleServerORCL这2个服务
手打。谢谢!
cmd下
tnsping QiaoweiPC:1521/system
能否正常ping通。
如果可以，那就是你plsql 中的oracle_home环境变量设置的问题。
这是因为服务中没有开启监听，在开启监听的过程中可能会遇到代码为1067的错误，这时需要手动删除listener.ora文件然后用oracle自带的Net
Configuration
Assitant进行重新创建监听，一般这样就解决了
你的机器不能解析QiaoweiPC，换成IP地址试试
绛旓細1銆佽繛鎺ヤ负锛歂ormal涓嶈鐨勮瘽杩愯锛歴ervices.msc鎵撳紑鏈嶅姟锛岄噸鍚疧racleTNSxxx鍜孫racleServerORCL杩2涓湇鍔℃墜鎵撱2銆佺敤tnsping妫娴plSQL鐧婚檰鏃禿atabase(鏁版嵁搴)鍒悕鏄惁鍙纭В鏋愶紝濡傛姤鈥淭NS-03505锛氭棤娉曡В鏋愬悕绉扳濓紝鍒欐database鍒悕鏈夊啿绐侊紝闇鏇存敼銆3銆佷娇鐢⊿QLPLUS娴嬭瘯杩炴帴銆傚鏋滆繕鏈夐棶棰橈紝鎴戜滑浣跨敤SQLPLUS娴嬭瘯...
绛旓細1锛屼綘璇存绘槸鏄粈涔堟剰鎬濓紝濡傛灉鏄粠瀹夎鎴愬姛鍒扮幇鍦ㄩ兘鏄繖涓彁绀猴紝閭ｄ箞浣犲彲浠ヨ冭檻涓涓嬩綘鐨勭洃鍚枃浠秚nsnames.ora鏈夋病鏈夐厤缃锛屽埆鍚嶏紝IP鍦板潃锛屼互鍙奡ID锛屽鏋滄槸鏈杩戞墠鍑虹幇锛岄偅涔堜綘瑕佹煡涓涓媜racle鐢佃剳鎵鍦↖P鍦板潃鏈夋病鏈変慨鏀硅繃锛屼慨鏀逛簡锛屽悓鐞嗭紝淇敼涓涓嬬洃鍚枃浠躲2锛屼綘鐨勭洃鍚湇鍔℃病鏈夊惎鍔紝鎴栬呴渶瑕侀噸鏂板惎鍔ㄤ竴涓...
绛旓細ORA-12154: TNS: 鏃犳硶瑙ｆ瀽鎸囧畾鐨勮繛鎺ユ爣璇嗙 闂\x0d\x0a\x0d\x0a鐩镐俊浣滀负ORACLE鏁版嵁搴撶殑寮鍙戜汉鍛樻病鏈夊皯纰板埌鈥淥RA-12154: TNS: 鏃犳硶瑙ｆ瀽鎸囧畾鐨勮繛鎺ユ爣璇嗙鈥濓紝浠婂ぉ鎴戜篃鍙堢鍒颁簡绫讳技鐨勬儏鍐碉紝灏嗘垜鐨勮В鍐虫柟娉曡繘琛屽皬缁擄紝甯屾湜鑳藉纰板埌鍚屾牱闂鐨勫弸浜轰滑鎻愪緵甯姪銆俓x0d\x0a\x0d\x0a闂鍦烘櫙鎻忚堪锛...
绛旓細<ora_home>\network\admin鏂囦欢澶涓sqlnet閰嶇疆鏂囦欢SQLNET.AUTHENTICATION_SERVICES = (NTS)鏄惁鍔犱笂#鍙蜂簡锛屽鏋滄槸鎶#鍙峰幓鎺夈傝繕涓嶈兘鐧诲叆鐨勮瘽鍙傝冧竴涓嬩笅闈㈠湴鍧鐨勫唴瀹广俬ttp://blog.csdn.net/wyzxg/article/details/4301266
绛旓細1锛屾湇鍔＄鐨勭洃鍚▼搴忓紑浜嗗悧锛屽懡浠ゆ槸lsnrctl start ,2锛屽鎴风閰嶄簡tns浜嗗悧锛屽湪cmd涓婅緭鍏 netca 閫夆樻湰鍦皀et xxx鈥欓偅涓紝3锛岀綉缁減ing寰楅氬悧锛屼竴鑸氨鏄繖涓変釜鍘熷洜浜嗐
绛旓細1銆佹煡鎵炬敞鍐岃〃锛屽皢鐩戝惉鍣ㄦ寚鍚戞柊鐨勪綅缃紝閲嶅惎鏈嶅姟锛孫K锛2銆PL/SQL DEVELOPER杩樻槸杩炴帴涓嶄簡锛屽叾瀹冩柟寮忛兘姝ｅ父銆傚皢鍘熷厛瀹夎鍦ㄥ叾瀹冮昏緫鐩樼殑ODP for .Net 鍗歌浇閲嶈鍒颁笌ORACLE 10.2.0鍚屼竴浣嶇疆銆傞噸鍚郴缁燂紝DEVELOPER杩樻槸鎶ラ敊锛屼笉杩囦簺鏃舵姤閿鎻愮ず淇℃伅涓虹┖銆3銆佸洜涓篋EVELOPER璁剧疆鏈夋洿鏀瑰悗锛岃繘鍏ヨ彍鍗昑OOLS銆婸REFERENCES....
绛旓細•1. 涓嬭浇32浣峅racle InstantClient锛屽苟灞曞紑鍒版煇鐩綍锛屼緥濡侰:\instantclient-basic-nt-11.2.0.2.0锛•2. 灏嗙郴缁熺殑tnsnames.ora鎷疯礉鍒拌鐩綍涓嬶紱•3. 鍦PLSQL Developer涓缃甇racle_Home鍜孫CI Library锛歍oolsPreferencesOracleConnection锛歄racle_Home锛欳:...
绛旓細鐩存帴鐧诲綍璇曡瘯銆傜敤鎴峰悕锛歺xx锛堝鏋滄槸System鐢ㄦ埛锛孲瑕佸ぇ鍐欍傦級瀵嗙爜锛歺xxx 鏁版嵁搴擄細浣犵殑ip鍦板潃锛1521/浣犵殑鏁版嵁搴撳疄渚嬶紙浣犵殑鐩戝惉閲屽啓鐨勮繖涓猄YSTEM锛夋瘮濡傦細192.168.1.164锛1521/SYSTEM 杩炴帴涓猴細Normal 涓嶈鐨勮瘽杩愯锛歴ervices.msc 鎵撳紑鏈嶅姟锛岄噸鍚 OracleTNSxxx鍜孫racleServerORCL杩2涓湇鍔 鎵嬫墦銆傝阿璋!
绛旓細2.鍦ㄨ繛鎺L/SQL鏃舵姤閿.鍦PLSQL Developer閫夋嫨Tools > Preferences > options鎴栬卌onnection > 鎵惧埌杩欎袱涓弬鏁 "Oracle Home" and "OCI Library".閫夋嫨鑷繁鎯宠鐨,姣斿鎴戠殑鏄.ORACLE_HOME:OraDb10g_home1 OCI Library:D:\oracle\product\10.2.0\db_1\bin\oci.dll.瀹屾垚涓婅堪鎿嶄綔闇瑕侀噸鍚疨L/SQL...
绛旓細2 濡傛灉鑳絧ing閫氾紝鍐峵elnet杩滅▼鏁版嵁搴撶殑绔彛,oracle鏈嶅姟榛樿绔彛鏄1521銆傚telnet 192.168.1.2 1521锛屽鏋滆兘澶焧elnet涓嶆垚鍔燂紝閭ｈ偗瀹氭棤娉曡繛鏁版嵁搴撱3 濡傛灉涓婅堪閮戒笉琛岋紝鎶婃湰鍦版満鍣ㄧ殑闃茬伀澧欏叧浜嗐傚啀璇曚笂杩颁袱姝ャ4 濡傛灉鑳絫elnet锛ORA-12170鐨勬剰鎬濆氨鏄繛鎺ヨ秴鏃躲傚鏋滆兘澶熷埌杩滅▼鏁版嵁搴撴湰鍦板幓鎿嶄綔锛屽彲浠ュ厛鍦...
