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 : 17-08-2017

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

  • ora-13156 : table to be registered string.string is not empty
  • ora-19611 : backup piece out of order. Expected string but found string
  • ora-19553 : device name string is invalid
  • ora-22312 : must specify either CASCADE or INVALIDATE option
  • ora-13462 : invalid blocking specification
  • ora-02348 : cannot create VARRAY column with embedded LOB
  • ora-26522 : rpc execution error
  • ora-08413 : invalid compiler type in FORMAT parameter at string
  • ora-01914 : invalid auditing option for sequence numbers
  • ora-07267 : spwat: invalid process number.
  • ora-12737 : Instant Client Light: unsupported server character set string
  • ora-24372 : invalid object for describe
  • ora-28602 : statement not permitted on tables containing bitmap indexes
  • ora-30178 : duplicate flag used in a format specification
  • ora-12528 : TNS:listener: all appropriate instances are blocking new connections
  • ora-24802 : user defined lob read callback error
  • ora-02436 : date or system variable wrongly specified in CHECK constraint
  • ora-06001 : NETASY: port set-up failure
  • ora-22309 : attribute with name "string" already exists
  • ora-25960 : join index cannot be based on a temporary table
  • ora-26711 : remote table does not contain a primary key constraint
  • ora-38451 : index is in an inconsistent state
  • ora-26664 : cannot create STREAMS process string
  • ora-24415 : Missing or null username.
  • ora-33298 : (AWUPG01) Analytic Workspace string is already in the newest format allowed by the current compatibility setting
  • ora-13250 : insufficient privileges to modify metadata table entries
  • ora-09923 : Can't spawn process - user log directory not created properly
  • ora-22153 : source variable-length array is not initialized
  • ora-07212 : slcpu: times error, unable to get cpu time.
  • ora-29279 : SMTP permanent error: 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.