Getting: "The cx_Oracle module is required.", even though all requirements are satisfied

[serpro69]

Hi,

I'm facing getting an error when running the modules:

"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

I have the cx_Oracle installed:

$ pip install cx_Oracle                                                                                                                                                                                                    
Requirement already satisfied: cx_Oracle in ./.virtualenvs/oci/lib/python3.6/site-packages (7.2.3)

ORACLE_HOME and LD_LIBRARY_PATH are also set:

$ echo $ORACLE_HOME                                                                                                                                                                                                        
/opt/oracle/instantclient_19_3
$ echo $LD_LIBRARY_PATH                                                                                                                                                                                                   
/opt/oracle/instantclient_19_3

I have tested the connection to db with sqlplus and that works fine as well.

I can import cx_Oracle from the cli:

$ python       
                                                                                                                                                                  
Python 3.6.8 (default, Oct  7 2019, 12:59:55)
[GCC 8.3.0] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import cx_Oracle
>>> print(cx_Oracle.version)
7.2.3
>>>

But for some reason this fails when used from the ansible module.
I thought the python virtual environment might be the reason but I tried installing cx_Oracle outside the venv and it still fails with the same error. Though I have a hunch it's something to do with the virtual env.
Do you know what am I doing wrong here?
Thanks.

[serpro69]

Well my thought was correct, the cx_Oracle has to be installed for /usr/bin/python. Is there any way to make it work with virtualenv?

[tdavison784]

Hi Sergio, You can make it work with the venv by pointing ansibles python interpreter to it. You can do this as an extra var or in the inventory file as well. ansible-playbook -i inventory site.yml -e “ansible_python_interpreter=path/to/venv/python”

…

On Wed, Nov 20, 2019 at 09:14 Sergio Pro ***@***.***> wrote: Well my thought was correct, the cx_Oracle has to be installed for /usr/bin/python. Is there any way to make it work with virtualenv? — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#116?email_source=notifications&email_token=AHY4VPY7DS42AEX7UEO3JRDQUVH6RA5CNFSM4JPTWTVKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEESJ3XI#issuecomment-556047837>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AHY4VPYNNXJBAIRLWEZWWIDQUVH6RANCNFSM4JPTWTVA> .

[serpro69]

Thanks @tdavison784, will try that.
I have tried setting that var from playbook, but that didn't work (maybe because of variable precedence). Haven't thought to set it from command line though.
I suppose the issue can be closed since this is unrelated to the ansible-oracle-modules