ORA-31521: CDC subscription string already subscribes to publication ID string column string

Cause : A Change Data Capture subscription intended for import already subscribed to a published column.

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

Either verify that the existing subscription has the desired characteristics or drop the existing subscription and perform the import again.

update : 24-09-2017
ORA-31521

ORA-31521 - CDC subscription string already subscribes to publication ID string column string
ORA-31521 - CDC subscription string already subscribes to publication ID string column string

  • ora-01092 : ORACLE instance terminated. Disconnection forced
  • ora-28584 : heterogeneous apply internal error
  • ora-08106 : cannot create journal table string.string
  • ora-01883 : overlap was disabled during a region transition
  • ora-16091 : dependent archive log destination already archived
  • ora-01507 : database not mounted
  • ora-32164 : Method called on Invalid Connection type
  • ora-29878 : warning in the execution of ODCIINDEXTRUNCATE routine
  • ora-08454 : more than one S symbol specified in picture mask
  • ora-38791 : flashback did not start because file string was not in a valid incarnation
  • ora-37181 : expected exactly string columns for dimension string, got string
  • ora-27162 : thread creation failed
  • ora-12002 : there is no materialized view log on table "string"."string"
  • ora-32773 : operation not supported for smallfile tablespace string
  • ora-22978 : only simple attribute name is allowed in the WITH OBJECT OID clause
  • ora-14050 : invalid ALTER INDEX MODIFY PARTITION option
  • ora-31214 : DBMS_LDAP: PL/SQL - Invalid LDAP mod type.
  • ora-30037 : Cannot perform parallel DML after a prior DML on the object
  • ora-25439 : duplicate variable value for variable: string
  • ora-26007 : invalid value for SETID or OID column
  • ora-06709 : TLI Driver: message send failure
  • ora-31154 : invalid XML document
  • ora-31003 : Parent string already contains child entry string
  • ora-30118 : syntax error at 'string' at the end of input
  • ora-02028 : fetching an exact number of rows is not supported by the server
  • ora-07585 : spdcr: $PARSE failure
  • ora-36635 : (XSDUNION03) The base dimension workspace object has an invalid datatype for use in a UNIQUE concat definition.
  • ora-09851 : soacon: Archmon unable to lock named pipe.
  • ora-13763 : illegal ranking attribute "string"
  • ora-14016 : underlying table of a LOCAL partitioned index must be partitioned
  • 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.