Error: ORA-12514: TNS: Listener Does Not Currently Know of Service Requested in Connect Descriptor


When adding an oracle database to Pyramid as a MashPit data source,

The following error is shown when testing the connection:

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


Check that the details that have been entered into the Pyramid Admin work when connecting directly to the Oracle database using the Oracle SQL Developer, see the example below:

 If the connection does not work directly, or is not in the below format, your database admin should be consulted as to the correct syntax to use.

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 3 wk agoLast active
  • 1172Views
  • 1 Following