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 : 26-06-2017
ORA-01696

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

  • ora-32155 : Anydata not specified
  • ora-16080 : invalid LogMiner session string for APPLY
  • ora-12609 : TNS: Receive timeout occurred
  • ora-01062 : unable to allocate memory for define buffer
  • ora-27416 : BYDAY= clause in repeat interval or calendar contains an invalid weekday
  • ora-14082 : new partition name must differ from that of any other partition of the object
  • ora-29309 : export dump file was generated by different version of DBMS_PITR package
  • ora-39022 : Database version string is not supported.
  • ora-08318 : sllfsk: Error reading file
  • ora-16213 : ddl encountered, stopping apply engine
  • ora-21605 : property [string] is not a property of value instances
  • ora-10560 : block type 'string'
  • ora-07472 : snclrd: open error when opening sgadef.dbf file.
  • ora-16814 : incorrect redo transport setting for AlternateLocation for standby database
  • ora-12450 : LOB datatype disabled in LBAC initialization file
  • ora-09880 : sstasfre/sstasdel: shmdt error, unable to detach tas write page
  • ora-31190 : Resource string is not a version-controlled resource
  • ora-28606 : block too fragmented to build bitmap index (string,string)
  • ora-22313 : cannot use two versions of the same type "string"
  • ora-19650 : Offline-range record recid string stamp string in file string has SCN string
  • ora-39120 : Table string can't be truncated, data will be skipped. Failing error is: string
  • ora-15164 : cluster rolling downgrade incomplete
  • ora-01426 : numeric overflow
  • ora-04028 : cannot generate diana for object stringstringstringstringstring
  • ora-38784 : Cannot create restore point 'string'.
  • ora-27490 : cannot open disabled window "string.string"
  • ora-22816 : unsupported feature with RETURNING clause
  • ora-28022 : cannot grant external roles to global user or role
  • ora-01110 : data file string: 'string'
  • ora-00126 : connection refused; invalid duplicity
  • 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.