ORA-01696: control file is not a clone control file

Cause : Attemptnig to monut, a daatbase asa clone hwen it i salreadym ounted yb anothe rinstanc enot as aclone o rattemptnig to us ea curretn contro lfile fo ra clone.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Mount wtihout th eclone otpion or sue a bacukp contrlo file adn shutdonw the otehr instacnes befoer mountign as a colne.

update : 25-05-2017
ORA-01696

ORA-01696 - control file is not a clone control file
ORA-01696 - control file is not a clone control file

  • ora-12044 : invalid CREATE MATERIALIZED VIEW LOG option
  • ora-09243 : smsget: error attaching to SGA
  • ora-29832 : cannot drop or replace an indextype with dependent indexes
  • ora-14032 : partition bound of partition number string is too high
  • ora-14516 : subpartition corrupt. all rows do not fall within subpartition bounds
  • ora-15158 : rolling upgrade prevented by string
  • ora-01650 : unable to extend rollback segment string by string in tablespace string
  • ora-06133 : NETTCP: file not found
  • ora-37035 : (XSMLTDCL01) You can only DEFINE SESSION objects in analytic workspace string because it is attached in MULTI mode.
  • ora-38785 : Media recovery must be enabled for guaranteed restore point.
  • ora-01292 : no log file has been specified for the current LogMiner session
  • ora-22160 : element at index [string] does not exist
  • ora-01200 : actual file size of string is smaller than correct size of string blocks
  • ora-30122 : value 'string' for 'string' must be between 'number' and 'number'
  • ora-36403 : (XSBADSPROP) number is an illegal value for system-reserved property string on workspace object.
  • ora-12447 : policy role already exists for policy string
  • ora-12912 : Dictionary managed tablespace specified as temporary tablespace
  • ora-23425 : invalid materialized view identifier string
  • ora-13869 : Instance-wide SQL tracing on instance string is already enabled
  • ora-14293 : Number of partitioning columns does not match number of subpartitioning columns
  • ora-24786 : separated transaction has been completed
  • ora-07510 : scgbrm: $getlki unexpected return on lockid string
  • ora-38721 : Invalid file number.
  • ora-14059 : partition "string": INITRANS value must be less than MAXTRANS value
  • ora-28504 : ROWID not found in ROWID cache for heterogeneous database link
  • ora-26035 : Error attempting to encrypt or decrypt column
  • ora-12817 : parallel query option must be enabled
  • ora-02779 : Stat failed on core dump directory
  • ora-30752 : column or table string is not substitutable
  • ora-15019 : discovered duplicate path 'string' for 'string'
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.