linux系统ora12532,11g: TNS-12532 / ORA-12532 Reported When Firewall Is Ena

已使用的参数文件:

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 [ID

748466.1] 转到底部

--------------------------------------------------------------------------------

修改时间:2009-9-20类型:PROBLEM状态:MODERATED优先级:3 注释

(0)

In this Document

Symptoms

Cause

Solution

References

--------------------------------------------------------------------------------

This document is being delivered to you via Oracle Support's

Rapid Visibility (RaV) process, and therefore has not been subject

to 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 is

reported :

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 Linux

platform.

Cause

The cause of the issue is either the firewall is blocking the

connection or there is an network issue.

Solution

You may check the same by trying a telnet to the listener port from

the same client where sqlplus connection failed.

$ telnet

The above would return a blank screen with blinking cursor. Note

that the above would also fail if you are facing transport

issues.

As the underlying cause for the issue is the firewall that has

been enabled, take assistance of the network administrator to

momentarily disable the firewall on the server host

Once done, re-try the connection from the

client host.

There is an unpublished internal bug 6031201 being worked upon

by our development team to correct the error code raised from

client. Incorrect error message "TNS:invalid argument" being

reported is misleading and needs to corrected to something like

"TNS:connection refused"