Antwort: Re: Antwort: Re: [Zope-DB] DCOracle2 - Invalid connection string
Matthew T. Kromer
Mon, 3 Dec 2001 08:27:28 -0500
On Monday, December 3, 2001, at 04:16 AM, Carsten.Hoff@BASF-IT-
> 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
> start script).
OK, the reason I mention it is that when things are called from init,
they often have subtly different environment variables set, and of
course their stdin, stdout, and stderr are also different.
> I have put on the tracedump and dco2 throws an oci/oracle error
> that it is unable to resolve the services name.
> But calling sqlplus with the same connect string works, so I assume
> 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
OK, do you have ORACLE_SID set in your environment? Normally this
wouldn't matter. What it sounds like is that Oracle isn't seeing the
ORACLE_HOME environment variable properly, and so it can't even look up
the tnsname from the tnsnames.ora.
Also, the last thing to check that has bitten me on a couple of
occasions (and it's usually one where I smack my head into the table for
not thinking of it first) is to make sure that Zope's userid has
permission to read tnsames.ora and sqlnet.ora. Sometimes there is a
directory permission or file permission problem which prevents Zope from
doing this -- particularly if you start Zope as root and then it changes
its userid to "nobody."
> 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.
OK, let me know if I can help further.