ORA-22634: Error adding new instance to AnyDataSet

Cause : Currenti nstancei n the AynDataSeth as not eben full yconstrutced.

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

Make suer that teh curren tinstanc eis full yconstrutced befoer addingn ew instnace.

update : 28-06-2017

ORA-22634 - Error adding new instance to AnyDataSet
ORA-22634 - Error adding new instance to AnyDataSet

  • ora-30736 : objects in a table or view hierarchy have to be in the same schema
  • ora-22931 : MOVE of nested table to a different tablespace not supported
  • ora-20000 : %s
  • ora-12841 : Cannot alter the session parallel DML state within a transaction
  • ora-01142 : cannot end online backup - none of the files are in backup
  • ora-36164 : (XSMXAGGR07) When using the COUNTVAR clause, the number of variables to be aggregated (number) must match the number of COUNTVAR variables (number).
  • ora-26752 : Unsupported LCR received for "string"."string"
  • ora-26083 : unsupported direct path stream version string
  • ora-02155 : invalid DEFAULT tablespace identifier
  • ora-30184 : argument type not compatible with a format code
  • ora-12524 : TNS:listener could not resolve HANDLER_NAME given in connect descriptor
  • ora-19603 : cannot backup or copy active file with KEEP .. UNRECOVERABLE option
  • ora-12828 : Can't start parallel transaction at a remote site
  • ora-13901 : Object string was not found.
  • ora-16129 : unsupported dml encountered
  • ora-36639 : (XSDUNION18) UNIQUE cannot be applied to this concat dimension because leaves workspace object and workspace object share the value number.
  • ora-36882 : (XSSRF01) The second parameter of an AW single row function cannot be NULL.
  • ora-26688 : missing key in LCR
  • ora-01648 : log string is the current log of disabled instance string (thread string)
  • ora-31187 : Cannot Add Node 'string' (type='string') to Simple Type Node 'string'
  • ora-25331 : cannot downgrade because there are commit-time queue tables
  • ora-02475 : maximum cluster chain block count of string has been exceeded
  • ora-30361 : unrecognized string type
  • ora-26701 : STREAMS process string does not exist
  • ora-16630 : that database property was deprecated
  • ora-27121 : unable to determine size of shared memory segment
  • ora-28653 : tables must both be index-organized
  • ora-31698 : Error stack buffer size must be specified and must be greater than 0.
  • ora-13699 : Advisor feature is not currently implemented.
  • ora-12838 : cannot read/modify an object after modifying it in parallel
  • 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.