SAP Knowledge Base Article - Preview

2970866 - Oracle / SWPM (Import Schema) . . . java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

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

SAP NetWeaver 7.5

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.