课程第50/51/52次（2017-09-08星期五和2017-09-10星期天上下午）

botang

第三阶段New Feature/OCM Exam Preparation（31-52）

1. LINUX:
   
2. listener 1521
   
3. l2       1526
   
4. WINDOWS:
   
5. tnsnames.ora     
   
6.     ....  1521
   
7.     ....  1526
   
8.     (load_balance=yes)
   
9. 
   
10. Clientside Connect-time Failover (CCF+CCLB)  
    
11. 
    
12. 9iRAC:
    
13.   rac1 1521 --->remote-listener 能知道rac2 1521都有什么
    
14.   rac2 1521 --->remote-listener 能知道rac1 1521都有什么
    
15. WINDOWS:
    
16.   tnsnames.ora
    
17.   ....  rac1 1521
    
18.   ....  rac2 1521
    
19.   (load_balance=yes)
    
20.   (failover_type=
    
21.    failover_method=
    
22.    retry=
    
23.    time_out=)
    
24.    
    
25. Clientside Failover (CF+CLB)
    
26. 
    
27. TAF(透明应用故障转移）
    
28. Prefer: rac1  
    
29. Avaliable: rac2
    
30. session rac1+rac2_shadows  -P PRECONNECT
    
31. 
    
32. TAF： 普通TAF  +  带预连接TAF
    
33. ---------------服务目标（service time，throughput） + 负载均衡目标(长会话和段会话)
    
34. 
    
35. 
    
36. 
    
37. 
    
38. 
    
39. 
    
40. 
    
41. 
    
42. 10gR2 RAC(AQ):
    
43.   rac1 1521 --->remote-listener 能知道rac2 1521都有什么
    
44.   AQ-->ONS
    
45.   rac2 1521 --->remote-listener 能知道rac1 1521都有什么
    
46.   AQ-->ONS
    
47. tnsnames.ora     
    
48.     ....  1521
    
49.     ....  1526
    
50.     (load_balance=yes)
    
51. Serverside Failover (SF+SLB)
    
52. 
    
53. TAF--> TAF2(FCF/FAN)
    
54. ---------------------------
    
55. --------------服务目标（service time，throughput） +  建议者loadbalance Advisor  负载均衡目标(长会话和段会话)
    
56. 
    
57. 
    
58. 
    
59. 
    
60. 
    
61. 11gR2 RAC(Serverpool):
    
62. 不讨论TAF
    
63. UNIFORM还是SINGLETON
    
64. -------------------
    
65. 
    
66. 
    
67. srvctl add service -d racdb -s GL -r racdb_2 -a racdb_1  -P PRECONNECT
    

复制代码

srvctl add service -d racdb -s GL -r racdb_2 -a racdb_1  -P PRECONNECT -q true  -m BASIC -e SELECT -w 1  -z 180 -B SERVICE_TIME -j LONG
推荐： srvctl add service -d racdb -s GL -r racdb_1,racdb_2 -q true  -m BASIC -e SELECT -w 1  -z 180 -B SERVICE_TIME -j LONG

1. oracle@station13 ~]$ crsctl status serverpool -p
   
2. NAME=Free
   
3. IMPORTANCE=0
   
4. MIN_SIZE=0
   
5. MAX_SIZE=-1
   
6. SERVER_NAMES=
   
7. PARENT_POOLS=
   
8. EXCLUSIVE_POOLS=
   
9. ACL=owner:oracle:rwx,pgrp:oinstall:rwx,other::r-x
   
10. 
    
11. NAME=Generic
    
12. IMPORTANCE=0
    
13. MIN_SIZE=0
    
14. MAX_SIZE=-1
    
15. SERVER_NAMES=station13 station14
    
16. PARENT_POOLS=
    
17. EXCLUSIVE_POOLS=
    
18. ACL=owner:oracle:r-x,pgrp:oinstall:r-x,other::r-x
    
19. 
    
20. NAME=ora.racdb
    
21. IMPORTANCE=0
    
