Oracle DBA FAQ

Would you like to react to this message? Create an account in a few clicks or log in to continue.
Oracle DBA FAQ

Oracle RAC interview questions, Oracle Dataguard, ASM, CRS, Oracle wait events, Performance Tuning


    ORA-16191: Primary log shipping client not logged on standby

    avatar
    Jay
    Guest


    ORA-16191: Primary log shipping client not logged on standby Empty ORA-16191: Primary log shipping client not logged on standby

    Post  Jay Fri Feb 12, 2010 9:55 pm

    Stanby database stop working with below error.

    ORA-16191: Primary log shipping client not logged on standby
    PING[ARCl]: Heartbeat failed to connect to standby 'STDBY'. Error is 16191.

    Redo shipping client performing standby login
    OCISessionBegin failed -1
    .. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied
    '
    *** 2009-02-25 14:41:21.470 61287 kcrr.c
    Error 1017 received logging on to the standby
    ------------------------------------------------------------
    Check that the primary and standby are using a password file
    and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
    and that the SYS password is same in the password files.
    returning error ORA-16191
    ------------------------------------------------------------
    avatar
    Mathew
    Guest


    ORA-16191: Primary log shipping client not logged on standby Empty Re: ORA-16191: Primary log shipping client not logged on standby

    Post  Mathew Fri Feb 12, 2010 9:57 pm

    Check if you have pwd file at both primary and stanby.

    If sys passwd is changed at primary, copy password file from primary to standby

    Restart the standby and start recovery.

      Current date/time is Thu Nov 21, 2024 6:22 pm