listener issue enterprise manger

[Roshan]

Hello Erman,

could you please advise if issue on SR below is due to agent on target? We have contacted support but still they are unable to fix it.

Also, when we enable EM monitoring  on same target, DB became slow.

SR 3-31351359411

Thanks,

Roshan

[Roshan]

SR.txt

[ErmanArslansOracleBlog]

You say "DB became slow", but you didn't mention it in the SR.
And according to the what I have read on that SR (and the related MOS document), the issue seems related with the DB. I mean those TNS-1189 errors (which is the issue that you reported in SR) are related with the DB server and listener configuration. So, got the check it on the DB server..

But!, it may also be related with the EM agent.. It needs to be checked from all the perspectives..
See the following common causes for TNS-1189 ;

The user is running a version of LSNRCTL that is lower than the version of the listener.
The user is attempting to administer the listener from a remote node.
The listener could not obtain the system resources needed to perform the authentication.
The local network connection between the listener and LSNRCTL was terminated unexpectedly during authentication message exchange, such as if LSNRCTL program was suddenly aborted.
The communication between the listener and LSNRCTL is being intercepted by a malicious user.
The software that the user is running is not following the authentication protocol, indicating a malicious user.
The listener is running under the GRID user and the 'oracle' user does not have permission to administer.
Typically the result of an incorrect $ORACLE_HOME setting for the user running LSNRCTL.

[Roshan]

Hi Erman,

thanks for the update.

we were getting this error message from email notifications.

Host=<target DB host on Exadata> 
Target type=Listener
Target name=LISTENER_<target host> 
Message=TNS-1189. Please check log for details.
Severity=Critical
Event reported time=Jan 19, 2023 12:09:22 PM MUT
Operating System=Linux
Platform=x86_64

 I checked the EM logs from Message URL above.

<EM_INSTANCE_BASE>/user_projects/domains/<domain_name>/servers/<SERVER_NAME>/logs/access.log


EMGC_OMS1.log:ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
EMGC_OMS1.log:ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
EMGC_OMS1.log:ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
EMGC_OMS1.log:ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
EMGC_OMS1.log:ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
EMGC_OMS1.log:ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
EMGC_OMS1.log:ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
EMGC_OMS1.log:ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
EMGC_OMS1.log:ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
EMGC_OMS1.log:ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
[oracle@emsprod logs]$ ls -lrt oracle
ls: cannot access 'oracle': No such file or directory
[oracle@emsprod logs]$ ls -lrt EMGC_OMS1.log
-rw-r-----. 1 oracle oinstall 4132056 Jan 19 17:00 EMGC_OMS1.log

<EM_INSTANCE_BASE>/user_projects/domains/<domain_name>/servers/<SERVER_NAME>/logs/<SERVER_NAME>-diagnostic.log

