ITPub博客

首页 > 数据库 > Oracle > 单系统多数据库的Listener和Tnsnames的写法

单系统多数据库的Listener和Tnsnames的写法

原创 Oracle 作者:mohan213 时间:2015-03-13 09:16:20 0 删除 编辑

Listener.ora


LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

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

    )

  )

 

ADR_BASE_LISTENER = /u01/app/oracle

 

Tnsnames.ora

ORCL11G =

  (DESCRIPTION =

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

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl11g)

    )

  )

 

 

JLCC =

  (DESCRIPTION =

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

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = jlcc)

    )

  )

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

上一篇: 写在前面……
请登录后发表评论 登录
全部评论

注册时间:2015-03-11

  • 博文量
    11
  • 访问量
    39227