12 Replies Latest reply on Jun 6, 2016 5:45 AM by Beauty_and_dBest

    EBS R12.2 Clone database error

    Beauty_and_dBest

      Hi ALL,

       

      EBS R12.2.4

      OL6

      11gR2

       

      I usually clone database very easily, with almost 100% success.

      But now It gets error.

      Please help which is causing the issue.

       

      Kind regards,

      jc

       

      Beginning database tier Apply - Wed Mar 25 07:41:00 2009

       

      /home/oraprod/PROD/11.2.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/home/oraprod/PROD/11.2.0/oui -classpath /home/oraprod/PROD/11.2.0/appsutil/clone/jlib/xmlparserv2.jar:/home/oraprod/PROD/11.2.0/appsutil/clone/jlib/ojdbc6.jar:/home/oraprod/PROD/11.2.0/appsutil/clone/jlib/java:/home/oraprod/PROD/11.2.0/appsutil/clone/jlib/oui/OraInstaller.jar:/home/oraprod/PROD/11.2.0/appsutil/clone/jlib/oui/ewt3.jar:/home/oraprod/PROD/11.2.0/appsutil/clone/jlib/oui/share.jar:/home/oraprod/PROD/11.2.0/appsutil/clone/jlib/oui/srvm.jar:/home/oraprod/PROD/11.2.0/appsutil/clone/jlib/ojmisc.jar   oracle.apps.ad.clone.ApplyDBTier -e /home/oraprod/PROD/11.2.0/appsutil/PROD2_drdb.xml -stage /home/oraprod/PROD/11.2.0/appsutil/clone   -showProgress

      APPS Password : Log file located at /home/oraprod/PROD/11.2.0/appsutil/log/PROD2_drdb/ApplyDBTier_03250741.log

        |      0% completed       Determining Source system database type ("single" or "rac").

      Source system indentified as being of type "single"!

        \     50% completed       RC-50004: Fatal: Error occurred in ApplyDatabase:

      Control file creation failed

       

      ERROR while running Apply...

      Wed Mar 25 07:46:55 2009

       

      ERROR: Failed to execute /home/oraprod/PROD/11.2.0/appsutil/clone/bin/adclone.pl

       

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

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

                         ADX Database Utility

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

       

      getConnectionUsingAppsJDBCConnector() -->

          APPS_JDBC_URL='null'

          Trying to get connection using SID based connect descriptor

      getConnection() -->

          sDbHost    : drdb

          sDbDomain  : oracle.local

          sDbPort    : 1521

          sDbSid     : PROD2

          sDbUser    : APPS

          Trying to connect using SID...

      getConnectionUsingSID() -->

          JDBC URL: jdbc:oracle:thin:@drdb.oracle.local:1521:PROD2

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

      ORA-27101: shared memory realm does not exist

      Linux-x86_64 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=drdb.oracle.local)(PORT=1521))(CONNEC            T_DATA=(SERVICE_NAME=PROD2)))

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

      ORA-27101: shared memory realm does not exist

      Linux-x86_64 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=drdb.oracle.local)(PORT=1521))(CONNEC            T_DATA=(SERVICE_NAME=PROD2.oracle.local)))

      WARNING:     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

       

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

       

      WARNING: RC-00118: Error occurred during creation of database

      Raised by oracle.apps.ad.clone.ApplyDatabase

       

       

      StackTrace:

      java.lang.Exception: Control file creation failed

              at oracle.apps.ad.clone.ApplyDatabase.doConf(ApplyDatabase.java:647)

              at oracle.apps.ad.clone.ApplyDatabase.doApply(ApplyDatabase.java:482)

              at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:373)

              at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:116)

              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

              at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)

              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

              at java.lang.reflect.Constructor.newInstance(Constructor.java:526)

              at oracle.apps.ad.clone.util.CloneProcessor.run(Unknown Source)

              at java.lang.Thread.run(Thread.java:745)