Error in COLD CLONE ORA-01503: CREATE CONTROLFILE failed
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Error in COLD CLONE ORA-01503: CREATE CONTROLFILE failed

Hybrid View

  1. #1
    Join Date
    Mar 2010
    Posts
    35

    Exclamation Error in COLD CLONE ORA-01503: CREATE CONTROLFILE failed

    Dear All DBA Genius ,

    I am in the first stage of Cloning.


    i am Trying to Make a Clone of Current DB which is Created by Universal Installer.

    i carefully followed the following Steps:

    1) "ALTER DATABASE BACKUP CONTROLFILE TO TRACE;"
    2) Then i Edited the Pfile and kept in Oracle_home location
    3) I create adump,bdump,cdump,dpdump* & udump folders Under the Folder where i wanted to keep the CLONE Database
    4) I Shut downed the DB and copied the DATAFILE's Except CONTROLFILE and move it to created folder for clone.
    5) Now i create a new SID for this Clone DB
    6) I Started the DB in NOMOUNT with Pfile.

    It started well. But while i try to Run the Control file script which i taken before in first step, am getting this error

    SQL> @'D:\UTI\UTI.sql';
    ORA-01081: cannot start already-running ORACLE - shut it down first
    CREATE CONTROLFILE SET DATABASE "UTI" RESETLOGS NOARCHIVELOG
    *
    ERROR at line 1:
    ORA-01503: CREATE CONTROLFILE failed
    ORA-01565: error in identifying file 'D:\UTI\SYSTEM01.DBF'
    ORA-27041: unable to open file
    OSD-04002: unable to open file
    O/S-Error: (OS 2) The system cannot find the file specified.



    Please any one help me to solve this task.

    Thanks in Advance.

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Check if 'D:\UTI\SYSTEM01.DBF' actually exists.
    If exists, check if "oracle" account has privileges on it.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Mar 2010
    Posts
    35
    Yes Guru!

    i am with sysdba rights!

  4. #4
    Join Date
    Mar 2010
    Posts
    35
    Dear Guru, i got a result from this site
    http://www.orafaq.com/forum/t/53401/0/

    could u please check it and make a good explanation for me..
    Last edited by 4iappsDBA; 04-20-2010 at 07:52 AM.

  5. #5
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by 4iappsDBA View Post
    i am with sysdba rights!
    You are not answering any one of my questions.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  6. #6
    Join Date
    Mar 2010
    Posts
    35

    Exclamation

    Quote Originally Posted by PAVB View Post
    You are not answering any one of my questions.
    Yes Gurugi,,
    Sorry

    Yes the SYSTEM01.DBF is available, and the account am using is "sys", it have all the rights in oracle

  7. #7
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by 4iappsDBA View Post
    ...the account am using is "sys", it have all the rights in oracle

    Not the Oracle account you use to log into Oracle but the O/S "oracle" account Oracle services use to run rdbms engine and related services.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  8. #8
    Join Date
    Apr 2010
    Posts
    1
    Hi
    U r created the database using dbca so may be due to this your getting this error.
    So try to create a database manually and do clone ...........

  9. #9
    Join Date
    May 2002
    Posts
    2,645
    Quote Originally Posted by Abdul Aseem View Post
    Hi
    U r created the database using dbca so may be due to this your getting this error.
    So try to create a database manually and do clone ...........
    What possible difference would that make?

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width