web analytics

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

Options

codeling 1599 - 6654
@2017-04-06 09:21:25

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.

@2017-04-06 09:28:53

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;....

@2018-07-03 09:01:48

 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

Comments

You must Sign In to comment on this topic.


© 2024 Digcode.com