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

• 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.
  
   

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

KBA , BC-DB-ORA , Oracle , BC-INS-SWPM , Installation with Software Provisioning Manager , Problem