Thanks for the question, Roberto.
Asked: November 11, 2016 - 4:04 pm UTC
Last updated: November 12, 2016 - 9:28 am UTC
Version: 10.1.2
Viewed 1000+ times
You Asked
Hi, Tom
We have a .NET application in a network path and when the user only have read & execute permission on the folder the connection to the Data Base can't be made, but when the user has also the modify permission the connection can be done.
This is the stack error that shows:
System.Data.OracleClient.OracleException: ORA-12560: TNS:protocol adapter error
at System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc)
at System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
at System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
at System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OracleClient.OracleConnection.Open()
And it only happens in a network path.
Thanks.
and Connor said...
A *client* can also write numerous logs when it connects, eg on my laptop
C:\oracle\diag>dir
Volume in drive C is TI10659400C
Volume Serial Number is 48C3-B1BC
Directory of C:\oracle\diag
20/12/2013 09:36 AM <DIR> .
20/12/2013 09:36 AM <DIR> ..
20/12/2013 09:36 AM <DIR> afdboot
20/12/2013 09:36 AM <DIR> apx
20/12/2013 09:36 AM <DIR> asm
20/12/2013 09:36 AM <DIR> asmtool
07/11/2014 11:02 AM <DIR> clients <<<=====
20/12/2013 09:36 AM <DIR> crs
20/12/2013 09:36 AM <DIR> diagtool
20/12/2013 09:36 AM <DIR> dps
...
<code>
and drilling down into that I see a sqlnet log
<code>
C:\>dir C:\oracle\diag\clients\user_hamcdc\host_2694232435_80\trace
Volume in drive C is TI10659400C
Volume Serial Number is 48C3-B1BC
Directory of C:\oracle\diag\clients\user_hamcdc\host_2694232435_80\trace
17/02/2014 09:15 AM <DIR> .
17/02/2014 09:15 AM <DIR> ..
06/11/2014 04:46 PM 14,415 sqlnet.log
So check your network folder for logging activities. Then consider setting LOG_DIRECTORY_CLIENT to a local file system.