- name: Install Python Scientific Computing Packages
  yum: name={{ item }} state=latest
  with_items:
    - python-matplotlib
    - python-pandas
    - numpy
    - scipy
    - gcc
    - python-pip
    - libaio
    - oracle-instantclient11.2-basic
    - oracle-instantclient11.2-sqlplus
    - oracle-instantclient11.2-devel

- name: Set ORACLE_HOME
  shell: "echo export ORACLE_HOME=/usr/lib/oracle/11.2/client64 >> ~/.bash_profile"
- name: Add to PATH
  shell: "echo export PATH=$PATH:/usr/lib/oracle/11.2/client64/bin >> ~/.bash_profile"
- name: Set LD_LIBRARY_PATH
  shell: "echo export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib >> ~/.bash_profile"
- name: Reload bash profile
  shell: "source ~/.bash_profile"
- name: Set up lib sources
  shell: "echo /lib > /etc/ld.so.conf.d/oracle-instantclient-11.2.so.conf"
- name: Set up lib sources
  shell: "echo /usr/lib/oracle/11.2/client64/lib >> /etc/ld.so.conf.d/oracle-instantclient-11.2.so.conf"
- name: Rerun ldconfig
  shell: "ldconfig -v"

# Install cx_Oracle Python package
- pip: name=cx_Oracle