Symptom
- db_update_out.log
. . .
java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:743)
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:672)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:566)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:270)
at com.sap.idm.db.util.IdMDBConn.createConnection(IdMDBConn.java:61)
at com.sap.idm.db.util.DBConn.<init>(DBConn.java:31)
at com.sap.idm.db.util.IdMDBConn.<init>(IdMDBConn.java:26)
at com.sap.idm.schematransport.impl.ImXportSchema.main(ImXportSchema.java:114)
Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:470)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:513)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:595)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:230)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1439)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:496)
... 9 more
Caused by: java.net.ConnectException: Connection refused (Connection refused)
(local port ##### to address ###.###.###.### (<hostnm>.<fqdn>),
remote port 1522 to address ###.###.###.### (<hostnm>.<fqdn>))
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:900)
at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:161)
at oracle.net.nt.ConnOption.connect(ConnOption.java:159)
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:428)
... 14 more
The database update has failed on phase "Import Schema". For more information, please check the update logs.
Read more...
Environment
Oracle 12.2.0.1.0 - 64bit
Oracle RAC [Real Applicaton Clusters]
RAC server
2 active physical server instance is running
<SID>1 on <hostnm>.<fqdn> * * * example * * * <hostnm>1.machine.test.group
. . . and . . .
<SID>2 on <hostnm>.<fqdn> * * * example * * * <hostnm>2machine.test.group
for example . . .
Url -> jdbc:oracle:thin:@
(DESCRIPTION_LIST =(FAILOVER=on)(LOAD_BALANCE=OFF)
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<hostnm>)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=IDN_HA)))
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<hostnm>)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=IDN_HA)))
)
File : tnsnames.ora
jdbc:oracle:thin@
(DESCRIPTION_LIST=
(FAILOVER=on)
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<hostnm>)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=IDN_HA)))
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<hostnm>)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=IDN_HA)))
)
SWPM
Product
Keywords
KBA , BC-DB-ORA , Oracle , BC-INS-SWPM , Installation with Software Provisioning Manager , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.