I am getting the "ERROR! the field 'hosts' is required but was not set"
error, and my playbook is as follows. I am trying to run a sql script
(record.sql) from the ansible control server to the DB server.
---
- hosts: DBServer
- tasks:
- name: Execute table.sql using sqlplus
shell: |
export ORACLE_HOME={/u01/app/oracle/product/12.2.0.1/dbhome_1}}
$ORACLE_HOME/bin/sqlplus -s tstsch/tstsch@dbname @record.sql
environment:
ORACLE_HOME: "{{/u01/app/oracle/product/12.2.0.1/dbhome_1}
<http://12.2.0.1/dbhome_1%7D>}"
PATH: "{{$PATH:$ORACLE_HOME/bin}}"
args:
chdir: "{{/home/ansible}}"
become: true
become_method: su
become_user: oracle
--
You received this message because you are subscribed to the Google Groups
"Ansible Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to ansible-devel+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/ansible-devel/7e095851-01b6-4a1c-b824-0df893cfbc8b%40googlegroups.com.
