13 Replies Latest reply: Sep 2, 2013 10:12 AM by nico_nij RSS

    Data Guard - ORA-17627: ORA-01017: invalid username/password

    nico_nij

      Hi,

       

      I have a strange behavior with a Data Guard environment on Linux and Oracle 11.2.0.2. Since a couple of days, I have the following error in the alertlog of the standby database:

       

      Errors in file /u00/app/oracle/diag/rdbms/SID_site2/SID/trace/SID_pr0f_22728.trc:

      ORA-17627: ORA-01017: invalid username/password; logon denied

      ORA-17629: Cannot connect to the remote database server

       

      First I restarted the Apply on the standby without any changes. So I tried to connect to the primary database from the standby server with Oracle .Net with success. In the other way, it's also working.

      I also tried to copy the password file from the primary server to the standby server and I restarted both the transport and the apply.

      The error is still happening on the standby but the most surprising is that the Data Guard is still fully synchronized.

       

      Why I get that error and what is the function of the process pr0f?

      How can I resolve that issue?