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]> 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]. > 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/CAL8fbwNEGV0oUrHM%2BW3qVB-jw%3DAUPhfQF9Cb%3DK8mk3HC%3DtspJQ%40mail.gmail.com.
