Former HPE Products
cancel
Showing results for 
Search instead for 
Did you mean: 

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

 
Patilamit
Occasional Visitor

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.

 

 

1 REPLY 1
Parvez_AL
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/ 

Thanks,
Parvez_AL
I am a HPE Employee
[Any personal opinions expressed are mine, and not official statements on behalf of Hewlett Packard Enterprise]
CM_Cert_Logo_Color.png