ora-12154问题怎么解决
ora-12154 \u65e0\u6cd5\u5904\u7406\u670d\u52a1\u5668\u540d\u9519\u8bef\u5982\u4f55\u5904\u7406\u3002ora-12154\u901a\u5e38\u7684\u68c0\u67e5\u548c\u5904\u7406\u529e\u6cd5\uff1a
1\u3001\u9996\u5148\u67e5\u770b\u5ba2\u6237\u7aef\u7684tnsnames.ora\u6587\u4ef6\uff0c\u627e\u5230\u6570\u636e\u5e93\u8fde\u63a5\u7684\u63cf\u8ff0\u4e2d\uff0csid= \u6216service_name=\u4e4b\u540e\u7684\u540d\u79f0\uff0c\u5047\u8bbe\u8fd9\u4e2a\u540d\u79f0\u662forcl\u3002
2\u3001\u7136\u540e\u5728\u5ba2\u6237\u7aef\u7528tnsping\u547d\u4ee4\uff0c\u6d4b\u8bd5\u521a\u624d\u627e\u5230\u7684\u5b9e\u4f8b\u540d\uff0c\u547d\u4ee4\uff1atnsping orcl
\u5982\u679c\u4e0d\u901a\uff0c\u5219\u8981\u4ece\u7f51\u7edc\u73af\u5883\u3001\u6570\u636e\u5e93\u73af\u5883\u7b49\u65b9\u9762\u627e\u539f\u56e0\uff0c\u770b\u662f\u5426\u5b9e\u4f8b\u540d\u9519\u8bef\u3001\u6570\u636e\u5e93\u662f\u5426\u542f\u52a8\u3001\u6570\u636e\u5e93\u76d1\u542c\u662f\u5426\u542f\u52a8\u3001\u7f51\u7edc\u662f\u5426\u901a\u7545\u3002
\u4f60\u7684\u914d\u7f6e\u6709\u95ee\u9898\u3002
\u68c0\u67e5listener.ora\u548ctnsnames.ora\u914d\u7f6e\uff1a
\u793a\u4f8b\u5982\u4e0b\uff1a
listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(ORACLE_HOME = F:\oracle\product\10.2.0\db_1)
(SID_NAME = orcl(\u4fee\u6539\u4e3a\u5b9e\u4f8b\u540d))
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1(\u4fee\u6539\u4e3a\u4e3b\u673aIP\u5730\u5740\u6216\u4e3b\u673a\u540d))(PORT = 1521))
)
)
tnsnames.ora
myORCL=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1(\u4fee\u6539\u4e3a\u4e3b\u673aIP\u5730\u5740\u6216\u4e3b\u673a\u540d))(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl\uff08\u4fee\u6539\u4e3a\u5b9e\u4f8b\u540d\uff09)
)
)
\u914d\u7f6e\u597d\u540etnsping myORCL \u770b\u901a\u4e0d\u901a\u3002
\u767b\u9646\u683c\u5f0f\u4e3a sqlplus username/password@myORCL
myORCL\u4e3atnsnames.ora\u4e2d\u914d\u7f6e\u7684\u540d\u79f0\uff0c\u540d\u79f0\u53ef\u4ee5\u968f\u4fbf\u53d6\uff0c\u4e0d\u4e00\u5b9a\u8981\u4e0e\u5b9e\u4f8b\u540d\u4e00\u6837\uff0c\u4e0d\u662f\u5b9e\u4f8b\u540d,\u6ce8\u610f\u533a\u522b\u3002
\u5f00\u542f\u76d1\u542c\u670d\u52a1\uff1alsnrctl start
1、首先查看客户端的tnsnames.ora文件，找到数据库连接的描述中，sid= 或service_name=之后的名称，假设这个名称是orcl。
2、然后在客户端用tnsping命令，测试刚才找到的实例名，命令：tnsping orcl
如果不通，则要从网络环境、数据库环境等方面找原因，看是否实例名错误、数据库是否启动、数据库监听是否启动、网络是否通畅。
绛旓細3銆佷娇鐢⊿QLPLUS娴嬭瘯杩炴帴銆傚鏋滆繕鏈夐棶棰橈紝鎴戜滑浣跨敤SQLPLUS娴嬭瘯鏄惁鑳藉杩炴帴銆4銆侀氳繃PL/SQLDeveloper杩炴帴dev_db鏃讹紝鎶モ淥RA-12154锛歍NS锛氭棤娉曡В鏋愭寚瀹氱殑杩炴帴鏍囪瘑绗︹濄傦紙杩欎釜闂浠ュ墠涔熺鍒拌繃锛屼絾瑙ｅ喅鏂规硶涓嶅お涓鏍凤紝鍥犲叿浣撶殑闂涓嶅お涓鏍枫5銆乷rcl杩欎釜浠ｈ〃鐨勬槸杩炴帴鐨勬湇鍔″悕銆備笉鏄暟鎹簱鍚嶃傛湇鍔″悕鍦ㄤ綘鐨勫紑...
绛旓細ora-12154 鏃犳硶澶勭悊鏈嶅姟鍣ㄥ悕閿欒瑙ｅ喅鏂规硶濡備笅锛氱紪杈戜唬鐮侊細XIEHENG_192.168.16.20 =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.16.20)(PORT = 1521))(CONNECT_DATA =(SID = XIEHENG)(SERVER = DEDICATED)GCBORA_192.168.1.3 =(DESCRIPTION =( ADDRESS_LIST...
绛旓細1銆闂 ORA-12154: TNS:could not resolve the connect identifier specified 锛屽嵆鏃犳硶瑙ｆ瀽鎸囧畾鐨勮繛鎺ワ紝杩欒鏄庣己灏戜簡涓涓幆澧冨彉閲忥紝TNS_ADMIN 銆2銆佹壘鍒癙LSQL涓殑oracle home锛堜富鐩綍锛夊拰OCI library锛坥ci.dll鍦板潃锛夐厤缃3銆佹牳瀵瑰畬涓婅堪闂鍚庡鍙戠幇闂浠嶆棫娌℃湁瑙ｅ喅锛屾煡鐪媡nsnames.ora鏂囦欢锛屾煡鐪嬫暟鎹簱...
绛旓細1銆佹鏌ユ湇鍔 鍑虹幇杩欑闂锛岄鍏堟垜浠兂鍒扮殑鏄鏌ユ湇鍔℃湁娌℃湁闂OracleOraDb11g_home2TNSListener銆傚湪杩愯涓緭鍏ervices.msc锛屾墦寮鏈嶅姟绐楀彛锛岀湅鐪婳racleOraDb11g_homeTNSListener杩欎釜鏈嶅姟鏄惁姝ｅ湪杩愯锛屽鏋滄病鏈夎繍琛岋紝鍒欏惎鍔ㄣ2銆佷娇鐢⊿QL PLUS娴嬭瘯杩炴帴銆傚鏋滆繕鏈夐棶棰橈紝鎴戜滑浣跨敤SQL PLUS娴嬭瘯鏄惁鑳藉杩炴帴銆傝繍琛岃緭鍏...
绛旓細ORA-12154: TNS: 鏃犳硶瑙ｆ瀽鎸囧畾鐨勮繛鎺ユ爣璇嗙鈥濄傚悓鏍风殑闂涔熶細鍑虹幇鍦ㄥ叾浠朞racle鏁版嵁搴撶鐞嗚蒋浠朵腑锛屾瘮濡俆oad for Oracle 鈥淥RA-12154: TNS: 鏃犳硶瑙ｆ瀽鎸囧畾鐨勮繛鎺ユ爣璇嗙鈥濇槸浣跨敤Oracle鏁版嵁搴撶殑鏂版墜閬囧埌鐨勬瘮杈冨父瑙佺殑闂涔嬩竴锛屽彧瑕佹垜浠簡瑙ｄ簡瀹冪殑宸ヤ綔鏂瑰紡锛屽喎闈欐帓鏌ワ紝鐩镐俊寰堝鏄撳氨鑳藉鎵惧埌闂鐨瑙ｅ喅鍔炴硶鐨勩
绛旓細鍥炵瓟锛氬叧閿湪杩欎釜閿欒涓: ORA-04052: 鍦ㄦ煡鎵捐繙绋嬪璞 FOLK_BAK.T_FL_LENDERBASICINFOP@FOLKBACKUP 鏃跺嚭閿 鎶ラ敊鐨勫師鍥犱负鍒涘缓瀵煎叆SCHEMA鐨凞BLINK澶辫触涓嶉氭棤娉曡闂 鐗瑰埆鐨凴AC鏁版嵁搴,瑕佷繚璇乼nsnames.ora鍦ㄤ袱涓妭鐐归兘杩佺Щ杩囨潵浜 瑙ｅ喅鍔炴硶鏄縼绉籺nsnames.ora 鍙﹀杩樺姞浜咰LUSTER=N璁╁叾鍙湪涓涓妭鐐硅繍琛 http://...
绛旓細3銆ora-12514: TNS: 鐩戝惉杩涚▼涓嶈兘瑙ｆ瀽鍦ㄨ繛鎺ユ弿杩扮涓粰鍑虹殑SERVICE_NAME 鎵撳紑NetManager锛岄変腑鏈嶅姟鍚嶇О锛屾鏌ユ湇鍔℃爣璇嗘爮閲岀殑鏈嶅姟鍚嶈緭鍏ユ槸鍚︽纭傝鏈嶅姟鍚嶅繀椤讳笌鏈嶅姟鍣ㄧ鐩戝惉鍣ㄩ厤缃殑鍏ㄥ眬鏁版嵁搴撳悕涓鑷淬傚悓鏃舵鏌qlnet.ora锛屼緥濡傚鏋滄兂瑕侀噰鐢ㄧ畝渚胯繛鎺ユ柟寮忚繛鎺ュ氨闇瑕佸湪NAMES.DIRECTORY_PATH鍙傛暟涓坊鍔燛ZCONNECT...
绛旓細鏈夊嚑绉瑙ｅ喅鏂规硶锛堥渶瑕佺敤root鐢ㄦ埛鎵ц锛1. 涓存椂绂佺敤闃茬伀澧欙紝鏈哄櫒閲嶅惎涔嬪悗闃茬伀澧欎細閲嶆柊鍚姩銆俿ervice iptables stop 2. 姘镐箙绂佺敤闃茬伀澧欍俢hkconfig iptables off 3. 鍦ㄩ槻鐏瑙勫垯涓墦寮1521绔彛锛圤racle鏁版嵁搴撶洃鍚鍙ｏ級iptables -A RH-Firewall-1-INPUT -p tcp --dport 1521 -j ACCEPT 淇敼鍚庨氳繃涓嬮潰...
绛旓細ORA-12154: TNS: 鏃犳硶瑙ｆ瀽鎸囧畾鐨勮繛鎺ユ爣璇嗙,瑙ｅ喅鎬濊矾锛氳繖绉嶆儏鍐垫垜閬囧埌杩囧嚑娆★紝涓鑸槸鍥犱负鐢32浣嶇殑瀹㈡埛绔幓閾炬帴64浣嶇殑oracle鏈嶅姟绔埌璐︾殑涓嶅吋瀹闂锛屽湪杩欑鎯呭喌涓嬶紝鎴戜滑闇瑕佸湪鏈満淇敼2澶勭幆澧冨彉閲忋備慨鏀逛竴锛氫慨鏀圭幆澧冨彉閲廜RACLE_HOME寰楀奸厤缃紝瑕佹寚鍚憃racle\product\10.2.0\client_1 淇敼浜岋細鍦ㄧ洃鍚...
绛旓細杩欐槸鍥犱负鏈嶅姟涓病鏈夊紑鍚洃鍚紝鍦ㄥ紑鍚洃鍚殑杩囩▼涓彲鑳戒細閬囧埌浠ｇ爜涓1067鐨勯敊璇紝杩欐椂闇瑕佹墜鍔ㄥ垹闄istener.ora鏂囦欢鐒跺悗鐢╫racle鑷甫鐨凬et Configuration Assitant杩涜閲嶆柊鍒涘缓鐩戝惉锛屼竴鑸繖鏍峰氨瑙ｅ喅浜
