cx-oracle-users — Primary discussion list for users (and developers) of cx_Oracle

Re: [cx-oracle-users] cx_Oracle 5.1 on OSX 10.6.7 with Instantclient 10.2 64bit

[Christopher J. <chr...@or...>]

Ideally installation of cx_Oracle would not overload the use of the
ORACLE_HOME variable.  We try and promote that Instant Client doesn't
need ORACLE_HOME set to run :)

Chris

On 04/22/2011 01:50 PM, Anthony Tuininga wrote:
> Hi,
>
> The line numbers you provide in your description don't match the ones
> that I have in my 5.1 installation....but I was able to find out where
> you were referring to, I believe. And I don't believe that your
> changes are necessary. You'll note on line 167 this line
>
> libDirs = [libPath, oracleHome]
>
> so you can see that the library path includes whatever ORACLE_HOME is.
> I've just checked in changes to further simplify things as earlier in
> the code in the CheckOracleHome() method the location of the clntsh
> library is determined.
>
> In any case, with the base 5.1 install and the new changes I just
> checked in I was able to successfully build cx_Oracle on my Mac Mini.
> So I'm not sure why you needed to make the changes you did. Can you
> try the vanilla one again and show me your error? Thanks.
>
> Anthony
>
> On Thu, Apr 21, 2011 at 3:24 PM, Chris Gould<chr...@to...>  wrote:
>> I've fixed the problem with cx_Oracle (as I described).  I vaguely remember
>> having a similar problem when I installed cx_Oracle 5.0.3 with an earlier
>> version of python (2.6).  The solution was the same this time.
>> Because I'm using Instantclient and not a full Oracle installation, I'd set
>> ORACLE_HOME env var to my instantclient directory.
>> I also set DYLD_LIBRARY_PATH to point to the InstantClient directory  (This
>> needs to be made a permanent setting in .bash_profile )
>> I created the extra symlink required in the InstantClient directory :
>> ln -s libclntsh.dylib.10.1  libclntsh.dylib
>> I also made 2 small changes to setup.py which came with cx_Oracle5.1.
>>   on line 73, change
>>      elif sys.platform == "darwin":
>>          subDirs = ["lib"]
>> to
>>      elif sys.platform == "darwin":
>>          subDirs = [""]
>> and on line 155 change
>>      libPath = os.path.join(oracleHome, "lib")
>> to
>>      libPath = os.path.join(oracleHome, "")
>> Then follow the stated instructions for building and installing cx_Oracle
>> The reason these changes are necessary is that if you've set ORACLE_HOME to
>> your instantclient directory, the files required are in $ORACLE_HOME not
>> $ORACLE_HOME/lib as they would be with a full Oracle installation (which is
>> what setup.py is assuming).
>> It'd be handy if the distributed setup.py could be modified to cater for the
>> InstantClient setup, since I guess more people these days will use this than
>> an old-skool OracleHome installation.
>> Chris.
>>
>> On 16 April 2011 01:18, Mark Harrison<mh...@pi...>  wrote:
>>>
>>> On 4/15/11 4:02 PM, Chris Gould wrote:
>>>> Hi -
>>>> I've downloaded and installed Python 2.7.1 for OSX (Intel 64 bit) which
>>>> is running fine.  I've also downloaded the source code for cx_Oracle and
>>>> tried to get it working.
>>>> I've followed the instructions (python setup.py build  , python setup.py
>>>> install)  and this seems to work OK.  But when I come to try importing
>>>> cx_Oracle I'm repeatedly getting the following error :
>>>>
>>>>
>>>>   >>>  import cx_Oracle
>>>> Traceback (most recent call last):
>>>>     File "<stdin>", line 1, in<module>
>>>> ImportError:
>>>> dlopen(/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/cx_Oracle.so,
>>>> 2): Symbol not found: _OCIAttrGet
>>>>     Referenced from:
>>>> /Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/cx_Oracle.so
>>>>     Expected in: flat namespace
>>>>    in
>>>> /Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/cx_Oracle.so
>>>>
>>>> I have set up the symlink in /usr/local/instantclient_10_2_64
>>>>
>>>> lrwxr-xr-x  1 root   staff        20 15 Apr 23:55 libclntsh.dylib ->
>>>> libclntsh.dylib.10.1
>>>> -rwxr-xr-x@ 1 chris  staff  25582048 31 Mar  2009 libclntsh.dylib.10.1
>>>>
>>>>
>>>> I've got the following environment variables set (which some googling
>>>> seems to imply might have been responsible for the problem)
>>>>
>>>> DYLD_LIBRARY_PATH=/usr/local/instantclient_10_2_64
>>>> LD_LIBRARY_PATH=/usr/local/instantclient_10_2_64:
>>>> ORACLE_HOME=/usr/local/instantclient_10_2_64
>>>>
>>>>
>>>> The instantclient libraries came from Oracle's website : I've got the
>>>> basic Instantclient 10.2.0.4 for 64bit OSX and also the SDK (though I don't
>>>> know if that's strictly necessary).
>>>>
>>>> Anyone got any ideas what's going wrong?
>>>
>>> In my experience, nothing but grief comes from setting environment
>>> variables
>>> to get oracle running.
>>>
>>> Here's what worked for me:
>>>
>>>
>>> http://stackoverflow.com/questions/684352/installing-oracle-instantclient-on-mac-os-x-without-setting-environment-variables
>>>
>>> HTH!
>>> Mark
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Benefiting from Server Virtualization: Beyond Initial Workload
>>> Consolidation -- Increasing the use of server virtualization is a top
>>> priority.Virtualization can reduce costs, simplify management, and improve
>>> application availability and disaster protection. Learn more about
>>> boosting
>>> the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev
>>> _______________________________________________
>>> cx-oracle-users mailing list
>>> cx-...@li...
>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>
>>
>> ------------------------------------------------------------------------------
>> Fulfilling the Lean Software Promise
>> Lean software platforms are now widely adopted and the benefits have been
>> demonstrated beyond question. Learn why your peers are replacing JEE
>> containers with lightweight application servers - and what you can gain
>> from the move. http://p.sf.net/sfu/vmware-sfemails
>> _______________________________________________
>> cx-oracle-users mailing list
>> cx-...@li...
>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>
>>
>
> ------------------------------------------------------------------------------
> Fulfilling the Lean Software Promise
> Lean software platforms are now widely adopted and the benefits have been
> demonstrated beyond question. Learn why your peers are replacing JEE
> containers with lightweight application servers - and what you can gain
> from the move. http://p.sf.net/sfu/vmware-sfemails
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

-- 
Email: chr...@or...
Tel:  +1 650 506 8630
Blog:  http://blogs.oracle.com/opal/

[cx-oracle-users] AUTO: Toby Mathieson is out of the office. (returning 05/01/2011)

[<Tob...@ce...>]

I am out of the office until 05/01/2011.

I will respond to your message when I return.


Note: This is an automated response to your message  "Re: [cx-oracle-users]
cx_Oracle 5.1 on OSX 10.6.7 with Instantclient 10.2 64bit" sent on
4/22/2011 10:50:45 PM.

This is the only notification you will receive while this person is away.

Re: [cx-oracle-users] cx_Oracle 5.1 on OSX 10.6.7 with Instantclient 10.2 64bit

[Chris G. <chr...@to...>]

Hi Anthony -
all the errors I got when using the original file are in the first email I
posted.  The build / install appears to work, but when trying to then import
cx_Oracle I get the errors as described.

Is your installation using InstantClient?

Chris.

On 22 April 2011 21:50, Anthony Tuininga <ant...@gm...> wrote:

> Hi,
>
> The line numbers you provide in your description don't match the ones
> that I have in my 5.1 installation....but I was able to find out where
> you were referring to, I believe. And I don't believe that your
> changes are necessary. You'll note on line 167 this line
>
> libDirs = [libPath, oracleHome]
>
> so you can see that the library path includes whatever ORACLE_HOME is.
> I've just checked in changes to further simplify things as earlier in
> the code in the CheckOracleHome() method the location of the clntsh
> library is determined.
>
> In any case, with the base 5.1 install and the new changes I just
> checked in I was able to successfully build cx_Oracle on my Mac Mini.
> So I'm not sure why you needed to make the changes you did. Can you
> try the vanilla one again and show me your error? Thanks.
>
> Anthony
>
> On Thu, Apr 21, 2011 at 3:24 PM, Chris Gould <chr...@to...>
> wrote:
> > I've fixed the problem with cx_Oracle (as I described).  I vaguely
> remember
> > having a similar problem when I installed cx_Oracle 5.0.3 with an earlier
> > version of python (2.6).  The solution was the same this time.
> > Because I'm using Instantclient and not a full Oracle installation, I'd
> set
> > ORACLE_HOME env var to my instantclient directory.
> > I also set DYLD_LIBRARY_PATH to point to the InstantClient directory
>  (This
> > needs to be made a permanent setting in .bash_profile )
> > I created the extra symlink required in the InstantClient directory :
> > ln -s libclntsh.dylib.10.1  libclntsh.dylib
> > I also made 2 small changes to setup.py which came with cx_Oracle5.1.
> >  on line 73, change
> >     elif sys.platform == "darwin":
> >         subDirs = ["lib"]
> > to
> >     elif sys.platform == "darwin":
> >         subDirs = [""]
> > and on line 155 change
> >     libPath = os.path.join(oracleHome, "lib")
> > to
> >     libPath = os.path.join(oracleHome, "")
> > Then follow the stated instructions for building and installing cx_Oracle
> > The reason these changes are necessary is that if you've set ORACLE_HOME
> to
> > your instantclient directory, the files required are in $ORACLE_HOME not
> > $ORACLE_HOME/lib as they would be with a full Oracle installation (which
> is
> > what setup.py is assuming).
> > It'd be handy if the distributed setup.py could be modified to cater for
> the
> > InstantClient setup, since I guess more people these days will use this
> than
> > an old-skool OracleHome installation.
> > Chris.
> >
> > On 16 April 2011 01:18, Mark Harrison <mh...@pi...> wrote:
> >>
> >> On 4/15/11 4:02 PM, Chris Gould wrote:
> >> > Hi -
> >> > I've downloaded and installed Python 2.7.1 for OSX (Intel 64 bit)
> which
> >> > is running fine.  I've also downloaded the source code for cx_Oracle
> and
> >> > tried to get it working.
> >> > I've followed the instructions (python setup.py build  , python
> setup.py
> >> > install)  and this seems to work OK.  But when I come to try importing
> >> > cx_Oracle I'm repeatedly getting the following error :
> >> >
> >> >
> >> >  >>> import cx_Oracle
> >> > Traceback (most recent call last):
> >> >    File "<stdin>", line 1, in <module>
> >> > ImportError:
> >> >
> dlopen(/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/cx_Oracle.so,
> >> > 2): Symbol not found: _OCIAttrGet
> >> >    Referenced from:
> >> >
> /Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/cx_Oracle.so
> >> >    Expected in: flat namespace
> >> >   in
> >> >
> /Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/cx_Oracle.so
> >> >
> >> > I have set up the symlink in /usr/local/instantclient_10_2_64
> >> >
> >> > lrwxr-xr-x  1 root   staff        20 15 Apr 23:55 libclntsh.dylib ->
> >> > libclntsh.dylib.10.1
> >> > -rwxr-xr-x@ 1 chris  staff  25582048 31 Mar  2009
> libclntsh.dylib.10.1
> >> >
> >> >
> >> > I've got the following environment variables set (which some googling
> >> > seems to imply might have been responsible for the problem)
> >> >
> >> > DYLD_LIBRARY_PATH=/usr/local/instantclient_10_2_64
> >> > LD_LIBRARY_PATH=/usr/local/instantclient_10_2_64:
> >> > ORACLE_HOME=/usr/local/instantclient_10_2_64
> >> >
> >> >
> >> > The instantclient libraries came from Oracle's website : I've got the
> >> > basic Instantclient 10.2.0.4 for 64bit OSX and also the SDK (though I
> don't
> >> > know if that's strictly necessary).
> >> >
> >> > Anyone got any ideas what's going wrong?
> >>
> >> In my experience, nothing but grief comes from setting environment
> >> variables
> >> to get oracle running.
> >>
> >> Here's what worked for me:
> >>
> >>
> >>
> http://stackoverflow.com/questions/684352/installing-oracle-instantclient-on-mac-os-x-without-setting-environment-variables
> >>
> >> HTH!
> >> Mark
> >>
> >>
> >>
> ------------------------------------------------------------------------------
> >> Benefiting from Server Virtualization: Beyond Initial Workload
> >> Consolidation -- Increasing the use of server virtualization is a top
> >> priority.Virtualization can reduce costs, simplify management, and
> improve
> >> application availability and disaster protection. Learn more about
> >> boosting
> >> the value of server virtualization.
> http://p.sf.net/sfu/vmware-sfdev2dev
> >> _______________________________________________
> >> cx-oracle-users mailing list
> >> cx-...@li...
> >> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> >
> >
> >
> ------------------------------------------------------------------------------
> > Fulfilling the Lean Software Promise
> > Lean software platforms are now widely adopted and the benefits have been
> > demonstrated beyond question. Learn why your peers are replacing JEE
> > containers with lightweight application servers - and what you can gain
> > from the move. http://p.sf.net/sfu/vmware-sfemails
> > _______________________________________________
> > cx-oracle-users mailing list
> > cx-...@li...
> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> >
> >
>

Re: [cx-oracle-users] cx_Oracle 5.1 on OSX 10.6.7 with Instantclient 10.2 64bit

[Anthony T. <ant...@gm...>]

Hi,

The line numbers you provide in your description don't match the ones
that I have in my 5.1 installation....but I was able to find out where
you were referring to, I believe. And I don't believe that your
changes are necessary. You'll note on line 167 this line

libDirs = [libPath, oracleHome]

so you can see that the library path includes whatever ORACLE_HOME is.
I've just checked in changes to further simplify things as earlier in
the code in the CheckOracleHome() method the location of the clntsh
library is determined.

In any case, with the base 5.1 install and the new changes I just
checked in I was able to successfully build cx_Oracle on my Mac Mini.
So I'm not sure why you needed to make the changes you did. Can you
try the vanilla one again and show me your error? Thanks.

Anthony

On Thu, Apr 21, 2011 at 3:24 PM, Chris Gould <chr...@to...> wrote:
> I've fixed the problem with cx_Oracle (as I described).  I vaguely remember
> having a similar problem when I installed cx_Oracle 5.0.3 with an earlier
> version of python (2.6).  The solution was the same this time.
> Because I'm using Instantclient and not a full Oracle installation, I'd set
> ORACLE_HOME env var to my instantclient directory.
> I also set DYLD_LIBRARY_PATH to point to the InstantClient directory  (This
> needs to be made a permanent setting in .bash_profile )
> I created the extra symlink required in the InstantClient directory :
> ln -s libclntsh.dylib.10.1  libclntsh.dylib
> I also made 2 small changes to setup.py which came with cx_Oracle5.1.
>  on line 73, change
>     elif sys.platform == "darwin":
>         subDirs = ["lib"]
> to
>     elif sys.platform == "darwin":
>         subDirs = [""]
> and on line 155 change
>     libPath = os.path.join(oracleHome, "lib")
> to
>     libPath = os.path.join(oracleHome, "")
> Then follow the stated instructions for building and installing cx_Oracle
> The reason these changes are necessary is that if you've set ORACLE_HOME to
> your instantclient directory, the files required are in $ORACLE_HOME not
> $ORACLE_HOME/lib as they would be with a full Oracle installation (which is
> what setup.py is assuming).
> It'd be handy if the distributed setup.py could be modified to cater for the
> InstantClient setup, since I guess more people these days will use this than
> an old-skool OracleHome installation.
> Chris.
>
> On 16 April 2011 01:18, Mark Harrison <mh...@pi...> wrote:
>>
>> On 4/15/11 4:02 PM, Chris Gould wrote:
>> > Hi -
>> > I've downloaded and installed Python 2.7.1 for OSX (Intel 64 bit) which
>> > is running fine.  I've also downloaded the source code for cx_Oracle and
>> > tried to get it working.
>> > I've followed the instructions (python setup.py build  , python setup.py
>> > install)  and this seems to work OK.  But when I come to try importing
>> > cx_Oracle I'm repeatedly getting the following error :
>> >
>> >
>> >  >>> import cx_Oracle
>> > Traceback (most recent call last):
>> >    File "<stdin>", line 1, in <module>
>> > ImportError:
>> > dlopen(/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/cx_Oracle.so,
>> > 2): Symbol not found: _OCIAttrGet
>> >    Referenced from:
>> > /Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/cx_Oracle.so
>> >    Expected in: flat namespace
>> >   in
>> > /Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/cx_Oracle.so
>> >
>> > I have set up the symlink in /usr/local/instantclient_10_2_64
>> >
>> > lrwxr-xr-x  1 root   staff        20 15 Apr 23:55 libclntsh.dylib ->
>> > libclntsh.dylib.10.1
>> > -rwxr-xr-x@ 1 chris  staff  25582048 31 Mar  2009 libclntsh.dylib.10.1
>> >
>> >
>> > I've got the following environment variables set (which some googling
>> > seems to imply might have been responsible for the problem)
>> >
>> > DYLD_LIBRARY_PATH=/usr/local/instantclient_10_2_64
>> > LD_LIBRARY_PATH=/usr/local/instantclient_10_2_64:
>> > ORACLE_HOME=/usr/local/instantclient_10_2_64
>> >
>> >
>> > The instantclient libraries came from Oracle's website : I've got the
>> > basic Instantclient 10.2.0.4 for 64bit OSX and also the SDK (though I don't
>> > know if that's strictly necessary).
>> >
>> > Anyone got any ideas what's going wrong?
>>
>> In my experience, nothing but grief comes from setting environment
>> variables
>> to get oracle running.
>>
>> Here's what worked for me:
>>
>>
>> http://stackoverflow.com/questions/684352/installing-oracle-instantclient-on-mac-os-x-without-setting-environment-variables
>>
>> HTH!
>> Mark
>>
>>
>> ------------------------------------------------------------------------------
>> Benefiting from Server Virtualization: Beyond Initial Workload
>> Consolidation -- Increasing the use of server virtualization is a top
>> priority.Virtualization can reduce costs, simplify management, and improve
>> application availability and disaster protection. Learn more about
>> boosting
>> the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev
>> _______________________________________________
>> cx-oracle-users mailing list
>> cx-...@li...
>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>
> ------------------------------------------------------------------------------
> Fulfilling the Lean Software Promise
> Lean software platforms are now widely adopted and the benefits have been
> demonstrated beyond question. Learn why your peers are replacing JEE
> containers with lightweight application servers - and what you can gain
> from the move. http://p.sf.net/sfu/vmware-sfemails
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>

Re: [cx-oracle-users] cx_Oracle 5.1 on OSX 10.6.7 with Instantclient 10.2 64bit

[Chris G. <chr...@to...>]

I've fixed the problem with cx_Oracle (as I described).  I vaguely remember
having a similar problem when I installed cx_Oracle 5.0.3 with an earlier
version of python (2.6).  The solution was the same this time.

Because I'm using Instantclient and not a full Oracle installation, I'd set
ORACLE_HOME env var to my instantclient directory.
I also set DYLD_LIBRARY_PATH to point to the InstantClient directory  (This
needs to be made a permanent setting in .bash_profile )

I created the extra symlink required in the InstantClient directory :

ln -s libclntsh.dylib.10.1  libclntsh.dylib

I also made 2 small changes to setup.py which came with cx_Oracle5.1.
 on line 73, change

    elif sys.platform == "darwin":
        subDirs = ["lib"]
to
    elif sys.platform == "darwin":
        subDirs = [""]

and on line 155 change
    libPath = os.path.join(oracleHome, "lib")
to
    libPath = os.path.join(oracleHome, "")

Then follow the stated instructions for building and installing cx_Oracle

The reason these changes are necessary is that if you've set ORACLE_HOME to
your instantclient directory, the files required are in $ORACLE_HOME not
$ORACLE_HOME/lib as they would be with a full Oracle installation (which is
what setup.py is assuming).

It'd be handy if the distributed setup.py could be modified to cater for the
InstantClient setup, since I guess more people these days will use this than
an old-skool OracleHome installation.

Chris.


On 16 April 2011 01:18, Mark Harrison <mh...@pi...> wrote:

> On 4/15/11 4:02 PM, Chris Gould wrote:
> > Hi -
> > I've downloaded and installed Python 2.7.1 for OSX (Intel 64 bit) which
> is running fine.  I've also downloaded the source code for cx_Oracle and
> tried to get it working.
> > I've followed the instructions (python setup.py build  , python setup.py
> install)  and this seems to work OK.  But when I come to try importing
> cx_Oracle I'm repeatedly getting the following error :
> >
> >
> >  >>> import cx_Oracle
> > Traceback (most recent call last):
> >    File "<stdin>", line 1, in <module>
> > ImportError:
> dlopen(/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/cx_Oracle.so,
> 2): Symbol not found: _OCIAttrGet
> >    Referenced from:
> /Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/cx_Oracle.so
> >    Expected in: flat namespace
> >   in
> /Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/cx_Oracle.so
> >
> > I have set up the symlink in /usr/local/instantclient_10_2_64
> >
> > lrwxr-xr-x  1 root   staff        20 15 Apr 23:55 libclntsh.dylib ->
> libclntsh.dylib.10.1
> > -rwxr-xr-x@ 1 chris  staff  25582048 31 Mar  2009 libclntsh.dylib.10.1
> >
> >
> > I've got the following environment variables set (which some googling
> seems to imply might have been responsible for the problem)
> >
> > DYLD_LIBRARY_PATH=/usr/local/instantclient_10_2_64
> > LD_LIBRARY_PATH=/usr/local/instantclient_10_2_64:
> > ORACLE_HOME=/usr/local/instantclient_10_2_64
> >
> >
> > The instantclient libraries came from Oracle's website : I've got the
> basic Instantclient 10.2.0.4 for 64bit OSX and also the SDK (though I don't
> know if that's strictly necessary).
> >
> > Anyone got any ideas what's going wrong?
>
> In my experience, nothing but grief comes from setting environment
> variables
> to get oracle running.
>
> Here's what worked for me:
>
>
> http://stackoverflow.com/questions/684352/installing-oracle-instantclient-on-mac-os-x-without-setting-environment-variables
>
> HTH!
> Mark
>
>
> ------------------------------------------------------------------------------
> Benefiting from Server Virtualization: Beyond Initial Workload
> Consolidation -- Increasing the use of server virtualization is a top
> priority.Virtualization can reduce costs, simplify management, and improve
> application availability and disaster protection. Learn more about boosting
> the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

Re: [cx-oracle-users] cx-oracle-users Digest, Vol 58, Issue 3

[Tamás G. <gt...@gt...>]

Hi,

I've met with a not-so-funny phenomenon using Cursor.prepare (for
testing SQL statements validity): first, it  didn't work (some 4.x
version of cx_Oracle), but 5.0.1 does work. The phenomenon is the
following: ALTER statements DOES execute during the prepare call! DML
(insert, update, delete) does not, but DML (alter, at least) does.
Quite a painful side effect...

