Highlighted
New Member.
248 views

.net Protocol - 2 Tier application with oracle db - 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.

0 Likes
2 Replies
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: .net Protocol - 2 Tier application with oracle db - ORA-12560: TNS:protocol adapter error

Seems like the LoadRunner protocol you should use is Oracle 2-tier and not .Net protocol.

It seems like you want to test the database work, and for that you need a database protocol.

Please reply if I miss understood your use case.

Gil

0 Likes
Highlighted
New Member.

Re: .net Protocol - 2 Tier application with oracle db - ORA-12560: TNS:protocol adapter error

Thanks for your reply Gil.

However, I tried with Oracle 2tier protocol . It threw many errors like the following :

undeclared identifier `OraLob0'
type error in argument 2 to `lrdfnc_assign'; found `int' expected `const pointer to const char'
type error in argument 2 to `lrdfnc_assign'; found `int' expected `const pointer to const char'
type error in argument 2 to `lrdfnc_assign'; found `int' expected `const pointer to const char'
type error in argument 2 to `lrdfnc_assign'; found `int' expected `const pointer to const char'
type error in argument 2 to `lrdfnc_assign'; found `int' expected `const pointer to const char'
type error in argument 2 to `lrdfnc_assign'; found `int' expected `const pointer to const char'
type error in argument 2 to `lrdfnc_assign'; found `int' expected `const pointer to const char'
type error in argument 2 to `lrdfnc_assign'; found `int' expected `const pointer to const char'
type error in argument 2 to `lrdfnc_assign'; found `int' expected `const pointer to const char'
type error in argument 2 to `lrdfnc_assign'; found `int' expected `const pointer to const char'
type error in argument 2 to `lrdfnc_assign'; found `int' expected `const pointer to const char'
type error in argument 2 to `lrdfnc_assign'; found `int' expected `const pointer to const char'
type error in argument 2 to `lrdfnc_assign'; found `int' expected `const pointer to const char'
type error in argument 2 to `lrdfnc_assign'; found `int' expected `const pointer to const char'
type error in argument 2 to `lrdfnc_assign'; found `int' expected `const pointer to const char'
type error in argument 2 to `lrdfnc_assign'; found `int' expected `const pointer to const char'
type error in argument 2 to `lrdfnc_assign'; found `int' expected `const pointer to const char'
type error in argument 2 to `lrdfnc_assign'; found `int' expected `const pointer to const char'
type error in argument 2 to `lrdfnc_assign'; found `int' expected `const pointer to const char'
too many errors

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.