My Oracle Support Banner

OCI Stack Monitoring: Enabling Stack Monitoring for the Database Fails with Error 'IO Error: Got minus one from a read call' (Doc ID 3040581.1)

Last updated on OCTOBER 03, 2024

Applies to:

OCI Stack Monitoring - Version N/A and later
Enterprise Manager Base Platform - Version 13.5.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Enabling Stack Monitoring Service Fails for the Pluggable Database.

Login to OCI Console.
Navigate to Oracle Database -> Database (PDB) -> Associated Services -> For Stack Monitoring Click Enable.
And the Enable fails.

/agent_inst/log/mgmt_agent.log

024-07-15 16:03:31,083 [SysExecutor.6 (channelWatcher)-36] INFO - doing a sqlchannel.cleanCache on cache name (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = <DB_HOSTNAME>)(PORT = PORT)) (CONNECT_DATA = (SERVICE_NAME = <SERVICE_NAME>))):xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx with delta seconds of 645
2024-07-15 16:04:02,624 [Executor.262780 (oci_oracle_pdb.ocid1.externalpluggabledatabase.oc1.xx:WaitTime) (oci_oracle_pdb.ocid1.externalpluggabledatabase.oc1xx:WaitTime:WaitTime)-393237] WARN - oci_oracle_pdb.ocid1.externalpluggabledatabase.oc1.xx:WaitTime:WaitTime
oracle.polaris.core.services.fetchlet.exception.FetchletException: Failed to connect: java.sql.SQLRecoverableException: IO Error: Got minus one from a read call
at oracle.polaris.core.services.fetchlet.sqlfetchlet.SqlFetchlet.getMetric(SqlFetchlet.java:975) ~[agent-core-1.0.3559.jar:?]
at oracle.polaris.core.source.interaction.execution.FetchletFactory.getMetric(FetchletFactory.java:252) ~[agent-core-1.0.3559.jar:?]
at oracle.polaris.core.source.interaction.execution.ExecuteAction.executeQueryDescriptor(ExecuteAction.java:435) ~[agent-core-1.0.3559.jar:?]
at oracle.polaris.core.source.interaction.execution.ExecuteAction._call(ExecuteAction.java:1311) ~[agent-core-1.0.3559.jar:?]
at oracle.polaris.core.source.interaction.execution.ExecuteAction.call(ExecuteAction.java:1597) ~[agent-core-1.0.3559.jar:?]
at oracle.polaris.core.source.metadata.impl.collection.MetricColl$1.call(MetricColl.java:151) ~[agent-core-1.0.3559.jar:?]
at oracle.polaris.core.source.metadata.impl.collection.MetricColl$1.call(MetricColl.java:141) ~[agent-core-1.0.3559.jar:?]
at oracle.polaris.core.task.TaskFutureImpl$WrappedTask.accountedCall(TaskFutureImpl.java:916) ~[agent-core-1.0.3559.jar:?]
at oracle.polaris.core.task.TaskFutureImpl$WrappedTask.call(TaskFutureImpl.java:977) [agent-core-1.0.3559.jar:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_351]
at oracle.polaris.core.task.TaskFutureImpl.run1(TaskFutureImpl.java:652) [agent-core-1.0.3559.jar:?]
at oracle.polaris.core.task.TaskFutureImpl.run(TaskFutureImpl.java:569) [agent-core-1.0.3559.jar:?]
at oracle.polaris.core.task.CompositeTask.runSubtask(CompositeTask.java:86) [agent-core-1.0.3559.jar:?]
at oracle.polaris.core.task.CompositeTask.runAllSubtasks(CompositeTask.java:112) [agent-core-1.0.3559.jar:?]
at oracle.polaris.core.task.CompositeTask.run(CompositeTask.java:99) [agent-core-1.0.3559.jar:?]
at oracle.polaris.core.source.metadata.impl.collection.CollectionItemTask.run(CollectionItemTask.java:448) [agent-core-1.0.3559.jar:?]
at oracle.polaris.core.task.AbstractTemplateTask.call(AbstractTemplateTask.java:270) [agent-core-1.0.3559.jar:?]
at oracle.polaris.core.task.AbstractTemplateTask.call(AbstractTemplateTask.java:54) [agent-core-1.0.3559.jar:?]
at oracle.polaris.core.task.scheduler.DispatchingTaskScheduler$ReschedulingHelper$ReschedulingTask.call(DispatchingTaskScheduler.java:285) [agent-core-1.0.3559.jar:?]
at oracle.polaris.core.task.scheduler.DispatchingTaskScheduler$ReschedulingHelper$ReschedulingTask.call(DispatchingTaskScheduler.java:245) [agent-core-1.0.3559.jar:?]
at oracle.polaris.core.task.executor.DiagWrappedTask.call(DiagWrappedTask.java:68) [agent-core-1.0.3559.jar:?]
at oracle.polaris.core.task.TaskFutureImpl$WrappedTask.accountedCall(TaskFutureImpl.java:916) [agent-core-1.0.3559.jar:?]
at oracle.polaris.core.task.TaskFutureImpl$WrappedTask.call(TaskFutureImpl.java:977) [agent-core-1.0.3559.jar:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_351]
at oracle.polaris.core.task.TaskFutureImpl.run1(TaskFutureImpl.java:652) [agent-core-1.0.3559.jar:?]
at oracle.polaris.core.task.TaskFutureImpl.run(TaskFutureImpl.java:569) [agent-core-1.0.3559.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_351]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_351]
at oracle.polaris.core.task.executor.TrackThreadFactory$1.run(TrackThreadFactory.java:52) [agent-core-1.0.3559.jar:?]
at oracle.polaris.core.util.system.GCAThread$RunnableWrapper.run(GCAThread.java:192) [agent-core-1.0.3559.jar:?]
at java.lang.Thread.run(Thread.java:750) [?:1.8.0_351]
Caused by: java.sql.SQLRecoverableException: IO Error: Got minus one from a read call
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:874) ~[ojdbc8-19.9.0.0.jar:19.9.0.0.0]
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:807) ~[ojdbc8-19.9.0.0.jar:19.9.0.0.0]
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:77) ~[ojdbc8-19.9.0.0.jar:19.9.0.0.0]
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:769) ~[ojdbc8-19.9.0.0.jar:19.9.0.0.0]
at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:450) ~[ojdbc8-19.9.0.0.jar:19.9.0.0.0]
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:324) ~[ojdbc8-19.9.0.0.jar:19.9.0.0.0]
at oracle.jdbc.pool.OracleDataSource$1.build(OracleDataSource.java:1778) ~[ojdbc8-19.9.0.0.jar:19.9.0.0.0]
at oracle.jdbc.pool.OracleDataSource$1.build(OracleDataSource.java:1764) ~[ojdbc8-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.oracle.OracleDataSourceConnectionFactoryAdapter.createConnection(OracleDataSourceConnectionFactoryAdapter.java:104) ~[ucp-19.9.0.0-36264722.jar:19.9.0.0.0]
at oracle.ucp.common.Database.createPooledConnection(Database.java:256) ~[ucp-19.9.0.0-36264722.jar:19.9.0.0.0]
at oracle.ucp.common.Topology.start(Topology.java:279) ~[ucp-19.9.0.0-36264722.jar:19.9.0.0.0]
at oracle.ucp.common.Core.start(Core.java:2380) ~[ucp-19.9.0.0-36264722.jar:19.9.0.0.0]
at oracle.ucp.common.UniversalConnectionPoolBase.start(UniversalConnectionPoolBase.java:690) ~[ucp-19.9.0.0-36264722.jar:19.9.0.0.0]
at oracle.ucp.jdbc.oracle.OracleJDBCConnectionPool.start(OracleJDBCConnectionPool.java:129) ~[ucp-19.9.0.0-36264722.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.startPool(PoolDataSourceImpl.java:926) ~[ucp-19.9.0.0-36264722.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1977) ~[ucp-19.9.0.0-36264722.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.access$400(PoolDataSourceImpl.java:202) ~[ucp-19.9.0.0-36264722.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl$31.build(PoolDataSourceImpl.java:4297) ~[ucp-19.9.0.0-36264722.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1933) ~[ucp-19.9.0.0-36264722.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1896) ~[ucp-19.9.0.0-36264722.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1881) ~[ucp-19.9.0.0-36264722.jar:19.9.0.0.0]
at oracle.polaris.core.util.channel.SqlConnectionCache.openConnection(SqlConnectionCache.java:460) ~[agent-core-1.0.3559.jar:?]
at oracle.polaris.core.services.fetchlet.sqlfetchlet.SqlFetchlet.getMetric(SqlFetchlet.java:942) ~[agent-core-1.0.3559.jar:?]
... 30 more
Caused by: oracle.net.ns.NetException: Got minus one from a read call
at oracle.net.ns.NSProtocolNIO.doSocketRead(NSProtocolNIO.java:562) ~[ojdbc8-19.9.0.0.jar:19.9.0.0.0]
at oracle.net.ns.NIOPacket.readNIOPacket(NIOPacket.java:408) ~[ojdbc8-19.9.0.0.jar:19.9.0.0.0]
at oracle.net.ns.NSProtocolNIO.negotiateConnection(NSProtocolNIO.java:132) ~[ojdbc8-19.9.0.0.jar:19.9.0.0.0]
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:364) ~[ojdbc8-19.9.0.0.jar:19.9.0.0.0]
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1625) ~[ojdbc8-19.9.0.0.jar:19.9.0.0.0]
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:606) ~[ojdbc8-19.9.0.0.jar:19.9.0.0.0]
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:807) ~[ojdbc8-19.9.0.0.jar:19.9.0.0.0]
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:77) ~[ojdbc8-19.9.0.0.jar:19.9.0.0.0]
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:769) ~[ojdbc8-19.9.0.0.jar:19.9.0.0.0]
at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:450) ~[ojdbc8-19.9.0.0.jar:19.9.0.0.0]
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:324) ~[ojdbc8-19.9.0.0.jar:19.9.0.0.0]
at oracle.jdbc.pool.OracleDataSource$1.build(OracleDataSource.java:1778) ~[ojdbc8-19.9.0.0.jar:19.9.0.0.0]
at oracle.jdbc.pool.OracleDataSource$1.build(OracleDataSource.java:1764) ~[ojdbc8-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.oracle.OracleDataSourceConnectionFactoryAdapter.createConnection(OracleDataSourceConnectionFactoryAdapter.java:104) ~[ucp-19.9.0.0-36264722.jar:19.9.0.0.0]
at oracle.ucp.common.Database.createPooledConnection(Database.java:256) ~[ucp-19.9.0.0-36264722.jar:19.9.0.0.0]
at oracle.ucp.common.Topology.start(Topology.java:279) ~[ucp-19.9.0.0-36264722.jar:19.9.0.0.0]
at oracle.ucp.common.Core.start(Core.java:2380) ~[ucp-19.9.0.0-36264722.jar:19.9.0.0.0]
at oracle.ucp.common.UniversalConnectionPoolBase.start(UniversalConnectionPoolBase.java:690) ~[ucp-19.9.0.0-36264722.jar:19.9.0.0.0]
at oracle.ucp.jdbc.oracle.OracleJDBCConnectionPool.start(OracleJDBCConnectionPool.java:129) ~[ucp-19.9.0.0-36264722.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.startPool(PoolDataSourceImpl.java:926) ~[ucp-19.9.0.0-36264722.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1977) ~[ucp-19.9.0.0-36264722.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.access$400(PoolDataSourceImpl.java:202) ~[ucp-19.9.0.0-36264722.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl$31.build(PoolDataSourceImpl.java:4297) ~[ucp-19.9.0.0-36264722.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1933) ~[ucp-19.9.0.0-36264722.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1896) ~[ucp-19.9.0.0-36264722.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1881) ~[ucp-19.9.0.0-36264722.jar:19.9.0.0.0]
at oracle.polaris.core.util.channel.SqlConnectionCache.openConnection(SqlConnectionCache.java:460) ~[agent-core-1.0.3559.jar:?]
at oracle.polaris.core.services.fetchlet.sqlfetchlet.SqlFetchlet.getMetric(SqlFetchlet.java:942) ~[agent-core-1.0.3559.jar:?]
... 30 more

 Agent Host to Database connection fails.

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.