I am getting this error when connecting to Oracle through SQL Plus (and Crystal Reports as well):
ORA-12154: TNS:could not resolve the connect identifier specified
Now this seems a familiar message and from forums the solution should be to have proper entry in tnsnames.ora and Sqlnet.ora file. I checked and found that the tns entry is perfect.
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
(ADDRESS= (PROTOCOL=tcp) (HOST= xx.xx.xx.xx) (PORT=1523))
(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(PORT = 1523))
(CONNECT_DATA =(SID = DEV1)
To my surprise, I found that I was able to connect easily through SQL Developer tool.
I have another tns entry for a different database in the tnsnames.ora file (DEV1) and I am able to connect to this database from SQL Developer as well as from SQL Plus.
Please let me know why I am getting the message when connecting (UAT1 database) using SQL Plus (and Crystal Reports). I need to Create a Crystal report connecting to the database.
Thanks in advance,