[Zope] Z Oracle Database Connections

[John Wormington]

-----Original Message-----
From: Oleg Broytmann [mailto:phd@phd.fep.ru]
Sent: Tuesday, June 26, 2001 10:31 AM
To: John Wormington
Cc: 'zope@zope.org'
Subject: Re: [Zope] Z Oracle Database Connections


On Tue, 26 Jun 2001, John Wormington wrote:
> BadRequest: <strong>Invalid connection string:
> </strong><CODE>username/password@server</CODE><br>
>
> OracleError
> (12154, 'ORA-12154: TNS:could not resolve service name')
> ********************************
>
> Now by looking at it I initially thought that it was an oracle problem.
> However out oracle admin showed me that she could log into that same box
and
> use sqlplus and get data back.  I have to now look into how to trouble
shoot
> either ZOracleDA or DCOracle.  Has anyone ran into these Database
Connection
> strings suddenly failing?

   To start debugging the problem, wrote a simple Python program and try to
connect to the server. Something like this:

**edit, all greek to me**

Oleg.
----
     Oleg Broytmann     http://www.zope.org/Members/phd/     phd@phd.pp.ru
           Programmers don't die, they just GOSUB without RETURN.

Hate to admit to this but I am not very keen on python so you will have to
forgive me.  I could not follow the simple Python program you sent me.
However, I did do some research and found out a little bit about DCOracle.
There is a test script included called DCOracle_test.py that tests the
extensions.
Forgive me if I am being overly simplistic but I am trying my best.  We have
a ZEO server that runs two client servers and a balance server.  In the
ZEO/lib/python/Products/ZOracleDA/src/ there is the DCOracle_test.py script.
When I test using it I see the following:

Import Succeeded
Connect Succeeded

That means that it is working but that does not solve my problem.  When I go
and look at the manage interface for the server the connection is still
closed and errors out on trying to open the connection.  Have any other
ideas on how to trouble shoot this?