icePort] [oracle.wsm.policy.name: oracle/em/wss_username_or_x509_or_flex_token_service_policy] User name from authenticated subject: SYSMAN
[2023-01-19T21:34:12.128+04:00] [EMGC_OMS1] [NOTIFICATION] [] [oracle.wsm.agent.handler.jaxrs.RESTJeeResourceFilter] [tid: [ACTIVE].ExecuteThread: '64' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 005we5NJ^gXFc5D5nBCCyZ00A8wk000_5D,0:1] [APP: emgc] [partition-name: DOMAIN] [tenant-name: GLOBAL] Tenant: default,  ProcessResponse is set to false
[2023-01-19T21:34:24.241+04:00] [EMGC_OMS1] [WARNING] [] [org.apache.myfaces.trinidadinternal.agent.AgentFactoryImpl] [tid: [ACTIVE].ExecuteThread: '59' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 827d7fd6-c7c5-4886-a3f8-a6ffec10496c-00000002,0:2] [APP: emgc] [partition-name: DOMAIN] [tenant-name: GLOBAL] The User-Agent "EMCTL COMMAND:  Oracle HTTPClient Version 10h" is unknown; creating an agent with "unknown" agent attributes.
[2023-01-19T21:34:24.242+04:00] [EMGC_OMS1] [NOTIFICATION] [] [oracle.adfinternal.controller.state.ControllerState] [tid: [ACTIVE].ExecuteThread: '59' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 827d7fd6-c7c5-4886-a3f8-a6ffec10496c-00000002,0:2] [APP: emgc] [partition-name: DOMAIN] [tenant-name: GLOBAL] ADFc: Limiting the number of RootViewPorts to 20
[2023-01-19T21:35:55.906+04:00] [EMGC_OMS1] [WARNING] [] [org.apache.myfaces.trinidadinternal.agent.AgentFactoryImpl] [tid: [ACTIVE].ExecuteThread: '50' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 9180f9d7-e8db-4ed3-8d59-145f87072e0a-00000002,0:2] [APP: emgc] [partition-name: DOMAIN] [tenant-name: GLOBAL] The User-Agent "EMCTL COMMAND:  Oracle HTTPClient Version 10h" is unknown; creating an agent with "unknown" agent attributes.
[2023-01-19T21:35:55.906+04:00] [EMGC_OMS1] [NOTIFICATION] [] [oracle.adfinternal.controller.state.ControllerState] [tid: [ACTIVE].ExecuteThread: '50' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 9180f9d7-e8db-4ed3-8d59-145f87072e0a-00000002,0:2] [APP: emgc] [partition-name: DOMAIN] [tenant-name: GLOBAL] ADFc: Limiting the number of RootViewPorts to 20

<EM_INSTANCE_BASE>/em/<OMS_NAME>/sysman/log/emoms.trc

        at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:337) [com.bea.core.utils.full.jar:12.2.1.4]
        at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:57) [com.oracle.weblogic.work.jar:12.2.1.4]
        at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41) [com.bea.core.weblogic.workmanager.jar:12.2.1.4]
        at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:655) [com.bea.core.weblogic.workmanager.jar:12.2.1.4]
        at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420) [com.bea.core.weblogic.workmanager.jar:12.2.1.4]
        at weblogic.work.ExecuteThread.run(ExecuteThread.java:360) [com.bea.core.weblogic.workmanager.jar:12.2.1.4]
