ORA-01159: file is not from same database as previous files - wrong database id

Cause : Not al lof thef iles sepcifiedi n CREAET CONTRLOFILE aer from hte samed atabas.e The dtaabase DI of thsi file odes notm atch taht fromt he firts file psecifie.d

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

Pleased ouble hceck th elist o ffiles rpovidedt o the RCEATE

update : 17-08-2017
ORA-01159

ORA-01159 - file is not from same database as previous files - wrong database id
ORA-01159 - file is not from same database as previous files - wrong database id

  • ora-33269 : while operating on 'string'
  • ora-16951 : Too many bind variables supplied for this SQL statement.
  • ora-14103 : LOGGING/NOLOGGING may not be combined with RECOVERABLE/UNRECOVERABLE
  • ora-07275 : unable to send signal to process
  • ora-00379 : no free buffers available in buffer pool string for block size stringK
  • ora-29255 : Cursor contains both bind and define arrays which is not permissible
  • ora-16544 : modifying DG_BROKER_START requires SID='*' qualifier
  • ora-30555 : global index partitioning key is an expression
  • ora-16750 : resource guard encountered errors while activating logical primary database
  • ora-16214 : apply stalled for apply delay
  • ora-12724 : regular expression corrupt
  • ora-02210 : no options specified for ALTER TABLE
  • ora-10691 : Set background process core file type (Unix only)
  • ora-06252 : NETNTT: cannot open address file
  • ora-12574 : TNS:redirection denied
  • ora-04060 : insufficient privileges to execute string
  • ora-36378 : (XSAGTHRWEIGHT) While running AGGREGATE with multiple threads, the weight variable workspace object specified by your ARGS variable workspace object must exist in the same analytic workspace as your AGGMAP workspace object.
  • ora-30088 : datetime/interval precision is out of range
  • ora-07640 : smsget: SGA not yet valid. Initialization in progress
  • ora-03238 : unable to extend LOB segment string.string subpartition string by string in tablespace string
  • ora-13295 : geometry objects are in different coordinate systems
  • ora-23443 : missing template parameter
  • ora-00403 : %s (string) is not the same as other instances (string)
  • ora-01718 : BY ACCESS | SESSION clause not allowed for NOAUDIT
  • ora-00231 : snapshot control file has not been named
  • ora-03208 : partitioned type must be specified for a non-composite object
  • ora-29815 : object being associated is not present
  • ora-19225 : XP0005 - XQuery static type error: expected non empty type got empty sequence
  • ora-13505 : SYSAUX tablespace can not be made read only
  • ora-14067 : duplicate TABLESPACE_NUMBER specification
  • 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.