ASP .net core time out error using Oracle

asp.net asp.net-core entity-framework-core oracle

Question

I'm new to ASP .Net Core and am working my way through a demo project to learn the tech stack.

My project is using .net core 2.2 and Oracle.ManagedDataAccess.Core and Oracle.EntityFramework.Core.

I created a model and then went and scaffolded my view and controller through VS 2019. I've set up ConfigureService(...) to use Oracle. I added an HTML link on my main index page to hook into the view created for my model. When it calls the Controller::Index() function, I end up getting the following timeout error

OracleException: Connection request timed out OracleInternal.ConnectionPool.PoolManager<PM, CP, PR>.Get(ConnectionString csWithDiffOrNewPwd, bool bGetForApp, OracleConnection connRefForCriteria, string affinityInstanceName, bool bForceMatch)

Any help or guidance as to what I could be doing wrong would be greatly appreciated!

1
0
9/23/2019 12:19:45 AM

Accepted Answer

It looks like a error connecting to the database. There are some things you should check:

  1. Make sure the connection string to the database, stored in the appsettings.json is correct.

  2. Make sure to have a firewall rule which allows inbound traffic to the port from where the Oracle db is listening.

If the problem persists then you should provide the code you are using to access the database.

0
9/23/2019 12:57:22 AM


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow