mtajammul / racgindb_ru

Oracle RAC Grid Infrastructure and Oracle Home patch - RU January'19

RACGInDB_RU

Oracle RAC Grid Infrastructure and Oracle Home patch - RU January'19 RU 18.3 to 18.5

Release Update for RAC GI and Oracle_HOME

Variables

---

oracle_user: "oracle" oracle_install_group: "oinstall" patch_dir: "/u01/patches" patchid: "28828717" tmp_dir: "/u01/app/temp" logdir: "/tmp/{{ patchid }}" oracle_home: "/u02/app/oracle/product/18.3.0/dbhome_1" grid_home: "/u02/app/18.3.0/grid" stage_dir: "/u01/stage" root_user: "root" grid_user: "grid" date: "{{ lookup('pipe', 'date +%Y%m%d-%H%M') }}"

Tree Structure for this role is -

[root@oel75 ansible]# tree roles/racdb_patch_apply/ roles/racdb_patch_apply/ ├── defaults │   └── main.yml ├── files │   └── sqlpatch.sql ├── tasks │   ├── main.yml │   ├── postpatch_apply.yml │   └── prepatch_apply.yml ├── templates └── vars └── main.yml

5 directories, 6 files

Tasks: main.yml

• pre_tasks_before_apply [prepatch_apply.yml]

  • Backup opatch file from grid home / oracle home
  • Update required opatch utility in grid home / Oracle home
  • Update opatch ownership in grid home / Oracle home
  • OPatch Conflict Check in grid home / Oracle home
  • OPatch SystemSpace Check in grid home / Oracle home
  • check inventory for grid home / Oracle home
  • One-Off Patch Conflict Detection (-analyze)
  • current patch information

• RU to grid home first node

• RU to grid home second node

• Pause after GI patching completion

• RU to database home first node

• RU to database home second node

• post_tasks_after_apply [postpatch_apply.yml]

  • Apply data patch