2018-03-01 Ansible Playbook for Oracle Directories

Overview

Following the successful creation of AUBURN as an Ansible server, I wanted to create a playbook for the installation of Grid Infrastructure (GI) 12.1.0.2 that could be used as I experimented with GI.

The previous procedure created an Ansible playbook that installed the Oracle pre-installation RPM. In this procedure, I want to complete the set-up of the Oracle user.

References

• Ansible Documentation
  • Module Index
    • Files Modules
      • file - Sets attributes of files
• Oracle^® 12.1 Grid Infrastructure Installation Guide
  • 6 Configuring Users, Groups and Environments for Oracle Grid Infrastructure and Oracle RAC
    • 6.1 Creating Groups, Users and Paths for Oracle Grid Infrastructure
      • 6.1.6 Creating the Oracle Home and Oracle Base Directory

Procedure

Create Directories

Following the suggestions made in 6.1.6 Creating the Oracle Home and Oracle Base Directory, I created a new playbook called install-dir.yml with the following entries:

--- - name: Prepare REDFERN Cluster for Oracle GI 12.1 installation (Installation Directories) hosts: redfern1.yaocm.id.au become: true tasks: - name: Creating the Oracle Home and Oracle Base Directory file: path: /opt/{{ item }} owner: oracle group: oinstall mode: 0755 state: directory recurse: yes with_items: - app/12.1.0/grid - app/grid - app/oracle

On AUBURN, I executed the playbook as follows:

ansible-playbook -K install-dir.yml

The output was:

SUDO password: PLAY [Prepare REDFERN Cluster for Oracle GI 12.1 installation (Installation Directories)] *** TASK [Gathering Facts] ********************************************************* ok: [redfern1.yaocm.id.au] TASK [Creating the Oracle Home and Oracle Base Directory] ********************** changed: [redfern1.yaocm.id.au] => (item=app/12.1.0/grid) changed: [redfern1.yaocm.id.au] => (item=app/grid) changed: [redfern1.yaocm.id.au] => (item=app/oracle) PLAY RECAP ********************************************************************* redfern1.yaocm.id.au : ok=2 changed=1 unreachable=0 failed=0

To verify this, I executed the following command on REDFERN1:

ls -lR /opt/app

The output was:

/opt/app: total 0 drwxr-xr-x. 3 oracle oinstall 18 Mar 1 23:11 12.1.0 drwxr-xr-x. 2 oracle oinstall 6 Mar 1 23:11 grid drwxr-xr-x. 2 oracle oinstall 6 Mar 1 23:11 oracle /opt/app/12.1.0: total 0 drwxr-xr-x. 2 oracle oinstall 6 Mar 1 23:11 grid /opt/app/12.1.0/grid: total 0 /opt/app/grid: total 0 /opt/app/oracle: total 0

Apart from the incorrect modification dates (the time is correct), the directory settings appear to be correct.