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

SOLUTION:

The reason for this error is connection identifier is not specified in the connection descriptor list so the connect identifier could not be resolved For Ex.if i use the type of connection identifier service name is BUSINESS if this name is not specified/configured in the namings list you will get this error.

Basically naming configured in three ways :
1.Directory naming.
2.Local naming(TNSNAMES.ORA file).
3. Easy connect naming.

SOLUTION IF YOU ARE USING Directory Naming:

>Check whether "LDAP" is listed as one of the values of the NAMES.DIRETORY_PATH parameter in the Oracle Net profile (SQLNET.ORA).
>Check whether the BUSINESS service name or database name used as the connect identifier is configured in the directory.
>Check whether the LDAP directory server is up and that it is accessible.
>Check whether the default context being used is correct by specifying a fully qualified BUSINESS service name or a full LDAP DN as the connect identifier.

SOLUTION IF YOU ARE USING Local naming(TNSNAMES.ORA file):
>First thing you have to confirm whether the TNSNAMES.ORA file exists and is in the proper directory and is accessible.
>Check that the BUSINESS service name used as the connect identifier exists in the TNSNAMES.ORA file.
>Basically the TNSNAMES.ORA is in the ADMIN folder under the ORACLE folder if if the ADMIN folder is not created while installing the oracle please create the ADMIN folder and paste the TNSNAMES.ORA file(refer the first point).
>Make sure that "TNSNAMES" is listed as one of the values of the NAMES.DIRECTORY_PATH parameter in the Oracle Net profile (SQLNET.ORA).
>check whether there is any syntax errors in the TNSNAMES.ORA mainly focus the paranthesis is correctly closed or not if there is any errors in the file and that line is not referred.

SOLUTION IF YOU ARE USING Easy connect naming:
>check whether the host, port and service name specified are correct or not.
>check that "EZCONNECT" is listed as one of the values of the NAMES.DIRETORY_PATH parameter in the Oracle Net profile (SQLNET.ORA).
> enclosing the connect identifier in quote marks thats will be better.

Thanks
A.T.J