ORA-23535: instantiating templates from multiple back ends is not allowed.

Cause : An attempt was made to set a new non-null back end database for an iAS site.

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

Call dbms_ias_configure.set_back_end_db procedure with null dblink. Then, call the same procedure with the new non-null dblink.

update : 18-08-2017
ORA-23535

ORA-23535 - instantiating templates from multiple back ends is not allowed.
ORA-23535 - instantiating templates from multiple back ends is not allowed.

  • ora-39500 : failed to notify CRS of a Startup/Shutdown event for database "string", instance "string" (ignored)
  • ora-00371 : not enough shared pool memory, should be atleast string bytes
  • ora-24419 : Proxy sessions are not supported in this mode.
  • ora-16130 : supplemental log information is missing from log stream
  • ora-25147 : UNIFORM SIZE value greater than maximum extent size
  • ora-16195 : DG_CONFIG requires DB_UNIQUE_NAME be explicitly defined
  • ora-13212 : failed to compare tile with the window object
  • ora-14277 : tables in EXCHANGE SUBPARTITION must have the same number of columns
  • ora-38407 : The ADT associated with the attribute set already exists.
  • ora-15090 : handle string is not a valid descriptor
  • ora-38726 : Flashback database logging is not on.
  • ora-16174 : user requested thread/sequence termination of managed recovery
  • ora-19706 : invalid SCN
  • ora-39305 : schema "string" does not exist
  • ora-01290 : cannot remove unlisted logfile string
  • ora-01119 : error in creating database file 'string'
  • ora-09847 : soacon: ARCH unable to open named pipe.
  • ora-39959 : invalid warning number (string)
  • ora-28261 : CURRENT_USER can not be used in PLSQL Definer's Right procedure.
  • ora-07476 : slsget: cannot get mapped memory statistics.
  • ora-25158 : Cannot specify RELY for foreign key if the associated primary key is NORELY
  • ora-24783 : Cannot switch non-migratable transactions
  • ora-02360 : fatal error during data export/import initialization
  • ora-28277 : LDAP search, while authenticating global user with passwords, failed.
  • ora-01981 : CASCADE CONSTRAINTS must be specified to perform this revoke
  • ora-39148 : unable to import data into pre-existing queue table string. Table_exists_action of string being ignored for this table
  • ora-07850 : sllfop: bad option
  • ora-28535 : invalid Heterogeneous Services context
  • ora-32404 : snapshot log uses Change Data Capture which is not enabled for this database
  • ora-22920 : row containing the LOB value is not locked
  • 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.