<div>
User said he could connect from his desktop and he could tnsping the instance. But he couldn't connect the instance from any other server. Anything wrong?
</div>


User said he could connect from his desktop and he could tnsping the instance. But he couldn't connect the instance from any other server. Anything wrong?

<div>
Thank you!<br />
Good luck!
</div>


<div>
<div class="content wysiwyg-content">
The instance entry in tnsnames.ora is as below. I could connect through<br />
sqlplus /@myprod1<br />
SQL&gt;<br />
<br />
MYPROD1 =<br />
&nbsp; (DESCRIPTION =<br />
&nbsp; &nbsp; (ADDRESS = (PROTOCOL = TCP)(HOST = myprodsrv)(PORT = 1521))<br />
&nbsp; &nbsp; (CONNECT_DATA =<br />
&nbsp; &nbsp; &nbsp; (SERVER = DEDICATED)<br />
&nbsp; &nbsp; &nbsp; (SERVICE_NAME = myprod1)<br />
&nbsp; &nbsp; )<br />
&nbsp; )<br />
But user told me he couldn't connect myprod1, and got the following error message.<br />
ERROR:<br />
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor<br />
The user told me they liked our setting myprod1 with .world in tnsnames.ora. But if I set up SERVICE_NAME=myprod1.world<wbr /> in tnsnames.ora file, &nbsp;it would fail to connect myprod1. <br />
How to fix it?<br />
Thanks! 
</div>
</div>


The instance entry in tnsnames.ora is as below. I could connect through
sqlplus /@myprod1
SQL>

MYPROD1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = myprodsrv)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = myprod1)
    )
  )
But user told me he couldn't connect myprod1, and got the following error message.
ERROR:
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?
Thanks! 

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

Exchange is the server side of a collaborative application product that is part of the Microsoft Server infrastructure. Exchange's major features include email, calendaring, contacts and tasks, support for mobile and web-based access to information, and support for data storage.