在oracle8.1.6 for AIX下启动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)))

yikaikai

用netconfig重新配置一下tnsnames.ora文件

TuFei

靠，跟我的问题一样。
关注中。。。。

linuxwl

重新配置一下
tnsnames.ora 和init.ora
文件就行

mydoor

具体重新配置的参数？需要修改原先的参数吗？

TuFei

关注中。

chaoping

post your listener.ora file.
Do you really need:
PROTOCOL_STACK=(PRESENTATION=GIOP)(SESSION=RAW))??

some sample listener.ora:

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = ish3)(PORT = 1521))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /home/oracle/product/8.1.7)
      (PROGRAM = extproc)
    )
   (SID_DESC =
      (ORACLE_HOME = /home/oracle/product/8.1.7)
      (SID_NAME = catalog)
    )
  )

mydoor

# 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
    )
  )



# 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)
    )
  )

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

tzg

重新运行NETCA配置LISTENER和TNS即可！