22. MIN_SIZE=0
    
23. MAX_SIZE=-1
    
24. SERVER_NAMES=station13 station14
    
25. PARENT_POOLS=Generic
    
26. EXCLUSIVE_POOLS=
    
27. ACL=owner:oracle:rwx,pgrp:oinstall:rwx,other::r--
    
28. 
    
29. NAME=ora.racdb_GL
    
30. IMPORTANCE=0
    
31. MIN_SIZE=0
    
32. MAX_SIZE=-1
    
33. SERVER_NAMES=station13 station14
    
34. PARENT_POOLS=ora.racdb
    
35. EXCLUSIVE_POOLS=
    
36. ACL=owner:oracle:rwx,pgrp:oinstall:rwx,other::r--
    
37. 
    
38. NAME=ora.servpool3
    
39. IMPORTANCE=1
    
40. MIN_SIZE=2
    
41. MAX_SIZE=2
    
42. SERVER_NAMES=
    
43. PARENT_POOLS=
    
44. EXCLUSIVE_POOLS=
    
45. ACL=owner:oracle:rwx,pgrp:oinstall:rwx,other::r--
    
46. 
    
47. [oracle@station13 ~]$ srvctl config database -d racdb
    
48. Database unique name: racdb
    
49. Database name:
    
50. Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1
    
51. Oracle user: oracle
    
52. Spfile:
    
53. Domain:
    
54. Start options: open
    
55. Stop options: immediate
    
56. Database role: PRIMARY
    
57. Management policy: AUTOMATIC
    
58. Server pools: racdb
    
59. Database instances: racdb_1,racdb_2
    
60. Disk Groups: DATA,FRA
    
61. Mount point paths:
    
62. Services: GL
    
63. Type: RAC
    
64. Database is administrator managed
    
65. [oracle@station13 ~]$ srvctl modify database -d racdb -g servpool3   
    
66. [oracle@station13 ~]$ srvctl config database -d racdb
    
67. Database unique name: racdb
    
68. Database name:
    
69. Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1
    
70. Oracle user: oracle
    
71. Spfile:
    
72. Domain:
    
73. Start options: open
    
74. Stop options: immediate
    
75. Database role: PRIMARY
    
76. Management policy: AUTOMATIC
    
77. Server pools: servpool3
    
78. Database instances:
    
79. Disk Groups: DATA,FRA
    
80. Mount point paths:
    
81. Services: GL
    
82. Type: RAC
    
83. Database is policy managed
    
84. [oracle@station13 ~]$ crsctl status serverpool -p
    
85. NAME=Free
    
86. IMPORTANCE=0
    
87. MIN_SIZE=0
    
88. MAX_SIZE=-1
    
89. SERVER_NAMES=
    
90. PARENT_POOLS=
    
91. EXCLUSIVE_POOLS=
    
92. ACL=owner:oracle:rwx,pgrp:oinstall:rwx,other::r-x
    
93. 
    
94. NAME=Generic
    
95. IMPORTANCE=0
    
96. MIN_SIZE=0
    
97. MAX_SIZE=-1
    
98. SERVER_NAMES=
    
99. PARENT_POOLS=
    
100. EXCLUSIVE_POOLS=
     
101. ACL=owner:oracle:r-x,pgrp:oinstall:r-x,other::r-x
     
102. 
     
103. NAME=ora.servpool3
     
104. IMPORTANCE=1
     
105. MIN_SIZE=2
     
106. MAX_SIZE=2
     
107. SERVER_NAMES=
     
108. PARENT_POOLS=
     
109. EXCLUSIVE_POOLS=
     
110. ACL=owner:oracle:rwx,pgrp:oinstall:rwx,other::r--
     
111. 
     
112. [oracle@station13 ~]$
     

复制代码

srvctl add service -s gl -d racdb   -g servpool3  -c SINGLETON -q true  -m BASIC -e SELECT -w 1  -z 180 -B SERVICE_TIME -j LONG