2023-01-19 00:00:04,029 [RJob Step 756789] ERROR aru.UpdateARUTables logp.251 - Error on accessing ARU : Unable to log in to My Oracle Support. Your My Oracle Support preferred credentials are not set. Set the My Oracle Support preferred credentials using the My Oracle Support Preferred Credentials page. To access this page, from the Setup menu, select My Oracle Support, then select Set Credentials.
oracle.sysman.emInternalSDK.core.patch.aru.ARUException: Unable to login to ARU since your My Oracle Support Preferred Credentials are not set
        at oracle.sysman.core.patch.aru.ARUClientImpl.login(ARUClientImpl.java:183) ~[emCoreConsole.jar:?]
        at oracle.sysman.core.patch.aru.ARUClientImpl.login(ARUClientImpl.java:125) ~[emCoreConsole.jar:?]
        at oracle.sysman.core.patch.job.aru.UpdateARUTables.executeCommand(UpdateARUTables.java:287) [emCoreConsole.jar:?]
        at oracle.sysman.emdrep.jobs.CommandStepExecutor.execute(CommandStepExecutor.java:157) [emCoreSDKImpl.jar:?]
        at oracle.sysman.emWebservices.inbound.jobs.worker.ConsoleJobStepExecutor.execute(ConsoleJobStepExecutor.java:385) [emCoreConsole.jar:?]
        at oracle.sysman.emWebservices.inbound.jobs.worker.ConsoleJobStepExecutor.executeStep(ConsoleJobStepExecutor.java:250) [emCoreConsole.jar:?]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_261]
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_261]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_261]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_261]
        at oracle.j2ee.ws.server.jaxws.ServiceEndpointRuntime.processMessage(ServiceEndpointRuntime.java:424) [com.oracle.webservices.fmw.wsserver-impl.jar:?]
        at oracle.j2ee.ws.server.jaxws.ServiceEndpointRuntime.processMessage(ServiceEndpointRuntime.java:231) [com.oracle.webservices.fmw.wsserver-impl.jar:?]
        at oracle.j2ee.ws.server.jaxws.JAXWSRuntimeDelegate.processMessage(JAXWSRuntimeDelegate.java:504) [com.oracle.webservices.fmw.wsserver-impl.jar:?]
        at oracle.j2ee.ws.server.provider.ProviderProcessor.doEndpointProcessing(ProviderProcessor.java:1364) [com.oracle.webservices.fmw.wsserver-impl.jar:?]
        at oracle.j2ee.ws.server.WebServiceProcessor$2.run(WebServiceProcessor.java:1391) [com.oracle.webservices.fmw.wsserver-impl.jar:?]
        at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_261]
        at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:314) [jps-api.jar:?]
        at oracle.security.jps.internal.jaas.AccActionExecutor.execute(AccActionExecutor.java:70) [jps-internal.jar:?]
        at oracle.security.jps.internal.jaas.AbstractSubjectSecurity$ActionExecutorWrapper.execute(AbstractSubjectSecurity.java:282) [jps-internal.jar:?]
        at oracle.security.jps.internal.jaas.CascadeActionExecutor$SubjectPrivilegedExceptionAction.run(CascadeActionExecutor.java:82) [jps-internal.jar:?]
        at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:386) [com.oracle.weblogic.security.subject.jar:12.2.1.4]
        at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:163) [com.oracle.weblogic.security.subject.jar:12.2.1.4]
        at weblogic.security.Security.runAs(Security.java:62) [com.oracle.weblogic.security.jar:12.2.1.4]
        at oracle.security.jps.wls.jaas.WlsActionExecutor.execute(WlsActionExecutor.java:50) [jps-wls.jar:?]
        at oracle.security.jps.internal.jaas.CascadeActionExecutor.execute(CascadeActionExecutor.java:55) [jps-internal.jar:?]
        at oracle.security.jps.internal.jaas.AbstractSubjectSecurity$ActionExecutorWrapper.execute(AbstractSubjectSecurity.java:282) [jps-internal.jar:?]
        at oracle.j2ee.ws.server.provider.GenericProviderPlatform.runAs(GenericProviderPlatform.java:468) [com.oracle.webservices.fmw.wsserver-impl.jar:?]
        at oracle.j2ee.ws.server.WebServiceProcessor.invokeEndpointImplementation(WebServiceProcessor.java:1410) [com.oracle.webservices.fmw.wsserver-impl.jar:?]
        at oracle.j2ee.ws.server.provider.ProviderProcessor.doRequestProcessingPhaseTwo(ProviderProcessor.java:718) [com.oracle.webservices.fmw.wsserver-impl.jar:?]
        at oracle.j2ee.ws.server.WebServiceProcessor.doRequestProcessing(WebServiceProcessor.java:677) [com.oracle.webservices.fmw.wsserver-impl.jar:?]
        at oracle.j2ee.ws.server.WebServiceProcessor.processRequest(WebServiceProcessor.java:248) [com.oracle.webservices.fmw.wsserver-impl.jar:?]
        at oracle.j2ee.ws.server.WebServiceProcessor.doService(WebServiceProcessor.java:212) [com.oracle.webservices.fmw.wsserver-impl.jar:?]
        at oracle.j2ee.ws.server.WebServiceServlet.doService(WebServiceServlet.java:700) [com.oracle.webservices.fmw.wsserver-impl.jar:?]
        at oracle.j2ee.ws.server.WebServiceServlet.doPost(WebServiceServlet.java:538) [com.oracle.webservices.fmw.wsserver-impl.jar:?]
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) [javax.servlet.javax.servlet-api.jar:3.1.0]
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) [javax.servlet.javax.servlet-api.jar:3.1.0]
        at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:295) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:260) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:137) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:353) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at oracle.sysman.eml.app.EMRepLoginFilter.doFilter(EMRepLoginFilter.java:396) [emCoreSDKImpl.jar:?]
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.websocket.tyrus.TyrusServletFilter.doFilter(TyrusServletFilter.java:274) [com.oracle.weblogic.websocket.jar:12.2.1.4]
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at oracle.sysman.eml.app.MBeanServerConnFilter.doFilter(MBeanServerConnFilter.java:43) [emCoreConsole.jar:?]
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at oracle.adf.library.webapp.LibraryFilter.doFilter(LibraryFilter.java:169) [adflibfilter.jar:?]
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at oracle.sysman.emInternalSDK.core.model.utils.EntityManagerFilter.doFilter(EntityManagerFilter.java:46) [emCoreInternalSDK.jar:?]
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at oracle.sysman.eml.app.ContextInitFilter.doFilter(ContextInitFilter.java:594) [emCoreSDKImpl.jar:?]
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at oracle.adfinternal.view.faces.caching.filter.AdfFacesCachingFilterImpl.doFilter(AdfFacesCachingFilterImpl.java:134) [adf-richclient-impl-11.jar:ASPEN (custom: 12.2.1.4.42.190911.2248)]
        at oracle.adf.view.rich.webapp.AdfFacesCachingFilter.doFilter(AdfFacesCachingFilter.java:66) [adf-richclient-api-11.jar:ASPEN (custom: 12.2.1.4.42.190911.2248)]
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at oracle.security.jps.ee.http.JpsAbsFilter$3.run(JpsAbsFilter.java:175) [jps-ee.jar:?]
        at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_261]
        at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:314) [jps-api.jar:?]
        at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:650) [jps-ee.jar:?]
        at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:112) [jps-ee.jar:?]
        at oracle.security.jps.ee.http.JpsAbsFilter.doFilterInternal(JpsAbsFilter.java:293) [jps-ee.jar:?]
        at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:150) [jps-ee.jar:?]
        at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:94) [jps-ee.jar:?]
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:248) [dms.jar:12.2.1.4.0]
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at oracle.jrf.servlet.ExtensibleGlobalFilter.doFilter(ExtensibleGlobalFilter.java:92) [jrf-api.jar:12.2.1.4.0]
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:32) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3797) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3763) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:344) [com.oracle.weblogic.security.subject.jar:12.2.1.4]
        at weblogic.security.service.SecurityManager.runAsForUserCode(SecurityManager.java:197) [com.oracle.weblogic.security.subject.jar:12.2.1.4]
        at weblogic.servlet.provider.WlsSecurityProvider.runAsForUserCode(WlsSecurityProvider.java:203) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:71) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2451) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2299) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2277) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.servlet.internal.ServletRequestImpl.runInternal(ServletRequestImpl.java:1710) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1670) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:272) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:352) [com.bea.core.utils.full.jar:12.2.1.4]
        at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:337) [com.bea.core.utils.full.jar:12.2.1.4]
        at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:57) [com.oracle.weblogic.work.jar:12.2.1.4]
        at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41) [com.bea.core.weblogic.workmanager.jar:12.2.1.4]
        at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:655) [com.bea.core.weblogic.workmanager.jar:12.2.1.4]
        at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420) [com.bea.core.weblogic.workmanager.jar:12.2.1.4]
        at weblogic.work.ExecuteThread.run(ExecuteThread.java:360) [com.bea.core.weblogic.workmanager.jar:12.2.1.4]
