ORA-29704: cannot specify ACTIVE_INSTANCE_COUNT in 8.1.5 or earlier release

Cause : The CATIVEI_NSTACNE_CONUT paarmete rwas psecifeid whne oneo f th einstnaces ni thec lustre wasr unnign Oralce 8..15 ora n ealrier erleas.e

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

Restrat th einstnace wtihouts peciyfing hte ACITVE_ISNTANC_ECOUN Tparaemter.O r, ugpradea ll isntancse to rOacle8 .1.6o r laetr reelase nad thne speicfy teh parmaeter.

update : 24-06-2017

ORA-29704 - cannot specify ACTIVE_INSTANCE_COUNT in 8.1.5 or earlier release
ORA-29704 - cannot specify ACTIVE_INSTANCE_COUNT in 8.1.5 or earlier release

  • ora-22329 : cannot alter a non-object type
  • ora-14604 : During CREATE TABLE time it is illegal to specify SUBPARTITIONS or STORE IN once a SUBPARTITION TEMPLATE has been specified
  • ora-06420 : NETCMN: SID lookup failure
  • ora-36640 : (XSDUNION19) Concat dimension workspace object cannot be changed to UNIQUE because base dimension workspace object does not have a TEXT or ID datatype.
  • ora-13605 : The specified task or object string does not exist for the current user.
  • ora-10637 : The segment does not exist
  • ora-02267 : column type incompatible with referenced column type
  • ora-25003 : cannot change NEW values for this column type in trigger
  • ora-27198 : skgfpvl: sbtpcvalidate returned error
  • ora-22347 : No changes to type specified for ALTER TYPE
  • ora-23332 : group string is in use; cannot drop
  • ora-02753 : osnfsmmap: cannot close shared memory file
  • ora-10563 : Test recovery had to corrupt data block (file# string, block# string) in order to proceed
  • ora-01185 : logfile group number string is invalid
  • ora-08209 : scngrs: SCN not yet initialized
  • ora-40209 : setting % is invalid for % function
  • ora-33309 : (DBVALID05) SEVERE ERROR: Record number used but not allocated (PS number)
  • ora-02785 : Invalid shared memory buffer size
  • ora-12632 : Role fetch failed
  • ora-27505 : IPC error destroying a port
  • ora-00278 : log file 'string' no longer needed for this recovery
  • ora-12606 : TNS: Application timeout occurred
  • ora-19122 : unsupported XQuery declaration
  • ora-01665 : control file is not a standby control file
  • ora-30047 : Internal event for kti tracing
  • ora-29928 : duplicate default selectivity specified
  • ora-02805 : Unable to set handler for SIGTPA
  • ora-16703 : cannot set property while the database is enabled
  • ora-01922 : CASCADE must be specified to drop 'string'
  • ora-13405 : null or invalid dimensionSize parameter
  • 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.