It worked as follows, removing and considering e stdout:
shell:
cmd: |
{{ env_orahome }}/bin/rman << EOF
{{ script_path_tmp.stdout }}
EOF
Thanks Todd.
Em quarta-feira, 16 de agosto de 2023 às 07:55:03 UTC-3, Todd Lewis
escreveu:
> Remove the double-quotes from
> shell:
> cmd: |
> {{ env_orahome }}/bin/rman << EOF
> "{{ script_path_tmp.stdout_lines }}"
> EOF
>
> On Tuesday, August 15, 2023 at 1:57:14 PM UTC-4 Luiz Gustavo wrote:
>
>> Hey guys.
>>
>> I'm passing commands to rman through a variable created by the shell
>> module.
>>
>> Where am I going wrong?
>>
>> ...
>>
>> - name: Creates purge script from the original script
>> shell: egrep -i 'connect|delete' "{{ script_path }}" | sed
>> '/^#/d;/delete/I s/[0-9]\{1,\}/1/'
>> register: script_path_tmp
>>
>> - name: Print var
>> debug:
>> msg: "{{ script_path_tmp.stdout_lines }}"
>>
>> - name: Runs RMAN archivelog purge script
>> shell:
>> cmd: |
>> {{ env_orahome }}/bin/rman << EOF
>> "{{ script_path_tmp.stdout_lines }}"
>> EOF
>> environment:
>> ORACLE_HOME: "{{ env_orahome }}"
>> register: rman_out
>>
>> # Result of execution:
>>
>> TASK [Print var]
>> ******************************************************************************************************************
>> ok: [hostname] => {
>> "msg": [
>> "CONNECT TARGET \"USER/pass@service as sysbackup\"",
>> "DELETE NOPROMPT ARCHIVELOG ALL BACKED UP 1 TIMES TO DEVICE TYPE
>> sbt;"
>> ]
>> }
>>
>> TASK [Runs RMAN archivelog purge script]
>> ***********************************************************************************************
>> fatal: [hostname]: FAILED! => {"changed": true, "cmd":
>> "/u01/app/oracle/product/19.0.0.0/dbhome_1/bin/rman << EOF\n
>> \"[u'CONNECT TARGET \"USER/pass@service as sysbackup\"', u'DELETE NOPROMPT
>> ARCHIVELOG ALL BACKED UP 1 TIMES TO DEVICE TYPE sbt;']\"\nEOF\n", "delta":
>> "0:00:00.552187", "end": "2023-08-11 10:22:21.657952", "msg": "non-zero
>> return code", "rc": 1, "start": "2023-08-11 10:22:21.105765", "stderr": "",
>> "stderr_lines": [], "stdout": "\nRecovery Manager: Release 19.0.0.0.0 -
>> Production on Fri Aug 11 10:22:21 2023\nVersion 19.16.0.0.0\n\nCopyright
>> (c) 1982, 2019, Oracle and/or its affiliates. All rights
>> reserved.\n\nRMAN> \nRMAN-00571:
>> ===========================================================\nRMAN-00569:
>> =============== ERROR MESSAGE STACK FOLLOWS ===============\nRMAN-00571:
>> ===========================================================\nRMAN-00558:
>> error encountered while parsing input commands\nRMAN-01009: syntax error:
>> found \"double-quoted-string\": expecting one of: \"advise, allocate,
>> alter, analyze, associate statistics, audit, backup, begin, @, call,
>> catalog, change, comment, commit, configure, connect, convert, copy,
>> create, create catalog, create global, create or replace global, create or
>> replace script, create script, crosscheck, declare, delete, delete from,
>> describe, describe catalog, disassociate statistics, drop, drop catalog,
>> drop database, duplicate, exit, explain plan, flashback, flashback table,
>> grant, grant catalog, grant register, host, import, insert, list, lock,
>> merge, mount, noaudit, open, print, purge, quit, recover, register,
>> release\"\nRMAN-01007: at line 1 column 3 file: standard input\n\nRMAN>
>> \n\nRecovery Manager complete.", "stdout_lines": ["", "Recovery Manager:
>> Release 19.0.0.0.0 - Production on Fri Aug 11 10:22:21 2023", "Version
>> 19.16.0.0.0", "", "Copyright (c) 1982, 2019, Oracle and/or its affiliates.
>> All rights reserved.", "", "RMAN> ", "RMAN-00571:
>> ===========================================================", "RMAN-00569:
>> =============== ERROR MESSAGE STACK FOLLOWS ===============", "RMAN-00571:
>> ===========================================================", "RMAN-00558:
>> error encountered while parsing input commands", "RMAN-01009: syntax error:
>> found \"double-quoted-string\": expecting one of: \"advise, allocate,
>> alter, analyze, associate statistics, audit, backup, begin, @, call,
>> catalog, change, comment, commit, configure, connect, convert, copy,
>> create, create catalog, create global, create or replace global, create or
>> replace script, create script, crosscheck, declare, delete, delete from,
>> describe, describe catalog, disassociate statistics, drop, drop catalog,
>> drop database, duplicate, exit, explain plan, flashback, flashback table,
>> grant, grant catalog, grant register, host, import, insert, list, lock,
>> merge, mount, noaudit, open, print, purge, quit, recover, register,
>> release\"", "RMAN-01007: at line 1 column 3 file: standard input", "",
>> "RMAN> ", "", "Recovery Manager complete."]}
>>
>>
>>
>>
--
You received this message because you are subscribed to the Google Groups
"Ansible Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/ansible-project/e1e88090-a302-4140-8aec-bc3ca0a5683dn%40googlegroups.com.
