Connecting to Oracle 11.2g Database from Team Studio fails with an error

Connecting to Oracle 11.2g Database from Team Studio fails with an error

book

Article ID: KB0076334

calendar_today

Updated On:

Products Versions
Spotfire Data Science Team Studio 6.5.0

Description

When trying to create an Oracle Data Source, nothing happens after we press the connect button. Team Studio production.log captures the following error message:
==========
Oracle error code type = DATABASE_MISSING
Oracle error code = 12514

==========
User-added image

 

Issue/Introduction

Connecting to Oracle 11.2g Database from Team Studio fails with an error "Oracle error code type = DATABASE_MISSING and Oracle error code = 12514"

Resolution

Oracle error code 12514 means that a listener received a request to establish a connection to a database or other service and that the listener does not know the actual name of the serve requested.

When creating the Oracle Data Source connection, we need to ensure the Database Name matches the SID or Service_Name for the Oracle 11.2g Database.  We can locate the SID by located the following file, tnsnames.ora.  DIR: $ORACLE_HOME/11.2.0/dbhome_2/NETWORK/ADMIN (might be different for each installation)
User-added image

Additional Information

Reference:
www.ibm.com/support/pages/ora-12514-tnslistener-does-not-currently-know-service-requested-connect-descriptor#:~:targetText=The%20error%20ORA%2D12514%20means,a%20database%20or%20other%20service.&targetText=This%20may%20be%20a%20temporary,has%20registered%20with%20the%20listener.

www.codeproject.com/Questions/680942/how-to-resolve-error-ORA-12514-TNS-listener-does-n