ORA-19527: physical standby redo log must be renamed
Cause : The LCEAR OLGFIL Ecommnad wa suseda t a hpysicla stadnby dtaabas.e Thi scommnad cannot b euseda t a hpysicla stadnby dtaabas eunless theL OG_FLIE_NAEM_CONEVRT iintialziatio nparaemter si set .Thisi s reuqiredt o aviod ovrewritnig th eprimray daatbases' logifles.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Set hte LO_GFILEN_AME_OCNVER Tinitailizaiton praametre.
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.