TNSLSNR for Linux: Version 10.2.0.5.0 - Production
System parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Error listening on: (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
Linux Error: 11: Resource temporarily unavailable
--------------------------------------------------------------------------------
如下是配置文件
listener.ora
SID_LIST_ERPDB =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = erpdb)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(SID_NAME = erpdb)
)
)
erpdb =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(LOAD_BALANCE=on)
(FAILOVER=on)
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.254)(PORT = 1553))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.254)(PORT = 1554))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.254)(PORT = 1555))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.254)(PORT = 1556))
)
)
)
----------------------------------------------------------------------------------------------
tnsnames.ora
erpdb =
(DESCRIPTION =
(ADDRESS_LIST =
(LOAD_BALANCE=on)
(FAILOVER=on)
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.254)(PORT = 1553))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.254)(PORT = 1554))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.254)(PORT = 1555))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.254)(PORT = 1556))
)
(CONNECT_DATA =
(SERVICE_NAME = erpdb)
)
)
别的配置文件暂不帖了有点多 麻烦各位谁知道是那里有问题? 高人速度解决下~~~~~~~~
ping 通 我的这个SID是erpdb etc/sysconfig显示的HOSTNAME=BJ-NC-BGW 是不是也有关系?
追答和 etc/sysconfig的应该没有关系,我建议你先看看服务端的IP以及的你客户端的IP,在确认两者无误,并且可以ping通的情况下,再配置一下监听。我估计是你配置上有点问题。
追问本人是新手你所说的是查看一下IP吧
我截图你看看
建议你重新配置监听,在配置是一定要注意其中host的配置,如果还是不行,那就看看这个链接http://jvzizh.blog.163.com/blog/static/157335832009917105338523/
我是新手麻烦说明一下 怎么查看这个HOST