[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 […]
Sql Developer Export to Excel With One Line of Code
Sometimes you may need to get the results of the SQL query to a .csv file or an Excel file. Perhaps you want to open it in Excel and make some alterations or some calculations as Excel still offers more convenience compared to SQL, particularly for relatively smaller datasets, or may be you want to […]
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 Install Oracle Client on Linux Easily
In this article, we will show you how to easily “install Oracle Client on Linux” and configure it, so that you can connect to your Oracle database. Whether you are using a local Linux machine or a cloud server with a Linux version installed on it, you may need to connect to a remote Oracle […]
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 […]