7.30Oracle Net管理错误

来源：互联网发布：云计算工程师做什么编辑：程序博客网时间：2024/06/08 06:29

解决方法

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也没有用，因为别的监听在用

0 0