000023352 - Oracle collection fail with ORA-12154: TNS:could not resolve the connect identifier specified

Document created by RSA Customer Support Employee on Jun 16, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000023352
IssueOracle collection fail with ORA-12154: TNS:could not resolve the connect identifier specified
Resolution

The most common error is incorrect "Server" value under the ODBC configuration

Start->Programs->Administrative tools-> Data Source ODBC (or the 32bit version on 64 bit OS)

Under the System DSN , the specific Oracle driver , the "Server" is actually an Oracle SID and NOT and IP/HOST name of the Oracle.

If your instance is called Ora1 then the "Server" is Ora1

Legacy Article IDa38556

Attachments

    Outcomes