cx-oracle-users Mailing List for cx_Oracle (Page 6)
Brought to you by:
atuining
Menu
▾
▴
cx-oracle-users — Primary discussion list for users (and developers) of cx_Oracle
You can subscribe to this list here.
| 2003 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(5) |
Aug
(9) |
Sep
(8) |
Oct
(12) |
Nov
(4) |
Dec
(8) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2004 |
Jan
(15) |
Feb
(12) |
Mar
(11) |
Apr
(5) |
May
(7) |
Jun
(8) |
Jul
(12) |
Aug
(2) |
Sep
(14) |
Oct
(17) |
Nov
(20) |
Dec
(3) |
| 2005 |
Jan
(16) |
Feb
(9) |
Mar
(22) |
Apr
(21) |
May
(73) |
Jun
(16) |
Jul
(15) |
Aug
(10) |
Sep
(32) |
Oct
(35) |
Nov
(22) |
Dec
(13) |
| 2006 |
Jan
(42) |
Feb
(36) |
Mar
(13) |
Apr
(18) |
May
(8) |
Jun
(17) |
Jul
(24) |
Aug
(30) |
Sep
(35) |
Oct
(33) |
Nov
(33) |
Dec
(11) |
| 2007 |
Jan
(35) |
Feb
(31) |
Mar
(35) |
Apr
(64) |
May
(38) |
Jun
(12) |
Jul
(18) |
Aug
(34) |
Sep
(75) |
Oct
(29) |
Nov
(51) |
Dec
(11) |
| 2008 |
Jan
(27) |
Feb
(46) |
Mar
(48) |
Apr
(36) |
May
(59) |
Jun
(42) |
Jul
(25) |
Aug
(34) |
Sep
(57) |
Oct
(97) |
Nov
(59) |
Dec
(57) |
| 2009 |
Jan
(48) |
Feb
(48) |
Mar
(45) |
Apr
(24) |
May
(46) |
Jun
(52) |
Jul
(52) |
Aug
(37) |
Sep
(27) |
Oct
(40) |
Nov
(37) |
Dec
(13) |
| 2010 |
Jan
(16) |
Feb
(9) |
Mar
(24) |
Apr
(6) |
May
(27) |
Jun
(28) |
Jul
(60) |
Aug
(16) |
Sep
(33) |
Oct
(20) |
Nov
(39) |
Dec
(30) |
| 2011 |
Jan
(23) |
Feb
(43) |
Mar
(16) |
Apr
(29) |
May
(23) |
Jun
(16) |
Jul
(10) |
Aug
(8) |
Sep
(18) |
Oct
(42) |
Nov
(26) |
Dec
(20) |
| 2012 |
Jan
(17) |
Feb
(27) |
Mar
|
Apr
(20) |
May
(18) |
Jun
(7) |
Jul
(24) |
Aug
(21) |
Sep
(23) |
Oct
(18) |
Nov
(12) |
Dec
(5) |
| 2013 |
Jan
(14) |
Feb
(10) |
Mar
(20) |
Apr
(65) |
May
(3) |
Jun
(8) |
Jul
(6) |
Aug
(3) |
Sep
|
Oct
(3) |
Nov
(28) |
Dec
(3) |
| 2014 |
Jan
(3) |
Feb
(9) |
Mar
(4) |
Apr
(7) |
May
(20) |
Jun
(2) |
Jul
(20) |
Aug
(7) |
Sep
(11) |
Oct
(8) |
Nov
(6) |
Dec
(12) |
| 2015 |
Jan
(16) |
Feb
(10) |
Mar
(14) |
Apr
(8) |
May
|
Jun
(8) |
Jul
(15) |
Aug
(7) |
Sep
(1) |
Oct
(33) |
Nov
(8) |
Dec
(5) |
| 2016 |
Jan
(18) |
Feb
(12) |
Mar
(6) |
Apr
(14) |
May
(5) |
Jun
(3) |
Jul
|
Aug
(21) |
Sep
|
Oct
(15) |
Nov
(8) |
Dec
|
| 2017 |
Jan
|
Feb
(14) |
Mar
(21) |
Apr
(9) |
May
(6) |
Jun
(11) |
Jul
(23) |
Aug
(6) |
Sep
(5) |
Oct
(7) |
Nov
(1) |
Dec
(1) |
| 2018 |
Jan
|
Feb
|
Mar
(16) |
Apr
(2) |
May
(1) |
Jun
|
Jul
(2) |
Aug
|
Sep
(2) |
Oct
|
Nov
|
Dec
|
| 2019 |
Jan
(2) |
Feb
(3) |
Mar
(1) |
Apr
(1) |
May
|
Jun
|
Jul
(2) |
Aug
(1) |
Sep
(2) |
Oct
|
Nov
|
Dec
(1) |
| 2020 |
Jan
|
Feb
(4) |
Mar
|
Apr
|
May
(2) |
Jun
(1) |
Jul
(4) |
Aug
|
Sep
(1) |
Oct
|
Nov
|
Dec
(3) |
| 2021 |
Jan
|
Feb
(5) |
Mar
|
Apr
(7) |
May
(6) |
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(1) |
Dec
|
| 2022 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2023 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: M.M.Rashid (Rubel) <mm...@gm...> - 2017-05-16 13:37:02
|
Dear All,
Due to in house python distribution which was compiled in MSC++ v2010, I
had to compile cx_Oracle with the same version. In doing so, I am having
two issues:
- If I compile in DEBUG mode, I get this error:
* LINK : fatal error LNK1104: cannot open file 'python27_d.lib'*
in my python instillation, I only have release library -
python27.lib
- So, I tried to compile in Release mode and this time it links fine. I
got the cx_oracle.pyd. Copying the pyd in sys.path and then trying to
import gives this error:
*Python 2.7.11 (default, Mar 10 2016, 10:58:13) [MSC v.1600 64 bit (AMD64)]
on win32*
*Type "help", "copyright", "credits" or "license" for more information.*
*>>> import cx_Oracle*
*Traceback (most recent call last):*
* File "<stdin>", line 1, in <module>*
*ImportError: dynamic module does not define init function (initcx_Oracle)*
*>>>*
What steps am I missing here?
--
M. M. RASHID(Rubel)
Perth, Australia.
|
|
From: Anthony T. <ant...@gm...> - 2017-05-15 17:17:58
|
All, See here (https://github.com/oracle/python-cx_Oracle/issues/25) for plans regarding cx_Oracle 6. Please reply to this e-mail or provide feedback on the GitHub issue. Thanks! Anthony |
|
From: Anthony T. <ant...@gm...> - 2017-04-19 02:37:21
|
All,
The newly released 6.0 beta 1 is the first release that makes use of wheels
-- mostly thanks to ODPI-C which has the ability to build once and use with
any Oracle client libraries (so long as they are 11.2, 12.1 or 12.1, that
is!). So at long last you can do a pip install and get the right binary for
your platform (so long as it is Windows or Linux anyway!).
Anthony
On Tue, Apr 26, 2016 at 9:53 AM, Anthony Tuininga <
ant...@gm...> wrote:
> Thanks for these suggestions. It will take some time to consider which
> approach to take. I'll reply back again when I have a positive decision
> made.
>
> One concern that eliminates a few of these possibilities is portability.
> cx_Oracle runs on more than just Windows so Windows-specific code/concepts
> can't be used. Creating differently named modules (for client version) or
> creating a wrapper module that imports the right sub-module at run-time are
> the two top choices I am considering right now. If anyone else has any
> thoughts on which approach would be best to take, I'd love to hear from you.
>
> Anthony
>
> On Thu, Apr 21, 2016 at 7:24 PM, Kubo Takehiro <ku...@ji...> wrote:
>
>> Hi,
>>
>> I know a little about python and nothing about wheels.
>> However I have three ideas.
>>
>> 1. Distribute cx_Oracle compiled for Oracle 10g.
>>
>> Oracle client library ABI keeps backward compatibility on Windows.
>> When a binary file is compiled for Oracle 10g, it works with Oracle
>> 10g, 11g and 12c.
>> However it cannot use features depends on Oracle 11g and 12c clients.
>>
>> 2. Check Oracle client version at runtime.
>>
>> This is ideal for pre-compiled packages but not practical because this
>> needs
>> too many changes in cx_Oracle.
>>
>> Add the following code to Module_Initialize() in cx_Oracle.c
>>
>> HMODULE hMod = GetModuleHandle("OCI.DLL");
>> void (*func)(sword*, sword*, sword*, sword*, sword*) = (void
>> (*)(sword*, sword*, sword*, sword*, sword*))GetProcAddress(hMod,
>> "OCIClientVersion");
>> if (func == NULL) {
>> oracle_version_hex = ORACLE_VERSION(10, 1)
>> } else {
>> sword major, minor, update, patch, port;
>> (*func)(&major, &minor, &update, &patch, &port);
>> oracle_version_hex = ORACLE_VERSION(major, minor);
>> }
>>
>> and rewrite code such as
>> #if ORACLE_VERSION_HEX >= ORACLE_VERSION(11,1)
>> ...
>> #endif
>> to
>> if (oracle_client_hex >= ORACLE_VERSION(11,1)) {
>> ...
>> }
>>
>> Use function pointers retrieved by GetProcAddress() for functions
>> added in Oracle 11g and 12c,
>>
>> 3. Add a bootstrap module if wheels can include more than one module.
>>
>> Compile cx_Oracle for Oracle 10.1, 10.2, 11.1, 11.2 and 12.1 and rename
>> them
>> to cx_Oracle.10.1.dll, cx_Oracle.10.2.dll, cx_Oracle.11.1.dll,
>> cx_Oracle.11.2.dll and cx_Oracle.12.1.dll respectively.
>>
>> Compile the following code as cx_Oracle.dll.
>>
>> // This is incomplete code. no error checks.
>>
>> typedef int sword;
>>
>> static void *get_init_func(const char *init_func_name)
>> {
>> HMODULE hMod;
>> void (*func)(sword*, sword*, sword*, sword*, sword*);
>> char dll_name[30];
>> char dll_full_path[MAX_PATH];
>>
>> // Get the Oracle client version and fill dll_name.
>> hMod = LoadLibrary("OCI.DLL");
>> func = (void (*)(sword*, sword*, sword*, sword*,
>> sword*))GetProcAddress(hMod, "OCIClientVersion");
>> if (func == NULL) {
>> strcpy(dll_name, "cx_Oracle.10.1.dll");
>> } else {
>> sword major, minor, update, patch, port;
>> (*func)(&major, &minor, &update, &patch, &port);
>> sprintf(dll_name, "cx_Oracle.%d.%d.dll", major, minor);
>> }
>> FreeLibrary(hMod);
>>
>> // get the current module handle.
>> GetModuleHandleEx(GET_MODULE_HANDLE_EX_FLAG_FROM_ADDRESS,
>> &get_init_func, &hMod);
>> ... fill dll_full_path with the directory name containing the
>> current module by using GetModuleFileName(hMod, ...).
>> ... append dll_name to dll_full_path.
>>
>> // Load the real cx_Oracle module and get the module initializer
>> function.
>> hMod = LoadLibrary(dll_full_path);
>> return GetProcAddress(hMod, init_func_name);
>> }
>>
>> #if PY_MAJOR_VERSION >= 3
>> PyMODINIT_FUNC PyInit_cx_Oracle(void)
>> {
>> PyObject *(*init)(void) =
>> (PyObject*(*)(void))get_init_func("PyInit_cx_Oracle");
>> return (*init)();
>> }
>> #else
>> void initcx_Oracle(void)
>> {
>> void (*init)(void) = (void(*)(void))get_init_func("initcx_Oracle");
>> (*init)();
>> }
>> #endif
>>
>>
>> Put cx_Oracle.dll, cx_Oracle.10.1.dll, cx_Oracle.10.2.dll,
>> cx_Oracle.11.1.dll, cx_Oracle.11.2.dll
>> and cx_Oracle.12.1.dll in a directory.
>>
>> ------------------------------------------------------------
>> ------------------
>> Find and fix application performance issues faster with Applications
>> Manager
>> Applications Manager provides deep performance insights into multiple
>> tiers of
>> your business applications. It resolves application problems quickly and
>> reduces your MTTR. Get your free trial!
>> https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
>> _______________________________________________
>> cx-oracle-users mailing list
>> cx-...@li...
>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>
>
>
|
|
From: Anthony T. <ant...@gm...> - 2017-04-18 22:09:31
|
What is cx_Oracle? cx_Oracle is a Python extension module that enables access to Oracle Database for Python 2.x and 3.x and conforms to the Python database API 2.0 specifications with a number of enhancements. Where do I get it? https://oracle.github.io/python-cx_Oracle The easiest method to install cx_Oracle 6.0b1 is via pip as in python -m pip install cx_Oracle --pre Note that the --pre option is required since this is a prerelease. What's new? By far the most important update is the transition to ODPI-C ( https://github.com/oracle/odpi) which means that cx_Oracle can now be built without Oracle Client header files or libraries and that at runtime cx_Oracle can adapt to Oracle Client 11.2, 12.1 or 12.2 libraries without needing to be rebuilt. This also permits the use of binary wheels for the first time which will make installation much simpler than before. The full release notes can be read here: http://cx-oracle.readthedocs.io/en/6.0b1/releasenotes.html#version-6-0-beta-1-april-2017 Please provide any feedback via GitHub issues ( https://github.com/oracle/python-cx_Oracle/issues). |
|
From: Anthony T. <ant...@gm...> - 2017-04-14 18:57:13
|
Glad you got everything worked out. :-) On Fri, Apr 14, 2017 at 10:03 AM, Dominique DEXHEIMER < dom...@to...> wrote: > I have cx_Oracle operational on my machine. The only remaining action was > to set PATH via control panel as shown in the web page you indicated, > instead of DOS which apparently does not keep the changes (I may have > limited admin rights). > > > > Thank you very much for your support. > > > > Dominique > > > > *From:* Anthony Tuininga [mailto:ant...@gm...] > *Sent:* vendredi 14 avril 2017 17:03 > *To:* cx-...@li... > *Subject:* Re: [cx-oracle-users] DLL load failed > > > > Yes, installing Instant Client 12 will work for you. However, do not set > ORACLE_HOME. On Windows you should simply put the location of OCI.DLL in > your PATH environment variable. And in your case, ensure that it is before > your other Oracle installation. > > > > This link gives the information on which Oracle client and server > combinations are supported. It is part of the ODPI-C library which will be > the underlying library used as of cx_Oracle 6. > > > > https://oracle.github.io/odpi/doc/installation.html#oracle- > client-and-database-versions > > > > Anthony > > > > On Fri, Apr 14, 2017 at 1:48 AM, Dominique DEXHEIMER < > dom...@to...> wrote: > > dependencywalker helped pinpoint the sore muscle, which is finding > OCI.DLL. However it may just be a back compatibility issue. I have Oracle > Client 10.2 while the oldest version of cx_Oracle is 11g. I looked up > previous posts for compatibility issues, but could not find anything > helpful. > > > > My best bet is to install Instant Client 12 and give it precedence over > the other client installed by pointing ORACLE_HOME to it. > > > > Thanks and regards, > > Dominique > > > > *From:* Massa, Harald Armin [mailto:ch...@gh...] > *Sent:* jeudi 13 avril 2017 18:26 > *To:* cx-...@li... > *Subject:* Re: [cx-oracle-users] DLL load failed > > > > Hi, > > > > I have run the installer cx_Oracle-5.2.1-12c.win-amd64-py2.7.exe on a > Dell Precision T5610, running Windows7 64 bits, with apparent success: the > compiled file cx_Oracle.pyd is in place under the site-packages directory. > However, it seems that Python misses parts of the module (see session > below), even after appending a line to sys.path. Would there be another > module registration to write somewhere before running it ? > > > > >>> import cx_Oracle > > > > Traceback (most recent call last): > > File "<pyshell#0>", line 1, in <module> > > import cx_Oracle > > ImportError: DLL load failed: The specified module could not be found. > > >>> > > > > most likely you are missing the Oracle OCI libary in the fitting 12c > version. They have to be downloaded and licenced with Oracle. > > > > Make sure cx_Oracle is able to find them, usefull things are: > > - have the bin directory in your path > > - have the oracle environment variables set correctly. > > > > Usefull tool to diagnose: > > http://www.dependencywalker.com/ > > > > Cheers, > > > > Harald > > > > > > > > > > -- > > > > GHUM GmbH > Harald Armin Massa > Spielberger Straße 49 > 70435 Stuttgart > 0173/9409607 > > Amtsgericht Stuttgart, HRB 734971 > > > ------------------------------------------------------------ > ------------------ > 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: Dominique D. <dom...@to...> - 2017-04-14 16:03:54
|
I have cx_Oracle operational on my machine. The only remaining action was to set PATH via control panel as shown in the web page you indicated, instead of DOS which apparently does not keep the changes (I may have limited admin rights). Thank you very much for your support. Dominique From: Anthony Tuininga [mailto:ant...@gm...] Sent: vendredi 14 avril 2017 17:03 To: cx-...@li... Subject: Re: [cx-oracle-users] DLL load failed Yes, installing Instant Client 12 will work for you. However, do not set ORACLE_HOME. On Windows you should simply put the location of OCI.DLL in your PATH environment variable. And in your case, ensure that it is before your other Oracle installation. This link gives the information on which Oracle client and server combinations are supported. It is part of the ODPI-C library which will be the underlying library used as of cx_Oracle 6. https://oracle.github.io/odpi/doc/installation.html#oracle-client-and-database-versions Anthony On Fri, Apr 14, 2017 at 1:48 AM, Dominique DEXHEIMER <dom...@to...<mailto:dom...@to...>> wrote: dependencywalker helped pinpoint the sore muscle, which is finding OCI.DLL. However it may just be a back compatibility issue. I have Oracle Client 10.2 while the oldest version of cx_Oracle is 11g. I looked up previous posts for compatibility issues, but could not find anything helpful. My best bet is to install Instant Client 12 and give it precedence over the other client installed by pointing ORACLE_HOME to it. Thanks and regards, Dominique From: Massa, Harald Armin [mailto:ch...@gh...<mailto:ch...@gh...>] Sent: jeudi 13 avril 2017 18:26 To: cx-...@li...<mailto:cx-...@li...> Subject: Re: [cx-oracle-users] DLL load failed Hi, I have run the installer cx_Oracle-5.2.1-12c.win-amd64-py2.7.exe on a Dell Precision T5610, running Windows7 64 bits, with apparent success: the compiled file cx_Oracle.pyd is in place under the site-packages directory. However, it seems that Python misses parts of the module (see session below), even after appending a line to sys.path. Would there be another module registration to write somewhere before running it ? >>> import cx_Oracle Traceback (most recent call last): File "<pyshell#0>", line 1, in <module> import cx_Oracle ImportError: DLL load failed: The specified module could not be found. >>> most likely you are missing the Oracle OCI libary in the fitting 12c version. They have to be downloaded and licenced with Oracle. Make sure cx_Oracle is able to find them, usefull things are: - have the bin directory in your path - have the oracle environment variables set correctly. Usefull tool to diagnose: http://www.dependencywalker.com/ Cheers, Harald -- GHUM GmbH Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 Amtsgericht Stuttgart, HRB 734971 ------------------------------------------------------------------------------ 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 |
|
From: Anthony T. <ant...@gm...> - 2017-04-14 15:03:15
|
Yes, installing Instant Client 12 will work for you. However, do not set ORACLE_HOME. On Windows you should simply put the location of OCI.DLL in your PATH environment variable. And in your case, ensure that it is before your other Oracle installation. This link gives the information on which Oracle client and server combinations are supported. It is part of the ODPI-C library which will be the underlying library used as of cx_Oracle 6. https://oracle.github.io/odpi/doc/installation.html#oracle-client-and-database-versions Anthony On Fri, Apr 14, 2017 at 1:48 AM, Dominique DEXHEIMER < dom...@to...> wrote: > dependencywalker helped pinpoint the sore muscle, which is finding > OCI.DLL. However it may just be a back compatibility issue. I have Oracle > Client 10.2 while the oldest version of cx_Oracle is 11g. I looked up > previous posts for compatibility issues, but could not find anything > helpful. > > > > My best bet is to install Instant Client 12 and give it precedence over > the other client installed by pointing ORACLE_HOME to it. > > > > Thanks and regards, > > Dominique > > > > *From:* Massa, Harald Armin [mailto:ch...@gh...] > *Sent:* jeudi 13 avril 2017 18:26 > *To:* cx-...@li... > *Subject:* Re: [cx-oracle-users] DLL load failed > > > > Hi, > > > > I have run the installer cx_Oracle-5.2.1-12c.win-amd64-py2.7.exe on a > Dell Precision T5610, running Windows7 64 bits, with apparent success: the > compiled file cx_Oracle.pyd is in place under the site-packages directory. > However, it seems that Python misses parts of the module (see session > below), even after appending a line to sys.path. Would there be another > module registration to write somewhere before running it ? > > > > >>> import cx_Oracle > > > > Traceback (most recent call last): > > File "<pyshell#0>", line 1, in <module> > > import cx_Oracle > > ImportError: DLL load failed: The specified module could not be found. > > >>> > > > > most likely you are missing the Oracle OCI libary in the fitting 12c > version. They have to be downloaded and licenced with Oracle. > > > > Make sure cx_Oracle is able to find them, usefull things are: > > - have the bin directory in your path > > - have the oracle environment variables set correctly. > > > > Usefull tool to diagnose: > > http://www.dependencywalker.com/ > > > > Cheers, > > > > Harald > > > > > > > > > > -- > > > > GHUM GmbH > Harald Armin Massa > Spielberger Straße 49 > 70435 Stuttgart > 0173/9409607 > > Amtsgericht Stuttgart, HRB 734971 > > ------------------------------------------------------------ > ------------------ > 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: Dominique D. <dom...@to...> - 2017-04-14 07:48:40
|
dependencywalker helped pinpoint the sore muscle, which is finding OCI.DLL. However it may just be a back compatibility issue. I have Oracle Client 10.2 while the oldest version of cx_Oracle is 11g. I looked up previous posts for compatibility issues, but could not find anything helpful.
My best bet is to install Instant Client 12 and give it precedence over the other client installed by pointing ORACLE_HOME to it.
Thanks and regards,
Dominique
From: Massa, Harald Armin [mailto:ch...@gh...]
Sent: jeudi 13 avril 2017 18:26
To: cx-...@li...
Subject: Re: [cx-oracle-users] DLL load failed
Hi,
I have run the installer cx_Oracle-5.2.1-12c.win-amd64-py2.7.exe on a Dell Precision T5610, running Windows7 64 bits, with apparent success: the compiled file cx_Oracle.pyd is in place under the site-packages directory. However, it seems that Python misses parts of the module (see session below), even after appending a line to sys.path. Would there be another module registration to write somewhere before running it ?
>>> import cx_Oracle
Traceback (most recent call last):
File "<pyshell#0>", line 1, in <module>
import cx_Oracle
ImportError: DLL load failed: The specified module could not be found.
>>>
most likely you are missing the Oracle OCI libary in the fitting 12c version. They have to be downloaded and licenced with Oracle.
Make sure cx_Oracle is able to find them, usefull things are:
- have the bin directory in your path
- have the oracle environment variables set correctly.
Usefull tool to diagnose:
http://www.dependencywalker.com/
Cheers,
Harald
--
GHUM GmbH
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
Amtsgericht Stuttgart, HRB 734971
|
|
From: Massa, H. A. <ch...@gh...> - 2017-04-13 16:51:42
|
Hi, I have run the installer cx_Oracle-5.2.1-12c.win-amd64-py2.7.exe on a Dell > Precision T5610, running Windows7 64 bits, with apparent success: the > compiled file cx_Oracle.pyd is in place under the site-packages directory. > However, it seems that Python misses parts of the module (see session > below), even after appending a line to sys.path. Would there be another > module registration to write somewhere before running it ? > > > > >>> import cx_Oracle > > > > Traceback (most recent call last): > > File "<pyshell#0>", line 1, in <module> > > import cx_Oracle > > ImportError: DLL load failed: The specified module could not be found. > > >>> > > > most likely you are missing the Oracle OCI libary in the fitting 12c version. They have to be downloaded and licenced with Oracle. Make sure cx_Oracle is able to find them, usefull things are: - have the bin directory in your path - have the oracle environment variables set correctly. Usefull tool to diagnose: http://www.dependencywalker.com/ Cheers, Harald -- GHUM GmbH Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 Amtsgericht Stuttgart, HRB 734971 |
|
From: Anthony T. <ant...@gm...> - 2017-04-13 16:51:23
|
Hi Dominique, You also need to have an Oracle Client installed. The simplest is the Oracle Instant Client which you can find at the link below. Follow the instructions at the bottom of the page from which you download the Instant Client packages for your platform. Also, make sure that you download a 64-bit client to match your 64-bit Python and 64-bit cx_Oracle installation. http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html Anthony On Thu, Apr 13, 2017 at 9:34 AM, Dominique DEXHEIMER < dom...@to...> wrote: > Hi everyone, > > > > I have run the installer cx_Oracle-5.2.1-12c.win-amd64-py2.7.exe on a > Dell Precision T5610, running Windows7 64 bits, with apparent success: the > compiled file cx_Oracle.pyd is in place under the site-packages directory. > However, it seems that Python misses parts of the module (see session > below), even after appending a line to sys.path. Would there be another > module registration to write somewhere before running it ? > > > > Regards, > > Dominique > > > > >>> import cx_Oracle > > > > Traceback (most recent call last): > > File "<pyshell#0>", line 1, in <module> > > import cx_Oracle > > ImportError: DLL load failed: The specified module could not be found. > > >>> > > > > ------------------------------------------------------------ > ------------------ > 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: Dominique D. <dom...@to...> - 2017-04-13 16:09:35
|
Hi everyone,
I have run the installer cx_Oracle-5.2.1-12c.win-amd64-py2.7.exe on a Dell Precision T5610, running Windows7 64 bits, with apparent success: the compiled file cx_Oracle.pyd is in place under the site-packages directory. However, it seems that Python misses parts of the module (see session below), even after appending a line to sys.path. Would there be another module registration to write somewhere before running it ?
Regards,
Dominique
>>> import cx_Oracle
Traceback (most recent call last):
File "<pyshell#0>", line 1, in <module>
import cx_Oracle
ImportError: DLL load failed: The specified module could not be found.
>>>
|
|
From: Anthony T. <ant...@gm...> - 2017-03-22 22:40:49
|
Hi CJ, The reason was simply that I didn't go beyond the system python that was installed on the machine. I have since uploaded the Python 3.5 RPMs that are based on the version of Python 3.5 that can be installed as part of SCL. Hope that is what you were looking for! Anthony On Sun, Mar 19, 2017 at 12:48 PM, CJ Lee <cjs...@gm...> wrote: > there seem to be windows installers for python 3.x and linux rpms for 2.x > but no rpms for python 3.x > is there a reason for this? > > ------------------------------------------------------------ > ------------------ > 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: CJ L. <cjs...@gm...> - 2017-03-19 18:49:03
|
there seem to be windows installers for python 3.x and linux rpms for 2.x but no rpms for python 3.x is there a reason for this? |
|
From: Anthony T. <ant...@gm...> - 2017-03-14 14:07:27
|
Thanks, Andreas. :-) On Tue, Mar 14, 2017 at 8:04 AM, Andreas Mock <and...@we...> wrote: > Hi Anthony, > > I'm still on this list for sentimental reasons. You may remember. :-) > > My congratulations for cx_Oracle getting higher consecrations. > > Best regards > Andreas > > > > -----Ursprüngliche Nachricht----- > > Von: Walter Dörwald [mailto:wa...@li...] > > Gesendet: Dienstag, 14. März 2017 14:09 > > An: cx-...@li... > > Betreff: Re: [cx-oracle-users] cx_Oracle 5.3 > > > > On 10 Mar 2017, at 7:28, Anthony Tuininga wrote: > > > > > What is cx_Oracle? > > > > > > cx_Oracle is a Python extension module that enables access to Oracle > > > Database for Python 2.x and 3.x and conforms to the Python database > > > API 2.0 > > > specifications with a number of enhancements. > > > > > > > > > Where do I get it? > > > https://oracle.github.io/python-cx_Oracle > > > > > > > > > What's new? > > > http://cx-oracle.readthedocs.io/en/5.3/releasenotes.html#version-5-3- > > march-2017 > > > In addition, my colleague, Chris Jones, has also blogged about the > > > release > > > here: https://blogs.oracle.com/opal/entry/python_cx_oracle_5_3 > > > > > > Note that the source for cx_Oracle has moved to GitHub: > > > https://github.com/oracle/python-cx_Oracle > > > > cx_Oracle is now an official Oracle package? > > > > This is indeed great news. Congratulations! > > > > Maybe some day we will see a cx_Oracle that supports asyncio? > > > > Servus, > > Walter > > > > ------------------------------------------------------------ > -------------- > > ---- > > 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: Anthony T. <ant...@gm...> - 2017-03-14 14:06:53
|
Thanks. Yes, indeed. cx_Oracle is now a package officially distributed by Oracle. As for asyncio, definitely something that is being looked at -- so hopefully someday support for it will be added! Anthony On Tue, Mar 14, 2017 at 7:09 AM, Walter Dörwald <wa...@li...> wrote: > On 10 Mar 2017, at 7:28, Anthony Tuininga wrote: > > > What is cx_Oracle? > > > > cx_Oracle is a Python extension module that enables access to Oracle > > Database for Python 2.x and 3.x and conforms to the Python database > > API 2.0 > > specifications with a number of enhancements. > > > > > > Where do I get it? > > https://oracle.github.io/python-cx_Oracle > > > > > > What's new? > > http://cx-oracle.readthedocs.io/en/5.3/releasenotes.html# > version-5-3-march-2017 > > In addition, my colleague, Chris Jones, has also blogged about the > > release > > here: https://blogs.oracle.com/opal/entry/python_cx_oracle_5_3 > > > > Note that the source for cx_Oracle has moved to GitHub: > > https://github.com/oracle/python-cx_Oracle > > cx_Oracle is now an official Oracle package? > > This is indeed great news. Congratulations! > > Maybe some day we will see a cx_Oracle that supports asyncio? > > Servus, > Walter > > ------------------------------------------------------------ > ------------------ > 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: Andreas M. <and...@we...> - 2017-03-14 14:04:15
|
Hi Anthony, I'm still on this list for sentimental reasons. You may remember. :-) My congratulations for cx_Oracle getting higher consecrations. Best regards Andreas > -----Ursprüngliche Nachricht----- > Von: Walter Dörwald [mailto:wa...@li...] > Gesendet: Dienstag, 14. März 2017 14:09 > An: cx-...@li... > Betreff: Re: [cx-oracle-users] cx_Oracle 5.3 > > On 10 Mar 2017, at 7:28, Anthony Tuininga wrote: > > > What is cx_Oracle? > > > > cx_Oracle is a Python extension module that enables access to Oracle > > Database for Python 2.x and 3.x and conforms to the Python database > > API 2.0 > > specifications with a number of enhancements. > > > > > > Where do I get it? > > https://oracle.github.io/python-cx_Oracle > > > > > > What's new? > > http://cx-oracle.readthedocs.io/en/5.3/releasenotes.html#version-5-3- > march-2017 > > In addition, my colleague, Chris Jones, has also blogged about the > > release > > here: https://blogs.oracle.com/opal/entry/python_cx_oracle_5_3 > > > > Note that the source for cx_Oracle has moved to GitHub: > > https://github.com/oracle/python-cx_Oracle > > cx_Oracle is now an official Oracle package? > > This is indeed great news. Congratulations! > > Maybe some day we will see a cx_Oracle that supports asyncio? > > Servus, > Walter > > -------------------------------------------------------------------------- > ---- > 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: Walter D. <wa...@li...> - 2017-03-14 13:42:34
|
On 10 Mar 2017, at 7:28, Anthony Tuininga wrote: > What is cx_Oracle? > > cx_Oracle is a Python extension module that enables access to Oracle > Database for Python 2.x and 3.x and conforms to the Python database > API 2.0 > specifications with a number of enhancements. > > > Where do I get it? > https://oracle.github.io/python-cx_Oracle > > > What's new? > http://cx-oracle.readthedocs.io/en/5.3/releasenotes.html#version-5-3-march-2017 > In addition, my colleague, Chris Jones, has also blogged about the > release > here: https://blogs.oracle.com/opal/entry/python_cx_oracle_5_3 > > Note that the source for cx_Oracle has moved to GitHub: > https://github.com/oracle/python-cx_Oracle cx_Oracle is now an official Oracle package? This is indeed great news. Congratulations! Maybe some day we will see a cx_Oracle that supports asyncio? Servus, Walter |
|
From: Anthony T. <ant...@gm...> - 2017-03-10 06:28:56
|
What is cx_Oracle? cx_Oracle is a Python extension module that enables access to Oracle Database for Python 2.x and 3.x and conforms to the Python database API 2.0 specifications with a number of enhancements. Where do I get it? https://oracle.github.io/python-cx_Oracle What's new? http://cx-oracle.readthedocs.io/en/5.3/releasenotes.html#version-5-3-march-2017 In addition, my colleague, Chris Jones, has also blogged about the release here: https://blogs.oracle.com/opal/entry/python_cx_oracle_5_3 Note that the source for cx_Oracle has moved to GitHub: https://github.com/oracle/python-cx_Oracle |
|
From: Shai B. <sh...@pl...> - 2017-03-09 16:01:49
|
Hi Derry,
On Thursday 09 March 2017 17:17:30 Derry Holding wrote:
> Hi there,
>
> I'm trying to parse data with variable fields and am looking for a more
> pythonic, efficient way to do this.
> Firstly I have a dict like so:
>
> smsreport_dict = dict: {'date': '2007-05-27 14:00:12 +0200', 'msgid':
> '2D67C865FB6FA25A9261C75E8D2F0F2B ', 'msgparts': '1', 'result': 'success'}
>
> This is compiled from an xml file, and the fields are not always the same
> in each xml file, however there are a maximum number of fields (and so
> field names) that the xml file can be. Consequently the Oracle DB has
> about 12 or so columns. I see two possible ways to execute the command, as
> follows:
>
> database_table_name = 'messaging'
>
> for field_name, input in smsreport_dict.items():
> sql_insert = 'insert into ' + database_table_name + ' {0}
> values {1}'.format(field_name, input)
> cursor.execute(sql_insert)
>
This looks wrong twice: Once, because you're inserting each field into its own
record here, and the sample contents you posted indicate that each such dict
should be stored as a single record. And a second time, because you're
formatting the values into the sql statement, which would expose you to sql
injections (malicious or just erroneous ones).
>
> # OR...
>
> sql_insert = 'insert into ' + database_table_name + ' (a, b, c, d)
> values (:1, :2, :3, :4)'
> cursor.prepare(sql_insert)
> cursor.executemany(None, smsreport_dict)
You don't need executemany to insert a single record.
You need to construct your insert statement and values, basically like so:
columns, values = zip(smsreport_dict.items())
value_placeholders = [":%s" % (i+1) for i in range(len(values))]
sql_insert = 'insert into {0} ({1}) values ({2})'.format(
database_table_name,
", ".join(columns),
", ".join(value_placehoders)
)
cursor.execute(sql_insert, values)
Error handling, transaction handling, dealing with columns whose names need to
be quoted, etc. are left as an exercise to the reader.
HTH,
Shai.
|
|
From: Derry H. <con...@de...> - 2017-03-09 15:17:38
|
Hi there,
I'm trying to parse data with variable fields and am looking for a more
pythonic, efficient way to do this.
Firstly I have a dict like so:
smsreport_dict = dict: {'date': '2007-05-27 14:00:12 +0200', 'msgid':
'2D67C865FB6FA25A9261C75E8D2F0F2B ', 'msgparts': '1', 'result': 'success'}
This is compiled from an xml file, and the fields are not always the same in
each xml file, however there are a maximum number of fields (and so field names)
that the xml file can be. Consequently the Oracle DB has about 12 or so columns.
I see two possible ways to execute the command, as follows:
database_table_name = 'messaging'
for field_name, input in smsreport_dict.items():
sql_insert = 'insert into ' + database_table_name + ' {0} values
{1}'.format(field_name, input)
cursor.execute(sql_insert)
connection.commit()
cursor.close()
connection.close()
# OR...
sql_insert = 'insert into ' + database_table_name + ' (a, b, c, d)
values (:1, :2, :3, :4)'
cursor.prepare(sql_insert)
cursor.executemany(None, smsreport_dict)
connection.commit()
cursor.close()
connection.close()
However if the field names are different depending on the xml file (therefore so
too can the number of fields/columns) then how can I accomodate for this
variation? I'm thinking it may be best to loop through "smsreport_dict" and
match each field name i.e date, msgid etc.
with the corresponding field/column name, that is already established in my
Oracle DB. Any ideas?
Regards,
Derry.
|
|
From: Kirankumar N <kir...@gm...> - 2017-03-09 07:32:24
|
Hi Folks, I’m working with cx_Oracle 5.2.1 and Python 2.7, it was all fine till my firm decided to change the DB connections from *TCP to TCPS.* so, i was forced to change the way we connect to DB using TNSORA file. This is how my code goes for the connection, *import cx_Oracle* *cx_Oracle.connect(‘user/pass@dbconnect’)* on execution of above code snippet it throws below error. cx_Oracle.DatabaseError: ORA-12560: TNS:protocol adapter error Even my DB team are clueless as there is no issue connecting with SQLPLUS and only issue with python module I don’t see any issue connection to database using the same handler using sqlplus, which confirms all my TNS_ADMIN and ORACLE_HOME are all set right ! *system123:~ Mymac$ sqlplus user/pass@dbconnect* *SQL*Plus: Release 12.1.0.2.0 Production on Tue Mar 7 22:21:04 2017* *Copyright (c) 1982, 2016, Oracle. All rights reserved.* *Last Successful login time: Tue Mar 07 2017 22:15:01 +05:30* *Connected to:* *Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production* *With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,* *Advanced Analytics, Real Application Testing and Unified Auditing options* *SQL> * Your help would be greatly appreciated here, hope i can get a solution. Thanks., Kiran |
|
From: Anthony T. <ant...@gm...> - 2017-03-02 15:52:12
|
Hi Joshua,
The function Cursor_InternalExecute() will not return until the command has
been completed. If you are dealing with a large amount of data it might
just be taking a long time to do its work. The other possibility is that
something in the database is blocking your statement from executing. You
can examine the table dba_locks and v$session to see what is happening with
your session.
Anthony
On Thu, Mar 2, 2017 at 1:26 AM, jos...@si... <
jos...@si...> wrote:
> Hi folks,
> Need you help. I wrote a python script to create several tables which
> select huge data from other tables in different python threads. I ran the
> script several times and it always turn out to unable to complete. So i ran
> gdb to check what the script was doing. The function stack show the
> Cursor_InternalExecute invoking did not return. I can't fix it then I see
> you help. The python code is like this:
>
> def split_credit(user_name, region_code):
> with CDB(zc_dbUser, zc_dbPasswd, zc_dbCon) as db: #thread's own
> cx_Oracle.Connection
> credittable = "XXXX_XXXXX_08{0}".format(region_code)
> creditsql = """CREATE TABLE XX.XX_XXXXX_08{0} tablespace {1} AS
> SELECT ....."""
> db.tabledrop(user_name, credittable)
> db.dosql(creditsql)
> time.sleep(1)
>
> workers = []
> for i in range(0, 10):
> region_code = "5"+str(i)
> workerCredit= threading.Thread(target=split_credit,
> name="credit_"+region_code, args=(zc_dbUser, region_code))
> workers.append(workerCredit)
> workerCredit.start()
>
> ------------------------------------------------------------
> ------------------
> 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: 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 > > |
|
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: 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 |
31 messages has been excluded from this view by a project administrator.
