Antwort: Re: Antwort: Re: [Zope-DB] DCOracle2 - Invalid connection string
Mon, 3 Dec 2001 10:16:06 +0100

Hi Matthew,
calling /etc/rc.d/init.d/zope start as root does not change anything (or am
I misunderstanding your request to start it manually, I did not find any
other start script).
I have put on the tracedump and dco2 throws an oci/oracle error
(ORA-12154), that it is unable to resolve the services name.
But calling sqlplus with the same connect string works, so I assume correct
tnsname.ora and sqlnet.oras. The instance I want to connect is an 8.1.6
installation on a hpux node in the same network (using tcp as connect
Thanks for any other hints.
For you information:
We are evaluating zope for our internal documention and or cms projects.
Oracle is our favourite DB so we need a possiblity to get data from oracle.

TIA carsten

"Matthew T. Kromer" <> am 30.11.2001 18:53:17

An:    Carsten Hoff/BASF-IT-S/BASF@EUROPE
Thema: Re: Antwort: Re: [Zope-DB] DCOracle2 - Invalid connection string wrote:

>Hi Matthew,
>thanks for your tip, but there is no sqlnet.log indicating a connection
>Is there a place to find other error logs.
>The host name is fully qualified in the tnsnames.ora and I get with the
>connection string a connection with sqlplus for the prompt.
>I have set the environment for zope in the script /ect/rc.d/init.d/zope in
>following way:
>--- schnipp ----
>export ORACLE_HOME=/opt/oracle/OraHome1
>export LD_LIBRARY_PATH=/opt/oracle/OraHome1/lib
># make sure starter script exists
>--- schnapp ---

Aha!  Launching Zope from init can be different -- can you launch Zope
manually and confirm that you still have errors with the connection string?

Also, could you  also

export DCO2TRACEDUMP=/tmp/dco2.tracedump

before starting Zope, and send me the tracedump file it writes to tmp?
 Zope can say "invalid connection string" even when the Oracle
connection string is good -- it can cover up other errors that occured
while trying to connect.

Also, because I'm curious, do you mind letting me know how you're using
Zope and DCO2?  I like to have a notion of how people are using the