Is it a cx_Oracle bug or an Oracle feature?
(AIX 5.3, Python 2.7.1, cx_Oracle 5.0.1, Oracle DB 10g R2)

Thanks,

Tamás Gulácsi

Re: [cx-oracle-users] cx_Oracle 5.1 on OSX 10.6.7 with Instantclient 10.2 64bit

[Mark H. <mh...@pi...>]

On 4/15/11 4:02 PM, Chris Gould wrote:
> Hi -
> I've downloaded and installed Python 2.7.1 for OSX (Intel 64 bit) which is running fine.  I've also downloaded the source code for cx_Oracle and tried to get it working.
> I've followed the instructions (python setup.py build  , python setup.py install)  and this seems to work OK.  But when I come to try importing cx_Oracle I'm repeatedly getting the following error :
>
>
>  >>> import cx_Oracle
> Traceback (most recent call last):
>    File "<stdin>", line 1, in <module>
> ImportError: dlopen(/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/cx_Oracle.so, 2): Symbol not found: _OCIAttrGet
>    Referenced from: /Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/cx_Oracle.so
>    Expected in: flat namespace
>   in /Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/cx_Oracle.so
>
> I have set up the symlink in /usr/local/instantclient_10_2_64
>
> lrwxr-xr-x  1 root   staff        20 15 Apr 23:55 libclntsh.dylib -> libclntsh.dylib.10.1
> -rwxr-xr-x@ 1 chris  staff  25582048 31 Mar  2009 libclntsh.dylib.10.1
>
>
> I've got the following environment variables set (which some googling seems to imply might have been responsible for the problem)
>
> DYLD_LIBRARY_PATH=/usr/local/instantclient_10_2_64
> LD_LIBRARY_PATH=/usr/local/instantclient_10_2_64:
> ORACLE_HOME=/usr/local/instantclient_10_2_64
>
>
> The instantclient libraries came from Oracle's website : I've got the basic Instantclient 10.2.0.4 for 64bit OSX and also the SDK (though I don't know if that's strictly necessary).
>
> Anyone got any ideas what's going wrong?

