Antwort: Re: [Zope-DB] DCOracle2 - Invalid connection string
Fri, 30 Nov 2001 16:31:11 +0100

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
same 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
the following way:

--- schnipp ----
export ORACLE_HOME=/opt/oracle/OraHome1
export LD_LIBRARY_PATH=/opt/oracle/OraHome1/lib

# make sure starter script exists
--- schnapp ---

is this correct? the product is correct loaded, so I assume this...

Thanks for any other tips

"Matthew T. Kromer" <> am 29.11.2001 23:09:22

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

>Hello together,
>both, compiling or installation of binaries, leads to the following prob.
>Test scripts say connection successfully tested.
>But inside Zope the Connection method gives:
>invalid connection string.
>env for ORACLE_HOME and LD_LIBRARY_PATH are set in the zope start script.
>System RH7.1 both python 1.5.2 and 2.1, Oracle Client 8.1.7.,
>DCOracle2-PR1.tar.gz, Zope 2.4.3.
>What am I doing wrong
>TIA carsten

Did I ever get back to you on this, Carsten?

Anyway, most of this time it has to do the the Oracle naming services,
ie sqlnet.ora and tnsnames.ora.  Often the installer put in a
NAMES.DEFAULT_DOMAIN in the sqlnet.ora, but the name is unqualified in

Usually there's like a sqlnet.log file generated when the name isn't
being resolved properly.