PyOracleClient

About

This package provides access to Oracle Instant Client's binaries, necessary to connect to Oracle databases with cx_Oracle.

Installation

You can install with pip as:

pip install pyoracleclient

Example

After installation you want to download the oracle instant client: you can do this via the following:

import pyoracleclient as pyoc

pyoc.get_client(version='19.3.0.0.0', sys='linux', url=None)

By default version 19.3 for linux 64bits is downloaded. To obtain a client for a different system provide the corresponding url instead. Visit 'https://www.oracle.com/database/technologies/instant-client/downloads.html', choose your version, and copy the download link. For example for version 19.3.0.0.0 linux 64b, this will be in the form: https://download.oracle.com/otn_software/linux/instantclient/193000/instantclient-basic-linux.x64-19.3.0.0.0dbru.zip.

You can now add tns names via the pyoracleclient.add_tns function as shown below.

import pyoracleclient as pyoc

pyoc._delete_all_tns()

pyoc.add_tns(name='FSSDB', service_name='servicename.prd.tns',
             protocol1='TCP', host1='host1address', port1=1000,
             protocol2='TCP', host2='host1address', port2=1000)

Alternatively you can append your own tns specification as a string as follows:

import pyoracleclient as pyoc

pyoc.add_custom_tns("""yourtnsname = (DESCRIPTION=
                    (ADDRESS_LIST=(FAILOVER=ON)
                                  (LOAD_BALANCE = OFF)
                                  (ADDRESS=(PROTOCOL=TCP)
                                           (HOST=host1address)
                                           (PORT=1000))
                                  (ADDRESS=(PROTOCOL=TCP)
                                           (HOST=host1address)
                                           (PORT=1000)))
                                  (CONNECT_DATA=(SERVER=dedicated)
                                  (SERVICE_NAME=servicename.prd.tns)))
                    """)

Finally, you can also fill the tnsnames.ora file manually. Its location can be found in the variable pyoracleclient._TNSORA_PATH.

Author

Luca Mingarelli, 2020

You find this work useful?