Erro ao tentar conectar no Oracle 12.2.0.1
Causa
Falha ao registar no listener
Analisando o log do listener
|
1 2 3 4 5 6 7 8 9 10 |
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> |
|
1 2 3 4 5 6 |
SQL> SHOW PARAMETER LOCAL LISTENER NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ local_listener string LISTENER_DBTESTE parallel_force_local boolean FALSE |
Ajustando listener
|
1 |
SQL> alter system set LOCAL_LISTENER='(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.0.212)(PORT=1521))'scope=both; |
Resolvido
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 |
[oracle@dbteste ~]$ lsnrctl status LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 12-FEB-2020 16:48:13 Copyright (c) 1991, 2016, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.0.0)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production Start Date 12-FEB-2020 16:36:42 Uptime 0 days 0 hr. 11 min. 30 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/oracle/product/12.2.0/dbhome_1/network/admin/listener.ora Listener Log File /u01/oracle/diag/tnslsnr/dbteste/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.0)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Services Summary... Service "DBTESTE" has 1 instance(s). Instance "DBDIVESA", status READY, has 1 handler(s) for this service... Service "DBTESTEXDB" has 1 instance(s). Instance "DBTESTE", status READY, has 1 handler(s) for this service... The command completed successfully |