ORA-12154: TNS:could not resolve the connect identifier specified Options

codeling Posts: 1057 Points: 4443
Posted: Thursday, April 6, 2017 9:21:25 AM

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.


codeling Posts: 1057 Points: 4443
Posted: Thursday, April 6, 2017 9:28:53 AM

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 Posts: 1057 Points: 4443
Posted: Tuesday, July 3, 2018 9:01:48 AM

 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