In my experience, nothing but grief comes from setting environment variables
to get oracle running.

Here's what worked for me:

http://stackoverflow.com/questions/684352/installing-oracle-instantclient-on-mac-os-x-without-setting-environment-variables

HTH!
Mark

[cx-oracle-users] cx_Oracle 5.1 on OSX 10.6.7 with Instantclient 10.2 64bit

[Chris G. <chr...@to...>]

Hi -
I've downloaded and installed Python 2.7.1 for OSX (Intel 64 bit) which is
running fine.  I've also downloaded the source code for cx_Oracle and tried
to get it working.
I've followed the instructions (python setup.py build  , python setup.py
install)  and this seems to work OK.  But when I come to try importing
cx_Oracle I'm repeatedly getting the following error :


>>> import cx_Oracle
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
ImportError:
dlopen(/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/cx_Oracle.so,
2): Symbol not found: _OCIAttrGet
  Referenced from:
/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/cx_Oracle.so
  Expected in: flat namespace
 in
/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/cx_Oracle.so

I have set up the symlink in /usr/local/instantclient_10_2_64

lrwxr-xr-x  1 root   staff        20 15 Apr 23:55 libclntsh.dylib ->
libclntsh.dylib.10.1
-rwxr-xr-x@ 1 chris  staff  25582048 31 Mar  2009 libclntsh.dylib.10.1


