This discussion is archived
8 Replies Latest reply: Aug 18, 2013 8:30 PM by Hussein Sawwan-Oracle RSS

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

Mohammed Abdul Muqeet Explorer
Currently Being Moderated

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 Employee ACE
    Currently Being Moderated
    java.lang.Exception: Control file creation failed

     

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

     

    Thanks,

    Hussein

  • 2. Re: 50% completed RC-50004: Fatal: Error occurred in ApplyDatabase
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated

    Please also see https://forums.oracle.com/community/developer/search.jspa?q="java.lang.Exception%3A+Control+file+creation+failed"+AND+Cl…

     

    Searching the forum before posting similar questions would save your time (and ours).

     

    Thanks,

    Hussein

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

    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 Explorer
    Currently Being Moderated

    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 Employee ACE
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated

    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 Explorer
    Currently Being Moderated

    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 Employee ACE
    Currently Being Moderated

    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points