Hi,
I need to get the database password file from its ASM location to the file system for a creation of Data Guard (in order to transfer it the Standby Site.)
I work in Oracle 12.2 on AIX.
I tried the following as both oracle and grid user, and in both cases the error is:
"ASMCMD-9456: password file should be located on an ASM disk group" and no file was created in the target location.
ASMCMD [+] > pwget --dbuniquename CDBOELD
+DATA1/CDBOELD/PASSWORD/pwdcdboeld.368.957193363
ASMCMD [+] > pwcopy --dbuniquename CDBOELD -f '+DATA1/CDBOELD/PASSWORD/pwdcdboeld.368.957193363' '/home/oracle'
ASMCMD-9456: password file should be located on an ASM disk group
ASMCMD [+] >
No file created under /home/oracle.
I then tried to transfer the password file to another ASM disk group, and it worked:
ASMCMD [+] > pwcopy --dbuniquename CDBOELD -f +DATA1/CDBOELD/PASSWORD/pwdcdboeld.368.957193363 +FRA1/CDBOELD
copying +DATA1/CDBOELD/PASSWORD/pwdcdboeld.368.957193363 -> +FRA1/CDBOELD/CDBOELD
ASMCMD [+] >
while it seems to have re-pointed the password file to the new location:
oracle@***************:+ASM1:/home/oracle>asmcmd -p
ASMCMD [+] > pwget --dbuniquename CDBOELD
+FRA1/CDBOELD/CDBOELD
ASMCMD [+] >
I have reviewed the following Oracle support note:
Step By Step Guide On Creating Physical Standby Using RMAN Backup based Duplicate In ASM For ASM Primary (Doc ID 837102.1)
which says:
"c) Recreate the password file in standby using orapwd utility"
Can someone tell me how this should work in 12.2: is pwcopy supposed to work, or should I re-create the password file?
Thank you,
Emilija