I've got the following environment variables set (which some googling seems
to imply might have been responsible for the problem)

DYLD_LIBRARY_PATH=/usr/local/instantclient_10_2_64
LD_LIBRARY_PATH=/usr/local/instantclient_10_2_64:
ORACLE_HOME=/usr/local/instantclient_10_2_64


The instantclient libraries came from Oracle's website : I've got the basic
Instantclient 10.2.0.4 for 64bit OSX and also the SDK (though I don't know
if that's strictly necessary).

Anyone got any ideas what's going wrong?

Happy to receive direct mails if anyone can shed any light on this.

Thanks
Chris.

Re: [cx-oracle-users] Version 5.1 vs 5.04

[Jim T. <jim...@ls...>]

I had similar issue.  I'm not sure how I fixed it though.

Can you try running InstantClient for 10.2?

I think Oracle 11 messes with .dll search order from what I understand.

If I recover my thoughts on what I did awhile back I'll let you and the 
list know.

On 4/14/2011 2:01 PM, Gerrat Rickert wrote:
> Thanks for the suggestion, Anthony.
> Nothing at all about it in the event log.
>
> I just found this: http://bugs.python.org/issue10854 and really wish they had decided to "re-implement depends.exe" in python ;)
>
> I tried running depends.exe via subprocess at the point where I would have imported cx_Oracle, but the output was the same as just running it from the command prompt (same error messages with both versions).
> I guess doing this isn't the same as importing it via python.
>
>
> Gerrat
>
>
> -----Original Message-----
> From: Anthony Tuininga [mailto:ant...@gm...]
> Sent: April 14, 2011 1:34 PM
> To: cx-...@li...
> Subject: Re: [cx-oracle-users] Version 5.1 vs 5.04
>
> You're welcome.
>
> One other thing: check the event log. There might be a "side-by-side"
> error that is taking place.
>
> Anthony
>
> On Thu, Apr 14, 2011 at 10:49 AM, Gerrat Rickert
> <gri...@co...>  wrote:
>> Thanks for the response, Anthony.
>>
>> I don't know how to go about finding which DLL it's complaining about - it
>> doesn't write that information to the error logs.
>>
>> I tried running Dependency Walker on cx_Oracle.pyd (not even sure if this is
>> correct/useful at all, but wanted to at least try *something*).
>>
>> It came back with an error message, and couldn't open: (MSVCR90.DLL,
>> IESHIMS.DLL, and WER.DLL), but I get the same error messages on the 5.04
>> (working) version as well.
>>
>>
>>
>> Regards,
>>
>>    Gerrat
>>
>>
>>
>>> Which DLL is it complaining about? Its possible that it is not found
>>> in the web environment but is found in the command line environment. I
>>> started compiling with the MSVC compiler for cx_Oracle 5.1 which might
>>> make a difference in how the linking took place. If you find out which
>>> DLL it is I can look more carefully into that.
>>> Anthony
>>> On Tue, Apr 12, 2011 at 11:27 AM, Gerrat Rickert
>>> <grickert@...>  wrote:
>>>> I had the windows version of cx_Oracle 5.04 for Oracle 11g for python 2.7
>>>> installed, and it worked fine (cx_Oracle-5.0.4-11g.win32-py2.7.msi).
>>>> It worked on an intranet web application as well as just at a command
>>>> prompt.
>>>> I upgraded to the 5.1 version (cx_Oracle-5.1-11g.win32-py2.7.msi) , and I
>>>> now get the message:
>>>> ImportError: DLL load failed: The specified module could not be found.
>>>> in my apache error logs when my web app tries importing cx_Oracle.
>>>> Nothing else has changed.
>>>> I'm using an Oracle 11g client (and connecting to an Oracle 11g
>>>> database).
>>>> The latest version (5.1) works fine from a command prompt, but not from
>>>> the
>>>> (Werkzeug) web application.
>>>> When I uninstalled it, and reinstalled the 5.04 version, everything works
>>>> again.
>>>> I don't really *need* to upgrade, but thought I might as well be using
>>>> the
>>>> latest version.
>>>> Anyone have any thoughts on why this doesn't work now?
>>>> Do I need to do something extra with this version that wasn't required
>>>> with
>>>> the previous?
>>>> Regards,
>>>>                   Gerrat
>> ------------------------------------------------------------------------------
>> Benefiting from Server Virtualization: Beyond Initial Workload
>> Consolidation -- Increasing the use of server virtualization is a top
>> priority.Virtualization can reduce costs, simplify management, and improve
>> application availability and disaster protection. Learn more about boosting
>> the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev
>> _______________________________________________
>> cx-oracle-users mailing list
>> cx-...@li...
>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>
>>
> ------------------------------------------------------------------------------
> Benefiting from Server Virtualization: Beyond Initial Workload
> Consolidation -- Increasing the use of server virtualization is a top
> priority.Virtualization can reduce costs, simplify management, and improve
> application availability and disaster protection. Learn more about boosting
> the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
> ------------------------------------------------------------------------------
> Benefiting from Server Virtualization: Beyond Initial Workload
> Consolidation -- Increasing the use of server virtualization is a top
> priority.Virtualization can reduce costs, simplify management, and improve
> application availability and disaster protection. Learn more about boosting
> the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

