ERROR! couldn't resolve module/action 'oracle_sql'

[anandsolomon]

Hi, I am trying to use oracle_sql module to run queries using ansible. I have installed Ansible, cx_oracle, and I also have oracle instant client. I am trying to run the below playbook, I am getting the error

ERROR! couldn't resolve module/action 'oracle_sql'. This often indicates a misspelling, missing collection, or incorrect module path.

---

• hosts: all
  user: oracle

  vars:
  oracle_home: /u01/app/oracle/product/12.2.0.1/dbhome_1
  host: all
  service_name: orcl
  set_init_mode: sysdba
  set_init_user: sys
  user: tstsch
  password: tstsch
  oracle_env:
  ORACLE_HOME: "{{ oracle_home }}"
  LD_LIBRARY_PATH: "{{ oracle_home }}/lib"

  tasks:

  • name: Run SQL
    oracle_sql:
    username: "{{ user }}"
    password: "{{ password }}"
    mode: sysdba
    port: 1521
    service_name: "{{ service_name }}"
    sql: "select * from dba_users"