Oracle instant client binaries to be used together with cx_Oracle.
Project description
PyOracleClient ![](https://pypi-camo.freetls.fastly.net/59ecf4c8e6ec054bcd6aff69ea17b7e687403e84/68747470733a2f2f6769746875622e636f6d2f4c7563614d696e676172656c6c692f50794f7261636c65436c69656e742f7261772f6d61737465722f70796f7261636c65636c69656e742f7265732f69636f6e2e706e67)
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
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for PyOracleClient-0.1.40-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 14790ef8888f74cbe03822f8cb72e1504c763e5ab59e2f2923a4ae65c4888036 |
|
MD5 | 47cd03f427d781b7dde61a5b0e273446 |
|
BLAKE2b-256 | 7ad80dac27500c70cb9f791fd8facd33b16715bf077b6111d7138106094345ff |