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