6 Replies Latest reply on Jan 28, 2016 12:35 PM by Srini Chavali-Oracle

    Error When Clone Oracle Database 11g

    User569974

      Dear Community,

       

      I clone Oracle database 11g, but failed always failed.  This is the error

       

      ---------------------------------------------------------------

                         ADX Database Utility                       

      ---------------------------------------------------------------

       

      getConnectionUsingAppsJDBCConnector() -->

          APPS_JDBC_URL='null'

          Trying to get connection using SID based connect descriptor

      getConnection() -->

          sDbHost    : enesis03

          sDbDomain  : enesis.com

          sDbPort    : 1527

          sDbSid     : CLONE

          sDbUser    : apps

          Trying to connect using SID...

      getConnectionUsingSID() -->

          JDBC URL: jdbc:oracle:thin:@enesis03.enesis.com:1527:CLONE

          Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available

      ORA-27101: shared memory realm does not exist

      IBM AIX RISC System/6000 Error: 2: No such file or directory

       

          Trying to connect using SID as ServiceName

      getConnectionUsingServiceName() -->

          JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=enesis03.enesis.com)(PORT=1527))(CONNECT_DATA=(SERVICE_NAME=CLONE)))

          Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available

      ORA-27101: shared memory realm does not exist

      IBM AIX RISC System/6000 Error: 2: No such file or directory

       

          Trying to connect using SID as ServiceName.DomainName

      getConnectionUsingServiceName() -->

          JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=enesis03.enesis.com)(PORT=1527))(CONNECT_DATA=(SERVICE_NAME=CLONE.enesis.com)))

          Exception occurred: java.sql.SQLException: Listener refused the connection with the following error:

      ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

       

          Connection could not be obtained; returning null

      =======================

       

       

      Please Help to resolve this issue, I search every where but no luck.

       

      Many Thanks to any help.

       


      Best Regards,

       

      Dian