ora 12560 错误

kb2008

oracle 10g    安装在linux上面，在客户端xp用 sqlplus 连接 ，一直报 ora 12560 tns 的错误

服务端：

listener.ora
LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.90.43 )(PORT = 1521))
  )




SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = ema )
      (ORACLE_HOME =  /home/oracle/product/10.2.0/db_1 )
    )
  )


tnsnames.ora

EMA  =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.90.43)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE = DEDICATED )
      (SERVICE_NAME = ema)
    )
  )



sqlnet.ora
NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME, ONAMES)



lsnrctl stat

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 01-JUL-2010 17:08:49

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.17.90.43)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                30-JUN-2010 10:23:32
Uptime                    1 days 6 hr. 45 min. 16 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /home/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /home/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.17.90.43)(PORT=1521)))
Services Summary...
Service "ema" has 2 instance(s).
  Instance "ema", status UNKNOWN, has 1 handler(s) for this service...
  Instance "ema", status READY, has 1 handler(s) for this service...
Service "emaXDB" has 1 instance(s).
  Instance "ema", status READY, has 1 handler(s) for this service...
Service "ema_XPT" has 1 instance(s).
  Instance "ema", status READY, has 1 handler(s) for this service...
The command completed successfully




tnsping ema

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 01-JUL-2010 17:09:06

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

Used parameter files:
/home/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.90.43)(PORT = 1521))) (CONNECT_DATA = (SERVICE = DEDICATED) (SERVICE_NAME = ema)))
OK (0 msec)



客户端

ema =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.90.43)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ema)
    )
  )



一直报ora 12560 的错误，网上 说一般是 防火墙问题，在客户端oracle_sid 没有设置，或者是在服务器上面有多个数据库。
但是在服务器端只是有一个数据库

kb2008

不知道我把问题说清楚了没

duolanshizhe

1、检查服务器端防火墙是否开启，是否阻塞1521端口。

2、客户端tnsnames.ora文件建议将service_name=ema换成sid试试

dfwuteng

回复 3# duolanshizhe

kb2008

回复 3# duolanshizhe


       1 服务器上面 没有防火墙设置
  

   2 在客户端上面改了 sid = ema    还是不行

dream_land

客户端是windows系统吗？net manager可以连接上吗？

kb2008

回复 6# dream_land


    客户端是 win  ，我不知道 你说的 net manage 怎么访问的； 我是按照网上的这个帖子做的：

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

下载几个压缩包,解压到一个目录, d:\oracleclient

instantclient-basic-win32-10.1.0.2.zip : 这是最核心的包
instantclient-jdbc-win32-10.1.0.2.zip: 包含JDBC Driver的包
instantclient-sqlplus-win32-10.1.0.2.zip: 最简单的SQLPLUS包
2.配置tnsnames.ora 如下格式（必须在主目录如D:\oracleclient下network\admin下）
oracledata =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.5(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = oracledata)
    )
  )

dingning239

客户端，你先执行命令tnsping oracledata   看看是否可以通？

如果不通，表示网络连接问题，或者防火墙开启了

hanhao120

用 netca 重建下监听看看如何

renxiao2003

http://www.itpub.net/223688.html
看看这个。