import cx_OracleĬon1 = cx_nnect(p_username, p_password, p_service) I can now easily switch to another ATP/ADW Database, in the same Python program, by changing the value of os.environ and opening a new connection.

P_username = ''p_password = ''p_service = 'atp_high'Ĭon = cx_nnect(p_username, p_password, p_service) Os.environ = '/Users/brendan.tierney/Dropbox/wallet_ATP'

This is a temporary assignment and over rides the TNS_ADMIN environment variable. This allows you to reassign the TNS_ADMIN environment variable to point to a new directory containing the TNSNAMES file. The question is how can you switch between ATP/ADW Database using different TNSNAMES files while inside one Python program? In most cases you need to switch between different database connections and hence need to use multiple TNSNAMES files. This will allow Python and cx_Oracle library to automatically pick up this file and you can connect to the ATP/ADW Database.īut most people don’t work with just a single database or use a single TNSNAMES file. To use the download TNSNAME file you will need to set the TNS_ADMIN environment variable. Sometimes these can be combined into one TNSNAMES file. Most people end up working with multiple database. You can download the Wallet file from the Database console on Oracle Cloud. The Wallet is used to create a secure connection to the Autonomous Database. Instead you have the name of the Autonomous Database. This file contains some of the connection details, but you don’t have access to ServiceName/SID, HostName, etc. With the Autonomous Oracle Database (ADW or ATP) you will need to use an Oracle Wallet file.

In that blog post I gave examples of connecting to an Oracle Database using the HostName (or IP address), the Service Name or the SID.īut with the Autonomous Oracle Database things are a little bit different. Check out that post for details of how to setup Oracle Client and the Oracle Python library cx_Oracle. I’ve previously written about connecting to an Oracle Database using Python. More and more people are using the FREE Oracle Autonomous Database for building new new applications, or are migrating to it. Posted on JanuUpdated on January 21, 2020 Python-Connecting to multiple Oracle Autonomous DBs in one program

Python connect to oracle database