论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2004-02-06 17:55 |只看该作者 |倒序浏览

环境： sco openserver 5.0.5
            oracle 7.3.2
            ORACLE_SID=epfront

现象：运行 lsnrctl start 报如下错

LSNRCTL for AT&T System V/386: Version 2.3.2.1.0 - Production on 06-FEB-04 16:53:43

Copyright (c) Oracle Corporation 1994.  All rights reserved.

Starting /usr/oracle/app/oracle/product/7.3.2/bin/tnslsnr: please wait...

TNSLSNR for AT&T System V/386: Version 2.3.2.1.0 - Production
System parameter file is /etc/listener.ora
Log messages written to /usr/oracle/app/oracle/product/7.3.2/network/log/listener.log
Attempted to listen on: (DESCRIPTION=(CONNECT_TIMEOUT=10000)(ADDRESS=(PROTOCOL=TCP)(Host=10.236.2.205)(Port=1521)))
TNS-12538: TNS:no such protocol adapter
TNS-12560: TNS:protocol adapter error
  TNS-00508: No such protocol adapter


备注："listener.ora"文件：
LISTENER=
(    ADDRESS_LIST=
      (ADDRESS=(PROTOCOL = TCP)(Host = 10.236.2.205)(Port=1521))
)

SID_LIST_LISTENER=
(    SID_LIST=
      (SID_DESC=
            (ORACLE_HOME=/usr/oracle/app/oracle/product/7.3.2)
            (SID_NAME=epfront)
      )
)

STARTUP_WAIT_TIME_LISTENER=0
CONNECT_TIMEOUT_LISTENER=10000
TRACE_LEVEL_LISTENER=OFF

tnsnames.ora 文件

ora7=
(    DESCRIPTION=
      (    ADDRESS_LIST=
            (ADDRESS=
                     (PROTOCOL = TCP)
                     (HOST = 10.236.2.205)
                     (PORT = 1521)
            )
      )
      (    CONNECT_DATA=
            (SID=epfront)
      )
)

请问有高手知道什么原因？