Oracle Instant Client role

Summary

This role installs and configures oracle instant client.

Requirements

• Minimal Version of the ansible for installation: 2.5

• Prepared ansible inventory file with listed VMs with python. These machines should be accessible via SSH. Supported CentOS 6.* and Centos 7.*

• Client / Server interoperability support matrix for different oracle versions

Role Variables

• transport - artifact source transport default: local

  available:

  • web - fetch artifact from custom web uri
  • local - local artifact

• transport_web - URI for http/https artifact default: "http://my-storage.example.com"

• transport_local - path for local artifact default: "/tmp"

• oracle_instantclient_packages - Oracle instant client package and tools

  default:

  • - "oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm"
  • - "oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm"
  • - "oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm"

• download_path - local folder for downloading artifacts default: /tmp

• ld_library_path - environment variable default: "/usr/lib/oracle/12.1/client64/lib"

Dependencies

None.

Example Playbook

Including an example of how to use your role (for instance, with variables passed in as parameters) is always nice for users too:

- name: "Install oracle instant client"
  hosts: "all"

  roles:
    - role: "lean_delivery.oracle_instant_client"
      transport: "web"
      transport_web: "http://my-storage.example.com"
      oracle_instantclient_packages:
        - "oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm"
        - "oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm"
        - "oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm"

- name: "Install oracle instant client"
  hosts: "all"

  roles:
    - role: "lean_delivery.oracle_instant_client"
      transport: "local"
      transport_local: "/tmp"
      oracle_instantclient_packages:
        - "oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm"
        - "oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm"
        - "oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm"

License

Apache

Author Information

authors:

• Lean Delivery Team team@lean-delivery.com