The instance entry in tnsnames.ora is as below. I could connect through
(ADDRESS = (PROTOCOL = TCP)(HOST = myprodsrv)(PORT = 1521))
(SERVER = DEDICATED)
(SERVICE_NAME = myprod1)
But user told me he couldn't connect myprod1, and got the following error message.
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
The user told me they liked our setting myprod1 with .world in tnsnames.ora. But if I set up SERVICE_NAME=myprod1.world in tnsnames.ora file, it would fail to connect myprod1.
How to fix it?