Why do I receive an ODBC connection failure (SQLSTATE=S1000, Native Error=12514) when trying to add a server in the CA Database Command Center portal?

Document ID : KB000055515
Last Modified Date : 14/02/2018
Show Technical Document Details

IBM Description of error:
IBM_ERROR_ODBC_CONNECT_FAILED ODBC Connection failed
SQLSTATE=S1000, Native Error=12514: CAI/PT ODBC Oracle 8 driver: Oracle ORA-12514 TNS: listener does not currently know of service requested in connect descriptor.

What it means for Database Command Center :
This error is an Oracle ORA-12514 error which is generated when a connection to a database or other service was requested using a specified connect identifier which could not be resolved into a connect descriptor using the naming methods. This is how to resolve:

  1. Verify there is a tnsnames.ora file and note it's location
  2. Check the net service name used as the connect identifier exists in the tnsnames.ora file
  3. Make sure there are no syntax errors anywhere in the tnsnames.ora file. Look for unmatched parentheses or stray characters
  4. Locate the sqlnet.ora file and verify that TNSNAMES.ORA is one of the parameters of NAMES.DIRECTORY_PATH