7.30 Oracle Net管理错误

解决方法

vi listener.ora

LISTENER =

       (DESCRIPTION_LIST =

         (DESCRIPTION =

                (ADDRESS = (PROTOCOL =TCP)(HOST = linux)(PORT = 1521))

         )

       )

 

LOGGING_LISTENER=OFF

 

SID_LIST_LISTENER =

 (SID_LIST =

   (SID_DESC =

     (SID_NAME = ora11g)

     (ORACLE_HOME = /oracle/app/product/11g/db)

     (PROGRAM = extproc)

    )

  )

 

将(PROGRAM = extproc)前面加#

oracle的KEY=EXTPROC0什么用，为什么我客户端开始连接显示无监听服务，改成KEY=EXTPROC2就可以连接了

监听默认的是  
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
  )
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    )
  )

你可能是再创建了一个监听，所以就成为了 extproc2了 ，设置成 extproc0是没有用的，设置成1也没有用，因为别的监听在用