ORA-23364: Feature not enabled: Advanced replication

Cause : The Advanced Replication feature is not enabled at this site. Updatable materialized views, deferred RPCs, and other replication features are, therefore, unavailable.

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

Do not attempt to use this feature. Contact an Oracle Customer Support representative if the Advanced Replication feature has been purchased but not enabled.

update : 26-09-2017
ORA-23364

ORA-23364 - Feature not enabled: Advanced replication
ORA-23364 - Feature not enabled: Advanced replication

  • ora-37135 : (XSCCOMP10) Cannot aggregate over COMPRESSED COMPOSITE workspace object using AGGMAP workspace object. The RELATION statement for dense dimension workspace object must precede RELATION statements over the bases of the COMPRESSED COMPOSITE.
  • ora-14252 : invalid ALTER TABLE MODIFY PARTITION option for a Hash partition
  • ora-13214 : failed to compute supercell for window object
  • ora-06312 : IPA: Incorrect outgoing service name supplied
  • ora-01875 : time zone minute must be between -59 and 59
  • ora-24794 : no active DTP service found
  • ora-10267 : Inhibit KSEDMP for testing
  • ora-16515 : no rcv channel
  • ora-23355 : object string.string does not exist or is invalid at master site
  • ora-14618 : cannot drop the last value of subpartition
  • ora-15002 : parameter LOCK_NAME_SPACE exceeds limit of string characters
  • ora-28514 : heterogeneous database link initialization could not convert system date
  • ora-13142 : invalid PROXIMITY window definition
  • ora-31698 : Error stack buffer size must be specified and must be greater than 0.
  • ora-25402 : transaction must roll back
  • ora-12433 : create trigger failed, policy not applied
  • ora-31121 : The string operator can not be FALSE
  • ora-02450 : Invalid hash option - missing keyword IS
  • ora-16533 : inconsistent Data Guard broker state
  • ora-31638 : cannot attach to job string for user string
  • ora-10936 : trace name context forever
  • ora-30103 : 'string' contains an illegal integer radix for 'string'
  • ora-36873 : (XSTFDSC03) Column type must be specified explicitly.
  • ora-36986 : (XSRELGID05) Relation workspace object must be dimensioned by workspace object.
  • ora-29504 : invalid or missing schema name
  • ora-14063 : Unusable index exists on unique/primary constraint key
  • ora-12236 : TNS:protocol support not loaded
  • ora-32120 : Buffer size is less than amount specified
  • ora-10585 : Test recovery can not apply redo that may modify control file
  • ora-31219 : DBMS_LDAP: PL/SQL - Invalid LDAP notypes.
  • 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.