[Zope] Z Oracle Database Connections

[John Wormington]

I have a question about Z Oracle Database Connections.  I am the unhappy
owner of a new responsibility of maintaining an existing install of Zope.
Originally it was working fine and now the connections drop one by one and
will not come back up.  Through a manage screen I can see that the
connection is closed.  I can click on the Open Connection button but it
errors.  The error is as follows:

********************************
Your action caused an unknown error to occur.
<!--
Error Type: BadRequest


Traceback:
Traceback (innermost last):
  File /mnt/disk1/Z1/Z3/lib/python/ZPublisher/Publish.py, line 171, in
publish
  File /mnt/disk1/Z1/Z3/lib/python/ZPublisher/mapply.py, line 160, in mapply
    (Object: manage_open_connection)
  File /mnt/disk1/Z1/Z3/lib/python/ZPublisher/Publish.py, line 112, in
call_object
    (Object: manage_open_connection)
  File /mnt/disk1/Z1/Z3/lib/python/Shared/DC/ZRDB/Connection.py, line 220,
in manage_open_connection
    (Object: RoleManager)
  File /mnt/disk1/Z1/Z3/lib/python/Shared/DC/ZRDB/Connection.py, line 240,
in connect
    (Object: RoleManager)
  File /mnt/disk1/Z1/Z2/lib/python/Products/ZOracleDA/db.py, line 124, in
__init__
  File /usr/local/lib/python1.5/site-packages/DCOracle/ocidb.py, line 77, in
__init__
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?  

The only luck that I have had was by bouncing the servers they will all come
up fine, but then after a matter of minutes they all drop one by one again.
The tnsnames.ora file has not changed location and (I hate when people say
this because I doubt them) nothing has changed that I am aware of.  It just
started dropping the connections.

Any help is greatly appreciated.  Thanks in advance

-John Wormington