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.
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.