-- 
Jim Thompson

Reply To: ji...@ls...

LSF Development Corp.     Jim Thompson
PO Box 201                6311 Ski Texas Lane	
Martindale, TX  78655     Rosharon, TX 77583

832 423 7428 (mobile - ATT)
775 264 6670 (e-fax)

http://www.lsfdev.com
http://www.SanMarcosRiverRanch.com

Re: [cx-oracle-users] Version 5.1 vs 5.04

[Gerrat R. <gri...@co...>]

Thanks for the suggestion, Anthony.  
Nothing at all about it in the event log.

I just found this: http://bugs.python.org/issue10854 and really wish they had decided to "re-implement depends.exe" in python ;)

I tried running depends.exe via subprocess at the point where I would have imported cx_Oracle, but the output was the same as just running it from the command prompt (same error messages with both versions).  
I guess doing this isn't the same as importing it via python.


Gerrat


-----Original Message-----
From: Anthony Tuininga [mailto:ant...@gm...] 
Sent: April 14, 2011 1:34 PM
To: cx-...@li...
Subject: Re: [cx-oracle-users] Version 5.1 vs 5.04

You're welcome.

One other thing: check the event log. There might be a "side-by-side"
error that is taking place.

Anthony

On Thu, Apr 14, 2011 at 10:49 AM, Gerrat Rickert
<gri...@co...> wrote:
> Thanks for the response, Anthony.
>
> I don't know how to go about finding which DLL it's complaining about - it
> doesn't write that information to the error logs.
>
> I tried running Dependency Walker on cx_Oracle.pyd (not even sure if this is
> correct/useful at all, but wanted to at least try *something*).
>
> It came back with an error message, and couldn't open: (MSVCR90.DLL,
> IESHIMS.DLL, and WER.DLL), but I get the same error messages on the 5.04
> (working) version as well.
>
>
>
> Regards,
>
>   Gerrat
>
>
>
>>Which DLL is it complaining about? Its possible that it is not found
>
>>in the web environment but is found in the command line environment. I
>
>>started compiling with the MSVC compiler for cx_Oracle 5.1 which might
>
>>make a difference in how the linking took place. If you find out which
>
>>DLL it is I can look more carefully into that.
>
>>
>
>>Anthony
>
>>
>
>>On Tue, Apr 12, 2011 at 11:27 AM, Gerrat Rickert
>
>><grickert@...> wrote:
>
>>> I had the windows version of cx_Oracle 5.04 for Oracle 11g for python 2.7
>
>>> installed, and it worked fine (cx_Oracle-5.0.4-11g.win32-py2.7.msi).
>
>>>
>
>>> It worked on an intranet web application as well as just at a command
>
>>> prompt.
>
>>>
>
>>>
>
>>>
>
>>> I upgraded to the 5.1 version (cx_Oracle-5.1-11g.win32-py2.7.msi) , and I
>
>>> now get the message:
>
>>>
>
>>> ImportError: DLL load failed: The specified module could not be found.
>
>>>
>
>>> in my apache error logs when my web app tries importing cx_Oracle.
>
>>>
>
>>> Nothing else has changed.
>
>>>
>
>>> I'm using an Oracle 11g client (and connecting to an Oracle 11g
>>> database).
>
>>>
>
>>> The latest version (5.1) works fine from a command prompt, but not from
>>> the
>
>>> (Werkzeug) web application.
>
>>>
>
>>>
>
>>>
>
>>> When I uninstalled it, and reinstalled the 5.04 version, everything works
>
>>> again.
>
>>>
>
>>>
>
>>>
>
>>> I don't really *need* to upgrade, but thought I might as well be using
>>> the
>
>>> latest version.
>
>>>
>
>>>
>
>>>
>
>>> Anyone have any thoughts on why this doesn't work now?
>
>>>
>
>>> Do I need to do something extra with this version that wasn't required
>>> with
>
>>> the previous?
>
>>>
>
>>>
>
>>>
>
>>>
>
>>>
>
>>> Regards,
>
>>>
>
>>>                 Gerrat
>
>>>
>
>>>
>
>>>
>
>>>
>
>>>
>
>>
>
> ------------------------------------------------------------------------------
> Benefiting from Server Virtualization: Beyond Initial Workload
> Consolidation -- Increasing the use of server virtualization is a top
> priority.Virtualization can reduce costs, simplify management, and improve
> application availability and disaster protection. Learn more about boosting
> the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>

------------------------------------------------------------------------------
Benefiting from Server Virtualization: Beyond Initial Workload 
Consolidation -- Increasing the use of server virtualization is a top
priority.Virtualization can reduce costs, simplify management, and improve 
application availability and disaster protection. Learn more about boosting 
the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev
_______________________________________________
cx-oracle-users mailing list
cx-...@li...
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

Re: [cx-oracle-users] Version 5.1 vs 5.04

[Anthony T. <ant...@gm...>]

You're welcome.

One other thing: check the event log. There might be a "side-by-side"
error that is taking place.

Anthony

On Thu, Apr 14, 2011 at 10:49 AM, Gerrat Rickert
<gri...@co...> wrote:
> Thanks for the response, Anthony.
>
> I don’t know how to go about finding which DLL it’s complaining about – it
> doesn’t write that information to the error logs.
>
> I tried running Dependency Walker on cx_Oracle.pyd (not even sure if this is
> correct/useful at all, but wanted to at least try *something*).
>
> It came back with an error message, and couldn’t open: (MSVCR90.DLL,
> IESHIMS.DLL, and WER.DLL), but I get the same error messages on the 5.04
> (working) version as well.
>
>
>
> Regards,
>
>   Gerrat
>
>
>
>>Which DLL is it complaining about? Its possible that it is not found
>
>>in the web environment but is found in the command line environment. I
>
>>started compiling with the MSVC compiler for cx_Oracle 5.1 which might
>
>>make a difference in how the linking took place. If you find out which
>
>>DLL it is I can look more carefully into that.
>
>>
>
>>Anthony
>
>>
>
>>On Tue, Apr 12, 2011 at 11:27 AM, Gerrat Rickert
>
>><grickert@...> wrote:
>
>>> I had the windows version of cx_Oracle 5.04 for Oracle 11g for python 2.7
>
>>> installed, and it worked fine (cx_Oracle-5.0.4-11g.win32-py2.7.msi).
>
>>>
>
>>> It worked on an intranet web application as well as just at a command
>
>>> prompt.
>
>>>
>
>>>
>
>>>
>
>>> I upgraded to the 5.1 version (cx_Oracle-5.1-11g.win32-py2.7.msi) , and I
>
>>> now get the message:
>
>>>
>
>>> ImportError: DLL load failed: The specified module could not be found.
>
>>>
>
>>> in my apache error logs when my web app tries importing cx_Oracle.
>
>>>
>
>>> Nothing else has changed.
>
>>>
>
>>> I’m using an Oracle 11g client (and connecting to an Oracle 11g
>>> database).
>
>>>
>
>>> The latest version (5.1) works fine from a command prompt, but not from
>>> the
>
>>> (Werkzeug) web application.
>
>>>
>
>>>
>
>>>
>
>>> When I uninstalled it, and reinstalled the 5.04 version, everything works
>
>>> again.
>
>>>
>
>>>
>
>>>
>
>>> I don’t really *need* to upgrade, but thought I might as well be using
>>> the
>
>>> latest version.
>
>>>
>
>>>
>
>>>
>
>>> Anyone have any thoughts on why this doesn’t work now?
>
>>>
>
>>> Do I need to do something extra with this version that wasn’t required
>>> with
>
>>> the previous?
>
>>>
>
>>>
>
>>>
>
>>>
>
>>>
>
>>> Regards,
>
>>>
>
>>>                 Gerrat
>
>>>
>
>>>
>
>>>
>
>>>
>
>>>
>
>>
>
> ------------------------------------------------------------------------------
> Benefiting from Server Virtualization: Beyond Initial Workload
> Consolidation -- Increasing the use of server virtualization is a top
> priority.Virtualization can reduce costs, simplify management, and improve
> application availability and disaster protection. Learn more about boosting
> the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>

Re: [cx-oracle-users] Version 5.1 vs 5.04

[Gerrat R. <gri...@co...>]

Thanks for the response, Anthony.  

I don't know how to go about finding which DLL it's complaining about -
it doesn't write that information to the error logs.

I tried running Dependency Walker on cx_Oracle.pyd (not even sure if
this is correct/useful at all, but wanted to at least try *something*).

It came back with an error message, and couldn't open: (MSVCR90.DLL,
IESHIMS.DLL, and WER.DLL), but I get the same error messages on the 5.04
(working) version as well. 

 

Regards,

  Gerrat

 

>Which DLL is it complaining about? Its possible that it is not found

>in the web environment but is found in the command line environment. I

>started compiling with the MSVC compiler for cx_Oracle 5.1 which might

>make a difference in how the linking took place. If you find out which

>DLL it is I can look more carefully into that.

> 

>Anthony

> 

>On Tue, Apr 12, 2011 at 11:27 AM, Gerrat Rickert

><grickert@...> wrote:

>> I had the windows version of cx_Oracle 5.04 for Oracle 11g for python
2.7

>> installed, and it worked fine (cx_Oracle-5.0.4-11g.win32-py2.7.msi).

>> 

>> It worked on an intranet web application as well as just at a command

>> prompt.

>> 

>> 

>> 

>> I upgraded to the 5.1 version (cx_Oracle-5.1-11g.win32-py2.7.msi) ,
and I

>> now get the message:

>> 

>> ImportError: DLL load failed: The specified module could not be
found.

>> 

>> in my apache error logs when my web app tries importing cx_Oracle.

>> 

>> Nothing else has changed.

>> 

>> I'm using an Oracle 11g client (and connecting to an Oracle 11g
database).

>> 

>> The latest version (5.1) works fine from a command prompt, but not
from the

>> (Werkzeug) web application.

>> 

>> 

>> 

>> When I uninstalled it, and reinstalled the 5.04 version, everything
works

>> again.

>> 

>> 

>> 

>> I don't really *need* to upgrade, but thought I might as well be
using the

>> latest version.

>> 

>> 

>> 

>> Anyone have any thoughts on why this doesn't work now?

>> 

>> Do I need to do something extra with this version that wasn't
required with

>> the previous?

>> 

>> 

>> 

>> 

>> 

>> Regards,

>> 

>>                 Gerrat

>> 

>> 

>> 

>> 

>> 

> 

Re: [cx-oracle-users] Version 5.1 vs 5.04

[Anthony T. <ant...@gm...>]

Which DLL is it complaining about? Its possible that it is not found
in the web environment but is found in the command line environment. I
started compiling with the MSVC compiler for cx_Oracle 5.1 which might
make a difference in how the linking took place. If you find out which
DLL it is I can look more carefully into that.

Anthony

On Tue, Apr 12, 2011 at 11:27 AM, Gerrat Rickert
<gri...@co...> wrote:
> I had the windows version of cx_Oracle 5.04 for Oracle 11g for python 2.7
> installed, and it worked fine (cx_Oracle-5.0.4-11g.win32-py2.7.msi).
>
> It worked on an intranet web application as well as just at a command
> prompt.
>
>
>
> I upgraded to the 5.1 version (cx_Oracle-5.1-11g.win32-py2.7.msi) , and I
> now get the message:
>
> ImportError: DLL load failed: The specified module could not be found.
>
> in my apache error logs when my web app tries importing cx_Oracle.
>
> Nothing else has changed.
>
> I’m using an Oracle 11g client (and connecting to an Oracle 11g database).
>
> The latest version (5.1) works fine from a command prompt, but not from the
> (Werkzeug) web application.
>
>
>
> When I uninstalled it, and reinstalled the 5.04 version, everything works
> again.
>
>
>
> I don’t really *need* to upgrade, but thought I might as well be using the
> latest version.
>
>
>
> Anyone have any thoughts on why this doesn’t work now?
>
> Do I need to do something extra with this version that wasn’t required with
> the previous?
>
>
>
>
>
> Regards,
>
>                 Gerrat
>
>
>
>
>
> ------------------------------------------------------------------------------
> Forrester Wave Report - Recovery time is now measured in hours and minutes
> not days. Key insights are discussed in the 2010 Forrester Wave Report as
> part of an in-depth evaluation of disaster recovery service providers.
> Forrester found the best-in-class provider in terms of services and vision.
> Read this report now!  http://p.sf.net/sfu/ibm-webcastpromo
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>

[cx-oracle-users] Version 5.1 vs 5.04

[Gerrat R. <gri...@co...>]

I had the windows version of cx_Oracle 5.04 for Oracle 11g for python
2.7 installed, and it worked fine (cx_Oracle-5.0.4-11g.win32-py2.7.msi).

It worked on an intranet web application as well as just at a command
prompt.

 

I upgraded to the 5.1 version (cx_Oracle-5.1-11g.win32-py2.7.msi) , and
I now get the message:

ImportError: DLL load failed: The specified module could not be found.

in my apache error logs when my web app tries importing cx_Oracle.  

Nothing else has changed.

I'm using an Oracle 11g client (and connecting to an Oracle 11g
database).

The latest version (5.1) works fine from a command prompt, but not from
the (Werkzeug) web application.

 

When I uninstalled it, and reinstalled the 5.04 version, everything
works again.

 

I don't really *need* to upgrade, but thought I might as well be using
the latest version.

 

Anyone have any thoughts on why this doesn't work now?

Do I need to do something extra with this version that wasn't required
with the previous?

 

 

Regards, 

                Gerrat

 

 

[cx-oracle-users] [przemolicc@poczta.fm: Re: ORA-28000: the account is locked - but it?works]

[<prz...@po...>]

> > Your code has a loop to connect to several databases and perform the same query.
> > Surely the result you get comes from the previous iteration of the loop?
>
> You are right - thank you :-)

And I am ashamed ...

Regards
Przemyslaw Bak (przemol)
--
http://przemol.blogspot.com/





























----------------------------------------------------------------
Najlepsze oferty na domy i mieszkania w Polsce!
Szutkaj tutaj >> http://linkint.pl/f2974

Re: [cx-oracle-users] ORA-28000: the account is locked - but it works

[<prz...@po...>]

