On 1/28/20 6:05 PM, Anand Solomon wrote:
> 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 ?
>
I suppose you could filter out the comments. How does your SQL script looks
like?
Regards
Racke
>
> 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]
> <mailto:[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
> <https://groups.google.com/d/msgid/ansible-project/7afeb9ff-12e0-4f4f-b4fc-0a86d515a694%40googlegroups.com?utm_medium=email&utm_source=footer>.
--
Ecommerce and Linux consulting + Perl and web application programming.
Debian and Sympa administration. Provisioning with Ansible.
--
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/d26236f5-02e1-611a-d422-9b78163640ee%40linuxia.de.
signature.asc
Description: OpenPGP digital signature
