Hello,
We are using an ASP.NET application and have recently switched from ODP.NET unmanaged data access to managed data access.
We have an environment with a windows server and a 10g (10.2.0.5.0) Oracle database on it. It works like a charm with the ManagedDataAccessÂ.
We have another environment on a sun solaris and also a 10g (10.2.0.4.0) Oracle database. It works well with unmanaged and also with SQL*plus, but there's no way that it will work with Managed data access, We are first getting an error ORA-03135 Connection lost contact, then if we retry we get a ORA-12537 Network Session end of file.
There's no firewall or antivirus that could interfere.
We found the following article, stating that the managed provider only works with a Windows database server. Can we get a official confirmation of that ?
http://docs.oracle.com/cd/E51173_01/win.122/e17732/featConfig.htm#ODPNT8163
- ODP.NET, Managed Provider only supports the ASO NTS authentication adapter. The database server must be on Windows, support NTS external authentication, and have
SQLNET.AUTHENTICATION_REQUIRED set to true, 1, or on. The ODP.NET, Managed Driver client must utilize NTS external authentication as well. All other ASO NTS connection scenarios will fail since the client and server will not be able to agree on an ASO authentication mechanism.