Oracle TNS報錯大全

1、tnsnames.ora檔名被修改

TNS-03505: Failed to resolve name
 

2、IP或hostname無法ping通

TNS-12543: TNS:destination host unreachable

 

3、主機名無法解析（涉及hosts檔案或DNS）

TNSPING和SQLPLUS報錯均為：   ORA-12545: Connect failed because target host or object does not exist

 

4、埠未開啟

ORA-12541: TNS:no listener

 

5、防火牆未開啟埠或tns檔案與listener中埠不一致

TNSPING報錯為：TNS-12535: TNS:operation timed out

SQLPLUS報錯為：ORA-12170: TNS:Connect timeout occurred

 

6、service_name指定服務名與監聽中不符

TNSPING可以通。

SQLPLUS連線報錯：ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

 

7、監聽未開啟

ORA-12541: TNS:no listener

 

8、連線RAC報錯

ORA-12545:Connect failed because target host or object does not exist

解決方法是：修改RAC的local_listener引數，將引數值中HOST=的值改為當前節點的VIP或者scanip--注意是IP而不是hostname，客戶端可以透過SCANIP或者VIP都可以連線到RAC資料庫庫

詳見：http://blog.csdn.net/haibusuanyun/article/details/17737553

 

9、共享模式連到靜態監聽

ORA-12523: TNS:listener could not find instance appropriate for the client

 

參考文件：

http://blog.csdn.net/haibusuanyun/article/details/14517211