Antwort: Re: Antwort: Re: Antwort: Re: [Zope-DB] DCOracle2 - Invalid connection string
Mon, 3 Dec 2001 15:19:53 +0100

see my comments,
excuses for my ugly reply but I have to use lotus notes...

Dario Lopez-K=E4sten <> am 03.12.2001 10:56:44

Kopie:  (Blindkopie: Carsten Hoff/BASF-IT-S/BASF)
Thema: Re: Antwort: Re: Antwort: Re: [Zope-DB] DCOracle2 - Invalid
       connection string

From: <>

> Hi Matthew,
> calling /etc/rc.d/init.d/zope start as root does not change anything =
> I misunderstanding your request to start it manually, I did not find =
> other start script).

zstart in the zope-directory

zstart does not exist??!

> 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
> tnsname.ora and sqlnet.oras. The instance I want to connect is an 8.1=
> installation on a hpux node in the same network (using tcp as connect=

> mode).

ok, checklist (sorry if they sound obvious, but i list them so we can
eliminate error sources):

1) are you trying sqlplus on the machine where Zope is installed?
   and is the connections succesfull (i.e. you can run a query)
   are you using the same shemaname as zope is to connect to th db?
Yes, yes, yes.

2) are you trying sqlplus as the user zope runs as?
   (i.e. has root got the proper environment to do sqlqueries?
    if you are running form init.d, and it chroots to nobody,
    has nobody access to the oracle environment)
I have tried to run sqlplus as root with manual setted env for oracle -=
then I have started with the same user in the same env zope with the zo=
script under /etc/rc.d/init.d

3) in the connectstring, user/pwd@<tnsname>, is <tnsname> exactly
   the string that identifies that source?

4) have you got several oracle products installed? if so are you
   sure that zope is using the proper environment?

there, I am all out of ideas to try.

hope this helps,

Currently I am wondering, where I have to set the ORACLE_HOME,
I have set them in the zope script /etc/...
Uncommenting these environment parameters lead to an error in the produ=
So I assume this place could not be so wrong (or should I use

Thanks for any hints


Note to Matthew:

Oracle is our standard datbase. We use it to keep *ALL* our content
and then some in it. All we use zope for is the application logic.

I guess that we could pass as heavy duty users of DCO2 and oracle.

the application we are building is a HA Student/Staff university
portal and Learning Managemnet System, that ideally is going to
save money and free time, while expanding the service level to both
students and staff and providing new services not previously possible.
- --------------------------------------------------------------------
Dario Lopez-K=E4sten     Systems Developer  Chalmers Univ. of Technolog=
y  ICQ will yield no hits    IT Systems & Services

Zope-DB mailing list