web analytics
ORA-12154: TNS:could not resolve the connect identifier specified Options
codeling
Posted: Thursday, April 6, 2017 9:21:25 AM

Rank:Advanced Member
Groups: Member
Joined: 12/11/2015
Posts: 984
Points: 4146

I am getting this error: "ORA-12154 could not resolve the connect identifier specified" when I I am trying access Oracle database using OracleConnection in Visual Studio.

Sponsor
Posted: Thursday, April 6, 2017 9:21:25 AM
codeling
Posted: Thursday, April 6, 2017 9:28:53 AM

Rank:Advanced Member
Groups: Member
Joined: 12/11/2015
Posts: 984
Points: 4146

I had 11g clients installed, I found that the following two environment variables were missing in my computer, after I added them, I can access my Oracle database.

ORACLE_HOME = C:\Ora112

TNS_ADMIN = C:\Ora112\FClient\network\admin

Also, double check the follwing environment variable is there:

PATH = C:\Ora112\FClient\bin;....

codeling
Posted: Tuesday, July 3, 2018 9:01:48 AM

Rank:Advanced Member
Groups: Member
Joined: 12/11/2015
Posts: 984
Points: 4146

 in Windows 7/8/10, open the Control Panel and go to “System and Security - > System.” There, click or tap the “Advanced system settings” link on the left. The System Properties window is opened. There click the Environment Variables button.

environment variables, Windows

Users browsing this topic
Guest

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.


© 2018 Digcode.com. All rights reserved.