8 Replies Latest reply: Aug 18, 2013 10:30 PM by Hussein Sawwan-Oracle RSS

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

    Mohammed Abdul Muqeet

      Hello Experts,

       

      Just Wanted to let you know that I am getting error while performing the adcfgclone.pl

      on the dbtier.

       

      OS:OEL6update4 x86- 64bit EBS:R12.1.3 DB: 11.2.0.3

       

      /u01/oracle/SID/db/tech_st/11.2.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=false  -Doracle.installer.oui_loc=/u01/oracle/SID/db/tech_st/11.2.0/oui -classpath /u01/oracle/SID/db/tech_st/11.2.0/appsutil/clone/jlib/xmlparserv2.jar:/u01/oracle/SID/db/tech_st/11.2.0/appsutil/clone/jlib/ojdbc5.jar:/u01/oracle/SID/db/tech_st/11.2.0/appsutil/clone/jlib/java:/u01/oracle/SID/db/tech_st/11.2.0/appsutil/clone/jlib/oui/OraInstaller.jar:/u01/oracle/SID/db/tech_st/11.2.0/appsutil/clone/jlib/oui/ewt3.jar:/u01/oracle/SID/db/tech_st/11.2.0/appsutil/clone/jlib/oui/share.jar:/u01/oracle/SID/db/tech_st/11.2.0/appsutil/clone/jlib/oui/srvm.jar:/u01/oracle/SID/db/tech_st/11.2.0/appsutil/clone/jlib/ojmisc.jar   oracle.apps.ad.clone.ApplyDBTier -e /u01/oracle/SID/db/tech_st/11.2.0/appsutil/SID_HOSTNAME.xml -stage /u01/oracle/SID/db/tech_st/11.2.0/appsutil/clone   -showProgress

      APPS Password : Log file located at /u01/oracle/SID/db/tech_st/11.2.0/appsutil/log/SID_HOSTNAME/ApplyDBTier_08182047.log

        |      0% completed

      Log file located at /u01/oracle/SID/db/tech_st/11.2.0/appsutil/log/SID_HOSTNAME/ApplyDBTier_08182047.log

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

      Control file creation failed

       

      ERROR while running Apply...

      Sun Aug 18 21:23:50 2013

       

      ERROR: Failed to execute /u01/oracle/SID/db/tech_st/11.2.0/appsutil/clone/bin/adclone.pl

       

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

       

      Clone Log file

       

       

      RC-00118: Error occurred during creation of database

      Raised by oracle.apps.ad.clone.ApplyDatabase

       

       

      StackTrace:

      1. java.lang.Exception: Control file creation failed

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

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

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

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

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

              at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:67)

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

       

       

      /u01/oracle/SID/db/tech_st/11.2.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=false  -Doracle.installer.oui_loc=/u01/oracle/SID/db/tech_st/11.2.0/oui -classpath /u01/oracle/SID/db/tech_st/11.2.0/appsutil/clone/jlib/xmlparserv2.jar:/u01/oracle/SID/db/tech_st/11.2.0/appsutil/clone/jlib/ojdbc5.jar:/u01/oracle/SID/db/tech_st/11.2.0/appsutil/clone/jlib/java:/u01/oracle/SID/db/tech_st/11.2.0/appsutil/clone/jlib/oui/OraInstaller.jar:/u01/oracle/SID/db/tech_st/11.2.0/appsutil/clone/jlib/oui/ewt3.jar:/u01/oracle/SID/db/tech_st/11.2.0/appsutil/clone/jlib/oui/share.jar:/u01/oracle/SID/db/tech_st/11.2.0/appsutil/clone/jlib/oui/srvm.jar:/u01/oracle/SID/db/tech_st/11.2.0/appsutil/clone/jlib/ojmisc.jar   oracle.apps.ad.clone.ApplyDBTier -e /u01/oracle/SID/db/tech_st/11.2.0/appsutil/SID_HOSTNAME.xml -stage /u01/oracle/SID/db/tech_st/11.2.0/appsutil/clone   -showProgress

      APPS Password : Log file located at /u01/oracle/SID/db/tech_st/11.2.0/appsutil/log/SID_HOSTNAME/ApplyDBTier_08182047.log

        |      0% completed

      Log file located at /u01/oracle/SID/db/tech_st/11.2.0/appsutil/log/SID_HOSTNAME/ApplyDBTier_08182047.log

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

      Control file creation failed

       

      ERROR while running Apply...

      Sun Aug 18 21:23:50 2013

       

      ERROR: Failed to execute /u01/oracle/SID/db/tech_st/11.2.0/appsutil/clone/bin/adclone.pl

       

      Please advise.

       

      Regards

        • 1. Re: 50% completed RC-50004: Fatal: Error occurred in ApplyDatabase
          Hussein Sawwan-Oracle
          java.lang.Exception: Control file creation failed

           

          Please check the database alert log file for details about the error.

           

          Thanks,

          Hussein

          • 3. Re: 50% completed RC-50004: Fatal: Error occurred in ApplyDatabase
            Mohammed Abdul Muqeet

            Hi Hussain,

             

            Quick update - i have not discovered any errors in the database alert log file.

             

            I ran adcfgclone.pl and after running 45 minutes it is failing with above error.

             

            COuld you please advise.

             

            Regards

            Mohammed.

            • 4. Re: 50% completed RC-50004: Fatal: Error occurred in ApplyDatabase
              Mohammed Abdul Muqeet

              Creating the control file for SID_HOSTNAME database ...


              SQL*Plus: Release 11.2.0.3.0 Production on Mon Aug 19 00:17:13 2013

              Copyright (c) 1982, 2011, Oracle.  All rights reserved.

              Connected to an idle instance.
              ORACLE instance shut down.
              Connected to an idle instance.
              ORA-00000: normal, successful completion
              ERROR:
              ORA-01012: not logged on


              ERROR:
              ORA-01012: not logged on


              ERROR:
              ORA-01012: not logged on


              ERROR:
              ORA-01012: not logged on


              ERROR:
              ORA-01012: not logged on


              ORA-00000: normal, successful completion
              Connected to an idle instance.
              ORA-01081: cannot start already-running ORACLE - shut it down first
              BEGIN dbms_backup_restore.zeroDbid(0); END;

              *
              ERROR at line 1:
              ORA-01012: not logged on
              Process ID: 0
              Session ID: 0 Serial number: 0


              ORACLE instance shut down.
              Connected to an idle instance.
              ORA-00000: normal, successful completion
              ERROR:
              ORA-01012: not logged on


              ERROR:
              ORA-01012: not logged on


              ERROR:
              ORA-01012: not logged on


              ERROR:
              ORA-01012: not logged on


              ERROR:
              ORA-01012: not logged on


              ERROR:
              ORA-01012: not logged on


              ERROR:
              ORA-01012: not logged on


              Disconnected
              exit_code=1

              Checking for errors ...

              The database has not been successfully created. Shutting down the instance ...

              SQL*Plus: Release 11.2.0.3.0 Production on Mon Aug 19 00:21:57 2013

              Copyright (c) 1982, 2011, Oracle.  All rights reserved.

              Connected to an idle instance.
              ORACLE instance shut down.
              Disconnected

              .end std out.

              .end err out.


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

              getConnectionUsingAppsJDBCConnector() -->
                  APPS_JDBC_URL='null'
                  Trying to get connection using SID based connect descriptor
              getConnection() -->
                  sDbHost    : NGDEBSLVP01
                  sDbDomain  : HOSTNAME.DOMAINNAME.COM
                  sDbPort    : 1523
                  sDbSid     : CDP1EBS1
                  sDbUser    : apps
                  Trying to connect using SID...
              getConnectionUsingSID() -->
                  JDBC URL: jdbc:oracle:thin:@NGDEBSLVP01.HOSTNAME.DOMAINNAME.COM:1523:CDP1EBS1
                  Exception occurred: java.sql.SQLException: IO Error: Socket read timed out
                  Trying to connect using SID as ServiceName
              getConnectionUsingServiceName() -->
                  JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=NGDEBSLVP01.HOSTNAME.DOMAINNAME.COM)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=CDP1EBS1)))
                  Exception occurred: java.sql.SQLException: IO Error: Socket read timed out
                  Trying to connect using SID as ServiceName.DomainName
              getConnectionUsingServiceName() -->
                  JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=NGDEBSLVP01.HOSTNAME.DOMAINNAME.COM)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=CDP1EBS1.HOSTNAME.DOMAINNAME.COM)))
                  Exception occurred: java.sql.SQLException: IO Error: Socket read timed out
                  Connection could not be obtained; returning null

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

              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:635)
                      at oracle.apps.ad.clone.ApplyDatabase.doApply(ApplyDatabase.java:473)
                      at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:366)
                      at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:110)
                      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:501)
                      at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:67)
                      at java.lang.Thread.run(Thread.java:637)

              • 5. Re: 50% completed RC-50004: Fatal: Error occurred in ApplyDatabase
                Hussein Sawwan-Oracle
                ORA-01081: cannot start already-running ORACLE - shut it down first

                 

                Is the database already running on the target server? Are you trying to clone a database with the same name which is already running on this server?

                 

                OERR: ORA 1081 cannot start already-running Oracle - shut it down first (Doc ID 18657.1)

                 

                Thanks,

                Hussein

                • 6. Re: 50% completed RC-50004: Fatal: Error occurred in ApplyDatabase
                  Hussein Sawwan-Oracle

                  MohammedAbdulMuqeet wrote:

                   

                  Hi Hussain,

                   

                  Quick update - i have not discovered any errors in the database alert log file.

                   

                  I ran adcfgclone.pl and after running 45 minutes it is failing with above error.

                   

                  COuld you please advise.

                   

                  Regards

                  Mohammed.

                   

                  Looks like the database is already running -- Please see my previous reply.

                   

                  Thanks,

                  Hussein

                  • 7. Re: 50% completed RC-50004: Fatal: Error occurred in ApplyDatabase
                    Mohammed Abdul Muqeet

                    So the database on the target server has not started yet. after 50% it is giving the above error.

                     

                    Database SID @ source and Target are diffrent.

                     


                    Regards

                    Mohammed. Abdul Muqeet

                    • 8. Re: 50% completed RC-50004: Fatal: Error occurred in ApplyDatabase
                      Hussein Sawwan-Oracle

                      Please shutdown all the instances running on the target server and run postclone again. If you still get the same error, then I would suggest you delete the files on the target server, restore the files again from the source node backup and run postclone again.

                       

                      Thanks,

                      Hussein