I am trying to connect to an oracle database. I had a chat with Steve at Safe and I added the connection information in the tnsnames.ora file and added an environmental variable pointing to the tnsnames.ora. I was really hoping that I had done everything that I needed. However, I am still getting the ora-12154 error message. Thank you in advance for your assistance. Attached is the log file from the latest attempt to connect and a screen shot of the environmental variable path.
Best Answer
Error Message ora-12154 when trying to connect to Oracle.
Best answer by steveatsafe
Hi Laura, Oh no - if you are still struggling after all this time lets perhaps have a screen share. Something isn't happy and I'd like to know what that is. What for an email from me.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+13- Safer
- Best Answer
Hi Laura, Oh no - if you are still struggling after all this time lets perhaps have a screen share. Something isn't happy and I'd like to know what that is. What for an email from me.
+13- Safer
Laura and I had a screen share session and with some testing determined the TNS_ADMIN didn't seem to be correctly configured. Even the 64bit tnsping command didn't work. We couldn't confirm the TNS_ADMIN environment variable setting since Laura didn't have Admin privileges to review it.
As noted in Laura's question, this prevented the Full Oracle 64bit client (with no tnsnames.ora file) and FME 64bit from finding the correct tns alias.
As a test, we copied the Full Oracle 32bit client's tnsnames.ora file to the 64bit location and both tnsping and FME were NOW happy.
To circumvent the lack of admin privileges, I had Laura, at the command prompt issue
echo %TNS_ADMIN% and determined (but only after our call and upon further review) that the tnsnames.ora was included in the path:
c:\oracle\product\11.2.0\OraHome112\NETWORK\ADMIN\tnsnames.ora This is incorrect and it should only include the path
c:\oracle\product\11.2.0\OraHome112\NETWORK\ADMIN