--- - name: Call SQL*Plus Script to disable all mangement packs hosts: ORA_SERVER tasks: - name: Create the Script Directory become: yes become_user: oracle ansible.builtin.file: owner: oracle group: oinstall path: "/home/oracle/ansible_scripts/" state: directory - name: Copy the sql*plus script become: yes become_user: oracle ansible.builtin.copy: src: ./scripts/set_pack_access.sql dest: /home/oracle/ansible_scripts - name: Call the script as oracle user become: yes become_user: oracle command: "$ORACLE_HOME/bin/sqlplus -s / as sysdba @/home/oracle/ansible_scripts/set_pack_access.sql" environment: ORACLE_HOME: "{{ item.0.oracle_home }}" ORACLE_SID: "{{ item.1 }}" with_subelements: - "{{ oracle_envs }}" - oracle_sid