|Issue||Oracle collection fail with ORA-12154: TNS:could not resolve the connect identifier specified|
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 ID||a38556|