1 Reply Latest reply: Oct 3, 2013 2:35 AM by user12234034 RSS

    Autoconfig failing in DB tier

    user12234034

      We are doing

       

      11i RAC to RAC cloning. Our environment is given below.

       

      Source database - 10g RAC on HP-UX

       

      Target database - 10gRAC on HP-UX

       

      Our database is restored. DBTechstack has run successfully. But autoconfig on dbTier is failing. Getting - Unable to connect database.

       

       

       

      I am getting this error - Would be great if someone can help.

       

      DEBUG: checkDBConnection out()
      Checking for DBConnection...
      DEBUG: checkDBConnection in()

      ---------------------------------------------------------------
                         ADX Database Utility
      ---------------------------------------------------------------

      getConnection() -->
          sDbHost    : erpdev03
          sDbDomain  : hutch.co.id
          sDbPort    : 1522
          sDbSid     : HCPTUP1
          sDbUser    : apps
          Trying to connect using SID...
      getConnectionUsingSID() -->
          JDBC URL: jdbc:oracle:thin:@erpdev03.hutch.co.id:1522:HCPTUP1
          Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
          Trying to connect using SID as ServiceName
      getConnectionUsingServiceName() -->
          JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erpdev03.hutch.co.id)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=HCPTUP1)))
          Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
          Trying to connect using SID as ServiceName.DomainName
      getConnectionUsingServiceName() -->
          JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erpdev03.hutch.co.id)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=HCPTUP1.hutch.co.id)))
          Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
          Connection could not be obtained; returning null

      -------------------ADX Database Utility Finished---------------

      RC-40201: Unable to connect to Database HCPTUP1.


      StackTrace:
      java.lang.Exception: Cannot connect to database using DBUtil
              at oracle.apps.ad.clone.ApplyDatabase.checkDBConnection(ApplyDatabase.java:3398)
              at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:535)
              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
              at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
              at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
              at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:68)
              at java.lang.Thread.run(Thread.java:534)

      DEBUG: checkDBConnection out()

       

      Regards,

      Arnab