![]() ![]() ![]() ![]() When the connection came, the listener found no matched service name registered with it. C:\Users\ed>sqlplus TNS:listener does not currently know of service requested in connect Next, we test the connection to the database by sqlplus ( SQL*Plus). Please note that, the message of successful tnsping did not indicate that the service name is existing on the remote listener. OK, the remote listener is up and reachable. Used TNSNAMES adapter to resolve the aliasĪttempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oracle-11g-server)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORCL))) All rights reserved.Ĭ:\oracle\app\client\ed\product\12.1.0\client_1\network\admin\sqlnet.ora First of all, we have to make sure the listener on the database server is reachable by using tnsping. It may have different error patterns from this post. That is to say, the listener is reachable.įor unknown requested SID, the listener throws ORA-12505: TNS:listener does not currently know of SID given in connect. Only one thing that can be sure in ORA-12514 is that the target listener is up and running. Here I divide scenarios that could throw ORA-12514 into several error patterns as below: As a result, it responds ORA-12514 to alert the failed connection.Īs a DBA, I have seen several kinds of ORA-12514 in different scenarios and solved them by different means. ORA-12514 means that the listener cannot find any matched service with yours, so it cannot establish the connection with the database for you. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |