Connection timeout when running PSA to upgrade SOA (Doc ID 3075770.1)

Last updated on MARCH 08, 2025

Applies to:

Symptoms

Customer is facing connection timeout when running PSA as seen in logs

[2025-02-12T15:44:27.139+05:30] [RCU] [TRACE] [] [upgrade.RCU.jdbcEngine] [tid: 28] [ecid: ************,0] Adding alter statement to list:ALTER SESSION SET CURRENT_SCHEMA=PROD_SOAINFRA
[2025-02-12T16:00:01.822+05:30] [SOA] [INCIDENT_ERROR] [] [upgrade.SOA.SOA1] [tid: 28] [ecid: *************,0] Error during upgrade of SOAINFRA schema.
[2025-02-12T16:00:01.834+05:30] [SOA] [INCIDENT_ERROR] [] [upgrade.SOA.SOA1] [tid: 28] [ecid: *************,0] Error during upgrade of SOAINFRA schema.
[2025-02-12T16:00:01.834+05:30] [SOA] [INCIDENT_ERROR] [] [upgrade.SOA.SOA1] [tid: 28] [ecid: *************,0] [[
java.sql.SQLRecoverableException: IO Error: Connection timed out
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:962)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1283)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1441)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1690)
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:446)
at oracle.ias.version.SchemaVersion.executeVersionQuery(SchemaVersion.java:2440)
at oracle.ias.version.SchemaVersion.hasRegistryEntry(SchemaVersion.java:2033)
at oracle.ias.version.SchemaVersion.setComponentUpgraded(SchemaVersion.java:1721)
at oracle.ias.update.plugin.soa.SOAINFRAPlugin.upgrade(SOAINFRAPlugin.java:276)
at oracle.ias.update.plugin.Plugin.upgrade(Plugin.java:352)
at oracle.ias.update.plan.PlanStep.upgrade(PlanStep.java:294)
at oracle.ias.update.UpgradeDriver.doUpgrades(UpgradeDriver.java:476)
at oracle.ias.update.gui.UAUpgradeThread.run(UAUpgradeThread.java:41)
Caused by: java.net.SocketException: Connection timed out
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:152)
at java.net.SocketInputStream.read(SocketInputStream.java:122)
at oracle.net.nt.MetricsEnabledInputStream.read(TcpNTAdapter.java:730)
at oracle.net.ns.Packet.receive(Packet.java:302)
at oracle.net.ns.DataPacket.receive(DataPacket.java:108)
at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:317)
at oracle.net.ns.NetInputStream.read(NetInputStream.java:262)
at oracle.net.ns.NetInputStream.read(NetInputStream.java:187)
at oracle.net.ns.NetInputStream.read(NetInputStream.java:104)
at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:126)
at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:82)
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1178)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:314)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:942)
... 12 more

Cause

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