2023-01-19 00:00:34,102 [RJob Step 755478] ERROR prereq.MigPrereqDownloadUtils logp.251 -
Error: Connection failed for url: https://download.oracle.com/otn_software/linux/instantclient/instantclient-basic-linuxx64.zip
         Cause: newSocket: Couldn't connect to (download.oracle.com/104.95.180.83, 443) even after 30000 millisecs
java.net.SocketTimeoutException: newSocket: Couldn't connect to (download.oracle.com/104.95.180.83, 443) even after 30000 millisecs
        at weblogic.socket.NIOSocketMuxer.newSocket(NIOSocketMuxer.java:441) ~[com.oracle.weblogic.server.muxers.jar:12.2.1.4]
        at weblogic.socket.NIOSocketMuxer.newSocket(NIOSocketMuxer.java:364) ~[com.oracle.weblogic.server.muxers.jar:12.2.1.4]
        at weblogic.net.http.HttpsClient.openWrappedSSLSocket(HttpsClient.java:621) ~[com.oracle.weblogic.net.jar:12.2.1.4]
        at weblogic.net.http.HttpsClient.openServer(HttpsClient.java:281) ~[com.oracle.weblogic.net.jar:12.2.1.4]
        at weblogic.net.http.HttpsClient.openServer(HttpsClient.java:362) ~[com.oracle.weblogic.net.jar:12.2.1.4]
        at weblogic.net.http.HttpsClient.New(HttpsClient.java:576) ~[com.oracle.weblogic.net.jar:12.2.1.4]
        at weblogic.net.http.HttpsClient.New(HttpsClient.java:557) ~[com.oracle.weblogic.net.jar:12.2.1.4]
        at weblogic.net.http.HttpsURLConnection.connect(HttpsURLConnection.java:265) ~[com.oracle.weblogic.net.jar:12.2.1.4]
        at weblogic.net.http.HttpURLConnection.getInputStream(HttpURLConnection.java:754) ~[com.oracle.weblogic.net.jar:12.2.1.4]
        at weblogic.net.http.SOAPHttpsURLConnection.getInputStream(SOAPHttpsURLConnection.java:42) ~[com.oracle.weblogic.net.jar:12.2.1.4]
        at weblogic.net.http.HttpURLConnection.getResponseCode(HttpURLConnection.java:1616) ~[com.oracle.weblogic.net.jar:12.2.1.4]
        at oracle.sysman.db.migration.model.prereq.MigPrereqDownloadUtils.validateConncetion(MigPrereqDownloadUtils.java:159) [em-db-migration-model.jar:?]
        at oracle.sysman.db.migration.model.prereq.commands.MigrationPrereqDownloadCmd.executeCommand(MigrationPrereqDownloadCmd.java:107) [em-db-migration-model.jar:?]
        at oracle.sysman.emdrep.jobs.CommandStepExecutor.execute(CommandStepExecutor.java:157) [emCoreSDKImpl.jar:?]
        at oracle.sysman.emWebservices.inbound.jobs.worker.ConsoleJobStepExecutor.execute(ConsoleJobStepExecutor.java:385) [emCoreConsole.jar:?]
        at oracle.sysman.emWebservices.inbound.jobs.worker.ConsoleJobStepExecutor.executeStep(ConsoleJobStepExecutor.java:250) [emCoreConsole.jar:?]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_261]
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_261]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_261]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_261]
        at oracle.j2ee.ws.server.jaxws.ServiceEndpointRuntime.processMessage(ServiceEndpointRuntime.java:424) [com.oracle.webservices.fmw.wsserver-impl.jar:?]
        at oracle.j2ee.ws.server.jaxws.ServiceEndpointRuntime.processMessage(ServiceEndpointRuntime.java:231) [com.oracle.webservices.fmw.wsserver-impl.jar:?]
        at oracle.j2ee.ws.server.jaxws.JAXWSRuntimeDelegate.processMessage(JAXWSRuntimeDelegate.java:504) [com.oracle.webservices.fmw.wsserver-impl.jar:?]
        at oracle.j2ee.ws.server.provider.ProviderProcessor.doEndpointProcessing(ProviderProcessor.java:1364) [com.oracle.webservices.fmw.wsserver-impl.jar:?]
        at oracle.j2ee.ws.server.WebServiceProcessor$2.run(WebServiceProcessor.java:1391) [com.oracle.webservices.fmw.wsserver-impl.jar:?]
        at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_261]
        at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:314) [jps-api.jar:?]
        at oracle.security.jps.internal.jaas.AccActionExecutor.execute(AccActionExecutor.java:70) [jps-internal.jar:?]
        at oracle.security.jps.internal.jaas.AbstractSubjectSecurity$ActionExecutorWrapper.execute(AbstractSubjectSecurity.java:282) [jps-internal.jar:?]
        at oracle.security.jps.internal.jaas.CascadeActionExecutor$SubjectPrivilegedExceptionAction.run(CascadeActionExecutor.java:82) [jps-internal.jar:?]
        at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:386) [com.oracle.weblogic.security.subject.jar:12.2.1.4]
        at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:163) [com.oracle.weblogic.security.subject.jar:12.2.1.4]
        at weblogic.security.Security.runAs(Security.java:62) [com.oracle.weblogic.security.jar:12.2.1.4]
        at oracle.security.jps.wls.jaas.WlsActionExecutor.execute(WlsActionExecutor.java:50) [jps-wls.jar:?]
        at oracle.security.jps.internal.jaas.CascadeActionExecutor.execute(CascadeActionExecutor.java:55) [jps-internal.jar:?]
        at oracle.security.jps.internal.jaas.AbstractSubjectSecurity$ActionExecutorWrapper.execute(AbstractSubjectSecurity.java:282) [jps-internal.jar:?]
        at oracle.j2ee.ws.server.provider.GenericProviderPlatform.runAs(GenericProviderPlatform.java:468) [com.oracle.webservices.fmw.wsserver-impl.jar:?]
        at oracle.j2ee.ws.server.WebServiceProcessor.invokeEndpointImplementation(WebServiceProcessor.java:1410) [com.oracle.webservices.fmw.wsserver-impl.jar:?]
        at oracle.j2ee.ws.server.provider.ProviderProcessor.doRequestProcessingPhaseTwo(ProviderProcessor.java:718) [com.oracle.webservices.fmw.wsserver-impl.jar:?]
        at oracle.j2ee.ws.server.WebServiceProcessor.doRequestProcessing(WebServiceProcessor.java:677) [com.oracle.webservices.fmw.wsserver-impl.jar:?]
        at oracle.j2ee.ws.server.WebServiceProcessor.processRequest(WebServiceProcessor.java:248) [com.oracle.webservices.fmw.wsserver-impl.jar:?]
        at oracle.j2ee.ws.server.WebServiceProcessor.doService(WebServiceProcessor.java:212) [com.oracle.webservices.fmw.wsserver-impl.jar:?]
        at oracle.j2ee.ws.server.WebServiceServlet.doService(WebServiceServlet.java:700) [com.oracle.webservices.fmw.wsserver-impl.jar:?]
        at oracle.j2ee.ws.server.WebServiceServlet.doPost(WebServiceServlet.java:538) [com.oracle.webservices.fmw.wsserver-impl.jar:?]
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) [javax.servlet.javax.servlet-api.jar:3.1.0]
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) [javax.servlet.javax.servlet-api.jar:3.1.0]
        at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:295) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:260) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:137) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:353) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at oracle.sysman.eml.app.EMRepLoginFilter.doFilter(EMRepLoginFilter.java:396) [emCoreSDKImpl.jar:?]
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.websocket.tyrus.TyrusServletFilter.doFilter(TyrusServletFilter.java:274) [com.oracle.weblogic.websocket.jar:12.2.1.4]
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at oracle.sysman.eml.app.MBeanServerConnFilter.doFilter(MBeanServerConnFilter.java:43) [emCoreConsole.jar:?]
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at oracle.adf.library.webapp.LibraryFilter.doFilter(LibraryFilter.java:169) [adflibfilter.jar:?]
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at oracle.sysman.emInternalSDK.core.model.utils.EntityManagerFilter.doFilter(EntityManagerFilter.java:46) [emCoreInternalSDK.jar:?]
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at oracle.sysman.eml.app.ContextInitFilter.doFilter(ContextInitFilter.java:594) [emCoreSDKImpl.jar:?]
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at oracle.adfinternal.view.faces.caching.filter.AdfFacesCachingFilterImpl.doFilter(AdfFacesCachingFilterImpl.java:134) [adf-richclient-impl-11.jar:ASPEN (custom: 12.2.1.4.42.190911.2248)]
        at oracle.adf.view.rich.webapp.AdfFacesCachingFilter.doFilter(AdfFacesCachingFilter.java:66) [adf-richclient-api-11.jar:ASPEN (custom: 12.2.1.4.42.190911.2248)]
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at oracle.security.jps.ee.http.JpsAbsFilter$3.run(JpsAbsFilter.java:175) [jps-ee.jar:?]
        at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_261]
        at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:314) [jps-api.jar:?]
        at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:650) [jps-ee.jar:?]
        at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:112) [jps-ee.jar:?]
        at oracle.security.jps.ee.http.JpsAbsFilter.doFilterInternal(JpsAbsFilter.java:293) [jps-ee.jar:?]
        at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:150) [jps-ee.jar:?]
        at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:94) [jps-ee.jar:?]
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:248) [dms.jar:12.2.1.4.0]
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at oracle.jrf.servlet.ExtensibleGlobalFilter.doFilter(ExtensibleGlobalFilter.java:92) [jrf-api.jar:12.2.1.4.0]
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:32) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3797) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3763) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:344) [com.oracle.weblogic.security.subject.jar:12.2.1.4]
        at weblogic.security.service.SecurityManager.runAsForUserCode(SecurityManager.java:197) [com.oracle.weblogic.security.subject.jar:12.2.1.4]
        at weblogic.servlet.provider.WlsSecurityProvider.runAsForUserCode(WlsSecurityProvider.java:203) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:71) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2451) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2299) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2277) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.servlet.internal.ServletRequestImpl.runInternal(ServletRequestImpl.java:1710) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1670) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:272) [com.oracle.weblogic.servlet.jar:12.2.1.4]
        at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:352) [com.bea.core.utils.full.jar:12.2.1.4]
        at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:337) [com.bea.core.utils.full.jar:12.2.1.4]
        at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:57) [com.oracle.weblogic.work.jar:12.2.1.4]
        at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41) [com.bea.core.weblogic.workmanager.jar:12.2.1.4]
        at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:655) [com.bea.core.weblogic.workmanager.jar:12.2.1.4]
        at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420) [com.bea.core.weblogic.workmanager.jar:12.2.1.4]
        at weblogic.work.ExecuteThread.run(ExecuteThread.java:360) [com.bea.core.weblogic.workmanager.jar:12.2.1.4]
