Prezados Amigos, Estou com um problema. Encontrei um ODA 12c e o LISTENER esta dando 'pau'. O detalhe é que ele estava funcionando, mas, esta necessário fazer uma configuração devido a um erro de uma aplicação antiga e fui informado que era necessário adicionar os parametros:SQLNET..ALLOWED_LOGON_VERSION_CLIENT=8SQLNET.ALLOWED_LOGON_VERSION_SERVER=8A aplicação continuou sem acessar. Fui fazer uma reconfiguração abrindo o 'netca' e parou de funcionar agora de vez... :( Vou mostrar a você os erros e talvez alguém consiga me dar uma luz...Com o usuário grid:
--LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 18-JUL-2018 10:00:55 Copyright (c) 1991, 2014, Oracle. All rights reserved. Welcome to LSNRCTL, type "help" for information. LSNRCTL> statusConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNR for Linux: Version 12.1.0.2.0 - ProductionStart Date 18-JUL-2018 09:31:46Uptime 0 days 0 hr. 29 min. 11 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /u01/app/12.1.0.2/grid/network/admin/listener.oraListener Log File /u01/app/grid/diag/tnslsnr/INC-SRV-DBMV1/listener/alert/log.xmlListening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))The listener supports no servicesThe command completed successfully------------------------------------------LSNRCTL> start TNS-01106: Listener using listener name LISTENER has already been startedseu eu parar e subir de novo não muda nada.------------------------------------------Meu listener (vim /u01/app/12.1.0.2/grid/network/admin/listener.ora): MGMTLSNR=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=MGMTLSNR)))) # line added by Agent# listener.ora Network Configuration File: /u01/app/12.1.0.2/grid/network/admin/listener.ora# Generated by Oracle configuration tools. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2 = ON ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1 = ON VALID_NODE_CHECKING_REGISTRATION_LISTENER_SCAN2=OFF # line added by Agent VALID_NODE_CHECKING_REGISTRATION_LISTENER_SCAN1=OFF # line added by Agent VALID_NODE_CHECKING_REGISTRATION_ASMNET2LSNR_ASM = SUBNET VALID_NODE_CHECKING_REGISTRATION_ASMNET1LSNR_ASM = SUBNET ASMNET2LSNR_ASM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = ASMNET2LSNR_ASM)) ) ) ASMNET1LSNR_ASM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = ASMNET1LSNR_ASM)) ) ) VALID_NODE_CHECKING_REGISTRATION_LISTENER = SUBNET LISTENER = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER)) ) ) ENABLE_GLOBAL_DYNAMIC_ENDPOINT_ASMNET2LSNR_ASM = ON ENABLE_GLOBAL_DYNAMIC_ENDPOINT_ASMNET1LSNR_ASM = ON ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON LISTENER_SCAN2 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN2)) ) ) LISTENER_SCAN1 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN1)) ) ) ENABLE_GLOBAL_DYNAMIC_ENDPOINT_MGMTLSNR=ON # line added by AgentVALID_NODE_CHECKING_REGISTRATION_MGMTLSNR=SUBNET # line added by Agent -----------------------Sem mais, Jefferson Silva.
