ITPub博客

首页 > 数据库 > Oracle > oracle监听文件listener.ora for 10g/11g

oracle监听文件listener.ora for 10g/11g

原创 Oracle 作者:巡完南山巡南山 时间:2019-01-28 14:11:05 0 删除 编辑

----------------------oracle 11g----------------------


SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = nms)

      (ORACLE_HOME = /u01/oracle/product/10.2.0/db_1/)

      (PROGRAM = extproc)

    )

)


LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = TJ-NMS-DB)(PORT = 1523))

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1523))

    )

  )


ADR_BASE_LISTENER = /u01/oracle


用非默认端口时需要改local_listener参数

SQL> alter system set local_listener="(address=(protocol=tcp)(host=192.168.0.100)(port=1523))";


----------------------oracle 10g----------------------

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (GLOBAL_DBNAME = ydwg)

      (ORACLE_HOME = /oracle/oracle10/product/10.2.0/db_1)

      (SID_NAME = ydwg)

    )

 )



LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

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

    )

  )








来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26964624/viewspace-2565035/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2016-04-11

  • 博文量
    45
  • 访问量
    65388