Forum Stats

  • 3,760,446 Users
  • 2,251,707 Discussions
  • 7,871,127 Comments

Discussions

Heartbeat failed to connect to standby

599375
599375 Member Posts: 171
edited Nov 9, 2010 4:04PM in General Database Discussions
Hi

I was trying to setup Data Guard. My oracle version is 10.2.0.4 and OS is Windows on both Primary and Standby.After completing the configuration and mounting the Standby Database, when i issue "alter database recover managed standby database" in the alert log i get an error as :

Sun Jul 20 05:08:19 2008
Errors in file c:\oracle\product\10.2.0\admin\lims\bdump\lims_arc1_2756.trc:
ORA-01017: invalid username/password; logon denied

Sun Jul 20 05:08:19 2008
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
------------------------------------------------------------
Sun Jul 20 05:08:19 2008
Errors in file c:\oracle\product\10.2.0\admin\lims\bdump\lims_arc1_2756.trc:
ORA-16191: Primary log shipping client not logged on standby

PING[ARC1]: Heartbeat failed to connect to standby 'to_prod'. Error is 16191.
----------------------------------------------------------------------------------------------------------------------


The Trace file also has the same error message.

I had verified that on both Primary and Standby Database :
->user sys password is same
->Password file exist on both and password is same in both the files
->Oracle version is same
->I can tnsping to both primary and standby servers

Regards.
Tagged:
«1

Comments

  • 208369
    208369 Member Posts: 241
    Do you have a password file on both?

    Attempt from the primary to make a sqlplus connection to the standby, e.g:

    sqlplus [email protected] as sysdba

    you should be able to log in and verify by querying v$instance

    jason.

    --
    http://jarneil.wordpress.com
  • 599375
    599375 Member Posts: 171
    Yes i tried, it says :

    ora-01033 oracle initialization or shutdown in progress
  • 208369
    208369 Member Posts: 241
    edited Jul 20, 2008 1:42PM
    that is what you see when you do not connect as the sys user, or you connect as the sys user but without as sysdba privellege.

    so you are saying you cannot connect to the standby database from the primary as sys with sysdba priv. fix that and you will have fixed your problem (well one of them anyway!)

    You do have a password file? and the remote_login_passwordfile parameter set?

    the standby is in the mount mode, right?

    jason.

    --
    http://jarneil.wordpress.com
  • 599375
    599375 Member Posts: 171
    Hi

    I had reconfigured everything, created new password file, now i am getting error :

    Pasted the Trace file contents are :

    *** 2008-07-20 21:47:24.812
    *** SERVICE NAME:() 2008-07-20 21:47:24.781
    *** SESSION ID:(156.1) 2008-07-20 21:47:24.781
    Redo shipping client performing standby login
    OCISessionBegin failed -1
    .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
    '
    *** 2008-07-20 21:47:25.046 62692 kcrr.c
    Error 1031 received logging on to the standby
    Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'to_prod'
    Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'to_prod'
    ORA-01031: insufficient privileges
    *** 2008-07-20 21:47:25.062 62692 kcrr.c
    PING[ARC1]: Heartbeat failed to connect to standby 'to_prod'. Error is 1031.
    *** 2008-07-20 21:47:25.062 60970 kcrr.c
    kcrrfail: dest:2 err:1031 force:0 blast:1

    Thanks
  • 599375
    599375 Member Posts: 171
    edited Jul 21, 2008 1:50AM
    Hi


    Error from Primary Database AlterLog

    PING[ARC0]: Heartbeat failed to connect to standby 'to_stdb'. Error is 16191.
    Mon Jul 21 11:17:05 2008
    Errors in file h:\oracle\product\10.2.0\admin\lims\bdump\lims_arc0_3004.trc:
    ORA-01017: invalid username/password; logon denied

    Mon Jul 21 11:17:05 2008
    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
    ------------------------------------------------------------
    Mon Jul 21 11:17:05 2008
    Errors in file h:\oracle\product\10.2.0\admin\lims\bdump\lims_arc0_3004.trc:
    ORA-16191: Primary log shipping client not logged on standby

    PING[ARC0]: Heartbeat failed to connect to standby 'to_stdb'. Error is 16191.

    ----------------------------------------------------------------------------------------------------------------------


    The Trace file also has the same error message


    Error from Standby Database AlertLog


    *** 2008-07-20 21:47:24.812
    *** SERVICE NAME:() 2008-07-20 21:47:24.781
    *** SESSION ID:(156.1) 2008-07-20 21:47:24.781
    Redo shipping client performing standby login
    OCISessionBegin failed -1
    .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
    '
    *** 2008-07-20 21:47:25.046 62692 kcrr.c
    Error 1031 received logging on to the standby
    Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'to_prod'
    Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'to_prod'
    ORA-01031: insufficient privileges
    *** 2008-07-20 21:47:25.062 62692 kcrr.c
    PING[ARC1]: Heartbeat failed to connect to standby 'to_prod'. Error is 1031.
    *** 2008-07-20 21:47:25.062 60970 kcrr.c
    kcrrfail: dest:2 err:1031 force:0 blast:1

    Thanks

    Message was edited by:
    Mudassir
  • 26741
    26741 Member Posts: 4,923 Gold Trophy
    1031 would still mean that the connection is not AS SYSDBA.
    The ORA-1017 doesn't help either ! It says "invalid username/password !!"

    Is the password file synchronised between both sites ?
  • 618702
    618702 Member Posts: 2,659
    ora-01033 oracle initialization or shutdown in progress

    Restart Oracle Service and listener.

    Try to connect as sysdba
  • 599375
    599375 Member Posts: 171
    Hi

    Yes, Password file is synchronized on both the servers.

    Regards
  • 26741
    26741 Member Posts: 4,923 Gold Trophy
    And is REMOTE_LOGIN_PASSWORDFILE configured to SHARED or EXCLUSIVE so that the Password file is used ?
  • 599375
    599375 Member Posts: 171
    Hi

    When i query 'select * from v$pwfile_users;' it says no rows selected.
    Password file already exist tried recreating it.

    Thanks
This discussion has been closed.