2023-01-19 01:00:00,823 [RJob Step 756917] WARN  jobCommand.JvmdHealthReportJob logp.251 - JVMD Health report job has started
2023-01-19 01:00:03,525 [RJob Step 756917] WARN  util.EJBUtil logp.251 - AD4J: Could not get AD4J Manager Details for manager idEMGC_OMS1
2023-01-19 01:00:03,574 [RJob Step 756917] WARN  jobCommand.JvmdHealthReportJob logp.251 -
 JVMD Health report job has completed with status 5
2023-01-19 04:52:35,529 [RJob Step 757108] WARN  exachkparser.ExachkVersionMonitor logp.251 - SQL_STD_KEYWORD :select keywd.keyword_name , ta.target_guid from EM_CS_KEYWORD keywd, MGMT_CS_CONFIG_STANDARD std, EM_CS_TARGET_ASSOC ta,  MGMT_TARGETS t where keywd.keyword_name like 'Version=%' and keywd.cs_guid=std.cs_guid and ta.cs_guid = std.cs_guid AND ta.target_guid = t.target_guid and std.cs_guid =( select std.cs_guid from EM_CS_KEYWORD keywd, MGMT_CS_CONFIG_STANDARD std where keywd.keyword_name='AHF' and std.target_type='host' and keywd.cs_guid=std.cs_guid )
2023-01-19 09:00:04,540 [RJob Step 757242] WARN  jobCommand.JvmdHealthReportJob logp.251 - JVMD Health report job has started
2023-01-19 09:00:07,619 [RJob Step 757242] WARN  util.EJBUtil logp.251 - AD4J: Could not get AD4J Manager Details for manager idEMGC_OMS1
2023-01-19 09:00:07,671 [RJob Step 757242] WARN  jobCommand.JvmdHealthReportJob logp.251 -
 JVMD Health report job has completed with status 5
