Re: python for oracle 10g/12c
Jani Tiainen <[email protected]> Wed, 1 Mar 2017 14:52:30 +0200
| Newsgroups | gmane.comp.python.db.cx-oracle |
|---|---|
| Message-ID | <[email protected]> |
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] > <mailto:[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] <mailto:[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] <mailto:[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] >> <mailto:[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 >> _______________________________________________ >> cx-oracle-users mailing list >> cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org >> <mailto: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 >> _______________________________________________ >> cx-oracle-users mailing list >> cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org >> <mailto: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 >> _______________________________________________ >> cx-oracle-users mailing list >> cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org >> <mailto: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> >> >> >> >> >> -- >> 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 >> <mailto: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> > > -- > 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 > <mailto: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> > > -- > 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 -- 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