Oracle RAC 12c (12.1.0.2) Operational Best Practices - A result of true collaboration

Information about Oracle RAC 12c (12.1.0.2) Operational Best Practices - A result of true...

Published on April 21, 2015

Author: MarkusMichalewicz

Source: slideshare.net

Content

1. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.    |   Oracle  RAC  12c  (12.1.0.2)   OperaBonal  Best  PracBces   A  result  of  true  collabora.on   Markus  Michalewicz   Director  of  Product  Management,  Oracle  Real  ApplicaBon  Clusters     April  14th  2015        @OracleRACpm    hOp://www.linkedin.com/in/markusmichalewicz        hOp://www.slideshare.net/MarkusMichalewicz    

2. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       Safe  Harbor  Statement   The  following  is  intended  to  outline  our  general  product  direcBon.  It  is  intended  for   informaBon  purposes  only,  and  may  not  be  incorporated  into  any  contract.  It  is  not  a   commitment  to  deliver  any  material,  code,  or  funcBonality,  and  should  not  be  relied  upon   in  making  purchasing  decisions.  The  development,  release,  and  Bming  of  any  features  or   funcBonality  described  for  Oracle’s  products  remains  at  the  sole  discreBon  of  Oracle.   3  

3. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       4   OperaBonal  Best  PracBces   Use  Case   Area   Generic   Clusters   Extended   Cluster   Dedicated   (OLTP  /  DWH)   Consolidated   Environments   Storage   OS   Network   Cluster   DB   Update   InstallaBon   t  SI   hJp://www.slideshare.net/MarkusMichalewicz/oracle-­‐rac-­‐12c-­‐collaborate-­‐best-­‐prac.ces-­‐ioug-­‐2014-­‐version    

4. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       Program  Agenda   1   2   3   4   New  in  Oracle  RAC  12.1.0.2  (Install)   OperaBonal  Best  PracBces  for    Generic  Clusters    Extended  Cluster    Dedicated  Environments    Consolidated  Environments   Appendices  A  –  D     5   5  

5. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       Program  Agenda   1   2   3   4   New  in  Oracle  RAC  12.1.0.2  (Install)   OperaBonal  Best  PracBces  for    Generic  Clusters    Extended  Cluster    Dedicated  Environments    Consolidated  Environments   Appendices  A  –  D     6   5  

6. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       12.1.0.1  Grid  Infrastructure   Management  Repository  (GIMR)     12.1.0.2  Grid  Infrastructure   Management  Repository  (GIMR)     •  Single  Instance  Oracle  Database  12c   Container  Database  with  one  PDB   –  The  resource  is  called  “ora.mgmtdb”   –  Future  consolidaBon  planned   –  Installed  on  one  of  the  (HUB)  nodes   –  Managed  as  a  failover  database   –  Stored  in  the  first  ASM  disk  group  created   7   New  in  12.1.0.2  install:  GIMR  –  No  Choice  Anymore  

7. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       12.1.0.1  disk  group  crea.on:     start  with  “GRID”  disk  group   12.1.0.2  disk  group  crea.on:     start  with  GIMR  hos.ng  disk  group     •  GIMR  typically  does  not  require     redundancy  for  the  disk  group.   –  Hence,  do  not  share  with  GRID  DG.   •  Clusterware  files  (VoBng  Files     and  OCR)  are  easy  to  relocate     –  See  example  in  Appendix  A.     •  More  informaBon:   –  How  to  Move  GI  Management  Repository  to   Different  Shared  Storage  (Diskgroup,  CFS  or  NFS  etc)   (Doc  ID  1589394.1)   –  Managing  the  Cluster  Health  Monitor  Repository   (Doc  ID  1921105.1)   8   RecommendaBon:  Change  in  Disk  Group  CreaBon   More  Informa.on  in  Appendix  A   12.1.0.2  disk  group  crea.on:     start  with  “GIMR”  disk  group  

8. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       For  Upgrades  Follow  the  OCR   •  CreaBng  a  new  disk  group  (DG)  for  the  GIMR  works  for  fresh  installs.   •  When  upgrading,  the  GIMR  is  placed  in  the  same  DG  as  the  OCR  in  12.1.0.2   – If  OCR  mirrors  are  used,  the  first  locaBon  in  the  list  will  be  used.   – For  future  versions  the  following  rules  apply:   •  If  a  GIMR  is  present  (12c  or  later),  then  the  new  GIMR  is  placed  in  the  same  DG  as  the  current  GIMR   •  If  no  GIMR  is  present,  the  new  GIMR  is  placed  in  the  same  DG  as  the  VoBng  Disk(s)  (ER  19661882)   •  In  order  to  define  the  GIMR  DG  locaBon  during  upgrades     – locate  “the  OCR”  in  the  respecBve  DG  using  ocrconfig  (online),  then  upgrade     and  finally  relocate  the  OCR  back  to  its  original  locaBon,  if  required.   9  

9. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       12.1.0.1:  Go  with  Standard  Cluster   12.1.0.2:  Use  Flex  Cluster     (includes  Flex  ASM  by  default)     10   New  in  12.1.0.2:  RecommendaBon  to  use  Flex  Cluster   One  excepBon:  if  installing   for  an  Extended  Oracle  RAC   Cluster  –  use  Standard   Cluster  +  Flex  ASM  

10. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       1. Standard  ASM   •  Pre-­‐12c  ASM  configura2on  mode   2. Oracle  Flex  ASM   •  Recommended   3. ASM  Client  Cluster   •  New  in  12.1.0.2,  assuming  “Standard   Cluster”  install  was  chosen  (not  Flex  Cluster)   4. Non-­‐ASM  managed  storage   11   12.1.0.2  –  Four  Storage  OpBons  available!?  

11. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       Flex  Cluster  12c   12.1.0.1  /  12.1.0.2  /  …     Client  Clusters  (CC)      12.1.0.2+  going  forward   12   What  is  an  ASM  Client  Cluster?   Node3Node2Node1 DBA DBA DBA Oracle ASM Oracle Clusterware ASM ASM ASM Flex ASM managed shared storage One  Cluster   LeafNodeNLeafNode..LeafNode1 … Oracle Clusterware<Loosely  coupled>   >Tightly  coupled<   AppA   AppA   AppB   Node2Node1 Oracle Grid Infrastructure Node… GI CC2   …   Node2Node1 Oracle Grid Infrastructure Node… GI CC1   …   Node2Node1 Oracle Clusterware ASM ASM Flex ASM Storage RAC DB Cluster AppA   AppA   AppB   AppC   AppD   AppE   Independent  clusters,   which  use  the  RAC  DB   Cluster  to  store  VoBng   Disks  and  OCR  (no   directly  aOached  shared   storage  required)  

12. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       DBCA   Despite  running  Leaf  Nodes   13   ConBnue  to  use  Leaf  Nodes  for  ApplicaBons  in  12.1.0.2   [GRID]>  olsnodes  -­‐s  -­‐t   germany  AcBve  Unpinned   argenBna  AcBve  Unpinned   brazil  AcBve  Unpinned   italy  Ac.ve  Unpinned   spain  Ac.ve  Unpinned   More  Informa.on  in  Appendix  D  

13. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       Install  what’s  necessary   Configure  what’s  desired   (update  later)   14   New  Network  Flexibility  in  12.1.0.2  –  RecommendaBon   More  Informa.on  in  Appendix  B  

14. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       15   AutomaBc  DiagnosBc  Repository  (ADR)     ADR_base diag asm rdbms tnslsnr clients crs (others) More  Informa.on  in  Appendix  C   •  Oracle  Grid  Infrastructure  now  supports   the  Automa.c  Diagnos.c  Repository     •  ADR  simplifies  log  analysis  by     •  centralizing  most  logs  under     a  defined  folder  structure.     •  maintaining  a  history  of  logs.     •  providing  its  own  command  line  tool     to  manage  diagnosBc  informaBon.  

15. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       Program  Agenda   1   2   3   4   New  in  Oracle  RAC  12.1.0.2  (Install)   OperaBonal  Best  PracBces  for    Generic  Clusters    Extended  Cluster    Dedicated  Environments    Consolidated  Environments   Appendices  A  –  D     16   5  

16. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       17   OperaBonal  Best  PracBces  –  Generic  Clusters   Use  Case   Area   Generic   Clusters   Extended   Cluster   Dedicated   (OLTP  /  DWH)   Consolidated   Environments   Storage   OS   Network   Cluster   DB  

17. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       18   Generic  Clusters  –  Storage   Use  Case   Area   Generic   Clusters   Extended   Cluster   Dedicated   (OLTP  /  DWH)   Consolidated   Environments   Storage   Appendix  A   OS   Network   Cluster   DB   Step  1:  Create  “GRID”  Disk  Group  –  Generic  Cluster   Step  2:  Move  Clusterware  Files   Step  3:  Move  ASM  SPFILE  /  password  file   More  Informa.on  in  Appendix  A  

18. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       Avoid  memory  pressure!   Use  Memory  Guard   AcBvated  by  default  with  12.1.0.2   19   Use  Solid  State  Disks  (SSDs)  to  host  swap     More  InformaBon  in  “My  Oracle  Support”   (MOS)  note  1671605.1  –  “Use  Solid  State   Disks  to  host  swap  space  in  order  to   increase  node  availability”   Use  HugePages  for  SGA  (Linux)   More  informaBon  in     MOS  notes  361323.1  &  401749.1   Avoid  Transparent  HugePages  (Linux6)   See  alert  in  MOS  note  1557478.1   Generic  Clusters  –  OS  /  Memory   argentinagermany Oracle  GI     Oracle  RAC   Oracle  GI     Oracle  RAC   argentinagermany Oracle  GI     Oracle  RAC   Oracle  GI     Oracle  RAC   Swapping  

19. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       •  OraChk     –  Formerly  RACcheck   –  A.k.a.  ExaChk     •  RAC  ConfiguraBon  Audit  Tool     –  Details  in  MOS  note  ID  1268927.1     •  Checks  “Oracle”  (Databases):   –  Standalone  Database   –  Grid  Infrastructure  &  Oracle  RAC     –  Maximum  Availability  Architecture     (MAA)  ValidaBon  (if  configured)     –  Oracle  Hardware  setup  configuraBon   20   Generic  Clusters  –  OS  /  OraChk  and  TFA   Trace  File  Analyzer   More  informaBon  in  MOS  note  1513912.1  

20. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       21   TFA  –  Efficiency  from  A  to  Z    

21. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       22   Generic  Clusters  –  OS  Summary   Use  Case   Area   Generic   Clusters   Extended   Cluster   Dedicated   (OLTP  /  DWH)   Consolidated   Environments   Storage   Appendix  A   OS   Memory  Config   +  OraChk  /  TFA   Network   Cluster   DB  

22. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       Define  “normal”   23   Size  Interconnect  for  aggregated  throughput     Use  redundancy  (HAIPs)  for  Load  Balancing   Use  different  subnets  for  the  interconnect   Use  Jumbo  Frames  wherever  possible   Ensure  enBre  infrastructure  support   Generic  Clusters  –  Network   More  Informa.on  in  Appendix  B   Receive()   argentinagermany 8K  Data   Block   1500  byte  MTU   Send()   Reassembly  FragmentaBon   Oracle  RAC   Oracle  RAC  

23. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       •   Fact:  In  virtual  environments,  certain     network  components  are  “virtualized”.   •   Consequence:  SomeBmes,  network  failures     are  not  reflected  in  the  guest  environment.   •   Reason:  OS  commands  run  in  the  guest  fail  to  detect   the  network  failure  as  the  “virtual  NIC”  remains  “up”.   •   Result:  correcBve  acBons  may  not  be  performed.   •   Solu.on:  Ping  Targets   24   Virtual  Generic  Clusters?  –  Use  Ping  Targets  with  12.1.0.2     Guest DBI Server APP More  Informa.on  aJached  

24. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       •   Ping  Targets  are  new  in  Oracle  RAC  12.1.0.2   •   Ping  Targets  use  a  probe  to  a  given  desBnaBon     (IP)  in  order  to  determine  network  availability.       •   Ping  Targets  are  used  in  addiBon  to  local  checks   •   Ping  Targets  are  used  on  the  public  network  only   •   Private  networks  already  use  constant  heartbeaBng   •   Ping  Targets  should  be  chosen  carefully:   •   Availability  of  the  ping  target  is  important   •   More  than  one  target  can  be  defined  for  redundancy   •   Ping  target  failures  should  be  meaningful     •   Example:  Pinging  a  central  switch  (probably  needs  to     be  enabled)  between  clients  and  the  database  servers.   25   (Virtual)  Generic  Clusters  –  Use  Ping  Targets  on  Public   [GRID]>  su     Password:       [GRID]>  srvctl  modify  network  -­‐k  1  -­‐pingtarget  “<UsefulTargetIP(s)>"   [GRID]>  exit   exit     [GRID]>  srvctl  config  network  -­‐k  1   Network  1  exists   Subnet  IPv4:  10.1.1.0/255.255.255.0/eth0,  staBc   Subnet  IPv6:     Ping  Targets:  <UsefulTargetIP(s)>   Network  is  enabled   Network  is  individually  enabled  on  nodes:     Network  is  individually  disabled  on  nodes:   Guest DBI Server APP

25. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       26   Generic  Clusters  –  Network  Summary   Use  Case   Area   Generic   Clusters   Extended   Cluster   Dedicated   (OLTP  /  DWH)   Consolidated   Environments   Storage   Appendix  A   OS   Memory  Config   +  OraChk  /  TFA   Network   As  discussed   +Appendix  B   Cluster   DB  

26. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       27   Generic  Clusters  –  Cluster   Use  Case   Area   Generic   Clusters   Extended   Cluster   Dedicated   (OLTP  /  DWH)   Consolidated   Environments   Storage   Appendix  A   OS   Memory  Config   +  OraChk  /  TFA   Network   As  discussed   +Appendix  B   Cluster   Appendix  D   DB   1.  Install  /  maintain  HUBs,  add  Leaf  Nodes   2.  Adding  nodes  to  the  cluster   3.  Use  Leaf  nodes  for  non-­‐DB  use  cases  

27. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       Program  Agenda   1   2   3   4   New  in  Oracle  RAC  12.1.0.2  (Install)   OperaBonal  Best  PracBces  for    Generic  Clusters    Extended  Cluster    Dedicated  Environments    Consolidated  Environments   Appendices  A  –  D     28   5  

28. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       29   Extended  Oracle  RAC   From  an  Oracle  perspec.ve,  an  Extended  RAC  installa.on  is  used  as  soon     as  data  (using  Oracle  ASM)  is  mirrored  between  independent  storage  arrays.   (Exadata  Storage  Cells  are  excluded  from  this  defini.on.)       ER:  open  to  make    "EXTENDED  ORACLE  RAC"  A  DISTINGUISHABLE  CONFIGURATION    

29. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       30   Extended  Cluster  –  Storage   Use  Case   Area   Generic   Clusters   Extended   Cluster   Dedicated   (OLTP  /  DWH)   Consolidated   Environments   Storage   Appendix  A   Appendix  A   OS   Memory  Config   +  OraChk  /  TFA   Network   As  discussed   +Appendix  B   Cluster   Appendix  D   DB   Step  1:  Create  “GRID”  Disk  Group  –  Extended  Cluster   Step  2:  Move  Clusterware  Files   Step  3:  Move  ASM  SPFILE  /  password  file   Step  4:  “srvctl  modify  asm  –count  all”    

30. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       Extended  Oracle  RAC  –  use  Standard  Cluster  +  Flex  ASM   •  What  are  “ASM_PREFERRED_READ_FAILURE_GROUPS”?   –  The  ASM_PREFERRED_READ_FAILURE_GROUPS  ini2aliza2on  parameter  is  a  comma-­‐delimited  list  of  strings  that  specifies  the  failure   groups  that  should  be  preferen2ally  read  by  the  given  instance.  This  parameter  is  generally  used  only  for  clustered  ASM  instances  and  its   value  can  be  different  on  different  nodes.     •  Example:  “diskgroup_name1.failure_group_name1,  ...”   –  For  extended  RAC,  this  paper:  Oracle  Real  ApplicaBon  Clusters  on  Extended  Distance  Clusters  (p.  26)  suggests  using  the   “ASM_PREFERRED_READ_FAILURE_GROUPS  parameter  to  go  to  the  local  mirror  instead  of  going  to  any  available  mirror.”     •  What  is  the  issue?   –  Using  Flex  ASM,  by  default  only  three  ASM  instances  are  started  in  the  cluster.   –  Assuming  that  the  Extended  RAC  uses  more  than  three  nodes  (e.g.  2  nodes  in  each  side),  there  is  a  likeliness  for  a  cross-­‐side  failover.   •  An  ASM  instance  cross-­‐side  failover  breaks  the  logic  to  use  “local  mirrors”  in  this  case,  as  the  local  mirror  is  side-­‐dependent.       •  SoluBon:     –  Follow  the  recommendaBon  to  use  “srvctl  modify  asm  –count  all”  for  Extended  Oracle  RAC  implementaBons  when  using  Flex  ASM.     •  This  reduces  the  staBsBcal  likeliness  for  a  cross-­‐side  failover.     –  For  future  releases,  ER  /  BUG  17045279  –  “ASM_PREFERRED_READ  DOES  NOT  WORK  WITH  FLEX  ASM”  addresses  this  problem.   31   How  to  make  use  of  “ASM_PREFERRED_READ_FAILURE_GROUPS”?  

31. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       32   Extended  Cluster  –  OS   Use  Case   Area   Generic   Clusters   Extended   Cluster   Dedicated   (OLTP  /  DWH)   Consolidated   Environments   Storage   Appendix  A   Appendix  A   OS   Memory  Config   +  OraChk  /  TFA   As  for  Generic   Clusters   Network   As  discussed   +Appendix  B   Cluster   Appendix  D   DB   More  informa.on:  Oracle  Real  ApplicaBon  Clusters   on  Extended  Distance  Clusters  (PDF)  -­‐   hOp://www.oracle.com/technetwork/database/opBons/ clustering/overview/extendedracversion11-­‐435972.pdf    

32. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       Define  “normal”   The  goal  in  an  Extended  RAC  setup  is  to  hide  the  distance.     Any  latency  increase  might  (!)     impact  applicaBon  performance.       33   VLANs  are  fully  supported  for  Oracle  RAC  –  for  more  informaBon,  see:       hOp://www.oracle.com/technetwork/database/database-­‐technologies/clusterware/overview/ interconnect-­‐vlan-­‐06072012-­‐1657506.pdf     VerBcal  subnet  separaBon  is  not  supported.   Extended  Cluster  –  Network   More  informa.on:  Oracle  Real  ApplicaBon  Clusters     on  Extended  Distance  Clusters  (PDF)  -­‐   hOp://www.oracle.com/technetwork/database/opBons/clustering/ overview/extendedracversion11-­‐435972.pdf    

33. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       34   Extended  Cluster  –  Network  Summary   Use  Case   Area   Generic   Clusters   Extended   Cluster   Dedicated   (OLTP  /  DWH)   Consolidated   Environments   Storage   Appendix  A   Appendix  A   OS   Memory  Config   +  OraChk  /  TFA   As  for  Generic   Clusters   Network   As  discussed   +Appendix  B   As  discussed   +Appendix  B   Cluster   Appendix  D   DB  

34. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       35   Extended  Cluster  –  Cluster  Summary   Use  Case   Area   Generic   Clusters   Extended   Cluster   Dedicated   (OLTP  /  DWH)   Consolidated   Environments   Storage   Appendix  A   Appendix  A   OS   Memory  Config   +  OraChk  /  TFA   As  for  Generic   Clusters   Network   As  discussed   +Appendix  B   As  discussed   +Appendix  B   Cluster   Appendix  D   As  Generic   DB   The  goal  in  an  Extended  RAC  setup  is  to  hide  the  distance.      

35. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       Program  Agenda   1   2   3   4   New  in  Oracle  RAC  12.1.0.2  (Install)   OperaBonal  Best  PracBces  for    Generic  Clusters    Extended  Cluster    Dedicated  Environments    Consolidated  Environments   Appendices  A  –  D     36   5  

36. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       37   Dedicated  Environments  –  Only  a  few  items  to  consider     Use  Case   Area   Generic   Clusters   Extended   Cluster   Dedicated   (OLTP  /  DWH)   Consolidated   Environments   Storage   Appendix  A   Appendix  A   OS   Memory  Config   +  OraChk  /  TFA   As  for  Generic   Clusters   Network   As  discussed   +Appendix  B   As  discussed   +Appendix  B   Cluster   Appendix  D   As  Generic   DB  

37. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       38   Dedicated  Environments  –  Network   [GRID]>  srvctl  config  scan  -­‐all   SCAN  name:  cupscan.cupgnsdom.localdomain,  Network:  1   Subnet  IPv4:  10.1.1.0/255.255.255.0/eth0,  staBc   Subnet  IPv6:     SCAN  0  IPv4  VIP:  10.1.1.55   SCAN  VIP  is  enabled.   SCAN  VIP  is  individually  enabled  on  nodes:     SCAN  VIP  is  individually  disabled  on  nodes:       SCAN  name:  cupscan2,  Network:  2   Subnet  IPv4:  10.2.2.0/255.255.255.0/,  staBc   Subnet  IPv6:     SCAN  1  IPv4  VIP:  10.2.2.55   SCAN  VIP  is  enabled.   SCAN  VIP  is  individually  enabled  on  nodes:     SCAN  VIP  is  individually  disabled  on  nodes:   SCAN  on     Network  1   SCAN  on     Network  2   More  InformaBon:     • Valid  Node  Checking  For  RegistraBon  (VNCR)  (Doc  ID  1600630.1)   • How  to  Enable  VNCR  on  RAC  Database  to  Register  only  Local  Instances   (Doc  ID  1914282.1)   More  informaBon:     •  Oracle  Real  ApplicaBon  Clusters  -­‐  Overview  of  SCAN  -­‐   hOp://www.oracle.com/technetwork/database/ opBons/clustering/overview/scan-­‐129069.pdf    

38. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       39   Dedicated  Environments  –  Network  Summary   Use  Case   Area   Generic   Clusters   Extended   Cluster   Dedicated   (OLTP  /  DWH)   Consolidated   Environments   Storage   Appendix  A   Appendix  A   OS   Memory  Config   +  OraChk  /  TFA   As  for  Generic   Clusters   Network   As  discussed   +Appendix  B   As  discussed   +Appendix  B   Appendix  B  +     as  discussed   Cluster   Appendix  D   As  Generic   DB  

39. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       Problem:  Patching  and  Upgrades   SoluBon:  Rapid  Home  Provisioning   40   Problem:  Memory  consumpBon   SoluBon:  Memory  Caps     Problem:  Number  of  ConnecBons   SoluBon:  various,     mostly  using  connecBon  pools   Dedicated  Environments  –  Database  (DB)   argentinagermany Connec.on   Pool   Oracle  GI     Oracle  RAC   Oracle  GI     Oracle  RAC  

40. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       New  in  Oracle  Database  12c:   •   SGA  and  PGA  aggregated  targets  can  be  limited.     •   See  documentaBon  for  “PGA_AGGREGATE_LIMIT”   41   Dedicated  Environments  –  Database  (DB)   [DB]>  sqlplus  /  as  sysdba     SQL*Plus:  Release  12.1.0.2.0  ProducBon  on  Thu  Sep  18  18:57:30  2014   …   SQL>  show  parameter  pga     NAME                                      TYPE    VALUE   -­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐  -­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐  -­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐   pga_aggregate_limit                          big  integer  2G   pga_aggregate_target                    big  integer  211M     SQL>  show  parameter  sga       NAME                                      TYPE    VALUE   -­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐  -­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐  -­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐   lock_sga              boolean    FALSE   pre_page_sga              boolean    TRUE   sga_max_size              big  integer  636M   sga_target              big  integer  636M   unified_audit_sga_queue_size            integer    1048576   1.  Do  not  handle  connecBon  storms,  prevent  them.     2.  Limit  the  number  of  connecBons  to  the  database.       3.  Use  ConnecBon  Pools  where  possible:   •  Oracle  Universal  ConnecBon  Pool  (UCP)  -­‐   hOp://docs.oracle.com/database/121/JJUCP/rac.htm#JJUCP8197   4.  Ensure  applicaBons  close  connecBons.   •  If  number  of  acBve  connecBons  is  fairly  less  than     the  number  of  open  connecBons,  consider  using   “Database  Resident  ConnecBon  Pooling”  -­‐   docs.oracle.com/database/121/JJDBC/drcp.htm#JJDBC29023     5.   If  you  cannot  prevent  the  storm,  slow  it  down.   •  Use  listener  parameters  to  miBgate  the  negaBve   side  effects  of  a  connecBon  storm.  Most  of  these   parameters  can  also  be  used  with  SCAN.     6.  Services  can  be  assigned  to  one  subnet  at  a  Bme.     You  control  the  subnet,  you  control  the  service.     Connec.on  Pool  

41. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       42   Dedicated  Environments  –  Database  Summary   Use  Case   Area   Generic   Clusters   Extended   Cluster   Dedicated   (OLTP  /  DWH)   Consolidated   Environments   Storage   Appendix  A   Appendix  A   OS   Memory  Config   +  OraChk  /  TFA   As  for  Generic   Clusters   Network   As  discussed   +Appendix  B   As  discussed   +Appendix  B   Appendix  B  +     as  discussed   Cluster   Appendix  D   As  Generic   DB   As  discussed  

42. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       Program  Agenda   1   2   3   4   New  in  Oracle  RAC  12.1.0.2  (Install)   OperaBonal  Best  PracBces  for    Generic  Clusters    Extended  Cluster    Dedicated  Environments    Consolidated  Environments   Appendices  A  –  D     43   5  

43. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       44   Consolidated  Environments  –  Network  Summary   Use  Case   Area   Generic   Clusters   Extended   Cluster   Dedicated   (OLTP  /  DWH)   Consolidated   Environments   Storage   Appendix  A   Appendix  A   OS   Memory  Config   +  OraChk  /  TFA   As  for  Generic   Clusters   Network   As  discussed   +Appendix  B   As  discussed   +Appendix  B   Appendix  B  +     as  discussed   As  dedicated  +   as  discussed     Cluster   Appendix  D   As  Generic   DB   As  discussed  

44. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       Database  ConsolidaBon   •   MulBple  database  instances  running  on  a  server   •   Need  to  manage  memory  across  instances   •   Use  Instance  Caging  and  QoS  (in  RAC  cluster)     45   Use  Oracle  MulBtenant   •   A  limited  number  of  Container  DB  instances  to  manage   •   Memory  allocaBon  on  the  server  is  simplified   •   Instance  Caging  may  not  be  needed  (QoS  sBll  beneficial)   Consolidated  Environments  –  No  VMs  è  2  Main  Choices     argentinagermany racdb1_3   Oracle  GI     Oracle  RAC   Oracle  GI     Oracle  RAC   brazil argentinagermany Oracle GI | HUB Oracle GI | HUB Oracle GI | HUB Oracle RAC Oracle RAC italy Oracle GI | HUB Oracle RAC cons   Oracle RAC cons1_2   cons1_1   CPU_Count=5   CPU_Count=3  

45. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       More  informaBon:     • hOp://www.oracle.com/technetwork/database/focus-­‐areas/ database-­‐cloud/database-­‐cons-­‐best-­‐pracBces-­‐1561461.pdf     • http://www.oracle.com/technetwork/database/options/ clustering/overview/rac-cloud-consolidation-1928888.pdf 46   Use  Oracle  MulBtenant   •   Can  be  operated  as  a  Dedicated  Environment,   •   at  least  from  the  cluster  perspecBve,   •   if  only  1  Container  Database  Instance  per  server  is  used   Consolidated  Environments  –  Make  them  Dedicated  …     argentinagermany racdb1_3   Oracle  GI     Oracle  RAC   Oracle  GI     Oracle  RAC   brazil argentinagermany Oracle GI | HUB Oracle GI | HUB Oracle GI | HUB Oracle RAC Oracle RAC italy Oracle GI | HUB Oracle RAC cons   Oracle RAC cons1_2   cons1_1   CPU_Count=5   CPU_Count=3  

46. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       47   Consolidated  Environments  –  Database  (DB)  Summary   Use  Case   Area   Generic   Clusters   Extended   Cluster   Dedicated   (OLTP  /  DWH)   Consolidated   Environments   Storage   Appendix  A   Appendix  A   OS   Memory  Config   +  OraChk  /  TFA   As  for  Generic   Clusters   Network   As  discussed   +Appendix  B   As  discussed   +Appendix  B   Appendix  B  +     as  discussed   As  dedicated  +   as  discussed     Cluster   Appendix  D   As  Generic   DB   As  discussed   As  above   Specifically  for  Oracle  MulBtenant  on  Oracle  RAC,  see:   hOp://www.slideshare.net/MarkusMichalewicz/oracle-­‐ mulBtenant-­‐meets-­‐oracle-­‐rac-­‐ioug-­‐2014-­‐version    

47. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       Appendix  A   Crea.ng  “GRID”  disk  group  to  place  the  Oracle  Clusterware  files  and  the  ASM  files     Oracle  ConfidenBal  –  Internal/Restricted/Highly  Restricted   48  

48. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       49   Create  “GRID”  Disk  Group  –  Generic  Cluster   Use   “quorum”   whenever   possible.    

49. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       50   Create  “GRID”  Disk  Group  –  Extended  Cluster   •  More  informaBon:   hOp://www.oracle.com/technetwork/ database/opBons/clustering/overview/ extendedracversion11-­‐435972.pdf     •   Use  logical  names   illustraBng  the  disk   desBnaBon   •   Use  a  quorum  for     ALL  (not  only  GRID)     disk  groups  used  in     an  ExtendedCluster     •   Use  VoBng   Disk  NFS   desBnaBon  

50. Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.       Replace  Vo.ng  Disk  Loca.on   Add  OCR  Loca.on   51   Move  Clusterware  Files   [GRID]>  crsctl  query  css  votedisk   ##    STATE        File  Universal  Id                                File  Name  Disk  group   -­‐-­‐    -­‐-­‐-­‐-­‐-­‐        -­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐                                -­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐  -­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐-­‐    1.  ONLINE      8bec21793ee84fd3bfc6831746bf60b4  (/dev/sde)  [GIMR]   Located  1  voBng  disk(s).     [GRID]>  crsctl  replace  votedisk  +GRID   Successful  addiBon &#x

#change presentations

Continuous Learning at Work
13. 08. 2019
0 views

Continuous Learning at Work

Related presentations


Other presentations created by MarkusMichalewicz

Maximizing Oracle RAC Uptime
01. 10. 2014
0 views

Maximizing Oracle RAC Uptime