Re: python for oracle 10g/12c
Jani Tiainen <[email protected]> Thu, 2 Mar 2017 11:49:27 +0200
| Newsgroups | gmane.comp.python.db.cx-oracle |
|---|---|
| Message-ID | <[email protected]> |
Hi, Having a CentOS is good, you can install rpm-packages and it should setup all your environment right so after installing instant client + sdk just reload/relogin and try to install cx_Oracle, it should work out of the box. On 02.03.2017 11:16, Venky 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 > > ------------------------------------------------------------------------------ > 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