From 184.108.40.206 on, since primary database password file is stored in ASM, so it needs to be manually copied onto standby database ASM for dataguard configuration. Otherwise the below errors will occur:
*** 2017-09-06 14:34:29.216 OCISessionBegin failed. Error -1 .. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied ' ORA-01017: invalid username/password; logon denied OCI_DBVER attribute value retrieval failed error=1017 *** 2017-09-06 14:34:30.323 OCISessionBegin failed. Error -1 .. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied ' *** 2017-09-06 14:34:30.323737 4929 krsh.c Error 1017 received logging on to the standby
Subscribe to get access
Read more of this content when you subscribe today.
3 thoughts on “How to Copy ASM Password File From Primary to Standby”
Thanks for the post, it gave me some ideas for my problem. I had similar issues and copied the password file from primary asm disk to standby oracle_home/dbs and it resolved the problem.
I was able to cross-login using sqlplus prmystby no issue before I copied the password file but I was getting the following error in stby.
ORA-16191: Primary log shipping client not logged on standby
Not sure why it worked after copying password file from asm.
LikeLiked by 1 person
Thanks Thomas, for primary/standby configurations, it is compulsory to have to copy password file from primary db to standby db. Cheers,
LikeLiked by 2 people