IBM Support

Importing a connection profile throws error ORA-12154: TNS:could not resolve the connect identifier specified

Troubleshooting


Problem

Trying to import a connection profile on ClearQuest Maintenance Tool throws the error mentioned below:
image-20230209123619-1
Even if you try to connect to the concerned Oracle database through PDSQL, it throws same error as mentioned below:
pdsql -v ora -db <Oracle database name> -s <Oracle server name> -u ******* -p ******** -co "<connect options>"
EXCEPTION: [Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
State: 08004 Native: 12154
Connect String used: DRIVER={CCM Oracle Native Client};UID=<Oracle db user>;PWD=******************;DBQ=<Oracle database name>

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"ARM Category":[{"code":"a8m0z000000boYlAAI","label":"ClearQuest-\u003EAdministration-\u003EMaintenance Tool"}],"ARM Case Number":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions"}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
09 February 2023

UID

ibm16953391