Skip to Main Content
  • Questions
  • ORA-46952: standby database format mismatch for password file

Breadcrumb

Dev Live Dev Intro

We are celebrating Developers at AskTOM. We welcome Developers of all levels of experience to join us at our FREE Developer Live events coming in August and September. Just click on the left to register today! If you are brand new to Database Technology, then we also have got you covered. Just click on the right for your comprehensive FREE training program to kick start your Oracle Database Development journey!

Question and Answer

Connor McDonald

Thanks for the question, Mohammad.

Asked: September 12, 2020 - 6:33 am UTC

Answered by: Connor McDonald - Last updated: September 14, 2020 - 3:11 am UTC

Category: Database Administration - Version: 19c R3

You Asked

Hi Dear,
I have a problem with standby database, whenever I run recovery manager in standby database it terminates and shows "ORA-46952: standby database format mismatch for password file" in alter log.
I did not find any in oracle support.
I would be glad to help me.
Best regards
Rajabi

and we said...

Password files have a "version", because from time to time we improve the internal format for security purposes etc.

You can see the version from

select file_name, format from v$passwordfile_info;

If you regenerate your password file on the primary with 'orapwd' , and the copy it to the standby you should be OK

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database