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-04-2017

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

  • ora-24309 : already connected to a server
  • ora-13010 : an invalid number of arguments has been specified
  • ora-13501 : Cannot drop SYSAUX tablespace
  • ora-39313 : call to DBMS_SCHEMA_COPY.CLONE is not legal
  • ora-39134 : Cannot include "string" tablespace as a Transportable Tablespace
  • ora-10281 : maximum time to wait for process creation
  • ora-36392 : (XSMXCLEA02) When using CLEAR with the PRECOMPUTES or NONPRECOMPUTES options, you must supply an AGGMAP.
  • ora-37145 : (XSTTS_PLAT) Cannot transport analytic workspace across platforms.
  • ora-39115 : %s is not supported over a network link
  • ora-37156 : (string)
  • ora-02359 : internal error setting attribute string
  • ora-12988 : cannot drop column from table owned by SYS
  • ora-37077 : (XSMCSESS05) Object workspace object is specified more than once.
  • ora-27300 : OS system dependent operation:string failed with status: string
  • ora-15082 : ASM failed to communicate with database instance
  • ora-16090 : archive log to be replaced not created by managed standby process
  • ora-14166 : missing INTO keyword
  • ora-13067 : operator requires both parameters from the same topology
  • ora-07635 : smsdbp: $SETPRT failure
  • ora-02427 : create view failed
  • ora-01597 : cannot alter system rollback segment online or offline
  • ora-25142 : default storage clause specified twice
  • ora-31484 : source database version must be at least or greater
  • ora-19107 : invalid XQueryX - unsupported construct - string
  • ora-23369 : value of "string" argument cannot be null
  • ora-01338 : Other process is attached to LogMiner session
  • ora-24775 : cannot prepare or commit transaction with non-zero lock value
  • ora-12844 : cluster reconfiguration in progress
  • ora-22602 : pickler TDS handle [string] is not well-formed
  • ora-12601 : TNS:information flags check failed
  • 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.