TNS-12541:无监听程序

gabrielhoo2008

RHEL4 + ORACLE10G
本地用的10Gclient

lintener.ora

LISTENER =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.127.19(PORT = 1521))
)
  
SID_LIST_LISTENER =
(SID_LIST =
  (SID_DESC =
  (ORACLE_HOME = /u01/app/oracle/oracle/product/10.2.0/db_1)
  (SID_NAME = orcl)
  )
)


tnsnames.ora

ORCL =
(DESCRIPTION =
  (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.127.19(PORT = 1251))
  )
  (CONNECT_DATA =
  (SERVICE_NAME = orcl)
  )
)


现在在DOS下运行tnsping orcl显示无监听程序
10gclient 运行sql plus 同样显示无监听程序

ORACLE 已经启动

监听状态如下：

Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=10.1.127.19(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                    LISTENER
Version                  TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                12-MAR-2009 16:19:47
Uptime                    0 days 0 hr. 8 min. 52 sec
Trace Level              off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File  /u01/app/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File        /u01/app/oracle/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.1.127.19(PORT=1521)))
Services Summary...
Service "orcl" has 1 instance(s).
  Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

gabrielhoo2008

几经解决

gabrielhoo2008

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

renxiao2003

高手啊。