课程第7/8次（2017-03-11星期六晚上和2017-03-12星期日晚上）

botang

上完1Z0-052第3章：建库
1Z0-051共12章（上完0章），1Z0-052共19章（上完2章），1Z0-053共21章（上完0章）
总共上完全部52章中的2章

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. ALLL =
   
5.   (DESCRIPTION =
   
6.     (ADDRESS_LIST =
   
7.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.90)(PORT = 1521))
   
8.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.90)(PORT = 1522))
   
9.     )
   
10.   )
    
11. 
    
12. ORACLR_CONNECTION_DATA =
    
13.   (DESCRIPTION =
    
14.     (ADDRESS_LIST =
    
15.       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    
16.     )
    
17.     (CONNECT_DATA =
    
18.       (SID = CLRExtProc)
    
19.       (PRESENTATION = RO)
    
20.     )
    
21.   )
    
22. 
    
23. BESTTNS =
    
24.   (DESCRIPTION =
    
25.     (ADDRESS_LIST =
    
26.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.90)(PORT = 1521))
    
27.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.90)(PORT = 1522))
    
28.       (LOAD_BALANCE = yes)
    
29.     )
    
30.     (CONNECT_DATA =
    
31.       (SERVICE_NAME = orcl.example.com)
    
32.     )
    
33.   )
    
34. 
    
35. RCAT =
    
36.   (DESCRIPTION =
    
37.     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.90)(PORT = 1521))
    
38.     (CONNECT_DATA =
    
39.       (SERVER = DEDICATED)
    
40.       (SERVICE_NAME = rcat.example.com)
    
41.     )
    
42.   )
    
43. 
    
44. UTFORCL =
    
45.   (DESCRIPTION =
    
46.     (ADDRESS = (PROTOCOL = TCP)(HOST = station199)(PORT = 1521))
    
47.     (CONNECT_DATA =
    
48.       (SERVER = DEDICATED)
    
49.       (SERVICE_NAME = utforcl.example.com)
    
50.     )
    
51.   )
    
52. 
    
53. ORCL =
    
54.   (DESCRIPTION =
    
55.     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.90)(PORT = 1521))
    
56.     (CONNECT_DATA =
    
57.       (SERVER = DEDICATED)
    
58.       (SERVICE_NAME = orcl.example.com)
    
59.     )
    
60.   )
    
61. 
    
62. ORCL199 =
    
63.   (DESCRIPTION =
    
64.     (ADDRESS = (PROTOCOL = TCP)(HOST = station199)(PORT = 1521))
    
65.     (CONNECT_DATA =
    
66.       (SERVER = DEDICATED)
    
67.       (SERVICE_NAME = orcl.example.com)
    
68.     )
    
69.   )
    

复制代码

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.   )
    

复制代码