We are having an intermittant problem with the logger environment for IS 4.6. We are running against an Oracle 220.127.116.11 database, using com.merant.sequelink.jdbc.SequeLinkDrive (4.6.035) for the Logger Adapter.
This is the intermittant error we are getting:
[Debug] 0 println In adapterStartup(). Database exception: In EIProcess.init(). Unable to connect to the database: Error Message: [MERANT][SequeLink JDBC Driver][Oracle]ORA-12154: TNS:could not resolve service name
Now, the problem is that we can access the userid and database just fine at the sqlplus level when this error occurs using the Oracle TNS access method. So the DBAs always tell us that is not the problem. We end up having to restart the drivers.
So has anyone come across this problem and a way to resolve it?