这篇文章主要讲解了“怎么解决oracle12.2 adg中的ORA-46952问题”，文中的讲解内容简单清晰，易于学习与理解，下面请大家跟着小编的思路慢慢深入，一起来研究和学习“怎么解决oracle12.2 adg中的ORA-46952问题”吧！

oracle 12.2 adg 在应用日志时报出这个问题

Errors in file /app/oracle/oracle/diag/rdbms/o12dbadg/O12DBDG/trace/O12DBDG_pr00_186543.trc:

ORA-46952: standby database format mismatch for password file '/app/oracle/oracle/product/12.2.0/dbhome_1/dbs/orapwO12DBDG'

问题还是在于备库的的password 文件手工创建的可能不规范，直接查出主库上的password文件，然后重新复制到备库上就可以解决这个问题：

SQL> select * from v$passwordfile_info;

FILE_NAME

--------------------------------------------------------------------------------

FORMAT IS_AS CON_ID

------ ----- ----------

+DATA/O12DB/PASSWORD/pwdo12db.256.1024706535

12 TRUE 0

关于这个错误的另外的排查处理思路：

Wasgettingthesameerrorafterprimarytostandbyswitchover:ORA-46952:standbydatabaseformatmismatchforpasswordfileANDMRP0:BackgroundMediaRecoveryprocessshutdown1.select*fromv$passwordfile_info;-->showeddifferentformatinprimary(12.2)andstandby(12)2.passwordchangeswerepropagatedcorrectlybetweenprimaryandsecondary***********************************************************************************************Formefixwas(RACenvironments):1.Deletepasswordfileonstandbywithversion12pwdelete--dbuniquenamestandby2.RemovefromSRVCTLsrvctlmodifydatabase-dbstandby-pwfile3.CreatenewpasswordfileinASM(asmcmd)pwcreate--dbuniquenamestandby+DATASM/standby/PASSWORD/pwdstandbyPwdThat#EnforcesThe12201ComplexityRulesPasswordmustcontainatleast8charactersPasswordmustnotcontaindoublequotesPasswordmustcontainatleast1letterPasswordmustcontainatleast1digitPasswordmustcontainatleast1specialcharacterPasswordmustnotcontaintheusernamePasswordmustnotcontainusernamereversed4.AddthepwdfilebacktoSRVCTLsrvctlmodifydatabase-dbstandby-pwfile+DATASM/standby/PASSWORD/pwdstandby5.select*fromv$passwordfile_info-->nowshowssameformat12.2asprimarypasswordfile6.ALTERDATABASERECOVERMANAGEDSTANDBYDATABASEDISCONNECTFROMSESSION;-->startedredoapplynoissuesIthinkourissuewasduetothelegacypasswordfilewehadontheoriginalprimarydbwhere12.2.0.1passwordcomplexityruleswerenotfollowedsoversionwasdeterminedas12vs12.2In12.2.0.1thereshouldbenoneedtocopypasswordfilesbetweenprimaryandstandbydbs.

Myissuegotresolvedafterifollowedbelowprocess:-1.Createdthepasswordfileinprimarywiththeoldpassword.2.deletedallthepasswordfileinthestandbysite.3.StartedtheMRPandstandbygotsync.4.changedthepasswordintheprimarydb(insqlplusonlylikealterusersys)anditgotsyncautomaticallywithoutcopyingfilemanually.SRhashelpedtoresolvetheissue:-TheWorkaroundtobypassthisdifferenceinRedoarethestepsininternalNote2503352.1

感谢各位的阅读，以上就是“怎么解决oracle12.2 adg中的ORA-46952问题”的内容了，经过本文的学习后，相信大家对怎么解决oracle12.2 adg中的ORA-46952问题这一问题有了更深刻的体会，具体使用情况还需要大家实践验证。这里是亿速云，小编将为大家推送更多相关知识点的文章，欢迎关注！