Thanks for the question, Selami.
Asked: October 19, 2023 - 1:27 pm UTC
Last updated: November 05, 2023 - 11:59 pm UTC
Version: 12.2
Viewed 100+ times
You Asked
Dear Tom,
I could not find a document explaining my complicated situation:
I have queried passwordfile locations gathered from V$PASSWORDFILE_INFO and by srvctl, then results are different on active dataguard such that:
On active dataguard: results of those two queries are different:
$ srvctl config database -d prodxxx1 | grep Password
Password file: +DATAC1/PRODXXXTDG/orapwprodxxx1
SQL> select * from V$PASSWORDFILE_INFO
FILE_NAME FORMAT IS_AS CON_ID
------------------------------------------------------------ ------ ----- ----------
/u01/app/oracle/product/12.2.0.1/dbhome_1/dbs/orapwprodxxx1 12 TRUE 0
On primary DB, both queries bring same result:
SQL> select * from V$PASSWORDFILE_INFO
FILE_NAME FORMAT IS_AS CON_ID
------------------------------------------------------------ ------ ----- ----------
+DATAC1/PRODXXX/PASSWORD/pwdprodxxx.273.1065533491 12 TRUE 0
$ srvctl config database -d prodmng | grep Password
Password file: +DATAC1/PRODXXX/PASSWORD/pwdprodxxx.273.1065533491
So, which location of password file on DG is correct? Which of them should I replace after change of SYS password?
Thanks in advance,
Selami
and Connor said...
If I had to hypothesize this probably occurred during standby creation.
Our standard steps for creating a standby include:
"copy the password file to the standby node"
and this is commonly done by using 'pwcopy' in ASMCMD to get a local copy of the file and then that is scp'd over to the standby node.
If the standby was built with that, then its possible that you end up with this scenario.
In any event, you should be able to rectify this using the steps defined in MOS note 1984091.1
If you still have the conflict after following the steps in that document, then drop a line to Support to make sure your configuration is not incorrect in some way.
We're not taking comments currently, so please try again later if you want to add a comment.