oracle-database-software-restore

[dawid@bsdek ~/workplace/roles/oracle-database-software-restore/tasks]$ cat main.yml
# Author Dawid Mocek
---
- name: Update yum packages
  yum: name=* state=latest

- name: Install yum packages for Oracle DB
  yum: name={{ item.name }} state=latest
  with_items:
    - { 'name': 'unzip.x86_64'}
    - { 'name': 'oracle-database-server-12cR2-preinstall.x86_64' }

- name: Create Oracle DB directories
  file: path={{ item.name }} state=directory owner="{{ oracle_uid }}" group="{{ oracle_gid }}" mode=0750
  with_items:
    - { 'name': '{{ oracle_base }}' }
    - { 'name': '{{ oracle_inventory }}' }
    - { 'name': '{{ oracle_workspace }}' }

- name: Copy bash profile
  template: src=bash_profile  dest="/home/{{ oracle_uid }}/.bash_profile" owner="{{ oracle_uid }}" group="{{ oracle_gid }}" mode=0644

- name: Copy Oracle DB cloned software to remote host
  synchronize: src=files/workspace/dbhome_1.zip dest="/home/{{ oracle_uid }}/workspace" compress=no

- name: Extract package
  unarchive: src="/home/{{ oracle_uid }}/workspace/dbhome_1.zip" dest=/ remote_src=yes owner="{{ oracle_uid }}" group="{{ oracle_gid }}"
  tags: unarchive

- name: Delete package
  file: path="/home/{{ oracle_uid }}/workspace/dbhome_1.zip" state=absent

- name: Execute clone Oracle perl script
  become: true
  become_user: "{{ oracle_uid }}"
  shell: "{{ oracle_home }}/perl/bin/perl {{ oracle_home }}/clone/bin/clone.pl ORACLE_BASE={{ oracle_base }}  ORACLE_HOME={{ oracle_home }} OSDBA_GROUP=dba OSOPER_GROUP=dba -defaultHomeName  -ignoreSysPrereqs -silent"
  tags: clone

- name: Execute root-scripts
  shell: "{{ item.name }}"
  with_items:
    - { 'name': '{{ oracle_inventory }}/orainstRoot.sh' }
    - { 'name': '{{ oracle_home }}/root.sh' }
  tags: root-scripts


[dawid@bsdek ~/workplace/roles/oracle-database-software-restore/defaults]$ cat main.yml
oracle_uid: 'oracle'
oracle_gid: 'oinstall'
oracle_base: /u01/app/oracle
oracle_home: "{{ oracle_base }}/product/12.1.0/dbhome_1"
oracle_inventory: /u01/app/oraInventory
oracle_workspace: "/home/{{ oracle_uid }}/workspace"

[dawid@bsdek ~/workplace/roles/oracle-database/tasks]$ cat main.yml
# Author Dawid Mocek
---

- name: Copy DBCA response file
  template: src=dbca.rsp.j2 dest="/home/{{ oracle_uid }}/dbca.rsp" owner="{{ oracle_uid }}" group="{{ oracle_gid }}" mode=0644

- name: Copy NETCA response file
  template: src=netca.rsp.j2 dest="/home/{{ oracle_uid }}/netca.rsp" owner="{{ oracle_uid }}" group="{{ oracle_gid }}" mode=0644

- name: Create database listener
  become: true
  become_user: "{{ oracle_uid }}"
  shell: "{{ oracle_home }}/bin/netca -silent -responsefile /home/{{ oracle_uid }}/netca.rsp"

- name: Create database instance
  become: true
  become_user: "{{ oracle_uid }}"
  shell: "{{ oracle_home }}/bin/dbca -silent -responseFile /home/{{ oracle_uid }}/dbca.rsp"

# - name: Create RMAN catalogue

# - name: Register RMAN in database

# - name: Create schema