课程第7/8次（2017-03-18星期六上下午）

botang

上完1Z0-052第3章：建库
进行1Z0-052第6章：网络
1Z0-052共19章（上完2章），1Z0-053共21章（上完0章）和1Z0-063多租户部分共9章（上完0章）
总共上完全部49章中的2章

listener.ora：

1. # listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/grid/network/admin/listener.ora
   
2. # Generated by Oracle configuration tools.
   
3. 
   
4. L2 =
   
5.   (DESCRIPTION =
   
6.     (ADDRESS = (PROTOCOL = TCP)(HOST = station90.example.com)(PORT = 1522))
   
7.   )
   
8. 
   
9. ADR_BASE_L2 = /u01/app/oracle
   
10. 
    
11. SID_LIST_LISTENER =
    
12.   (SID_LIST =
    
13.     (SID_DESC =
    
14.       (GLOBAL_DBNAME = orcl.example.com)
    
15.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    
16.       (SID_NAME = orcl)
    
17.     )
    
18.     (SID_DESC =
    
19.       (GLOBAL_DBNAME = rcat.example.com)
    
20.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    
21.       (SID_NAME = rcat)
    
22.     )
    
23.   )
    
24. 
    
25. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_L2 = ON
    
26. 
    
27. LISTENER =
    
28.   (DESCRIPTION =
    
29.     (ADDRESS = (PROTOCOL = TCP)(HOST = station90.example.com)(PORT = 1521))
    
30.   )
    
31. 
    
32. ADR_BASE_LISTENER = /u01/app/oracle
    
33. 
    
34. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON
    
35. 
    
36. SID_LIST_L2 =
    
37.   (SID_LIST =
    
38.     (SID_DESC =
    
39.       (GLOBAL_DBNAME = orcl.example.com)
    
40.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    
41.       (SID_NAME = orcl)
    
42.     )
    
43.     (SID_DESC =
    
44.       (GLOBAL_DBNAME = rcat.example.com)
    
45.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    
46.       (SID_NAME = rcat)
    
47.     )
    
48.   )
    

复制代码

tnsnames.ora：

1. # tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/grid/network/admin/tnsnames.ora
   
2. # Generated by Oracle configuration tools.
   
3. 
   
4. FORDB =
   
5.   (DESCRIPTION =
   
6.     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.90)(PORT = 1522))
   
7.   )
   
8. 
   
9. CCF =
   
10.   (DESCRIPTION =
    
11.     (ADDRESS_LIST =
    
12.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.90)(PORT = 1521))
    
13.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.90)(PORT = 1522))
    
14.       (LOAD_BALANCE = yes)
    
15.     )
    
16.     (CONNECT_DATA =
    
17.       (SERVICE_NAME = orcl.example.com)
    
18.     )
    
19.   )
    
20. 
    
21. RCAT =
    
22.   (DESCRIPTION =
    
23.     (ADDRESS = (PROTOCOL = TCP)(HOST = station90.example.com)(PORT = 1521))
    
24.     (CONNECT_DATA =
    
25.       (SERVER = DEDICATED)
    
26.       (SERVICE_NAME = rcat.example.com)
    
27.     )
    
28.   )
    
29. 
    
30. ORCL =
    
31.   (DESCRIPTION =
    
32.     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.90)(PORT = 1521))
    
33.     (CONNECT_DATA =
    
34.       (SERVER = DEDICATED)
    
35.       (SERVICE_NAME = orcl.example.com)
    
36.     )
    
37.   )
    
38. 
    
39. CCFRCAT =
    
40.   (DESCRIPTION =
    
41.     (ADDRESS_LIST =
    
42.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.90)(PORT = 1521))
    
43.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.90)(PORT = 1522))
    
44.       (LOAD_BALANCE = yes)
    
45.     )
    
46.     (CONNECT_DATA =
    
47.       (SERVICE_NAME = rcat.example.com)
    
48.     )
    
49.   )
    

复制代码