9 Replies Latest reply on Jul 8, 2021 11:07 AM by Navdeep Kaur

    Migration of DB server

    Navdeep Kaur New Member

      Hi All,

       

      Recently I have migrated my DB server. I updated the details in the C_REPOS_DATABASE table. But application deployment is failing after that. Any suggestion?

       

      Thanks in advance.

        • 1. Re: Migration of DB server
          Marmik Mishra Active Member

          Hi Navdeep,

           

          Could you please let us know the error you can see in the logs.

           

          Also, please confirm your DB and appserver you are using.

           

           

          Regards,
          Marmik

          • 2. Re: Migration of DB server
            Navdeep Kaur New Member

            Hi Marmik,

             

            DB server is Oracle and appserver is Jboss. I tried running the postinstall script, but deployment failed. Below is the error that I'm facing:

             

            BUILD FAILED

            /usr/local/prod/infamdm/MDM10/hub/server/bin/build.xml:84: The following error occurred while executing this line:

            /usr/local/prod/infamdm/MDM10/hub/server/bin/common.xml:518: 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:666)

            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:208)

            at com.informatica.mdm.jdbc.authentication.UsernamePasswordAuthenticator.login(UsernamePasswordAuthenticator.java:22)

            at com.informatica.mdm.jdbc.connection.JdbcConnectionFactory.getConnection(JdbcConnectionFactory.java:30)

            at com.siperian.build.internal.util.db.DatabaseCustomTask.getConnection(DatabaseCustomTask.java:199)

            at com.siperian.build.db_changes.anttask.AddApplicationUsers.run(AddApplicationUsers.java:43)

            at com.siperian.build.anttask.CustomTask.execute(CustomTask.java:75)

            at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)

            at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)

            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

            at java.lang.reflect.Method.invoke(Method.java:498)

            at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)

            at org.apache.tools.ant.Task.perform(Task.java:348)

            at org.apache.tools.ant.Target.execute(Target.java:435)

            at org.apache.tools.ant.Target.performTasks(Target.java:456)

            at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1393)

            at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)

            at org.apache.tools.ant.Project.executeTargets(Project.java:1248)

            at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:440)

            at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)

            at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)

            at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)

            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

            at java.lang.reflect.Method.invoke(Method.java:498)

            at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)

            at org.apache.tools.ant.Task.perform(Task.java:348)

            at org.apache.tools.ant.Target.execute(Target.java:435)

            at org.apache.tools.ant.Target.performTasks(Target.java:456)

            at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1393)

            at org.apache.tools.ant.Project.executeTarget(Project.java:1364)

            at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)

            at org.apache.tools.ant.Project.executeTargets(Project.java:1248)

            at org.apache.tools.ant.Main.runBuild(Main.java:851)

            at org.apache.tools.ant.Main.startAnt(Main.java:235)

            at org.apache.tools.ant.Main.start(Main.java:198)

            at org.apache.tools.ant.Main.main(Main.java:286)

            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:506)

            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:1452)

            at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:496)

            ... 39 more

            Caused by: java.net.NoRouteToHostException: No route to host (Host unreachable)

            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:589)

            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)

            ... 44 more

            • 3. Re: Migration of DB server
              SRINIVASA KALYAN KARAVADI Active Member

              Looks like it is not even able to establish the connection to your host.

               

              Caused by: java.net.NoRouteToHostException: No route to host (Host unreachable)

              at java.net.PlainSocketImpl.socketConnect(Native Method)

              • 4. Re: Migration of DB server
                Navdeep Kaur New Member

                I have updated standalone-full.xml file as well with DB connection details. But it is not helping. Am I missing something here?

                • 5. Re: Migration of DB server
                  SRINIVASA KALYAN KARAVADI Active Member

                  Please check if the DB hostname, port and service name are correct ?

                   

                  Are you able to ping the servicename from the same server ?

                   

                  Example: tnsping orcl

                  • 6. Re: Migration of DB server
                    Marmik Mishra Active Member

                    Hi Navdeep,

                     

                    From the error trace, it seems =>

                    - You are using the wrong connectURL.

                     

                    - The wrong port number or IP address (or DNS host name) was used.

                     

                    - The listener is not configured properly.

                     

                    - The listener process (service) is not running.

                     

                    Please check the same, take help of your DBA if required and re-run postinstallsetup.



                    • 7. Re: Migration of DB server
                      Anuvinda Kulkarni Guru

                      You can also try to remove all instances of ORS data sources from standalone-full.xml (take a back of the file before you do that) and restart app server to see if deployment is successful. This will help you isolate the issue further.

                      • 8. Re: Migration of DB server
                        Sathiesh M Guru

                        Pls check and correct your JDBC url in build.properties file.

                        Reference - Support

                        • 9. Re: Migration of DB server
                          Navdeep Kaur New Member

                          I missed updating the correct URL in the build.properties file. Thank you everyone for the help.