Chinaunix

标题: Oracle 的lsnrctl启动出错，求救！ [打印本页]

作者: mydoor 时间: 2003-01-17 19:34
标题: Oracle 的lsnrctl启动出错，求救！
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 时间: 2003-01-18 21:37
标题: Oracle 的lsnrctl启动出错，求救！
把tnsnames.ora和listener.ora贴出来

作者: angeldudu 时间: 2003-01-19 13:38
标题: Oracle 的lsnrctl启动出错，求救！
是一装上就有问题吗，看看tnsnames.ora和listener.ora这两个文件

作者: mydoor 时间: 2003-01-20 09:01
标题: Oracle 的lsnrctl启动出错，求救！
# 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 时间: 2003-01-20 11:14
标题: Oracle 的lsnrctl启动出错，求救！
运行adapters，把结果贴出来。

作者: zglcl008 时间: 2003-01-20 11:44
标题: Oracle 的lsnrctl启动出错，求救！
如客户端的非正常退出，也可能会引起服务器端的Listening 错误
可以终止后重新启动Listening
或重新启动数据库服务。

作者: mydoor 时间: 2003-01-20 13:11
标题: Oracle 的lsnrctl启动出错，求救！
运行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

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)