Path: csiph.com!fu-berlin.de!uni-berlin.de!not-for-mail
From: "Dr. Volker Jaenisch" <volker.jaenisch@inqbus.de>
Newsgroups: de.comp.lang.python
Subject: Re: [Python-de] Oracle ansprechend
Date: Tue, 28 Mar 2017 14:50:22 +0200
Lines: 58
Message-ID: <mailman.102.1490705434.2634.python-de@python.org>
References: <d96551a8-7391-6417-6b48-9eac69c8bde5@thomas-guettler.de> <2b817542-217c-e6da-4b7e-770db667d2ec@inqbus.de>
Mime-Version: 1.0
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
X-Trace: news.uni-berlin.de w0Sv5VPlIyy1u9NsEKOYQQuJJWN30wo56TGeVR5XJn3Q==
Return-Path: <volker.jaenisch@inqbus.de>
X-Original-To: python-de@python.org
Delivered-To: python-de@mail.python.org
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=inqbus.de; s=20160215; h=Content-Transfer-Encoding:Content-Type:In-Reply-To: MIME-Version:Date:Message-ID:From:References:To:Subject:Sender:Reply-To:Cc: Content-ID:Content-Description:Resent-Date:Resent-From:Resent-Sender: Resent-To:Resent-Cc:Resent-Message-ID:List-Id:List-Help:List-Unsubscribe: List-Subscribe:List-Post:List-Owner:List-Archive; bh=JUTYZjdxPA5KRJ69PY0I7gKJ+jEhS76anVOlQrZfYBY=; b=B6hILYCW4dQF2m4fDYO3NRoxwX F930d1qhjficzTkS/JcpEH2pV6J9S5S1303+VxFxY/1bXw5R78OSZ8sHdb98AABhHBWqcpoi1y313 fI1iIovLGp9PUjznTBR05XI5dw1rxDMTZajsBylDdiJpeKp8Q5KjLKa3PQFwZrw0ZJbM=;
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Icedove/45.6.0
In-Reply-To: <d96551a8-7391-6417-6b48-9eac69c8bde5@thomas-guettler.de>
X-BeenThere: python-de@python.org
X-Mailman-Version: 2.1.23
Precedence: list
List-Id: Die Deutsche Python Mailingliste <python-de.python.org>
List-Unsubscribe: <https://mail.python.org/mailman/options/python-de>, <mailto:python-de-request@python.org?subject=unsubscribe>
List-Archive: <http://mail.python.org/pipermail/python-de/>
List-Post: <mailto:python-de@python.org>
List-Help: <mailto:python-de-request@python.org?subject=help>
List-Subscribe: <https://mail.python.org/mailman/listinfo/python-de>, <mailto:python-de-request@python.org?subject=subscribe>
X-Mailman-Original-Message-ID: <2b817542-217c-e6da-4b7e-770db667d2ec@inqbus.de>
X-Mailman-Original-References: <d96551a8-7391-6417-6b48-9eac69c8bde5@thomas-guettler.de>
Xref: csiph.com de.comp.lang.python:4725

Servus Thomas!


Am 28.03.2017 um 13:49 schrieb Thomas G=FCttler:
> Hallo,
>
> seit Jahren arbeite ich PostgreSQL und da bin ich nun etwas verw=F6hnt.=

> Der psycopg2 Adapter ist =FCberall verf=FCgbar.
>
> Aber nun soll ich mich mit Oracle verbinden. Ich bekommt diese Meldung:=

>
> (oracle-test)foo@host:~/tmp/oracle-test> pip install cx_Oracle
> Collecting cx-Oracle
>   Using cached cx_Oracle-5.3.tar.gz
>     Complete output from command python setup.py egg_info:
>     Traceback (most recent call last):
>       File "<string>", line 20, in <module>
>       File "/home/pypi/tmp/pip-build-aJfsPO/cx-Oracle/setup.py", line
> 174, in <module>
>         raise DistutilsSetupError("cannot locate an Oracle software " \=

>     distutils.errors.DistutilsSetupError: cannot locate an Oracle
> software installation
Ja Oracle ist ein Krampf!

Ich habe Oracle den Instant-Client genommen:

http://www.oracle.com/technetwork/database/features/instant-client/index-=
097480.html

Dabei ist wichtig den Richtigen f=FCr die richtige DB-Version zu finden.
Die sind zwar abw=E4rtskompatibel aber nur bedingt weit.

Dann m=FCssen diese beiden Umgebungs-Variablen gesetzt werden:

export LD_LIBRARY_PATH=3D/opt/oracle/instantclient_10_2:$LD_LIBRARY_PATH
export PATH=3D/opt/oracle/instantclient_10_2:$PATH

Danach sollte cx-oracle =FCber pip installierbar sein.

Beste Gr=FC=DFe

Volker

--=20
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D
   inqbus Scientific Computing    Dr.  Volker Jaenisch
   Richard-Strauss-Stra=DFe 1       +49(08861) 690 474 0
   86956 Schongau-West            http://www.inqbus.de
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D