On Wed, Apr 06, 2011 at 08:56:13AM +0200, Amaury Forgeot d'Arc wrote:
> Hi,
> 
> 2011/4/6  <prz...@po...>:
> > Hello,
> >
> > I have the following code running on CentOS 5.5 + cx_Oracle-5.0.4-1:
> >
> >  ...
> >  for DB in config['main']['databases'].split():
> >      try:
> >          con = cx_Oracle.connect(<user>/<pass>)
> >          cs = con.cursor()
> >          cs.execute ("select 1 from dual")
> >          con.rollback ()
> >          con.close()
> >      except cx_Oracle.Error as ex:
> >          tmp_ex = ex
> >          # log tmp_ex to file ...
> >  ...
> >  STR = DATE_TMP.strftime("%Y-%m-%d %H:%M:%S"), STATUS[DB], str(tmp_ex).rstrip('\n'), DB
> >  LOG.debug (' '.join(STR))
> >  ...
> >
> >
> > This code was working for a few months.
> > Just recently I get "ORA-28000: the account is locked" (logged to a file using tmp_ex) while connecting to the database
> > but I still get a result from 'select ...' (!!!).
> > When I try to connect to this database using sqlplus I am also able to connect and get
> > a result.
> >
> > Can anybody explain what is going on ?
> 
> Your code has a loop to connect to several databases and perform the same query.
> Surely the result you get comes from the previous iteration of the loop?

You are right - thank you :-)

Regards
Przemyslaw Bak (przemol)
--
http://przemol.blogspot.com/





























-------------------------------------------------	
Wygraj 300 zl na paliwo!
Sprawdz &#187; http://linkint.pl/f2960

Re: [cx-oracle-users] ORA-28000: the account is locked - but it works

