This discussion is archived
9 Replies Latest reply: Jan 11, 2013 6:56 AM by Srinivasan R RSS

Log Files are not shipping to standby.

Srinivasan R Newbie
Currently Being Moderated
Hi,

I am getting the below error. My log files are not getting shipped from primary to standby. Below is the error msg from alert log file. Help needed.


Thu Jan 10 17:27:17 2013
Error 1031 received logging on to the standby
Errors in file d:\app\sesa241915\diag\rdbms\orcl\orcl\trace\orcl_arc2_2944.trc:
ORA-01031: insufficient privileges
PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. Error is 1031.


Thanks in advance.
  • 1. Re: Log Files are not shipping to standby.
    861120 Explorer
    Currently Being Moderated
    hi

    Your password file is missing in standby database or the file mismatch between primary and standby.

    Please, make sure the your parameter REMOTE_LOGIN_PASSWORDFILE is in EXCLUSIVE value and copy the password file from primary to standby again.

    Start and stop the shipping logs on primary:
    ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2 = DEFER; 
    
    ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2 = ENABLE; 
    Make some switchs (alter system switch logfile;) and check if the destination 2 has problem:
    select error from v$archive_dest where destt_id=2;
    Regards
    http://flaviosoares.com

    Edited by: Flávio Soares on Jan 10, 2013 10:40 AM
  • 2. Re: Log Files are not shipping to standby.
    mseberg Guru
    Currently Being Moderated
    Hello;

    Generally if the listener.ora and tnsnames.ora are working for Data Guard, you can avoid this error.

    Assume you have :

    remote_login_passwordfile='EXCLUSIVE'

    Also in Oracle 11 you must copy not create the password file on the new Standby. You must move and renamed it.
    Then start the Standby on this password file and then start recovery.

    Example :

    If my Primary password file is 'orapwRECOVER2'
    I would copy that to the Standby server and rename to orapwSTANDBY ( STANDBY would be your database name )

    ORA-01031: insufficient privileges

    Might be user does not have sysdba. Would try :
    sqlplus sys/password@Standby as sysdba (from the primary system)
    
    and
    
    sqlplus sys/password@primary as sysdba (from the standby system)
    Best Regards

    mseberg

    Edited by: mseberg on Jan 11, 2013 3:24 AM
  • 3. Re: Log Files are not shipping to standby.
    Srinivasan R Newbie
    Currently Being Moderated
    Hi,

    Thanks for your quick response.

    I tried both the scenarios, but still my log files are not getting shipped. In the alert log, still the same errors.

    Fri Jan 11 09:26:14 2013
    Error 1031 received logging on to the standby
    Errors in file d:\app\sesa241915\diag\rdbms\orcl\orcl\trace\orcl_arc2_2944.trc:
    ORA-01031: insufficient privileges
    PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. Error is 1031.

    Appart from this I tried these scenarios as well

    1) The entry in the listener.ora file for service_name for the auxiliary instance.
    2) The entry for db_name in the init<sid>.ora file for the auxiliary instance.
    3) The naming of the password file.
    4) The $ORACLE_SID for the auxiliary instance.

    All four items have matching case characters.

    Now I am not seeing any error message in the alert log, but still log files are not shipping.

    In the alert i am getting the below message.

    Fri Jan 11 17:48:35 2013
    Thread 1 advanced to log sequence 53 (LGWR switch)
    Current log# 2 seq# 53 mem# 0: D:\APP\SESA241915\ORADATA\ORCL\REDO02.LOG
    Fri Jan 11 17:48:35 2013
    Archived Log entry 47 added for thread 1 sequence 52 ID 0x4f65996b dest 1:


    Regards
    Srinivasan R

    Edited by: Srinivasan R on Jan 11, 2013 5:49 PM
  • 4. Re: Log Files are not shipping to standby.
    mseberg Guru
    Currently Being Moderated
    Hello again;

    1031 would still mean that the connection is not AS SYSDBA.

    Did you perform the connects as shown in prior reply?

    Best Regards

    mseberg
  • 5. Re: Log Files are not shipping to standby.
    Srinivasan R Newbie
    Currently Being Moderated
    Yes,

    I am able to connect the standby as sysdba from primary.

    Regards
    Srinivasan R
  • 6. Re: Log Files are not shipping to standby.
    mseberg Guru
    Currently Being Moderated
    Great, but that only answers half the question.

    Until you can connect both ways you probably still have an issue.

    h1. Example

    From a standby alert log

    RFS[1]: Possible network disconnect with primary database

    You need to be able to connect both ways.

    Best Regards

    mseberg

    Edited by: mseberg on Jan 11, 2013 8:09 AM
  • 7. Re: Log Files are not shipping to standby.
    CKPT Guru
    Currently Being Moderated
    Can you post information from the file "d:\app\sesa241915\diag\rdbms\orcl\orcl\trace\orcl_arc2_2944.trc"

    and output from the below query.
    set lines 200
    set numwidth 15
    column ID format 99
    column "SRLs" format 99 
    column active format 99 
    col type format a4
    
    select     ds.dest_id id
    ,     ad.status
    ,     ds.database_mode db_mode
    ,     ad.archiver type
    ,     ds.recovery_mode
    ,     ds.protection_mode
    ,     ds.standby_logfile_count "SRLs"
    ,     ds.standby_logfile_active active
    ,     ds.archived_seq#
    from     v$archive_dest_status     ds
    ,     v$archive_dest          ad
    where     ds.dest_id = ad.dest_id
    and     ad.status != 'INACTIVE'
    order by
         ds.dest_id
    /
    I want to understand one thing, You were able to connect from primary to standby and vice versa using the Net service? and you having only issue with log shipping?
  • 8. Re: Log Files are not shipping to standby.
    Srinivasan R Newbie
    Currently Being Moderated
    Hi all,

    Thanks for quick response.


    The problem is with the firewall settings. I turned off the firewall in standby. Now i tried to connect the primary from standby, I am able to connect. Vice Versa.


    Now the issue is resolved.

    Log file are getting shipped properly.


    Regards
    Srinivasan R
  • 9. Re: Log Files are not shipping to standby.
    Srinivasan R Newbie
    Currently Being Moderated
    Please find the content of trace file.

    *** 2013-01-11 10:16:41.389
    OCISessionBegin failed -1
    .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
    '
    *** 2013-01-11 10:16:41.404 4132 krsh.c
    Error 1031 received logging on to the standby
    *** 2013-01-11 10:16:41.404 869 krsu.c
    Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    ORA-01031: insufficient privileges
    *** 2013-01-11 10:16:41.420 4132 krsh.c
    PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. Error is 1031.
    *** 2013-01-11 10:16:41.420 2747 krsi.c
    krsi_dst_fail: dest:2 err:1031 force:0 blast:1

    *** 2013-01-11 10:17:41.482
    Redo shipping client performing standby login
    OCISessionBegin failed. Error -1
    .. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied
    '
    OCISessionBegin failed. Error -1
    .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
    '
    OCISessionBegin failed -1
    .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
    '
    *** 2013-01-11 10:17:41.795 4132 krsh.c
    Error 1031 received logging on to the standby
    *** 2013-01-11 10:17:41.795 869 krsu.c
    Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    ORA-01031: insufficient privileges
    *** 2013-01-11 10:17:41.795 4132 krsh.c
    PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. Error is 1031.
    *** 2013-01-11 10:17:41.795 2747 krsi.c
    krsi_dst_fail: dest:2 err:1031 force:0 blast:1

    *** 2013-01-11 10:18:41.857
    Redo shipping client performing standby login
    OCISessionBegin failed. Error -1
    .. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied
    '
    OCISessionBegin failed. Error -1
    .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
    '
    OCISessionBegin failed -1
    .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
    '
    *** 2013-01-11 10:18:42.154 4132 krsh.c
    Error 1031 received logging on to the standby
    *** 2013-01-11 10:18:42.154 869 krsu.c
    Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    ORA-01031: insufficient privileges
    *** 2013-01-11 10:18:42.154 4132 krsh.c
    PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. Error is 1031.
    *** 2013-01-11 10:18:42.154 2747 krsi.c
    krsi_dst_fail: dest:2 err:1031 force:0 blast:1

    *** 2013-01-11 10:19:42.185
    Redo shipping client performing standby login
    OCISessionBegin failed. Error -1
    .. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied
    '
    OCISessionBegin failed. Error -1
    .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
    '
    OCISessionBegin failed -1
    .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
    '
    *** 2013-01-11 10:19:42.467 4132 krsh.c
    Error 1031 received logging on to the standby
    *** 2013-01-11 10:19:42.467 869 krsu.c
    Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    ORA-01031: insufficient privileges
    *** 2013-01-11 10:19:42.467 4132 krsh.c
    PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. Error is 1031.
    *** 2013-01-11 10:19:42.467 2747 krsi.c
    krsi_dst_fail: dest:2 err:1031 force:0 blast:1

    *** 2013-01-11 10:20:42.545
    Redo shipping client performing standby login

    *** 2013-01-11 10:20:42.639
    OCISessionBegin failed. Error -1
    .. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied
    '
    OCISessionBegin failed. Error -1
    .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
    '
    OCISessionBegin failed -1
    .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
    '
    *** 2013-01-11 10:20:42.810 4132 krsh.c
    Error 1031 received logging on to the standby
    *** 2013-01-11 10:20:42.810 869 krsu.c
    Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    ORA-01031: insufficient privileges
    *** 2013-01-11 10:20:42.810 4132 krsh.c
    PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. Error is 1031.
    *** 2013-01-11 10:20:42.810 2747 krsi.c
    krsi_dst_fail: dest:2 err:1031 force:0 blast:1

    *** 2013-01-11 10:21:42.889
    Redo shipping client performing standby login
    OCISessionBegin failed. Error -1
    .. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied
    '
    OCISessionBegin failed. Error -1
    .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
    '
    OCISessionBegin failed -1
    .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
    '
    *** 2013-01-11 10:21:43.217 4132 krsh.c
    Error 1031 received logging on to the standby
    *** 2013-01-11 10:21:43.217 869 krsu.c
    Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    ORA-01031: insufficient privileges
    *** 2013-01-11 10:21:43.217 4132 krsh.c
    PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. Error is 1031.
    *** 2013-01-11 10:21:43.217 2747 krsi.c
    krsi_dst_fail: dest:2 err:1031 force:0 blast:1

    *** 2013-01-11 10:22:43.295
    Redo shipping client performing standby login
    OCISessionBegin failed. Error -1
    .. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied
    '
    OCISessionBegin failed. Error -1
    .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
    '
    OCISessionBegin failed -1
    .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
    '
    *** 2013-01-11 10:22:43.639 4132 krsh.c
    Error 1031 received logging on to the standby
    *** 2013-01-11 10:22:43.639 869 krsu.c
    Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    ORA-01031: insufficient privileges
    *** 2013-01-11 10:22:43.639 4132 krsh.c
    PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. Error is 1031.
    *** 2013-01-11 10:22:43.639 2747 krsi.c
    krsi_dst_fail: dest:2 err:1031 force:0 blast:1

    *** 2013-01-11 10:23:43.701
    Redo shipping client performing standby login
    OCISessionBegin failed. Error -1
    .. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied
    '
    OCISessionBegin failed. Error -1
    .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
    '
    OCISessionBegin failed -1
    .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
    '
    *** 2013-01-11 10:23:44.045 4132 krsh.c
    Error 1031 received logging on to the standby
    *** 2013-01-11 10:23:44.045 869 krsu.c
    Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    ORA-01031: insufficient privileges
    *** 2013-01-11 10:23:44.045 4132 krsh.c
    PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. Error is 1031.
    *** 2013-01-11 10:23:44.045 2747 krsi.c
    krsi_dst_fail: dest:2 err:1031 force:0 blast:1

    *** 2013-01-11 10:24:44.123
    Redo shipping client performing standby login
    OCISessionBegin failed. Error -1
    .. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied
    '
    OCISessionBegin failed. Error -1
    .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
    '
    OCISessionBegin failed -1
    .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
    '
    *** 2013-01-11 10:24:44.451 4132 krsh.c
    Error 1031 received logging on to the standby
    *** 2013-01-11 10:24:44.451 869 krsu.c
    Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    ORA-01031: insufficient privileges
    *** 2013-01-11 10:24:44.451 4132 krsh.c
    PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. Error is 1031.
    *** 2013-01-11 10:24:44.451 2747 krsi.c
    krsi_dst_fail: dest:2 err:1031 force:0 blast:1

    *** 2013-01-11 10:25:44.514
    Redo shipping client performing standby login

    *** 2013-01-11 10:25:44.639
    OCISessionBegin failed. Error -1
    .. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied
    '
    OCISessionBegin failed. Error -1
    .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
    '
    OCISessionBegin failed -1
    .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
    '
    *** 2013-01-11 10:25:44.951 4132 krsh.c
    Error 1031 received logging on to the standby
    *** 2013-01-11 10:25:44.951 869 krsu.c
    Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    ORA-01031: insufficient privileges
    *** 2013-01-11 10:25:44.951 4132 krsh.c
    PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. Error is 1031.
    *** 2013-01-11 10:25:44.951 2747 krsi.c
    krsi_dst_fail: dest:2 err:1031 force:0 blast:1

    *** 2013-01-11 10:26:45.014
    Redo shipping client performing standby login

    *** 2013-01-11 10:26:45.170
    OCISessionBegin failed. Error -1
    .. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied
    '
    OCISessionBegin failed. Error -1
    .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
    '
    OCISessionBegin failed -1
    .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
    '
    *** 2013-01-11 10:26:45.373 4132 krsh.c
    Error 1031 received logging on to the standby
    *** 2013-01-11 10:26:45.373 869 krsu.c
    Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    ORA-01031: insufficient privileges
    *** 2013-01-11 10:26:45.389 4132 krsh.c
    PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. Error is 1031.
    *** 2013-01-11 10:26:45.389 2747 krsi.c
    krsi_dst_fail: dest:2 err:1031 force:0 blast:1

    *** 2013-01-11 10:27:45.435
    Redo shipping client performing standby login
    OCISessionBegin failed. Error -1
    .. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied
    '

    *** 2013-01-11 10:27:45.779
    OCISessionBegin failed. Error -1
    .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
    '
    OCISessionBegin failed -1
    .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
    '
    *** 2013-01-11 10:27:45.951 4132 krsh.c
    Error 1031 received logging on to the standby
    *** 2013-01-11 10:27:45.951 869 krsu.c
    Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    ORA-01031: insufficient privileges
    *** 2013-01-11 10:27:45.967 4132 krsh.c
    PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. Error is 1031.
    *** 2013-01-11 10:27:45.967 2747 krsi.c
    krsi_dst_fail: dest:2 err:1031 force:0 blast:1

    *** 2013-01-11 10:28:46.029
    Redo shipping client performing standby login
    OCISessionBegin failed. Error -1
    .. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied
    '

    *** 2013-01-11 10:28:46.326
    OCISessionBegin failed. Error -1
    .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
    '
    OCISessionBegin failed -1
    .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
    '
    *** 2013-01-11 10:28:46.435 4132 krsh.c
    Error 1031 received logging on to the standby
    *** 2013-01-11 10:28:46.435 869 krsu.c
    Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    ORA-01031: insufficient privileges
    *** 2013-01-11 10:28:46.435 4132 krsh.c
    PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. Error is 1031.
    *** 2013-01-11 10:28:46.435 2747 krsi.c
    krsi_dst_fail: dest:2 err:1031 force:0 blast:1

    *** 2013-01-11 10:29:46.482
    Redo shipping client performing standby login
    OCISessionBegin failed. Error -1
    .. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied
    '
    OCISessionBegin failed. Error -1
    .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
    '
    OCISessionBegin failed -1
    .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
    '
    *** 2013-01-11 10:29:46.889 4132 krsh.c
    Error 1031 received logging on to the standby
    *** 2013-01-11 10:29:46.889 869 krsu.c
    Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    ORA-01031: insufficient privileges

    *** 2013-01-11 10:29:46.904
    *** 2013-01-11 10:29:46.904 4132 krsh.c
    PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. Error is 1031.
    *** 2013-01-11 10:29:46.904 2747 krsi.c
    krsi_dst_fail: dest:2 err:1031 force:0 blast:1
    Redo shipping client performing standby login

    *** 2013-01-11 10:30:47.140
    OCISessionBegin failed. Error -1
    .. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied
    '
    OCISessionBegin failed. Error -1
    .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
    '
    OCISessionBegin failed -1
    .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
    '
    *** 2013-01-11 10:30:47.297 4132 krsh.c
    Error 1031 received logging on to the standby
    *** 2013-01-11 10:30:47.297 869 krsu.c
    Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    ORA-01031: insufficient privileges
    *** 2013-01-11 10:30:47.312 4132 krsh.c
    PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. Error is 1031.
    *** 2013-01-11 10:30:47.312 2747 krsi.c
    krsi_dst_fail: dest:2 err:1031 force:0 blast:1

    *** 2013-01-11 10:31:47.378
    Redo shipping client performing standby login
    OCISessionBegin failed. Error -1
    .. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied
    '
    OCISessionBegin failed. Error -1
    .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
    '
    OCISessionBegin failed -1
    .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
    '
    *** 2013-01-11 10:31:47.691 4132 krsh.c
    Error 1031 received logging on to the standby
    *** 2013-01-11 10:31:47.691 869 krsu.c
    Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    ORA-01031: insufficient privileges
    *** 2013-01-11 10:31:47.691 4132 krsh.c
    PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. Error is 1031.
    *** 2013-01-11 10:31:47.691 2747 krsi.c
    krsi_dst_fail: dest:2 err:1031 force:0 blast:1

    *** 2013-01-11 10:32:47.772
    Redo shipping client performing standby login
    OCISessionBegin failed. Error -1
    .. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied
    '
    OCISessionBegin failed. Error -1
    .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
    '
    OCISessionBegin failed -1
    .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
    '
    *** 2013-01-11 10:32:48.069 4132 krsh.c
    Error 1031 received logging on to the standby
    *** 2013-01-11 10:32:48.069 869 krsu.c
    Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    ORA-01031: insufficient privileges
    *** 2013-01-11 10:32:48.069 4132 krsh.c
    PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. Error is 1031.
    *** 2013-01-11 10:32:48.069 2747 krsi.c
    krsi_dst_fail: dest:2 err:1031 force:0 blast:1

    *** 2013-01-11 10:33:48.135
    Redo shipping client performing standby login

    *** 2013-01-11 10:34:09.261
    OCIServerAttach failed -1
    .. Detailed OCI error val is 12170 and errmsg is 'ORA-12170: TNS:Connect timeout occurred
    '

    *** 2013-01-11 10:34:45.873
    OCIServerAttach failed -1
    .. Detailed OCI error val is 12170 and errmsg is 'ORA-12170: TNS:Connect timeout occurred
    '

    *** 2013-01-11 10:35:06.984
    OCIServerAttach failed -1
    .. Detailed OCI error val is 12170 and errmsg is 'ORA-12170: TNS:Connect timeout occurred
    '
    *** 2013-01-11 10:35:06.984 4132 krsh.c
    Error 12170 received logging on to the standby
    *** 2013-01-11 10:35:06.984 869 krsu.c
    Error 12170 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    Error 12170 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    ORA-12170: TNS:Connect timeout occurred
    *** 2013-01-11 10:35:06.999 4132 krsh.c
    PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. Error is 12170.
    *** 2013-01-11 10:35:06.999 2747 krsi.c
    krsi_dst_fail: dest:2 err:12170 force:0 blast:1

    *** 2013-01-11 10:36:07.063
    Redo shipping client performing standby login
    OCISessionBegin failed. Error -1
    .. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied
    '
    OCISessionBegin failed. Error -1
    .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
    '
    OCISessionBegin failed -1
    .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
    '
    *** 2013-01-11 10:36:07.267 4132 krsh.c
    Error 1031 received logging on to the standby
    *** 2013-01-11 10:36:07.267 869 krsu.c
    Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'orcl'
    ORA-01031: insufficient privileges
    *** 2013-01-11 10:36:07.267 4132 krsh.c
    PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. Error is 1031.
    *** 2013-01-11 10:36:07.267 2747 krsi.c
    krsi_dst_fail: dest:2 err:1031 force:0 blast:1



    2. Please find the query results.

    From Primary:

    SQL> set lines 200
    SQL> set numwidth 15
    SQL> column ID format 99
    SQL> column "SRLs" format 99
    SQL> column active format 99
    SQL> col type format a4
    SQL> select ds.dest_id id
    2 , ad.status
    3 , ds.database_mode db_mode
    4 , ad.archiver type
    5 , ds.recovery_mode
    6 , ds.protection_mode
    7 , ds.standby_logfile_count "SRLs"
    8 , ds.standby_logfile_active active
    9 , ds.archived_seq#
    10 from v$archive_dest_status ds
    11 , v$archive_dest ad
    12 where ds.dest_id = ad.dest_id
    13 and ad.status != 'INACTIVE'
    14 order by
    15 ds.dest_id
    16 /

    ID STATUS DB_MODE TYPE RECOVERY_MODE PROTECTION_MODE SRLs ACTIVE ARCHIVED_SEQ#
    --- --------- --------------- ---- ----------------------- -------------------- ---- ------ ---------------
    1 VALID OPEN ARCH IDLE MAXIMUM PERFORMANCE 0 0 72
    2 ERROR UNKNOWN LGWR IDLE MAXIMUM PERFORMANCE 0 0 0


    From Standby:

    SQL> set lines 200
    SQL> set numwidth 15
    SQL> column ID format 99
    SQL> column "SRLs" format 99
    SQL> column active format 99
    SQL> col type format a4
    SQL> select ds.dest_id id
    2 , ad.status
    3 , ds.database_mode db_mode
    4 , ad.archiver type
    5 , ds.recovery_mode
    6 , ds.protection_mode
    7 , ds.standby_logfile_count "SRLs"
    8 , ds.standby_logfile_active active
    9 , ds.archived_seq#
    10 from v$archive_dest_status ds
    11 , v$archive_dest ad
    12 where ds.dest_id = ad.dest_id
    13 and ad.status != 'INACTIVE'
    14 order by
    15 ds.dest_id
    16 /

    ID STATUS DB_MODE TYPE RECOVERY_MODE PROTECTION_MODE SRLs ACTIVE ARCHIVED_SEQ#
    --- --------- --------------- ---- ----------------------- -------------------- ---- ------ ---------------
    1 VALID OPEN ARCH IDLE MAXIMUM PERFORMANCE 0 0 72
    2 ERROR UNKNOWN LGWR IDLE MAXIMUM PERFORMANCE 0 0 0

    Regards
    Srinivasan R

Legend

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