Hi,
I am using oracle_sql module and running a sql script. The sql script
contains comments. The playbook fails because "
FAILED! => {"changed": false, "msg": "Something went wrong while executing
sql - ORA-00911: invalid character sql:
Is there a way I can keep the comments and execute the sql script ?
On Saturday, January 25, 2020 at 5:17:44 PM UTC-5, Dick Visser wrote:
>
> Hi
>
> Ansible doesn’t have such a module, so I assume this is a 3rd party module?
> In that case you might have more luck asking the module’s authors for
> support.
>
>
> On Sat, 25 Jan 2020 at 16:07, Anand Solomon <[email protected]
> <javascript:>> wrote:
>
>> I am trying to create oracle user using oracle_user module in a RDS
>> server. Here is my playbook
>>
>> - hosts: all
>> vars:
>> oracle_home: /home/ansible/instantclient_12_2
>> user: SYSDBA
>> password: ******
>> prt: "1521"
>> hostname: "RDS Instance"
>> sname: TESTDB
>> oracle_env:
>> ORACLE_HOME: "{{oracle_home}}"
>> LD_LIBRARY_PATH: "{{oracle_home}}"
>> PATH: "{{oracle_home}}"
>>
>> vars_files:
>> - vault-pass.yml
>>
>> tasks:
>> - name: This playbook will create the user.
>> oracle_user:
>> oracle_home: /home/ansible/instantclient_12_2
>> user: "{{user}}"
>> password: "{{password}}"
>> service_name: "{{sname}}"
>> port: "{{prt}}"
>> hostname: "{{hostname}}"
>> schema: *****
>> schema_password: ****
>> default_tablespace: USERS
>> # state: present
>> grants: "'create session', create any table'"
>> environment: "{{oracle_env}}"
>>
>> This fails with below error
>> FAILED! => {"changed": false, "msg": "The cx_Oracle module is required.
>> 'pip install cx_Oracle' should do the trick. If cx_Oracle is installed,
>> make sure ORACLE_HOME & LD_LIBRARY_PATH is set"}
>>
>> DO we need to have cx_oracle installed in the target server too? I had
>> this same issue with oracle_sql module too, but I used "connection: local"
>> to enforced the playbook to look at the local cx_oracle install. This is
>> not working in oracle_user module.
>>
>> --
>> 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] <javascript:>.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/ansible-project/c1c30471-934e-42e2-9e2b-991c1e57db87%40googlegroups.com
>>
>> <https://groups.google.com/d/msgid/ansible-project/c1c30471-934e-42e2-9e2b-991c1e57db87%40googlegroups.com?utm_medium=email&utm_source=footer>
>> .
>>
> --
> Sent from a mobile device - please excuse the brevity, spelling and
> punctuation.
>
--
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/7afeb9ff-12e0-4f4f-b4fc-0a86d515a694%40googlegroups.com.
