Re: python for oracle 10g/12c
Venky <[email protected]> Thu, 2 Mar 2017 16:00:48 +0530
| Newsgroups | gmane.comp.python.db.cx-oracle |
|---|---|
| Message-ID | <CAFm3R6kytYq6XOM-Y8x394VEnrzQNLXq8OC-sBAUnjnZHDQ2Wg@mail.gmail.com> |
So right now i have downloaded 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>[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 > -- 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