Oracle 的lsnrctl启动出错，求救！

mydoor

tns-12538，tns-12560,tns-00508错误

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Attempted to listen on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=OAServer)(PORT=1521))(PROTOCOL_STACK=(PRESENTATION=GIOP)(SESSION=RAW)))
TNS-12538: TNS:no such protocol adapter
TNS-12560: TNS:protocol adapter error
  TNS-00508: No such protocol adapter

No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))

jiazhao688

把tnsnames.ora和listener.ora贴出来

angeldudu

是一装上就有问题吗，看看tnsnames.ora和listener.ora这两个文件

mydoor

# TNSNAMES.ORA Configuration File:/oracle/app/oracle/product/8.1.6/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

OA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = OAServer)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = OA)
    )
  )

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




# LISTENER.ORA Configuration File:/oracle/app/oracle/product/8.1.6/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = OAServer)(PORT = 1521))
      (PROTOCOL_STACK =
        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = OAServer)(PORT = 2481))
      (PROTOCOL_STACK =
        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /oracle/app/oracle/product/8.1.6)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = OA)
      (ORACLE_HOME = /oracle/app/oracle/product/8.1.6)
      (SID_NAME = ora
    )
  )

steel

运行adapters，把结果贴出来。

zglcl008

如客户端的非正常退出，也可能会引起服务器端的Listening 错误
可以终止后重新启动Listening
或重新启动数据库服务。

mydoor

运行adapters后：

Installed Net8 Tranport Protocols are:

    IPC
   Error!!! TCP/IP is not completely installed!
   Present in libntcp8, but missing from ntcontab.o...
    BEQueath
   Error!!! SSL is not completely installed!
   Present in libntcps8, but missing from ntcontab.o...
    RAW

Installed Net8 Naming Adapters are:

    TNSnames
    OracleNames
    LDAP
    Hostname

Installed Oracle Advanced Security option/Security products are:

    RC4 40-bit encryption algorithm
    RC4 56-bit encryption algorithm
    DES40 40-bit encryption algorithm
    DES 56-bit encryption algorithm
    MD5 crypto-checksumming algorithm