TNS-12560: TNS:protocol adapter error 錯誤解決
環境: 資料庫伺服器 linux rh4 +oracle 10.2.0.4
客戶端:winxp sp2
連線資料庫時報TNS-12560錯誤
C:\Documents and Settings\Paul Yi>tnsping asm
TNS Ping Utility for 32-bit Windows: Version 9.2.0.8.0 - Production on 07-JUL-20
08 09:45:01
Copyright (c) 1997, 2006, Oracle Corporation. All rights reserved.
Used parameter files:
D:\oracle\ora92\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 192.168.1.206)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME =orcl)))
TNS-12560: TNS:protocol adapter error
例項採用靜態註冊 在伺服器上執行正常
[oracle@localhost admin]$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 07-JUL-2008 08:44:39
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.206)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 07-JUL-2008 08:40:31
Uptime 0 days 0 hr. 4 min. 8 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/10.2/db/network/admin/listener.ora
Listener Log File /oracle/10.2/db/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.206)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@localhost admin]$ tnsping asm
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 07-JUL-2008 08:56:12
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1.206)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (10 msec)
[oracle@localhost admin]$
最後想到防火牆問題 把防火牆關閉後
[root@localhost ~]# service iptables stop
Flushing firewall rules: [ OK ]
Setting chains to policy ACCEPT: filter [ OK ]
Unloading iptables modules: [ OK ]
C:\Documents and Settings\Paul Yi>tnsping asm
TNS Ping Utility for 32-bit Windows: Version 9.2.0.8.0 - Production on 07-JUL
08 09:52:13
Copyright (c) 1997, 2006, Oracle Corporation. All rights reserved.
Used parameter files:
D:\oracle\ora92\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = T
(HOST = 192.168.1.206)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME =orcl)))
OK (0 msec)
正常 ,但想一下是透過預設埠1521訪問的,所以允許訪問伺服器上的1521埠即可
vi /etc/sysconfig/iptables
將
-A RH-Firewall-1-INPUT -j REJECT --reject-with icmp-host-prohibited
改為
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 1520:1523 -j ACCEPT
允許1520到1523的埠訪問
[root@localhost ~]# service iptables restart
Flushing firewall rules: [ OK ]
Setting chains to policy ACCEPT: filter [ OK ]
Unloading iptables modules: [ OK ]
Applying iptables firewall rules: [ OK ]
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7199859/viewspace-374281/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- EBS TNS-12546: TNS:permission denied+ TNS-12560: TNS:protocol adapter error+TNS-00516: Permission deProtocolAPTError
- TNS-04414 file error 錯誤解決Error
- Oracle TNS-12560, TNS-00530 錯誤Oracle
- Connect oracle database error in sqlplus: ORA-12560: TNS: protocol adapter errorOracleDatabaseErrorSQLProtocolAPT
- TNS-12547 TNS-12560 TNS-00517解決辦法
- tns-12560 tns-00530 解決方法一例
- 登入asmcmd提示ORA-12557: TNS:protocol adapter not loadable (DBD ERROR: OCIServerAttach)ASMProtocolAPTErrorServer
- Datastore error in 'dirbdb'錯誤解決ASTError
- lsnrclt start 出錯!TNS-12537, TNS-12560,TNS-00507 解決方法,oracle監聽啟動出錯Oracle
- PHP curl error 60 錯誤解決PHPError
- TNS-12537, TNS-12560, TNS-00507 Linux Error: 29: Illegal seek error When StartinLinuxError
- Bequeath Connection Generates Ora-12560: Tns:Protocol Adapter Error [ID 831007.1]ProtocolAPTError
- 關於錯誤程式碼107(err_ssl_protocol_error)SSL 協議出錯的解決方案ProtocolError協議
- TNS-12537, TNS-12560, TNS-00507 Linux Error: 29: Illegal seek error When Starting the ListenerLinuxError
- HTTP 錯誤 500.19- Internal Server Error 錯誤解決方法HTTPServerError
- TNS-1254 TNS-12560 TNS-00511 Linux Error: 111 【轉載】LinuxError
- HTTP 錯誤 500.21 - Internal Server Error 解決方案HTTPServerError
- 【故障|監聽】TNS-12545、TNS-12560、TNS-00515和Linux Error: 111LinuxError
- TNS-12547,TNS-12537錯誤解決方法一例
- Oracle的TNS-12502 錯誤原因及解決Oracle
- [Modules/zlibmodule.o] Error 1錯誤解決IBMError
- ORA-12560: TNS: Protocol Adapter Error ORA-00600: [2037] 在WIN上一次處理ProtocolAPTError
- TNS-12535: TNS:操作超時 錯誤解釋
- java jdbc Protocol violation錯誤JavaJDBCProtocol
- 【故障處理】修改maxuproc引數解決TNS-00519錯誤
- 解決ORA-12560: TNS: 協議介面卡錯誤協議
- Oracle的TNS-12502錯誤原因及解決(轉)Oracle
- SSL錯誤ssl connect error 35的解決方案Error
- 錯誤解決:cc: Internal error: Killed (program cc1)Error
- Myeclipse 錯誤An internal error has occurred 解決辦法EclipseError
- 解決錯誤:ASP.NET Error: Failed to access IIS metabaseASP.NETErrorAI
- Js錯誤Error物件詳解JSError物件
- 解決一切listview或者adapter等類似的資料錯誤,點選錯誤的問題。ViewAPT
- linux下oracle的TNS-12546錯誤解決辦法LinuxOracle
- mysqldump error1066 錯誤的解決辦法MySqlError
- 解決 eslint 的 Parsing error: Unexpected token 錯誤EsLintError
- TNS-12541: TNS:no listener錯誤處理
- ORA-12560: TNS: 協議介面卡錯誤的解決方法協議