11g: TNS-12532 / …
来源:互联网 发布:saas软件推广 编辑:程序博客网 时间:2024/05/18 22:46
已使用的参数文件:
F:\app\SN10712\product\11.1.0\db_1\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =(PROTOCOL = TCP)
(HOST = 10.10.21.25)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME =testdb)))
TNS-12532: TNS: 无效的参数
C:\Documents and Settings\sn10712>
C:\Documents and Settings\sn10712>telnet 10.10.21.25 1521
正在连接到10.10.21.25...不能打开到主机的连接, 在端口 1521.
系统找不到指定的文件。
C:\Documents and Settings\sn10712>
11g: TNS-12532 / ORA-12532 Reported When Firewall Is Enabled [ID748466.1] 转到底部
--------------------------------------------------------------------------------
修改时间:2009-9-20类型:PROBLEM状态:MODERATED优先级:3 注释(0)
In this Document
--------------------------------------------------------------------------------
This document is being delivered to you via Oracle Support'sRapid Visibility (RaV) process, and therefore has not been subjectto an independent technical review.
Applies to:
Oracle Net Services - Version: 11.1.0.6.0
This problem can occur on any platform.
Symptoms
Firewall is enabled between the clients and server.
On trying to connect from the client host, the following error isreported :
ORA - 12532: TNS : invalid argument
Client trace indicates the following :
ntt2err: soc error - operation=1, ntresnt[0]=502,ntresnt[1]=113, ntresnt[2]=0
ntt2err: exit
nttcni: exit
nttcon: exit
nserror: entry
nserror: nsres: id=0, op=65, ns=12532, ns2=12560; nt[0]=502,nt[1]=113, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
nsopen: unable to open transport
Here the OS error is 113 -No route to host in Linuxplatform.
Cause
The cause of the issue is either the firewall is blocking theconnection or there is an network issue.
Solution
You may check the same by trying a telnet to the listener port fromthe same client where sqlplus connection failed.
$ telnet
The above would return a blank screen with blinking cursor. Notethat the above would also fail if you are facing transportissues.
As the underlying cause for the issue is the firewall that hasbeen enabled, take assistance of the network administrator tomomentarily disable the firewall on the server host
There is an unpublished internal bug 6031201 being worked uponby our development team to correct the error code raised fromclient. Incorrect error message "TNS:invalid argument" beingreported is misleading and needs to corrected to something like"TNS:connection refused"
- 11g: TNS-12532 / …
- ORA-609 : TNS-12537: TNS:connect…
- ORACLE 11G 配置DG&nbsp…
- g++ error : decla…
- LOB segment and LOB index(11g R2…
- TNS-01192: Missing SID…
- Oracle 11g Password Features
- How to Modify a ATI Switchable G…
- Oracle 11g R2安装手册(…
- Oracle 11g 下载|Oracle…
- Oracle 11g R1中资源管…
- 11g 重建EM 报ORA-20001…
- 10g Recyclebin Feature…
- 11G RAC 简单命令
- oracle 11g 分区表
- oracle 11g 新参数 MEMORY_TARGET
- oracle 11g jdbc 驱动链接
- linux oracle 11g 安装
- 腾讯云服务器Nginx+php+mysql环境搭建
- Linux下查询一个包是32位还是64位
- rpm -ivh elfutils-libe…
- OPP time out 问题
- Troubleshooting and Di…
- 11g: TNS-12532 / …
- tnsping通但无法连接的问题处理
- linux下如何禁用防火墙
- Can Not Allocate Log
- DLL开发与使用
- PMON failed to ac…
- PRVF-5439: NTP daemon&…
- PRVF-5439 : NTP d…
- Oracle RAC 11.2.0.2&nb…