This discussion is archived
12 Replies Latest reply: Feb 6, 2013 9:32 PM by Step_Into_Oracle_DBA RSS

problem with primary log shipping

Madhu.149 Newbie
Currently Being Moderated
Hello All,


Oracle Database 11g EE 11.2.0.1

I have configured primary and standby database, but I am facing the below error.
alert_edu.log

Errors in file d:\oracle11gee\diag\rdbms\edu\education\trace\education_arc2_924.trc:
ORA-16191: Primary log shipping client not logged on standby
PING[ARC2]: Heartbeat failed to connect to standby 'edu_stby'. Error is 16191.
Wed Jan 30 09:18:56 2013
Errors in file d:\oracle11gee\diag\rdbms\edu\education\trace\education_arc2_924.trc:
ORA-01017: invalid username/password; logon denied
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
------------------------------------------------------------
Errors in file d:\oracle11gee\diag\rdbms\edu\education\trace\education_arc2_924.trc:
ORA-16191: Primary log shipping client not logged on standby
PING[ARC2]: Heartbeat failed to connect to standby 'edu_stby'. Error is 16191.
Primary:*
Service Name = edu
password file = PWDedu.ora (in dbs directory)


Standby*
Service Name = edu_stby
password file = PWDedu_stby.ora


Can anyone help me to solve this problem?
  • 1. Re: problem with primary log shipping
    yoonas Expert
    Currently Being Moderated
    Hi,

    Whats is your db unnique name for 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
    >
    Did you check the REMOTE_LOGIN_PASSWORDFILE parameter

    Hope you copied the the password file from source to target host and renamed to the above given name.



    See
    Troubleshooting - Heartbeat failed to connect to standby [ID 1432367.1]
    Troubleshooting ORA-16191 and ORA-1017 in Data Guard Log Transport Services [ID 1368170.1]

    Regards
    Yoonas

    Edited by: yoonus on Jan 29, 2013 9:01 PM
  • 2. Re: problem with primary log shipping
    Madhu.149 Newbie
    Currently Being Moderated
    Hi,
    Whats is your db unnique name for standby?
    Standby db unique name is edu_stby
    Did you check the REMOTE_LOGIN_PASSWORDFILE parameter
    
    
    SQL> show parameter password;
    
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    remote_login_passwordfile            string      EXCLUSIVE
    Hope you copied the the password file from source to target host and renamed to the above given name.
    
    
    Yes.
    Thanks,
    Madhu

    Edited by: Madhu.149 on Jan 30, 2013 10:37 AM
  • 3. Re: problem with primary log shipping
    yoonas Expert
    Currently Being Moderated
    Can you access target server (ping <server>)

    Try connecting with edu_stby , username/password@edu_stby as sysdba
    tnsping edu_stby
    post output of lsnrctl on standby

    Edited by: yoonus on Jan 29, 2013 10:44 PM
  • 4. Re: problem with primary log shipping
    Sunny kichloo Expert
    Currently Being Moderated
    What was the syntax by which you created password file on primary database??

    The error that you are facing usually comes if you are entering the wrong password or you have not copied the password file properly??
  • 5. Re: problem with primary log shipping
    987990 Newbie
    Currently Being Moderated
    Hi,

    In 11g we need to transfer pwd file from primary to standby, just scp pwd file to standby, don't create it at standby and post the result and standby.

    Regards,

    Sanjay K. Tiwari
    www.DBActivities.com
  • 6. Re: problem with primary log shipping
    Madhu.149 Newbie
    Currently Being Moderated
    Yes I can connect..

    Primary: sqlplus <uname>/<pwd>@edu as sysdba
    Standby: sqlplus <uname>/<pwd>@edu_stby as sysdba


    Also, tnsping is working fine (tnsping edu, tnsping edu_stby)
  • 7. Re: problem with primary log shipping
    Madhu.149 Newbie
    Currently Being Moderated
    primary
    orapwd file=%oracle_home%/database/PWDedu.ora ignorecase=y

    standby
    copied PWDedu.ora to standby and renamed as PWDedu_stby.ora
  • 8. Re: problem with primary log shipping
    Madhu.149 Newbie
    Currently Being Moderated
    Yes I did the same, but even I am getting same error in alert log
  • 9. Re: problem with primary log shipping
    yoonas Expert
    Currently Being Moderated
    Are you using same setup as primary(user,directory structures...) on standby .See any privilege issue is there,
    by the way standby is up?

    What does this trace file say d:\oracle11gee\diag\rdbms\edu\education\trace\education_arc2_924.trc

    Edited by: yoonus on Jan 29, 2013 11:42 PM
  • 10. Re: problem with primary log shipping
    Madhu.149 Newbie
    Currently Being Moderated
    Yes Settings are same for standby (directories etc)

    education_arc2_924.trc
    *** 2013-01-30 11:32:11.338 4132 krsh.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
    ------------------------------------------------------------
    *** 2013-01-30 11:32:11.369 869 krsu.c
    Error 16191 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'edu_stby'
    Error 16191 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'edu_stby'
    ORA-16191: Primary log shipping client not logged on standby
    *** 2013-01-30 11:32:11.385 4132 krsh.c
    PING[ARC2]: Heartbeat failed to connect to standby 'edu_stby'. Error is 16191.
  • 11. Re: problem with primary log shipping
    yoonas Expert
    Currently Being Moderated
    Can you copy the file again and bounce the standby database
    you can also check Your standby instance name case is same as the the instance name in the passwordfile name
    Please post the standby server lsnrctl status output and primary and standby pfile contents

    Edited by: yoonus on Jan 30, 2013 12:55 AM
  • 12. Re: problem with primary log shipping
    Step_Into_Oracle_DBA Explorer
    Currently Being Moderated
    Is this RAC envionment or Standalone?

    Compare both the password files using cksum utility.

    And also defer and enable log_archive_dest_2

    Alter system set log_Archive_dest_state_2=defer;

    Alter system set log_Archive_dest_state_2=enable;

    And then do a log switch in Primary to check whether shipping is happening.


    Mark your Post as Answered or Helpful if Your question is answered.

    Thanks & Regards,
    SID

    (StepIntoOracleDBA)

    Email : stepintooracledba@gmail.com

    http://stepintooracledba.blogspot.in/

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points