Getting error while connecting with Spotlight Oracle...
ORA 12154 TNS. could not resolve the connect identifier specified
Also referenced as:
Tried to configure Spotlight but keep getting errors, ORA-12154 and than ORA-12504.
1. There are multiple Oracle clients installed on the client PC, and the default client is pointing to the wrong Oracle Home
2. Spoltight using a 10g client and installed on a path with a bracket on it (for example c:\Program Files(x86) ...)
1. Use the Oracle Home selector in the connection profile to point Spotlight to the correct Oracle Home (ie Right click the connection profile in Connection Manager and select Properties to see the profile details, then in the Oracle Home field select the correct Oracle home).
2. Use an Oracle client 11 or install Spoltight on a path without a bracket on it
