Use of Oracle wallet (SEPS) & tnsnames.ora for configuration

[patrickjolliffe]

Hi looks like a very useful project, I am going to try to download it and have a play around.
One thing that immediately strikes me as slightly problematic (at least for me) is requirement to provide per instance parameters as below.
Ideally I would like to store the host&port&service/sid via tnsnames.ora, and store the oracle_user and password in wallet.
I think that is not possible per current configuration, have you considered this? (maybe a enhancement request)?

oracle_host:
oracle_port:
oracle_user:
oracle_pass:
oracle_mode: <[SYSDBA|SYSOPER]>
oracle_sid:
oracle_service: <service_name>

[Nosmoht]

Hi @hkpatv,

never considered that, but sounds like a good enhancement. As i don't know if i have time within the next weeks, feel free to send a PR ;)

[patrickjolliffe]

Your competition actually handles this reasonably well:
https://github.com/oravirt/ansible-oracle-modules
We are actually using those modules for now.