Re: python for oracle 10g/12c
Venky <[email protected]> Thu, 2 Mar 2017 16:30:11 +0530
| Newsgroups | gmane.comp.python.db.cx-oracle |
|---|---|
| Message-ID | <CAFm3R6=+bXFX_doCCk9bgArNWpmAGRus-=3ZA16amk5ZWyozJQ@mail.gmail.com> |
Also the python i have is 2.7.5 Anticipate your quick help on this. On Thu, Mar 2, 2017 at 4:03 PM, Venky <[email protected]> wrote: > Sorry for spam abt last email. > > Right now i have downloaded below files: > > file:///Users/Venky/Downloads/oracle-instantclient12.2- > devel-12.2.0.1.0-1.x86_64.rpm > file:///Users/Venky/Downloads/oracle-instantclient12.2- > sqlplus-12.2.0.1.0-1.x86_64.rpm > file:///Users/Venky/Downloads/oracle-instantclient12.2- > basic-12.2.0.1.0-1.x86_64.rpm > > What else i need to download for the linux version mentioned in last email. > > Regards, > Venky > > On Thu, Mar 2, 2017 at 2:46 PM, Venky <[email protected]> wrote: > >> 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> >>>>>>> cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org >>>>>>> <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 >> > > > > -- > Hi > > > ~Venky > -- 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