9 Replies Latest reply: Oct 21, 2012 9:44 AM by Hussein Sawwan-Oracle RSS

    11i Cloning problem occured 70 percent each time

    DBA_Zeropoint
      Dear all

      i was performing 11i application post clone at linux plate form. My application version is 11.5.0 and Linux 4 on both target and source system. During post of clone, when i reach the point 70 %, every time give the same error. Can you please help me to overcome my problem. The error detail is as
      ----------------------

      Beginning database tier Apply - Wed Jun 20 10:08:18 2012
      Log file located at /oracle/oracle/proddb/9.2.0/appsutil/log/TEST_localhost/ApplyDBTier_06201008.log
      RC-50004: Fatal: Error occurred in ApplyDatabase:
      Control file creation failed

      ERROR while running Apply...

      ERROR: Failed to execute /oracle/oracle/proddb/9.2.0/appsutil/clone/bin/adclone.pl
      ======== AND IN LOG FILE I FOUND==============
      Connected.
      ORACLE instance shut down.
      Connected to an idle instance.
      ORACLE instance started.

      Total System Global Area 581506668 bytes
      Fixed Size          452204 bytes
      Variable Size          402653184 bytes
      Database Buffers     167772160 bytes
      Redo Buffers          10629120 bytes

      Control file created.

      alter database open resetlogs
      *
      ERROR at line 1:
      ORA-01194: file 1 needs more recovery to be consistent
      ORA-01110: data file 1: '/oracle/oracle/proddata/system01.dbf'


      alter tablespace TEMP add tempfile '/oracle/oracle/proddata/temp01.dbf' REUSE
      *
      ERROR at line 1:
      ORA-01109: database not open


      ALTER DATABASE RENAME GLOBAL_NAME TO "TEST.localdomain"
      *
      ERROR at line 1:
      ORA-01109: database not open


      ORA-01109: database not open


      Database dismounted.
      ORACLE instance shut down.
      Connected to an idle instance.
      ORACLE instance started.

      Total System Global Area 581506668 bytes
      Fixed Size          452204 bytes
      Variable Size          402653184 bytes
      Database Buffers     167772160 bytes
      Redo Buffers          10629120 bytes
      Database mounted.

      PL/SQL procedure successfully completed.

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

      Total System Global Area 581506668 bytes
      Fixed Size          452204 bytes
      Variable Size          402653184 bytes
      Database Buffers     167772160 bytes
      Redo Buffers          10629120 bytes

      Control file created.

      alter database open resetlogs
      *
      ERROR at line 1:
      ORA-01194: file 1 needs more recovery to be consistent
      ORA-01110: data file 1: '/oracle/oracle/proddata/system01.dbf'


      alter tablespace TEMP add tempfile '/oracle/oracle/proddata/temp01.dbf' REUSE
      *
      ERROR at line 1:
      ORA-01109: database not open


      ALTER DATABASE RENAME GLOBAL_NAME TO "TEST.localdomain"
      *
      ERROR at line 1:
      ORA-01109: database not open


      declare lib_ver varchar2(3);
      *
      ERROR at line 1:
      ORA-01219: database not open: queries allowed on fixed tables/views only


      Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
      With the Partitioning, OLAP and Oracle Data Mining options
      JServer Release 9.2.0.6.0 - Production
      exit_code=1

      Checking for errors ...

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

      SQL*Plus: Release 9.2.0.6.0 - Production on Wed Jun 20 10:10:08 2012

      Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

      Connected.
      ORACLE instance shut down.
      Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
      With the Partitioning, OLAP and Oracle Data Mining options
      JServer Release 9.2.0.6.0 - Production

      .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 : localhost
      sDbDomain : localdomain
      sDbPort : 1522
      sDbSid : TEST
      sDbUser : APPS
      Trying to connect using SID...
      getConnectionUsingSID() -->
      JDBC URL: jdbc:oracle:thin:@localhost.localdomain:1522:TEST
      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=localhost.localdomain)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=TEST)))
      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=localhost.localdomain)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=TEST.localdomain)))
      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-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.<init>(ApplyDatabase.java:661)
           at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:328)
           at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:304)
           at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:154)
           at java.lang.reflect.Constructor.newInstance(Native Method)
           at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:68)
           at java.lang.Thread.run(Thread.jav


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

      Please guide me what i do in this scnerio. Because i performed post of clone 4 or 5 time. But same error occured


      REGARDS


      AHMED....
        • 1. Re: 11i Cloning problem occured 70 percent each time
          Helios-GunesEROL
          Hi;
          ERROR at line 1:
          ORA-01194: file 1 needs more recovery to be consistent
          ORA-01110: data file 1: '/oracle/oracle/proddata/system01.dbf'
          Did you run preclone before start clone?
          Did you close all your process before running copy process.(ps -u oramgr)
          It seems you need to run preclone again and start over copy process

          Regard
          Helios
          • 2. Re: 11i Cloning problem occured 70 percent each time
            user423976
            Hi,

            As the control file is created, try to perform recovery using clause backup controlfile and open the database.

            If this works, then you can go ahead with next step of cloning process.
            • 3. Re: 11i Cloning problem occured 70 percent each time
              DBA_Zeropoint
              Thanks Dear

              The following is error statement when failer occur.


              " Beginning database tier Apply - Sat Jun 23 13:03:55 2012
              Log file located at /oracle/oracle/proddb/9.2.0/appsutil/log/TEST_erptest/ApplyDBTier_06231303.log
              RC-50004: Fatal: Error occurred in ApplyDatabase:
              Control file creation failed

              ERROR while running Apply...

              ERROR: Failed to execute ./adclone.pl"

              =====


              Please help me with your kind information.

              Regards

              Ahmed
              • 4. Re: 11i Cloning problem occured 70 percent each time
                Hussein Sawwan-Oracle
                Log file located at /oracle/oracle/proddb/9.2.0/appsutil/log/TEST_erptest/ApplyDBTier_06231303.log
                RC-50004: Fatal: Error occurred in ApplyDatabase:
                Control file creation failed
                Check this log file and the database log file for details about the error (why the database was not created successfully).

                Thanks,
                Hussein
                • 5. Re: 11i Cloning problem occured 70 percent each time
                  DBA_Zeropoint
                  Dear Hussein


                  This is the log detail i copied from log file.
                  -----

                  Beginning database tier Apply - Wed Jun 20 10:08:18 2012
                  Log file located at /oracle/oracle/proddb/9.2.0/appsutil/log/TEST_localhost/ApplyDBTier_06201008.log
                  RC-50004: Fatal: Error occurred in ApplyDatabase:
                  Control file creation failed

                  ERROR while running Apply...

                  ERROR: Failed to execute /oracle/oracle/proddb/9.2.0/appsutil/clone/bin/adclone.pl
                  ======== AND IN LOG FILE I FOUND==============
                  Connected.
                  ORACLE instance shut down.
                  Connected to an idle instance.
                  ORACLE instance started.

                  Total System Global Area 581506668 bytes
                  Fixed Size 452204 bytes
                  Variable Size 402653184 bytes
                  Database Buffers 167772160 bytes
                  Redo Buffers 10629120 bytes

                  Control file created.

                  alter database open resetlogs
                  *
                  ERROR at line 1:
                  ORA-01194: file 1 needs more recovery to be consistent
                  ORA-01110: data file 1: '/oracle/oracle/proddata/system01.dbf'

                  alter tablespace TEMP add tempfile '/oracle/oracle/proddata/temp01.dbf' REUSE
                  *
                  ERROR at line 1:
                  ORA-01109: database not open


                  ALTER DATABASE RENAME GLOBAL_NAME TO "TEST.localdomain"
                  *
                  ERROR at line 1:
                  ORA-01109: database not open


                  ORA-01109: database not open


                  Database dismounted.
                  ORACLE instance shut down.
                  Connected to an idle instance.
                  ORACLE instance started.

                  Total System Global Area 581506668 bytes
                  Fixed Size 452204 bytes
                  Variable Size 402653184 bytes
                  Database Buffers 167772160 bytes
                  Redo Buffers 10629120 bytes
                  Database mounted.

                  PL/SQL procedure successfully completed.

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

                  Total System Global Area 581506668 bytes
                  Fixed Size 452204 bytes
                  Variable Size 402653184 bytes
                  Database Buffers 167772160 bytes
                  Redo Buffers 10629120 bytes

                  Control file created.

                  alter database open resetlogs
                  *
                  ERROR at line 1:
                  ORA-01194: file 1 needs more recovery to be consistent
                  ORA-01110: data file 1: '/oracle/oracle/proddata/system01.dbf'


                  alter tablespace TEMP add tempfile '/oracle/oracle/proddata/temp01.dbf' REUSE
                  *
                  ERROR at line 1:
                  ORA-01109: database not open


                  ALTER DATABASE RENAME GLOBAL_NAME TO "TEST.localdomain"
                  *
                  ERROR at line 1:
                  ORA-01109: database not open


                  declare lib_ver varchar2(3);
                  *
                  ERROR at line 1:
                  ORA-01219: database not open: queries allowed on fixed tables/views only


                  Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
                  With the Partitioning, OLAP and Oracle Data Mining options
                  JServer Release 9.2.0.6.0 - Production
                  exit_code=1

                  Checking for errors ...

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

                  SQL*Plus: Release 9.2.0.6.0 - Production on Wed Jun 20 10:10:08 2012

                  Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

                  Connected.
                  ORACLE instance shut down.
                  Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
                  With the Partitioning, OLAP and Oracle Data Mining options
                  JServer Release 9.2.0.6.0 - Production

                  .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 : localhost
                  sDbDomain : localdomain
                  sDbPort : 1522
                  sDbSid : TEST
                  sDbUser : APPS
                  Trying to connect using SID...
                  getConnectionUsingSID() -->
                  JDBC URL: jdbc:oracle:thin:@localhost.localdomain:1522:TEST
                  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=localhost.localdomain)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=TEST)))
                  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=localhost.localdomain)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=TEST.localdomain)))
                  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-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.<init>(ApplyDatabase.java:661)
                  at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:328)
                  at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:304)
                  at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:154)
                  at java.lang.reflect.Constructor.newInstance(Native Method)
                  at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:68)
                  at java.lang.Thread.run(Thread.jav


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

                  Please guide me what i do in this scnerio. Because i performed post of clone 4 or 5 time. But same error occured


                  REGARDS


                  AHMED....
                  • 6. Re: 11i Cloning problem occured 70 percent each time
                    Yakub
                    Hi,

                    Please see this MOS id:

                    Rapid Clone Failed While Running "Adcfgclone.pl dbTier": ORA-01194 and RC-00118 [ID 375389.1]

                    Hope it will resolve your issue.

                    Thanks,
                    Yakub.
                    • 7. Re: 11i Cloning problem occured 70 percent each time
                      Hussein Sawwan-Oracle
                      alter database open resetlogs
                      *
                      ERROR at line 1:
                      ORA-01194: file 1 needs more recovery to be consistent
                      ORA-01110: data file 1: '/oracle/oracle/proddata/system01.dbf'
                      Looks like you backup/database is not consistent and you need to shutdown the source instance properly, run preclone again then copy the files -- https://forums.oracle.com/forums/search.jspa?threadID=&q=ORA-01194+AND+ORA-01110&objID=c3&dateRange=all&userID=&numResults=15&rankBy=10001

                      Thanks,
                      Hussein
                      • 8. Re: 11i Cloning problem occured 70 percent each time
                        DBA_Zeropoint
                        Actually the problem was copying the files from source to target machine. Some files were missing during copying process. So now the Clone is successful without any other operations. Thanks for all your comments.

                        Best Regards,

                        Ahmed
                        • 9. Re: 11i Cloning problem occured 70 percent each time
                          Hussein Sawwan-Oracle
                          923284 wrote:
                          Actually the problem was copying the files from source to target machine. Some files were missing during copying process. So now the Clone is successful without any other operations. Thanks for all your comments.
                          Thanks for the update and for sharing the solution.

                          Regards,
                          Hussein