Thread: [cx-oracle-users] python for oracle 10g/12c
Brought to you by:
atuining
Menu
▾
▴
cx-oracle-users
|
From: Venky <ven...@gm...> - 2017-02-27 16:12:23
|
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 |
|
From: Venky <ven...@gm...> - 2017-02-27 16:14:19
|
I need for linux support. On Mon, Feb 27, 2017 at 9:42 PM, Venky <ven...@gm...> 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 > |
|
From: Chris G. <chr...@to...> - 2017-02-27 16:22:56
|
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 <ven...@gm...> 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-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > > |
|
From: Anthony T. <ant...@gm...> - 2017-02-27 17:20:00
|
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 <chr...@to...> 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 <ven...@gm...> 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-...@li... >> 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-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > > |
|
From: Venky <ven...@gm...> - 2017-02-28 10:01:00
|
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 < ant...@gm...> 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 <chr...@to...> > 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 <ven...@gm...> 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-...@li... >>> 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-...@li... >> 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-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > > -- Hi ~Venky |
|
From: Jani T. <re...@gm...> - 2017-02-28 10:20:15
|
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 > <ant...@gm... <mailto:ant...@gm...>> 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 > <chr...@to... <mailto:chr...@to...>> 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 <ven...@gm... > <mailto:ven...@gm...>> 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-...@li... > <mailto:cx-...@li...> > 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-...@li... > <mailto:cx-...@li...> > 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-...@li... > <mailto:cx-...@li...> > 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-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users -- Jani Tiainen |
|
From: Venky <ven...@gm...> - 2017-03-01 12:28:05
|
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 <re...@gm...> 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 < > <ant...@gm...>ant...@gm...> 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 < <chr...@to...> >> chr...@to...> 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 < <ven...@gm...> >>> ven...@gm...> 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-...@li... >>>> 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-...@li... >>> 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-...@li... >> 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 lis...@li...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-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > > -- Hi ~Venky |
|
From: Jani T. <re...@gm...> - 2017-03-01 12:52:40
|
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 <re...@gm... > <mailto:re...@gm...>> 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 >> <ant...@gm... <mailto:ant...@gm...>> >> 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 >> <chr...@to... <mailto:chr...@to...>> >> 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 >> <ven...@gm... >> <mailto:ven...@gm...>> 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-...@li... >> <mailto:cx-...@li...> >> 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-...@li... >> <mailto:cx-...@li...> >> 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-...@li... >> <mailto:cx-...@li...> >> 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-...@li... >> <mailto:cx-...@li...> >> 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-...@li... > <mailto:cx-...@li...> > 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-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users -- Jani Tiainen |
|
From: Venky <ven...@gm...> - 2017-03-02 09:16:40
|
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 <re...@gm...> 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 <re...@gm...> 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 < >> ant...@gm...> 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 < >>> <chr...@to...>chr...@to...> 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 < <ven...@gm...> >>>> ven...@gm...> 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-...@li...>cx-...@li...urcefo >>>>> 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-...@li... >>>> 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-...@li... >>> 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 lis...@li...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-...@li... 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 lis...@li...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-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > > -- Hi ~Venky |
|
From: Venky <ven...@gm...> - 2017-03-02 10:30:57
|
So right now i have downloaded On Thu, Mar 2, 2017 at 2:46 PM, Venky <ven...@gm...> 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 <re...@gm...> 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 <re...@gm...> 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 < >>> ant...@gm...> 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 < >>>> <chr...@to...>chr...@to...> 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 < <ven...@gm...> >>>>> ven...@gm...> 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-...@li...>cx-...@li...urcefo >>>>>> 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-...@li... >>>>> 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-...@li... >>>> 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 lis...@li...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-...@li... >>> 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 lis...@li...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-...@li... >> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> >> > > > -- > Hi > > > ~Venky > -- Hi ~Venky |
|
From: Jani T. <re...@gm...> - 2017-03-02 09:49:38
|
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 <re...@gm... > <mailto:re...@gm...>> 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 <re...@gm... >> <mailto:re...@gm...>> 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 >>> <ant...@gm... >>> <mailto:ant...@gm...>> 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 >>> <chr...@to... >>> <mailto:chr...@to...>> 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 >>> <ven...@gm... >>> <mailto:ven...@gm...>> 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-...@li...urcefo >>> <mailto:cx-...@li...urcefo>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-...@li... >>> <mailto:cx-...@li...> >>> 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-...@li... >>> <mailto:cx-...@li...> >>> 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-...@li... >>> <mailto:cx-...@li...> >>> 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-...@li... >> <mailto:cx-...@li...> >> 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-...@li... >> <mailto:cx-...@li...> >> 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-...@li... > <mailto:cx-...@li...> > 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-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users -- Jani Tiainen |
|
From: Venky <ven...@gm...> - 2017-03-02 10:33:20
|
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 <ven...@gm...> 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 <re...@gm...> 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 <re...@gm...> 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 < >>> ant...@gm...> 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 < >>>> <chr...@to...>chr...@to...> 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 < <ven...@gm...> >>>>> ven...@gm...> 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-...@li...>cx-...@li...urcefo >>>>>> 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-...@li... >>>>> 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-...@li... >>>> 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 lis...@li...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-...@li... >>> 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 lis...@li...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-...@li... >> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> >> > > > -- > Hi > > > ~Venky > -- Hi ~Venky |
|
From: Jani T. <re...@gm...> - 2017-03-02 11:00:12
|
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 <ven...@gm... > <mailto:ven...@gm...>> 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 <re...@gm... > <mailto:re...@gm...>> 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 >> <re...@gm... <mailto:re...@gm...>> 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 >>> <ant...@gm... >>> <mailto:ant...@gm...>> 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 >>> <chr...@to... >>> <mailto:chr...@to...>> 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 >>> <ven...@gm... >>> <mailto:ven...@gm...>> 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-...@li...urcefo >>> <mailto:cx-...@li...urcefo>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-...@li... >>> <mailto:cx-...@li...> >>> 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-...@li... >>> <mailto:cx-...@li...> >>> 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-...@li... >>> <mailto:cx-...@li...> >>> 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-...@li... >> <mailto:cx-...@li...> >> 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-...@li... >> <mailto:cx-...@li...> >> 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-...@li... > <mailto:cx-...@li...> > 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-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users -- Jani Tiainen |
|
From: Venky <ven...@gm...> - 2017-03-02 11:00:20
|
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 <ven...@gm...> 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 <ven...@gm...> 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 <re...@gm...> 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 <re...@gm...> 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 < >>>> ant...@gm...> 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 < >>>>> <chr...@to...>chr...@to...> 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 < <ven...@gm...> >>>>>> ven...@gm...> 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-...@li...> >>>>>>> cx-...@li... >>>>>>> <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-...@li... >>>>>> 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-...@li... >>>>> 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 lis...@li...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-...@li... >>>> 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 lis...@li...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-...@li... >>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >>> >>> >> >> >> -- >> Hi >> >> >> ~Venky >> > > > > -- > Hi > > > ~Venky > -- Hi ~Venky |
|
From: Chris G. <chr...@to...> - 2017-03-02 12:32:40
|
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 <ven...@gm...> 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 <ven...@gm...> 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 <ven...@gm...> 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 <re...@gm...> 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 <re...@gm...> >>>> 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 < >>>>> ant...@gm...> 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 < >>>>>> <chr...@to...>chr...@to...> 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 < <ven...@gm...> >>>>>>> ven...@gm...> 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-...@li...> >>>>>>>> cx-...@li... >>>>>>>> <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-...@li... >>>>>>> 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-...@li... >>>>>> 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 lis...@li...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-...@li... >>>>> 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 lis...@li...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-...@li... >>>> 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-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > > |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X