课程第9次（2018-10-23星期二）

botang

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. 
   
6. ADR_BASE_L2 = /u01/app/oracle
   
7. 
   
8. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_L2 = ON
   
9. 
   
10. LISTENER =
    
11.   (DESCRIPTION =
    
12.     (ADDRESS = (PROTOCOL = TCP)(HOST = station90.example.com)(PORT = 1521))
    
13.   )
    
14. 
    
15. ADR_BASE_LISTENER = /u01/app/oracle
    
16. 
    
17. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON
    
18. 
    
19. SID_LIST_L2 =
    
20.   (SID_LIST =
    
21.     (SID_DESC =
    
22.       (GLOBAL_DBNAME = orcl.example.com)
    
23.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    
24.       (SID_NAME = orcl)
    
25.     )
    
26.   )
    

复制代码

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. 
   
3. select  * from v$dispatcher;
   
4. 
   
5. select  * from v$session where saddr   in  (select saddr from v$circuit);

复制代码

上完1Z0-052 第6章 网络（6/40）