2023-01-19 11:45:42,197 [[ACTIVE] ExecuteThread: '79' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR da.EmResolutionDao logp.251 - Could not start refreshing patch resolution requests, Mos Session is not available.
2023-01-19 15:42:10,940 [RJob Step 757560] WARN  SyncSlaveTargetJobCommand executeCommandStep.511 - Invalid entries from agent found are  [oracle_storage_cdb, activity_pending, dataguard_11gR2, oracle_cdb_racconfig]
2023-01-19 15:42:10,967 [RJob Step 757560] WARN  SyncSlaveTargetJobCommand executeCommandStep.549 - Final List of Invalid entries from agent found are  []
2023-01-19 15:42:16,878 [RJob Step 757560] WARN  oms.TargetCollection logp.251 - TargetCollections will drop MAX_INTERVAL and MIN_INTERVAL constraints when passed to/from the agent.
2023-01-19 16:12:42,424 [Thread-2030007] WARN  client.RepositoryUtils logp.251 - getting unrestricted (private/repository owner) connection
2023-01-19 16:12:42,549 [Thread-2030008] WARN  client.RepositoryUtils logp.251 - getting unrestricted (private/repository owner) connection
2023-01-19 16:52:33,667 [RJob Step 757668] WARN  exachkparser.ExachkVersionMonitor logp.251 - SQL_STD_KEYWORD :select keywd.keyword_name , ta.target_guid from EM_CS_KEYWORD keywd, MGMT_CS_CONFIG_STANDARD std, EM_CS_TARGET_ASSOC ta,  MGMT_TARGETS t where keywd.keyword_name like 'Version=%' and keywd.cs_guid=std.cs_guid and ta.cs_guid = std.cs_guid AND ta.target_guid = t.target_guid and std.cs_guid =( select std.cs_guid from EM_CS_KEYWORD keywd, MGMT_CS_CONFIG_STANDARD std where keywd.keyword_name='AHF' and std.target_type='host' and keywd.cs_guid=std.cs_guid )
2023-01-19 17:00:02,951 [RJob Step 757683] WARN  jobCommand.JvmdHealthReportJob logp.251 - JVMD Health report job has started
2023-01-19 17:00:04,173 [RJob Step 757683] WARN  util.EJBUtil logp.251 - AD4J: Could not get AD4J Manager Details for manager idEMGC_OMS1
2023-01-19 17:00:04,224 [RJob Step 757683] WARN  jobCommand.JvmdHealthReportJob logp.251 -
 JVMD Health report job has completed with status 5
2023-01-19 18:39:01,968 [RJob Step 757755] WARN  selfupdate.SelfUpdateJobCommand logp.251 - Either Online mode is not configured or MOS credentials are not set. Aborting...
[oracle@emsprod log]$

Do you think issue is with the EM setup? EM db is 19.17.0.0.0 EE. Shall I reinstall agent on target? Please guide me.

Thanks

[ErmanArslansOracleBlog]

ORA-12505 is a different thing. TNS-1189 is different, "Cause: newSocket: Couldn't connect to (download.oracle.com/104.95.180.83, 443" is different.. The latter is pure java and EM conf related( How to Set Preferred Credentials for My Oracle Support in Enterprise Manager12c Cloud Control (Doc ID 1371796.1)) and it is related with web connection. That one is related with self update probably (online mode), you can disable that feature(If you don't use it..) . I think, that error will be dissapeared when you do that. The other former ones are related with SQLnet, but they are different. The latter may be emergent, but currently seems unrelated.
Your issue is TNS-1189 right. Check the listener log.. What does it tell you about it?