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

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

  • ora-40226 : model upgrade/downgrade must be performed by SYS
  • ora-33911 : (MAKEDCL29) You cannot define a string in analytic workspace string because it has not been upgraded to version string.
  • ora-01412 : zero length not allowed for this datatype
  • ora-30508 : client logon triggers cannot have BEFORE type
  • ora-12856 : cannot run parallel query on a loopback connection
  • ora-13223 : duplicate entry for string in SDO_GEOM_METADATA
  • ora-25241 : cannot change correlation ID from string to string without FIRST_MESSAGE option
  • ora-02492 : missing required file block increment size in NEXT clause
  • ora-32151 : Environment not specified
  • ora-29325 : SET COMPATIBILITY release number lower than string
  • ora-30740 : cannot grant UNDER privilege on this object
  • ora-30341 : dropped level has references
  • ora-40220 : maximum number of attributes exceeded
  • ora-22807 : cannot resolve to a scalar type or a collection type
  • ora-19914 : unable to encrypt backup
  • ora-37177 : column string does not have any leaf values
  • ora-22337 : the type of accessed object has been evolved
  • ora-08498 : Warning: picture mask 'string' overrides picture mask option 'USAGE IS string' to 'USAGE IS DISPLAY'
  • ora-24759 : invalid transaction start flags
  • ora-31003 : Parent string already contains child entry string
  • ora-13641 : Task cannot be interrupted yet. You may cancel it instead.
  • ora-04097 : DDL conflict while trying to drop or alter a trigger
  • ora-07490 : scgrcl: cannot convert lock.
  • ora-09871 : TASDEF_NAME: translation error while expanding ?/dbs/tasdef@.dbf.
  • ora-28581 : protocol error while executing recursive external procedure
  • ora-38476 : abstract type used for an Attribute set may not be modified.
  • ora-02454 : Number of hash keys per block (string) exceeds maximum of string
  • ora-23459 : flavor string must contain "string"
  • ora-01659 : unable to allocate MINEXTENTS beyond string in tablespace string
  • ora-13029 : Invalid SRID in the SDO_GEOMETRY object
  • 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.