设为首页收藏本站

Botang唐波's Oracle Station

查看: 90|回复: 0

课程第9次(2018-10-23星期二)

[复制链接]

744

主题

1117

帖子

8077

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
8077
发表于 2018-10-23 20:01:12 | 显示全部楼层 |阅读模式
1. 监听器的位置:
  1. /u01/app/oracle/product/11.2.0/grid/network/admin
复制代码
2. 非标端口的静态注册:
  1. L2 =
  2.   (DESCRIPTION =
  3.     (ADDRESS = (PROTOCOL = TCP)(HOST = station90.example.com)(PORT = 1522))
  4.   )

  5. ADR_BASE_L2 = /u01/app/oracle

  6. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_L2 = ON

  7. LISTENER =
  8.   (DESCRIPTION =
  9.     (ADDRESS = (PROTOCOL = TCP)(HOST = station90.example.com)(PORT = 1521))
  10.   )

  11. ADR_BASE_LISTENER = /u01/app/oracle

  12. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON

  13. SID_LIST_L2 =
  14.   (SID_LIST =
  15.     (SID_DESC =
  16.       (GLOBAL_DBNAME = orcl.example.com)
  17.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  18.       (SID_NAME = orcl)
  19.     )
  20.   )
复制代码

3. 非标端口的动态注册(数据库服务器也是客户端):
  1. fordb =
  2.   (DESCRIPTION =
  3.    (ADDRESS_LIST=
  4.     (ADDRESS = (PROTOCOL = TCP)(HOST = station90.example.com)(PORT = 1521))
  5.     (ADDRESS = (PROTOCOL = TCP)(HOST = station90.example.com)(PORT = 1522))
  6.    )
  7.   )
复制代码
把local_listener指向fordb

4. 故障转移和负载均衡tnsnames.ora:
  1. DOUBLE =
  2.   (DESCRIPTION =
  3.     (ADDRESS_LIST =
  4.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.90)(PORT = 1521))
  5.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.90)(PORT = 1522))
  6.       (LOAD_BALANCE = yes)
  7.     )
  8.     (CONNECT_DATA =
  9.       (SERVICE_NAME = orcl.example.com)
  10.     )
  11.   )
复制代码

5. 共享服务器:
  1. select  * from v$circuit;

  2. select  * from v$dispatcher;

  3. select  * from v$session where saddr   in  (select saddr from v$circuit);
复制代码
上完1Z0-052 第6章 网络(5/40)





回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Botang唐波's Oracle Station   

GMT+8, 2018-11-18 01:15 , Processed in 0.159702 second(s), 24 queries .

快速回复 返回顶部 返回列表