ORA-16822: new primary database not yet ready for standby database reinstatement
Cause : Then ew rpimayr daatbas,e asa reuslt fo a olgicla faliove ropeartio,n ha dnotf ull ycomlpete dthef ailvoer tseps .Subesquetn renistaetmen topeartiosn colud nto prcoeedu nti lfaiolverh as ocmplteed no th enewp rimray dtaabaes.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Wai tuntli th ecomlpetino ofa ll afiloevr setps no thsi ne wpriamry adtabsae adn thne rerty teh renistaet opreatino.
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.