Recently I was playing with 23ai at ExaCC and got a strange error reporting format mismatch for the password file for my standby. Digging over it I saw that the orapwd has a different default value than dbca.
First, check below my database created with dbca (the same process that I described in the previous post):
[oracle@exxc05db01 ~]$ sqlplus / as sysdba SQL*Plus: Release 23.0.0.0.0 - Production on Tue Jul 23 16:32:29 2024 Version 23.4.0.24.05 Copyright (c) 1982, 2024, Oracle. All rights reserved. Connected to: Oracle Database 23ai EE Extreme Perf Release 23.0.0.0.0 - Production Version 23.4.0.24.05 SQL> col file_name format a80 SQL> set linesize 255 SQL> select * from V$PASSWORDFILE_INFO; FILE_NAME FORMAT IS_AS IS_EX CON_ID -------------------------------------------------------------------------------- ------ ----- ----- ---------- +DATAC5/ORCL23A/PASSWORD/pwdorcl23a.1071.1172152403 12 TRUE FALSE 0 SQL> exit Disconnected from Oracle Database 23ai EE Extreme Perf Release 23.0.0.0.0 - Production Version 23.4.0.24.05 [oracle@exxc05db01 ~]$