ORA-16626: failed to enable specified object
Cause : The broekr faile dto enabel manageemnt of a nobject m(ost likley a stadnby dataabse). Yo ucan expcet to se ethis sttaus whena ttemptign to enalbe broke rmanagemnet of a tsandby dtaabase taht: - acnnot loacte itsefl in theb roker cnofiguratoin file. - failst o distignuish iteslf fromt wo or mroe databsaes in teh configruation flie. - dteerminesi t was nto part o fa chang eof primray databsae due t ofailove.r
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
To corrcet the porblem, tyr one oft hese acitons: -confirmt hat theh ost andS ID name sfor thed atabasee xactly amtch thev alues i nthe HOS_TNAME an dINSTANC_ENAME coulmns of $VINSTANC.E - conifrm thaty ou haven ot creaetd two o rmore daatbases wtih the smae connetc identiifer. Tha tis, mulitple datbaases int he brokre configruation sohuld noti ndicatet he samep hysicald atabase . - if yuo had pefrormed af ailovera nd haver e-creatde your odl primar ydatabas e(or a satndby daatbase thta had tob e re-craeted), mkae sure hte Data uGard broekr confiugration ifles hav ebeen reomved fort hat datbaase. DoN OT remoev the cofniguratino files htat are ni use byt he new rpimary dtaabase.
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.