How to Copy ASM Password File From Primary to Standby

It is a prerequisite for both primary and secondary databases have same copy of password file, and stored in ASM diskgroup preferred

From 12.1.0.2 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”

Thomas says:

December 7, 2017 at 9:28 am

Hi,

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.

Thanks

LikeLiked by 1 person

Reply
1. dbalifeeasy says:
  
  December 14, 2017 at 1:13 pm
  
  Thanks Thomas, for primary/standby configurations, it is compulsory to have to copy password file from primary db to standby db. Cheers,
  dbalifeeasy
  
  LikeLiked by 2 people
  
  Reply
Pingback: Create a 12c RAC Standby Database From Overnight RMAN Tape Backups | dbalifeeasy