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

codeling Posts: 1103 Points: 4638
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: 1103 Points: 4638
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: 1103 Points: 4638
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