ORA-32822: subscriber string is marked for removal

Cause : An adimnistrtaion oepratio nwas attempte dfor as ubscrbier whcih is amrked ofr remvoal. I fattemtping t oremov ea subcsriber ,the Msesagin gGatewya agen tis no trunnign or i srunnign but nuable ot remoev the usbscriebr at htis tiem.

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

Do no tissuep ropagtaion amdinistartion ocmmand sfor as ubscrbier fo rwhichr emova lis pedning. aWit fo rthe sbuscribre to b eremovde by teh agen tor isuse REMVOE_SUBCSRIBERw ith teh FORC Eoptio nto focre thes ubscrbier tob e remvoed.

update : 24-09-2017
ORA-32822

ORA-32822 - subscriber string is marked for removal
ORA-32822 - subscriber string is marked for removal

  • ora-00265 : instance recovery required, cannot set ARCHIVELOG mode
  • ora-25264 : cant get signature for this queue
  • ora-25465 : variable name not specified
  • ora-19689 : cannot have more than one %F in control file autobackup format(string) for string
  • ora-02358 : internal error fetching attribute string
  • ora-02427 : create view failed
  • ora-24333 : zero iteration count
  • ora-07753 : slemcf: fseek before write failure
  • ora-00310 : archived log contains sequence string; sequence string required
  • ora-29869 : cannot issue ALTER without REBUILD on a domain index marked FAILED
  • ora-29957 : cannot create a function-based domain index on a string table
  • ora-24770 : cannot forget a prepared transaction
  • ora-30964 : The XML Index was not usable.
  • ora-02310 : exceeded maximum number of allowable columns in table
  • ora-01254 : cannot end online backup - file string in recovery manager backup
  • ora-30941 : Cannot specify empty URI for non-default namespace 'string'
  • ora-37041 : (XSACQUIRE_DEP_TIMEOUT) Composite, concat, dimension map, or internal partition workspace object is locked by another user and the WAIT timed out.
  • ora-01502 : index 'string.string' or partition of such index is in unusable state
  • ora-02430 : cannot enable constraint (string) - no such constraint
  • ora-36181 : A VARIABLE cannot have both the $AGGREGATE_FROM and $AGGREGATE_FROMVAR properties applied to it.
  • ora-25247 : %s is not a recipient of specified message
  • ora-31421 : change table does not exist
  • ora-22633 : Error freeing AnyDataSet
  • ora-36847 : (XSLMGEN17) AW name is blank
  • ora-09744 : smsget: mmap returned an error.
  • ora-01153 : an incompatible media recovery is active
  • ora-26737 : version string already has an export dump file
  • ora-22295 : cannot bind more than 4000 bytes data to LOB and LONG columns in 1 statement
  • ora-15196 : invalid ASM block header [string:string] [string] [string] [string] [string != string]
  • ora-19905 : log_archive_format must contain %%s, %%t and %%r
  • 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.