SO I figured I’ll post a quick solution to this problem that had been troubling me today.

I have a .Net application connecting to an Oracle Database. I have installed the ODP.Net data connection libraries. I created the Oracle connection successfully within Entity Framework, and used LINQ to retrieve the data. All is well… until this solution is deployed this onto a server…

ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

(continue reading…)