Re: python for oracle 10g/12c

Right now i have below linux where i will have my python code to connect to
oracle 10g and 12c residing on some other linux machine with below version.

uname -a

Linux localhost.localdomain 3.10.0-327.el7.x86_64 #1 SMP Thu Nov 19
22:10:57 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux

cat /etc/centos-release

CentOS Linux release 7.2.1511 (Core)



On Wed, Mar 1, 2017 at 6:22 PM, Jani Tiainen <[email protected]> wrote:

> Oracle Instant Client and SDK can be obtained from Oracle site:
>
> http://www.oracle.com/technetwork/database/features/
> instant-client/index-097480.html
>
> Note that you have to register yourself before downloading.
>
> Depending on your operating system what else you need varies.
>
>
>
> On 01.03.2017 14:27, Venky wrote:
>
> Thanks for clarifying the details.
>
> So can you please help me with the location from where i can get all the
> ones you mentioned ( like Instant Client, Instant Client SDK,
>  cx_Oracle,etc) so that i would be able to connect to oracle 10g/12c
> using python once i installed it.
>
>
>
> On Tue, Feb 28, 2017 at 3:50 PM, Jani Tiainen <[email protected]> wrote:
>
>> Instant Client is set of OCI libraries that are used to communicate to
>> Oracle database.
>>
>> And they are required, it's also required to have Instant Client SDK
>> files for compilation, and libaio1 installed from system packages.
>> cx_Oracle itself merely contains just bindings to communicate from Python
>> to Oracle through OCI libraries (Instant Client) and do some conversions
>> for certain datatypes.
>>
>>
>>
>> On 28.02.2017 12:00, Venky wrote:
>>
>> Thanks for the quick reply.
>>
>> Few queries, since i am a starter, what are InstantClient files? Is this
>> compulsory?
>>
>> Also installing "pip install cx_Oracle" on my linux box will install the
>> latest Oracle driver and does this has the support for which i was
>> asking?
>> Anything else i need to install as part of this cx_Oracle?
>>
>>
>> ~Venky
>>
>> On Mon, Feb 27, 2017 at 10:49 PM, Anthony Tuininga <
>> [email protected]> wrote:
>>
>>> If you use the Oracle 12c Release 1 instant client you can access an
>>> Oracle 10g Release 2 or higher database. Anything earlier than that would
>>> require the use of the Oracle 11g Release 2 instant client instead. Since
>>> Oracle 10g Release 1 is no longer supported the use of the Oracle 12c
>>> Release 1 instant client should work perfectly for you.
>>>
>>> Anthony
>>>
>>> On Mon, Feb 27, 2017 at 9:22 AM, Chris Gould <
>>> <[email protected]>[email protected]> wrote:
>>>
>>>> If you use the Oracle 12c driver (and the 12c InstantClient files) it
>>>> should be backward compatible with earlier versions of the database.
>>>>
>>>>
>>>> On 27 February 2017 at 16:12, Venky < <[email protected]>
>>>> [email protected]> wrote:
>>>>
>>>>> Hi Folks,
>>>>>
>>>>> Need you help. I wanted to automate few things for Oracle 10g using
>>>>> python.
>>>>>
>>>>> So can you guys, help me locate the library for the same. Also, in
>>>>> near future would be working on the same but with Oracle 12c.
>>>>>
>>>>> So do we have a single oracle lib for python which can work for all
>>>>> oracle versions or do we have lib for oracle specific to versions?
>>>>>
>>>>> Anticipating your quick reply.
>>>>>
>>>>>
>>>>> ~Venky
>>>>>
>>>>> ------------------------------------------------------------
>>>>> ------------------
>>>>> Check out the vibrant tech community on one of the world's most
>>>>> engaging tech sites, SlashDot.org! <http://sdm.link/slashdot>
>>>>> http://sdm.link/slashdot
>>>>> _______________________________________________
>>>>> cx-oracle-users mailing list
>>>>> <cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org>[email protected]
>>>>> rge.net
>>>>> <https://lists.sourceforge.net/lists/listinfo/cx-oracle-users>
>>>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>>>>
>>>>>
>>>>
>>>> ------------------------------------------------------------
>>>> ------------------
>>>> Check out the vibrant tech community on one of the world's most
>>>> engaging tech sites, SlashDot.org! <http://sdm.link/slashdot>
>>>> http://sdm.link/slashdot
>>>> _______________________________________________
>>>> cx-oracle-users mailing list
>>>> cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
>>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>>>
>>>>
>>>
>>> ------------------------------------------------------------
>>> ------------------
>>> Check out the vibrant tech community on one of the world's most
>>> engaging tech sites, SlashDot.org! <http://sdm.link/slashdot>
>>> http://sdm.link/slashdot
>>> _______________________________________________
>>> cx-oracle-users mailing list
>>> cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>>
>>>
>>
>>
>> --
>> Hi
>>
>>
>> ~Venky
>>
>>
>> ------------------------------------------------------------------------------
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
>>
>> _______________________________________________
>> cx-oracle-users mailing listcx-oracle-users-5NWGOfrQmneRv+LV9MX5ugtCRVl27V+i0wdF1cv0I5s@public.gmane.org://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>
>> --
>> Jani Tiainen
>>
>> ------------------------------------------------------------------------------
>> Check out the vibrant tech community on one of the world's most engaging
>> tech sites, SlashDot.org! http://sdm.link/slashdot
>> _______________________________________________ cx-oracle-users mailing
>> list cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org https://lists.sourceforge.net/
>> lists/listinfo/cx-oracle-users
>
> --
> Hi ~Venky
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
>
> _______________________________________________
> cx-oracle-users mailing listcx-oracle-users-5NWGOfrQmneRv+LV9MX5ugtCRVl27V+i0wdF1cv0I5s@public.gmane.org://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
> --
> Jani Tiainen
>
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> _______________________________________________
> cx-oracle-users mailing list
> cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>


-- 
Hi


~Venky

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot

_______________________________________________
cx-oracle-users mailing list
cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users