[Amaury F. d'A. <ama...@gm...>]

Hi,

2011/4/6  <prz...@po...>:
> Hello,
>
> I have the following code running on CentOS 5.5 + cx_Oracle-5.0.4-1:
>
>  ...
>  for DB in config['main']['databases'].split():
>      try:
>          con = cx_Oracle.connect(<user>/<pass>)
>          cs = con.cursor()
>          cs.execute ("select 1 from dual")
>          con.rollback ()
>          con.close()
>      except cx_Oracle.Error as ex:
>          tmp_ex = ex
>          # log tmp_ex to file ...
>  ...
>  STR = DATE_TMP.strftime("%Y-%m-%d %H:%M:%S"), STATUS[DB], str(tmp_ex).rstrip('\n'), DB
>  LOG.debug (' '.join(STR))
>  ...
>
>
> This code was working for a few months.
> Just recently I get "ORA-28000: the account is locked" (logged to a file using tmp_ex) while connecting to the database
> but I still get a result from 'select ...' (!!!).
> When I try to connect to this database using sqlplus I am also able to connect and get
> a result.
>
> Can anybody explain what is going on ?

Your code has a loop to connect to several databases and perform the same query.
Surely the result you get comes from the previous iteration of the loop?


-- 
Amaury Forgeot d'Arc

[cx-oracle-users] ORA-28000: the account is locked - but it works

[<prz...@po...>]

Hello,

I have the following code running on CentOS 5.5 + cx_Oracle-5.0.4-1:

  ...
  for DB in config['main']['databases'].split():
      try:
          con = cx_Oracle.connect(<user>/<pass>)
          cs = con.cursor()
          cs.execute ("select 1 from dual")
          con.rollback ()
          con.close()
      except cx_Oracle.Error as ex:
          tmp_ex = ex
          # log tmp_ex to file ...
  ...
  STR = DATE_TMP.strftime("%Y-%m-%d %H:%M:%S"), STATUS[DB], str(tmp_ex).rstrip('\n'), DB
  LOG.debug (' '.join(STR))
  ...


This code was working for a few months.
Just recently I get "ORA-28000: the account is locked" (logged to a file using tmp_ex) while connecting to the database
but I still get a result from 'select ...' (!!!).
When I try to connect to this database using sqlplus I am also able to connect and get
a result.

Can anybody explain what is going on ?


Regards
Przemyslaw Bak (przemol)
--
http://przemol.blogspot.com/





























-------------------------------------------------
Jedz te potrawy, aby uchronic sie przed rakiem!
Sprawdz  >> http://linkint.pl/f2946

[cx-oracle-users] cx_Oracle 5.1, LONG columns and unicode

[Walter D. <wa...@li...>]

Hello all!

I'm currently trying to port ll.orasql 
(http://www.livinglogic.de/Python/orasql/) to cx_Oracle 5.1. Previously 
(i.e. with cx_Oracle 5.0.4) ll.orasql was using cx_Oracle in UNICODE mode.

I'm having trouble getting proper unicode data out of LONG columns. I'm 
using the outputtypehandler Anthony demonstrated in

 
http://sourceforge.net/mailarchive/forum.php?thread_name=ijo3ea%246am%241%40dough.gmane.org&forum_name=cx-oracle-users

like this:

import cx_Oracle

def OutputTypeHandler(cursor, name, defaultType, size, precision, scale):
    if defaultType in (cx_Oracle.STRING, cx_Oracle.FIXED_CHAR):
       return cursor.var(unicode, size, cursor.arraysize)

db = cx_Oracle.Connection("user/password@...")
db.outputtypehandler = OutputTypeHandler

c = db.cursor()

src = u"create or replace view evil as {}".format(
    u" union all ".join(
       u"select '{}' as a from dual".format(u"\u3042"*250) for i in 
xrange(250)
    )
)

c.execute(src)

c.execute("select text from user_views where view_name='EVIL'")

d = c.fetchone()[0]

if isinstance(d, str):
    print type(d), len(d), len(d.decode("utf-8"))
else:
    print type(d), len(d.encode("utf-8")), len(d)

This gives me the output

    <type 'str'> 196239 71239

i.e. the data I get is an 8bit string. When I change OutputTypeHandler 
to this:

def OutputTypeHandler(cursor, name, defaultType, size, precision, scale):
    if defaultType in (cx_Oracle.STRING, cx_Oracle.FIXED_CHAR, 
cx_Oracle.LONG_STRING):
       return cursor.var(unicode, size, cursor.arraysize)

I get

    <type 'unicode'> 65535 23787

i.e. I get unicode output, but the data seems to be truncated to 64K of 
encoded bytes.

(BTW, the database encoding is utf-8, i.e.

   select value from nls_database_parameters
   where parameter='NLS_CHARACTERSET';

returns AL32UTF8)

What am I doing wrong?

Servus,
    Walter

Re: [cx-oracle-users] 11g Continuous Qurey Notification

[Ulherr, C. <chr...@te...>]

Hi, thanks for the feedback. Let me explain a little further the new functionality available in 11g, and how that differs from what cx_Oracle currently offers.

In 10g, we have something called DCN / OCN (Database Change Notification / Object Change Notification). For the purposes of this discussion, we will consider these two terms synonymous. This is what cx_Oracle currently implements. You resister a query against an object, and then get notified when that object is modified. For example, if we had:

create table t (x int);

You could register queries like:
select * from t
select * from t where x > 10
select * from t where x < 3


For DCN, all of the above registrations produce the same result. The predicate is basically irrelevant in this case. Even if we register with "where x > 10", and then the value 1 is inserted into t, we will still get notified.


In 11g, we have an enhancement to DCN whereby we can ask to be notified only if the *result set* of the query changes. This functionality is named Query Result Change Notification (QRCN). In this case, the predicates matter. If we register "select * from t where > 10", then we do not expect to get notifications if the values 1, 2 or 3 are inserted into t, but do expect to get notified if the value 15 is inserted, for example.


At a deeper level, here's how it's implemented in OCI:

If you look at the source code of cx_Oracle, in the file Subscription.c, you will see a lot of OCIAttrSet() calls on OCI_HTYPE_SUBSCRIPTION, like:

    status = OCIAttrSet(self->handle, OCI_HTYPE_SUBSCRIPTION,
            (dvoid*) &self->namespace, sizeof(ub4), OCI_ATTR_SUBSCR_NAMESPACE,
            env->errorHandle);


For QRCN, there is a new attribute named OCI_ATTR_SUBSCR_CQ_QOSFLAGS that can be set in a similar manner to indicate "we would like to be notified when the result-set changes, instead of at the object level". For example, from Oracle's 11.2 documentation:



     checker(errhp, OCIAttrSet (subscrhp, OCI_HTYPE_SUBSCRIPTION,
                  (dvoid *)&qosflags, sizeof(ub4),
                  OCI_ATTR_SUBSCR_CQ_QOSFLAGS, errhp));


The qosflags would be set to OCI_SUBSCR_CQ_QOS_QUERY, and optionally or'ed with OCI_SUBSCR_CQ_QOS_BEST_EFFORT (described further in the Oracle documentation). From a Python perspective, this would likely be an added option to the existing subscribe() method (much like the current  rowids = True option, you could have a qrcn = True option to specify this behavior at subscription time).


I'm not sure how straightforward this would be to add to cx_Oracle. This new attribute is only available in 11g, so it would seem some conditional compilation would be necessary (i.e. if compiling against 10g OCI headers, skip this part).

Hope this helps to clear things up.

-----Original Message-----
From: Anthony Tuininga [mailto:ant...@gm...] 
Sent: Friday, April 01, 2011 9:07 PM
To: cx-...@li...
Subject: Re: [cx-oracle-users] 11g Continuous Qurey Notification

Hi, as far as I know in 11g Release 2 the same interface in cx_Oracle is only able to use query change notification. It seems impossible to use object change notification -- but perhaps I don't understand how to switch between the two. In any case, I believe if you register a query you will get what you are expecting. If not, let me know what you are hoping to do and I'll see what I can do to help.

Anthony

On Fri, Apr 1, 2011 at 3:16 PM, Ulherr, Chris <chr...@te...> wrote:
> I've noticed cx_Oracle has support for Database Change Notification 
> (aka object change notification in 11g), but not new 11g features like 
> Query Result Change Notification (similar, but not the same as DCN/OCN).
>
>
>
> Are there any plans to implement this in cx_Oracle?
>
> ----------------------------------------------------------------------
> -------- Create and publish websites with WebMatrix Use the most 
> popular FREE web apps or write code yourself; WebMatrix provides all 
> the features you need to develop and publish your website. 
> http://p.sf.net/sfu/ms-webmatrix-sf
>
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>

------------------------------------------------------------------------------
Create and publish websites with WebMatrix Use the most popular FREE web apps or write code yourself; WebMatrix provides all the features you need to develop and publish your website. http://p.sf.net/sfu/ms-webmatrix-sf
_______________________________________________
cx-oracle-users mailing list
cx-...@li...
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

Re: [cx-oracle-users] 11g Continuous Qurey Notification

[Anthony T. <ant...@gm...>]

Hi, as far as I know in 11g Release 2 the same interface in cx_Oracle
is only able to use query change notification. It seems impossible to
use object change notification -- but perhaps I don't understand how
to switch between the two. In any case, I believe if you register a
query you will get what you are expecting. If not, let me know what
you are hoping to do and I'll see what I can do to help.

Anthony

On Fri, Apr 1, 2011 at 3:16 PM, Ulherr, Chris
<chr...@te...> wrote:
> I've noticed cx_Oracle has support for Database Change Notification (aka
> object change notification in 11g), but not new 11g features like Query
> Result Change Notification (similar, but not the same as DCN/OCN).
>
>
>
> Are there any plans to implement this in cx_Oracle?
>
> ------------------------------------------------------------------------------
> Create and publish websites with WebMatrix
> Use the most popular FREE web apps or write code yourself;
> WebMatrix provides all the features you need to develop and
> publish your website. http://p.sf.net/sfu/ms-webmatrix-sf
>
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>

[cx-oracle-users] 11g Continuous Qurey Notification

[Ulherr, C. <chr...@te...>]

I've noticed cx_Oracle has support for Database Change Notification (aka object change notification in 11g), but not new 11g features like Query Result Change Notification (similar, but not the same as DCN/OCN).

Are there any plans to implement this in cx_Oracle?

Re: [cx-oracle-users] Long values ...

[Jani T. <re...@gm...>]

Could you provide some more information DDL & DML + server version you're 
using since there is few known bugs in certain Oracle versions regarding 
similiar issues.

-- 

Jani Tiainen

On Friday 01 April 2011 13:01:13 Roger Wenham wrote:
> Hi,
> 
> I am occasionally getting the database error:
> 
>      ORA-01461: can bind a LONG value only for insert into a LONG column
> 
> The table the code is updating only has varchar2 and number columns.
> 
> I my only guess is that there is something in one of the strings that is
> causing cx_Oracle to treat it as a LONG, even though the column is
> something else....
> 
> What would cause cx_Oracle to try and treat one of the variables variable
> as a LONG?
> 
> Any help or pointers would be greatly appreciated....
> 
> Roger
> --
> Mit freundlichen Grüßen
> 
> Roger Wenham
> tomaxx GmbH
> 
> Max-Planck-Strasse 3
> D-85609 Aschheim
> Germany
> 
> Phone:    +49-89-959892-16
> Fax:      +49-89-959892-29
> 
> e-Mail:   Rog...@to...
> 
> 
> ---------------------------------------------------------------------------
> -- Geschaeftsführer/CEO: Alexander Keller, Ilan Sikary
> Sitz/Domicile: Aschheim
> Amtsgericht/Local Court: München/Munich
> HRB-Nr./Commercial Register No.: 124261
> ---------------------------------------------------------------------------
> --
> 
> This e-mail message and any attachments may contain confidential,
> proprietary or non-public information. This information is intended solely
> for the designated recipient(s). If an addressing or transmission error
> has misdirected this e-mail, please notify the sender immediately and
> destroy this e-mail. Any review, dissemination, use or reliance upon this
> information by unintended recipients is prohibited. Any opinions expressed
> in this e-mail are those of the author personally.
> 
> 
> ---------------------------------------------------------------------------
> --- Create and publish websites with WebMatrix
> Use the most popular FREE web apps or write code yourself;
> WebMatrix provides all the features you need to develop and
> publish your website. http://p.sf.net/sfu/ms-webmatrix-sf
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

[cx-oracle-users] Long values ...

[Roger W. <rog...@to...>]

Hi,

I am occasionally getting the database error:

     ORA-01461: can bind a LONG value only for insert into a LONG column

The table the code is updating only has varchar2 and number columns.

I my only guess is that there is something in one of the strings that is causing cx_Oracle 
to treat it as a LONG, even though the column is something else....

What would cause cx_Oracle to try and treat one of the variables variable as a LONG?

Any help or pointers would be greatly appreciated....

Roger
--
Mit freundlichen Grüßen

Roger Wenham
tomaxx GmbH

Max-Planck-Strasse 3
D-85609 Aschheim
Germany

Phone:    +49-89-959892-16
Fax:      +49-89-959892-29

e-Mail:   Rog...@to...


-----------------------------------------------------------------------------
Geschaeftsführer/CEO: Alexander Keller, Ilan Sikary
Sitz/Domicile: Aschheim
Amtsgericht/Local Court: München/Munich
HRB-Nr./Commercial Register No.: 124261
-----------------------------------------------------------------------------

This e-mail message and any attachments may contain confidential,
proprietary or non-public information. This information is intended solely
for the designated recipient(s). If an addressing or transmission error
has misdirected this e-mail, please notify the sender immediately and
destroy this e-mail. Any review, dissemination, use or reliance upon this
information by unintended recipients is prohibited. Any opinions expressed
in this e-mail are those of the author personally.

[cx-oracle-users] AUTO: Toby Mathieson is out of the office. (returning 03/30/2011)

[<Tob...@ce...>]

I am out of the office until 03/30/2011.

I will respond to your message when I return.


Note: This is an automated response to your message  "Re: [cx-oracle-users]
Contents of cx-oracle-users digest..." sent on 3/26/2011 3:38:24 AM.

This is the only notification you will receive while this person is away.