[Zope-DB] DCOralcle2 "Invalid connection string"

[Matthew T. Kromer]

This is probably a permissions problem with the ORACLE_HOME directory.


On Dec 1, 2004, at 12:21 PM, Emily Stumpf wrote:

> Greetings,
>
> I need to get DCOracle2 working in zope and its not. :(
>
> Finally I was able to get sqlplus on the webserver to connect 
> successfully to my DB (not on the local machine) when I figured out 
> that it was looking for tnsnames.ora in a slightly different place 
> then I had it..
>
> Okay, so here's the problem in zope:
>
> When I try to create a DCOracle2 connection with connection string in 
> this format login/password at DB where DB is set in tnsnames.ora (located 
> in $ORACLE_HOME/network/admin/tnsnames.ora and now also in 
> /etc/tnsnames.ora :P), I get "Invalid connection string"
>
> Ok, and I just now noticed that sqlplus works with that connection 
> string when ORACLE_HOME is Not set, but when I set it, it says:
>
> SP2-0642: SQL*Plus internal error state 2165, context <bignumber>:0:0
> Unable to proceed
>
> ?? Ahh :( What a mess..
>
> Some information about this system:
> OS: Linux Redhat Enterprise Workstation 3 Update 2 (2.4.21-20.EL)
>
> DCOracle2 version: Tried with 1.3beta, and trying now with 1.2 but 
> same problems.
>
> Oracle: Oracle10g-basic-instantclient+some additional header files 
> from a full Oracle 10g install from a different machine. So 
> ORACLE_HOME is located in: /usr/lib/oracle/10.1.0.2/client and it 
> contains the following directories:
> bin lib network rdbms
>
> rdbms was the directory of header files and contains a dir called 
> public with a bunch of .h files.
>
> How I compiled dco2.so:
> For awhile I had trouble with getting this to compile at all. I think 
> the combination that caused it to compile was putting that rdbms dir 
> in $ORACLE_HOME, in src/dco2.c changing all instances of "dword *" to 
> "dvoid *" and running "python setup.py install".
>
> Was trying to test it with test/test1.py which I modified to:
> import dco2
> db=dco2.connect("username","pw","DB")
>
> and I always get:
> OCIEnvCreate failed: src/dco2.c:1497Traceback (most recent call last):
>   File "test1.py", line 3, in ?
>     db = dco2.connect("username","pw","DB")
> dco2.DatabaseError: (67, '\xe0\xebV\xb7\xe0\xebV\xb7')
>
> Interesting is if I run zope from /usr/local/zope/instance/bin/runzope 
> I get
>
> OCIEncCreate failed: src/dco2.c 1497
>
> If anyone has any ideas, or if I should have given some information 
> that I didn't please let me know asap.
>
> Thanks!
> -- Emily
> _______________________________________________
> Zope-DB mailing list
> Zope-DB at zope.org
> http://mail.zope.org/mailman/listinfo/zope-db