[6 Lines Of Code] How To Connect Oracle Database In Python
Oracle is generous to give everyone a full cloud database for free. I am frequently using this database because Oracle SQL is really a powerful tool for data analysis. Currently, I create many CSV files, from webscraping, financial data from APIs, etc.. So, a connection between Python and Oracle database is an absolute requirement for […]
cx_Oracle.DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: “libclntsh.so: cannot open shared object file: No such file or directory”
I have Python script which inserts certain data to an Oracle Autonomous Database. I order to connect to the Oracle Database, I am using cx_Oracle module. When I run this script directly, there is no problem. However, when I tried to run a crontab it threw this error: A similar question is asked here. The […]
How To Fix “cx_oracle Database Error ORA-12547: TNS: Lost Contact”
cx_Oracle is a Python extension module that provides access to Oracle Database from your Python application. You can connect your Python application to an Oracle Database. However, I’ve recently encountered ORA-12547: TNS: lost contact error while connecting to Oracle Autonomous Database. In this post, I’m going to show you how to fix ORA-12547: TNS: lost contact […]