Hi,
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.
Sqlnet.ora:
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
tnsnames.ora:
UAT1=
(DESCRIPTION=
(ADDRESS= (PROTOCOL=tcp) (HOST= xx.xx.xx.xx) (PORT=1523))
(CONNECT_DATA= (service_name=UAT1))
)
DEV1 =
(DESCRIPTION=
(ADDRESS_LIST =
(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,
Ayaz
] 
Blog
Search
Help
Members
Register
Login
Home
