PL/SQL连接oracle报ORA-12560错误

[zmzbs123]

XP系统连公司的服务器上的oracle没问题的，可是连自己的服务器上的oracle遇到问题
oracle安装在linux系统上，在linux上用sqlplus可以正常访问数据库
在服务器上
tnsping orcl

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 01-1ÔÂ -2010 00:35:50

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
/u01/app/oracle/product/10.2.0/db/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.17)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (0 msec)
服务器上的tnsnames.ora

pis_test =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)



EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

@localhost admin]$ lsnrctl service

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 01-1ÔÂ -2010 00:33:34

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:3 refused:0 state:ready
LOCAL SERVER
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: localhost.localdomain, pid: 4550>
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=43910))
Service "orcl_XPT" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:3 refused:0 state:ready
LOCAL SERVER
The command completed successfully

在XP上的tnsnames.ora

pis_test =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.17)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)

不知道是什么地方配错了，请高手指点啊~~

[zmzbs123]

这两个是一样的

[zmzbs123]

谢谢大家，问题解决了，原因就是需要在linux上要运行 service iptables stop

[iqlife]

pis_test =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.17)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)

pis_test =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

两个配置一样的,改个试试

[QKForex]

你机子上有两个数据库,可以在命令行设置ORACLE_SID
C:/>SET ORACLE_SID=ORCL
或者
C:/>SET ORACLE_SID=RO
看你用哪个了

[crazylaa]

xp的连到pis_test吗？不是连orcl。