This discussion is archived
9 Replies Latest reply: Oct 21, 2012 7:44 AM by Hussein Sawwan-Oracle RSS

11i Cloning problem occured 70 percent each time

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

Legend

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