Erro
TNS-01151: Missing listener name, orcl, in LISTENER.ORA
Causa
Verificado que a porta foi alterada no listener.ora e no tnsnames.ora não foi alterada.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
/u01/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora # tnsnames.ora Network Configuration File: /u01/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. PROD = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = bdora-prod.prod.local)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = PROD) ) ) |
|
1 2 3 4 5 6 7 8 9 10 11 12 |
# listener.ora Network Configuration File: /u01/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = bdora-prod.prod.local)(PORT = 1522)) ) ) ADR_BASE_LISTENER = /u01/oracle |
Solução.
Acertar a porta no /u01/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
|
1 2 3 4 5 6 7 8 9 10 11 12 |
# listener.ora Network Configuration File: /u01/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = bdora-prod.prod.local)(PORT = 1521)) ) ) ADR_BASE_LISTENER = /u01/oracle |