Re: python for oracle 10g/12c
Jani Tiainen <[email protected]> Thu, 2 Mar 2017 13:00:01 +0200
| Newsgroups | gmane.comp.python.db.cx-oracle |
|---|---|
| Message-ID | <[email protected]> |
Nothing. That should get you going just fine. (check that libaio1 is installed after installing basic rpm) also python-dev package is required to compile cx_oracle. On 02.03.2017 12:33, Venky 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] > <mailto:[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] > <mailto:[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 > <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 >>> [email protected] >>> <mailto:[email protected]>rge.net >>> <http://rge.net> >>> 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 >> <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 > > -- > 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