Question: Running Oracle SQL scripts with Ansible playbook


Running Oracle SQL scripts with Ansible playbook

Answers 1
Added at 2016-12-27 09:12

A look at the core database modules in Ansible documentation shows no signs of a module for Oracle. What is the best way to handle SQL/PLSQL deployments via Ansible for Oracle databases?

Are we expected to use roles from Ansible Galaxy to handle this? Very few people seem to have downloaded roles listed on Galaxy for Oracle.

Answers to

Running Oracle SQL scripts with Ansible playbook

nr: #1 dodano: 2016-12-27 22:12

I have created a role to install apex 5 (where I first uninstall apex 4). I use modules like 'script' and 'shell'. I am not too happy about environment initialization but I am still learning. For any SQL/PLSQL task, sqlplus is the right tool. (perhaps SQLcl can do better..?)

- name: Determine apex version
  become: yes
  become_user: oracle
  shell: source /etc/profile &&  sqlplus -S / as sysdba @"{{ temp_dir }}/apexver.sql"
  register: apexver
     executable: /bin/bash
  changed_when: "'APEX_040000' in apexver.stdout"

- name: oracle apex remove
  become: yes
  become_user: oracle
  script: {{ item }} 
    - 'XE'
  ignore_errors: yes
  register: result
  when: "'APEX_040000' in apexver.stdout"

22:18 $ cat

# set oracle environment
. /u01/app/oracle/product/11.2.0/xe/bin/

sqlplus -s /nolog <<EOF
connect / as sysdba
Source Show
◀ Wstecz