I am using oracle_pdb and oracle_user modules to set up Oracle Databases and users via ansible. This works fine until we use only Standalone databases.
Now I need to set up a CDB/PDB Database. Creation works fine. User setup with a loop on all needed users works also without error.Passwords are stored in an ansible-vault.
But the setted up passwords are not correct.
Encrypting the vault with ansible-vault shows correct password
But login with this passwords rsults in ORA-1017 user/password incorrect.
- name: create deploy user DPLUS_%
connection: local
no_log: true
oracle_user:
hostname: "{{ db_hostname }}"
service_name: "{{ rcs_pdb_service }}"
user: "{{ db_connect_user }}"
password: "{{ db_connect_password }}"
mode: "{{ db_connect_mode }}"
schema: "{{ item.username }}"
schema_password: "{{ item.password_vault }}"
default_tablespace: "{{ rcs_db_deploy_default_tablespace }}"
default_temp_tablespace: "{{ rcs_db_deploy_temporary_tablespace }}"
with_items:
- "{{ rcs_db_deploy_users }}"
loop_control:
label: "{{ item.username }}"
Vault entry:
- username: DPLUS_APPL
password_hash: S:ABDED382253DB7932BCBCC93C6D3B6E742B664C5D9F1E737D5AB373714D8;T:89F040CEB67D2AD5B57DC0C8B62B60C308F9A10BEA45E0081FB6C70D664D6AFE584E67022A501C679CE8A78968A5F7F63359690728B27C92C33AEE77D0FCCCFAEA0E6DF37A46AEDC3B41BB04393BC755
password_vault: !vault |
$ANSIBLE_VAULT;1.1;AES256
663265616166353031353066383331366435323635333762346339323038333162306531643532343765373433633836643631343035643539313838303063630a376465393635356663393338626632613061353033636230386565623539393564653963313734663231316334343738326663633234366534613839373966300a6138386137316164656339313231643434643162646132333665626536626631
- oracle_user