posted 17 years ago
In our production environment, we had set up SAS 8.1 to work with OCI (InstantClient 10.2) and successfully configured the datasource and connection pools.
However, we are intermittenly experiencing ORA-03135 - Connection lost contact error - when our application tries to get connection and execute some query. And then the subsequent attempts would produce ORA-03114 - not connected to oracle error. If we try again later, the problem goes away and everything works fine.
The weird thing is that we can still ping the datasource from the admin console without problem while we experience this error from the application. So I don't think there is any problem with the oracle server.
Any idea what might be happening here?
Thanks for any help.
