The following exception is very common type of exception for
.net developer and oracle user.
ORA-12154:TNS:could not resolve the connect
identifier specified
Especially when you are using Oracle Data Provider for .Net
and getting the above exception because of wrong connection string. So whenever
you are using ODP you must following the connection string in the following
pattern.
string connString = "user id=*****;password=*****;data
source=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= IP Address or Host
Name)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME= *****)));";
oracleConnection1.ConnectionString = connString;
oracleConnection1.Open();