Other HPE Product Questions
Showing results for 
Search instead for 
Did you mean: 

C#.Net Protocol -(ORA-12560: TNS:protocol adapter error) -

New Member

C#.Net Protocol -(ORA-12560: TNS:protocol adapter error) -

This query is about Loadrunner - .net protocol . We have application built using C# ( framework 4.6.2) and communicating with Oracle DB version 11g. 

While recording and replay we are getting below error.

Error: Action.cs(8154): YYYY.Common.Core.DataAccess.YYYYDataAccessException: An unexpected error occurred while attempting to connect to the database (). Database error message: (ORA-12560: TNS:protocol adapter error). If the inner exception is a timeout, it is possible that the thread-pool is exhausted due to clients not calling Dispose() on returned OracleConnection objects. To fix this, find usages of this method and ensure they clean up correctly. ---> Oracle.DataAccess.Client.OracleException: ORA-12560: TNS:protocol adapter error
at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src)
at Oracle.DataAccess.Client.OracleConnection.Open()
at YYYY.Common.Core.DataAccess.YYYYDatabaseConnectionManager.CreateOracleDatabaseConnection()
--- End of inner exception stack trace ---
at YYYY.Common.Core.DataAccess.YYYYDatabaseConnectionManager.CreateOracleDatabaseConnection()
at YYYY.XXX.Core.DataAccess.XXXOracleConnectionManager.CreateOracleConnection()
at YYYY.XXX.Core.DataAccess.XXXOracleConnectionManager.BeginTransaction()
at YYYY.XXX.Core.DataAccess.XXXTableFiller`1.Fill(KeyValuePair`2[] paramValues)
at YYYY.XXX.Core.DataAccess.Security.UserBranchSetManager.GetAll()
at Script.VuserClass.Action() in C:\Software\XXX\TEST2\XXX2\Action.cs:line 8154

We tried many options but no success. Please suugest any apt solution.

If this is not right forum for Loadrunner queries please help in posting at right forum.



Community Manager

Re: C#.Net Protocol -(ORA-12560: TNS:protocol adapter error) -

Hi Amit,

Loadrunner is part of a different company named " Micro Focus " . So you will need to repost your question to the Micro Focus Community at https://community.softwaregrp.com/ 

I work for HPE
[Any personal opinions expressed are mine, and not official statements on behalf of Hewlett Packard Enterprise]