Re: python for oracle 10g/12c
Chris Gould <[email protected]> Thu, 2 Mar 2017 12:32:12 +0000
| Newsgroups | gmane.comp.python.db.cx-oracle |
|---|---|
| Message-ID | <CA+UgK-F1kS6hrnCoPRB7JKjSVZHQTb16WBxG8fS1DJvCCPFf+Q@mail.gmail.com> |
I think you should have a go at working it out for yourself! There's plenty of information out there. It's a bit cheeky to expect people here to take you through everything step-by-step. Chris. On 2 March 2017 at 11:00, Venky <[email protected]> wrote: > 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-sqlpl >> us-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 > > ------------------------------------------------------------------------------ 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