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.
