ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

During the development of a Sitefinity based application that used an Oracle 11g RDBMS as the data repository I ran into the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I had tested the [...]