I have installed the python Oracle module cx_Oracle on my Linux machine. The oracle user and root user can both import cx_Oracle and create a database connection using cx_Oracle.Connection(...).
Other users on the server can also import cx_Oracle but when they try to create a connection object the following exception is thrown:
>>> cx_Oracle.Connection('....')
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
cx_Oracle.InternalError: No Oracle error?
I have confirmed that the user I am trying to get to work has all the correct system variables set, ORACLE_HOME, LD_LIBRARY_PATH, ORACLE_SID and PATH. This user also has no problem using sqlplus and connecting to databases that way.
I assume this is a file permissions problem since both the oracle and root users have no problems. I am just not sure which file could be causing the issue.
Copyright Notice:Content Author:「user1042361」,Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/12482299/cx-oracle-connection-throws-cx-oracle-internalerror-no-oracle-error