listener.ora及tnsnames各种模板

最新推荐文章于 2024-11-18 11:35:31 发布

Yushan Bai

最新推荐文章于 2024-11-18 11:35:31 发布

阅读量3.4k

点赞数

分类专栏： ORACLE Listener类问题

本文链接：https://blog.csdn.net/haibusuanyun/article/details/11180027

版权

ORACLE Listener类问题专栏收录该内容

25 篇文章

订阅专栏

1.配置静态注册listener.ora

正确模板示例如下：有IPC，无IPC可以参考 http://blog.csdn.net/q947817003/article/details/11138143

SID_LIST_LISTENER =
(SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/db11g/product/11.1.0/db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = orcltest)
      (ORACLE_HOME = /u01/app/db11g/product/11.1.0/db_1)
      (SID_NAME = orcltest)
    )
)
LISTENER =
(DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.18)(PORT = 1521))
    )
)

使用NETCA创建监听完成后的默认动态监听listener.ora：

[oracle@bys3 admin]$ cat listener.ora
LISTENER =
(DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = bys3.bys.com)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
)
ADR_BASE_LISTENER = /u01

2.tnsnames各种模板

参考文档 http://docs.oracle.com/cd/B28359_01/network.111/b28317/tnsnames.htm

net_service_name=
(DESCRIPTION=
   (ADDRESS=(protocol_address_information))
   (CONNECT_DATA=
     (SERVICE_NAME=service_name)))


Example 6-2 Net Service Name with Multiple Connect Descriptors in tnsnames.ora

net_service_name=
(DESCRIPTION_LIST=
(DESCRIPTION=
   (ADDRESS=(protocol_address_information))
   (ADDRESS=(protocol_address_information))
   (ADDRESS=(protocol_address_information))
   (CONNECT_DATA=
     (SERVICE_NAME=service_name)))
(DESCRIPTION=
   (ADDRESS=(protocol_address_information))
   (ADDRESS=(protocol_address_information))
   (ADDRESS=(protocol_address_information))
   (CONNECT_DATA=
     (SERVICE_NAME=service_name))))

##################################################
Example 6-3 Multiple Address Lists in tnsnames.ora

net_service_name=
(DESCRIPTION=
(ADDRESS_LIST=
   (LOAD_BALANCE=on)
   (FAILOVER=off)
   (ADDRESS=(protocol_address_information))
   (ADDRESS=(protocol_address_information)))
(ADDRESS_LIST=
   (LOAD_BALANCE=off)
   (FAILOVER=on)
   (ADDRESS=(protocol_address_information))
   (ADDRESS=(protocol_address_information)))
(CONNECT_DATA=
   (SERVICE_NAME=service_name)))
#####################################
Example 6-4 Multiple Oracle Connection Manager Addresses in tnsnames.ora

sample1=
(DESCRIPTION=
   (SOURCE_ROUTE=yes)
   (ADDRESS=(PROTOCOL=tcp)(HOST=host1)(PORT=1630))    # hop 1
   (ADDRESS_LIST=
     (FAILOVER=on)
     (LOAD_BALANCE=off)                                # hop 2
     (ADDRESS=(PROTOCOL=tcp)(HOST=host2a)(PORT=1630))
     (ADDRESS=(PROTOCOL=tcp)(HOST=host2b)(PORT=1630)))
   (ADDRESS=(PROTOCOL=tcp)(HOST=host3)(PORT=1521))    # hop 3
   (CONNECT_DATA=(SERVICE_NAME=Sales.us.example.com)))
################################
Example 6-5 Client Load Balancing in tnsnames.ora

sample2=
(DESCRIPTION=
   (LOAD_BALANCE=on)
   (FAILOVER=on)
   (ADDRESS_LIST=
     (SOURCE_ROUTE=yes)
     (ADDRESS=(PROTOCOL=tcp)(HOST=host1)(PORT=1630))
     (ADDRESS=(PROTOCOL=tcp)(HOST=host2)(PORT=1521)))
(ADDRESS_LIST=
     (SOURCE_ROUTE=yes)
     (ADDRESS=(PROTOCOL=tcp)(HOST=host3)(port=1630))
     (ADDRESS=(PROTOCOL=tcp)(HOST=host4)(port=1521)))
   (CONNECT_DATA=(SERVICE_NAME=sales.us.example.com)))