python - cx_Oracle does not recognize location of Oracle software installation for installation on Linux -

-

i have been able install cx_oracle use python 3.4 on windows 8 laptop, , trying same setup (cx_oracle python 3.4) onto linux machine. when running setup.py file cx_oracle-5.1.3.tar.gz, end error:

    sudo python3 setup.py install     traceback (most recent call last):        file "setup.py", line 135, in <module>           raise distutilssetuperror("cannot locate oracle software " \     distutils.errors.distutilssetuperror: cannot locate oracle software installation

following other answers looked @ (easy_install cx_oracle (python package) on windows, https://gist.github.com/jarshwah/3863378) have installed these 3 instant client rpms:

rpm -ivh oracle-instantclient12.1-basic-12.1.0.2.0-1.i386.rpm rpm -ivh oracle-instantclient12.1-devel-12.1.0.2.0-1.i386.rpm rpm -ivh oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.i386.rpm

and set oracle_home folder installed to, supposed python identify location of oracle files can installation properly.

i still same "cannot locate oracle software installation" error each time try run setup.py file.

any idea need able install cx_oracle?

update more info:

echo $oracle_home returns /instantclient_12_1, rpm files installed to.

this contents of /instantclient_12_1 directory:

adrci                  libnnz12.so       libsqlplusic.so  tnsnames.ora basic_readme           libocci.so        libsqlplus.so    tnsnames.ora_andy genezi                 libocci.so.12.1   ojdbc6.jar       uidrvci glogin.sql             libociei.so       ojdbc7.jar       xstreams.jar libclntshcore.so.12.1  libocijdbc12.so   sdk libclntsh.so           libons.so         sqlplus libclntsh.so.12.1      liboramysql12.so  sqlplus_readme

this bit different directory have windows 8 install - 1 has .dll , .sym files, orasql12.dll. should linux version of instant client install have different files?

update partial solution:

i found solution installed cx_oracle properly, during shell instance:

i set these 2 environment variables:

export oracle_home=/instantclient_12_1 export ld_library_path=$ld_library_path:$oracle_home

and created symbolic link:

ln -s libclntsh.so.12.1 libclntsh.so

after that, going cx_oracle folder , doing worked:

python3 setup.py build python3 setup.py install

for reason, sudo python3 setup.py install did not work this.

update link related question:

my next problem getting environment variables persist outside of shell instance don't have define environment variables each time. environment variables put in profile.d show when echo them, python fails import cx_oracle properly, , have export environment variables again reason. don't know proper procedure posting different question related one, opened new question here:

linux profile.d environment variables don't work cx_oracle in python

please me out this, feel stuck on try make work. environment variables show when echo them, seem functional if export them again before running python code.

updated

as petriborg suggested, setting ld_run_path @ build time include path oracle shared library files in cx_oracle shared library built during installation. obviates need ld_library_path suggested in first answer.

for rpms using, oracle_home should set /usr/lib/oracle/12.1/client. if using pip:

$ export oracle_home=/usr/lib/oracle/12.1/client $ export ld_run_path=/usr/lib/oracle/12.1/client/lib:$ld_run_path $ pip install cx_oracle $ python -c 'import cx_oracle; print(cx_oracle.version)' 5.1.3

read documentation info on installing , executing applications use client libraries.


Comments

Post a Comment

Popular posts from this blog

PHP DOM loadHTML() method unusual warning -

-
i had following code works fine on localhost: $document = new domdocument(); $document->loadhtml($p_result); $form = $document->getelementsbytagname('form')->item(0); // code continues using $form variable after same code updated on outside server, loadhtml() failed , issued warning. warning: domdocument::loadhtml() expects parameter 1 valid path, string given in path/name/to/script.php returned null instead of object code pretty gets fatal error. note contents of $p_result absolutely same on outside server , on localhost. but why displays kind of warning , why not work? doesn't loadhtml() expects argument 1 string in first place? why method expects parameter 1 valid path ? just make clear i'm not calling loadhtmlfile() , i'm calling loadhtml() . thanks. you're affected one of php bugs . issue present in php 5.6.8 , 5.6.9. have affected php version on server, , bug-free version on localhost. the bug forbids null
Read more

python - How to create jsonb index using GIN on SQLAlchemy? -

-
here's current code creating index jsonb. index("mytable_data_idx_id_key", mytable.data['id'].astext, postgresql_using='gin') but got error. sqlalchemy.exc.programmingerror: (psycopg2.programmingerror) data type text has no default operator class access method "gin" hint: must specify operator class index or define default operator class data type. [sql: "create index event_data_idx_id_key on event using gin ((data ->> 'id'))"] is there way create index on sqlalchemy? the postgresql specific sqlalchemy docs @ http://docs.sqlalchemy.org/en/latest/dialects/postgresql.html#operator-classes mention postgresql_ops dictionary provide "operator class" used postgresql, , provide example illustrating use: index('my_index', my_table.c.id, my_table.c.data, postgresql_ops={ 'data': 'text_pattern_ops',
Read more

c# - TransactionScope not rolling back although no complete() is called -

-
i'm using transactionscope rollback transaction fail bool errorreported = false; action<importerrorlog> newerrorcallback = e => { errorreported = true; errorcallback(e); }; using (var transaction = new transactionscope()) { foreach (importtaskdefinition task in taskdefinition) { loader.load(streamfile, newerrorcallback, task.destinationtable, processingtaskid); } if (!errorreported) transaction.complete(); } i'm sure there no transactionscope started ahead or after code. i'm using entity framework insert in db. regardless state of errorreported transaction never rolled in case of error. what missing ? transactionscope sets transaction.current . that's does. wants transacted must @ property. i believe ef each time connection opened reason. probably, connection open when scope installed. open connection inside of scope or enlist manually. ef has nasty "design decision": default opens
Read more