• EN
Solved

Error Message ora-12154 when trying to connect to Oracle.

  • 3 April 2018
  • 2 replies
  • 24 views
L
Badge

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.

icon

Best answer by steveatsafe 3 April 2018, 01:45

View original
1 Attachment

2 replies

steveatsafe
Rank
Userlevel 1
Badge +11

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.

SteveatSafe
steveatsafe
Rank
Userlevel 1
Badge +11

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

SteveatSafe

Reply


Community Stats

28,866
Posts
109,982
Replies
36,671
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.