{"id":973,"date":"2020-02-12T16:54:41","date_gmt":"2020-02-12T19:54:41","guid":{"rendered":"http:\/\/rodrigosilvaesilva.com.br\/?p=973"},"modified":"2020-02-12T16:54:41","modified_gmt":"2020-02-12T19:54:41","slug":"ora-12514-tnslistener-does-not-currently-know-of-service-requested-in-connect-descriptor-2","status":"publish","type":"post","link":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/2020\/02\/12\/ora-12514-tnslistener-does-not-currently-know-of-service-requested-in-connect-descriptor-2\/","title":{"rendered":"ORA-12514: TNS:listener does not currently know of service requested in connect descriptor"},"content":{"rendered":"

Erro ao tentar conectar no Oracle 12.2.0.1<\/p>\n

Causa<\/h1>\n

Falha ao registar no listener<\/p>\n

Analisando o log do listener<\/h1>\n
less \/u01\/oracle\/diag\/tnslsnr\/dbteste\/listener\/alert\/log.xml\n\n\n <\/txt>\n<\/msg>\n<msg time='2020-02-12T13:39:42.367-02:00' org_id='oracle' comp_id='tnslsnr'\n type='UNKNOWN' level='16' host_id='bdoracle.local'\n host_addr='10.0.0.0' pid='8331'>\n <txt>No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))\n <\/txt><\/pre>\n
SQL> SHOW PARAMETER LOCAL LISTENER\n\nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\nlocal_listener                       string      LISTENER_DBTESTE\nparallel_force_local                 boolean     FALSE<\/pre>\n
Ajustando listener<\/h1>\n
SQL> alter system set LOCAL_LISTENER='(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.0.212)(PORT=1521))'scope=both;<\/pre>\n
Resolvido<\/h1>\n
[oracle@dbteste ~]$ lsnrctl status\n\nLSNRCTL for Linux: Version 12.2.0.1.0 - Production on 12-FEB-2020 16:48:13\n\nCopyright (c) 1991, 2016, Oracle.  All rights reserved.\n\nConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.0.0)(PORT=1521)))\nSTATUS of the LISTENER\n------------------------\nAlias                     LISTENER\nVersion                   TNSLSNR for Linux: Version 12.2.0.1.0 - Production\nStart Date                12-FEB-2020 16:36:42\nUptime                    0 days 0 hr. 11 min. 30 sec\nTrace Level               off\nSecurity                  ON: Local OS Authentication\nSNMP                      OFF\nListener Parameter File   \/u01\/oracle\/product\/12.2.0\/dbhome_1\/network\/admin\/listener.ora\nListener Log File         \/u01\/oracle\/diag\/tnslsnr\/dbteste\/listener\/alert\/log.xml\nListening Endpoints Summary...\n  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.0)(PORT=1521)))\n  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))\nServices Summary...\nService \"DBTESTE\" has 1 instance(s).\n  Instance \"DBDIVESA\", status READY, has 1 handler(s) for this service...\nService \"DBTESTEXDB\" has 1 instance(s).\n  Instance \"DBTESTE\", status READY, has 1 handler(s) for this service...\nThe command completed successfully<\/pre>\n
 <\/p>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
Erro ao tentar conectar no Oracle 12.2.0.1 Causa Falha ao registar no listener Analisando o log do listener less \/u01\/oracle\/diag\/tnslsnr\/dbteste\/listener\/alert\/log.xml <\/txt> <\/msg> <msg time=’2020-02-12T13:39:42.367-02:00′ org_id=’oracle’ comp_id=’tnslsnr’ type=’UNKNOWN’ level=’16’ host_id=’bdoracle.local’ host_addr=’10.0.0.0′ pid=’8331′> <txt>No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) <\/txt> SQL> SHOW PARAMETER LOCAL LISTENER NAME TYPE VALUE ———————————— ———– —————————— local_listener string LISTENER_DBTESTE parallel_force_local boolean FALSE Ajustando…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[20,35,181,232,233,334],"class_list":["post-973","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-u01-oracle-diag-tnslsnr-dbteste-listener-alert-log-xml","tag-ajustando-listener","tag-listener","tag-ora-12514","tag-ora-12514-tnslistener-does-not-currently-know-of-service-requested-in-connect-descriptor","tag-show-parameter-local-listener"],"_links":{"self":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/973","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=973"}],"version-history":[{"count":0,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/973\/revisions"}],"wp:attachment":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=973"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=973"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=973"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}