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.
Solved
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.
+12- 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.
+12- 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\ADMINReply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.