This discussion is archived
2 Replies Latest reply: Oct 12, 2013 5:07 AM by mseberg RSS

Error 1031 received logging on to the standby

SENSEIYODA Newbie
Currently Being Moderated

Error 1031 received logging on to the standby

ORA-01031:insufficient privileges

PING[ARC0]: Heartbeat failed to connect to standby 'dgp'. Error is 1031.




please help me

  • 1. Re: Error 1031 received logging on to the standby
    Anar Godjaev Expert
    Currently Being Moderated

    HI,

     

    For the redo transfer to take place efficiently, the password file on standby should be a copy from the primary and renamed standby. We can use v$pwd_file_users data dictionary view to check if the password file is used

    1.copy the password file from the primary to the standby and renamed the password file in the following format ie orapw<sid> .

    2.Restart the media recovery process on the standby.

     

    Once the above steps are completed we could see that redo shipping and redo apply is taking place.

    Copy the latest Password file from available PRIMARY Node to rest of PRIMARY and STANDBY nodes:

    cd $ORACLE_HOME/dbs

    ls -lrt

    scp orapw<sid> oracle@PROD_NODE_2_hostname:/oracle/home/dbs

    scp orapw<sid> oracle@DR_NODE_1_hostname:/oracle/home/dbs

    scp orapw<sid> oracle@DR_NODE_2_hostname:/oracle/home/dbs

     

    DR

     

    select * from gv$pwfile_users;

    we have to check sec_case_sensitive_logon parameter on primary and standby.

    SQL> show parameter sec_case_sensitive_logon;

     

    NAME TYPE VALUE

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

    sec_case_sensitive_logon boolean FALSE

    SQL>

    We have to recreate the passwd file or copy Primary server to Standby server.

     

    In cause sec_case_sensitive_logon parameter value is true, we have to use below orapwd command.

    orapwd file=$ORACLE_HOME/dbs/orapwPROD password=password123 entries=10 ignorecase=y

     

    In cause sec_case_sensitive_logon parameter value is false, we have to use below orapwd command.

    orapwd file=$ORACLE_HOME/dbs/orapwPROD password=password123 entries=10

     

    DR

     

    cancelling MRP process:

    alter database recover managed standby database cancel;

     

    starting mrp process:

    alter database recover managed standby database disconnect from session;

    select inst_id,process,status,thread#,sequence#,block#,blocks from gv$managed_standby;

    check DR sync and see the difference.

     

    Referance Link:

     

     

    Thank you

  • 2. Re: Error 1031 received logging on to the standby
    mseberg Guru
    Currently Being Moderated

    Hello;

     

    Until you can do the following:

     

    sqlplus sys/pass@Standby as sysdba (from the primary system)

     

    and

     

    sqlplus sys/pass@primary as sysdba (from the standby system)

     

    You will not be able to ship redo.

     

    If it is your password file not only do you have to copy it to the standby and rename it, but you need to stop recovery and restart the database on the new password file.

     

    Also double check this parameter;

     

    remote_login_passwordfile='EXCLUSIVE'

     

    If the 1031 stops and you get another error try:

     

    Shutdown listener and Database

    Start Database

    Start Listener

    SQL> alter system register;

    Start MRP

     

    Best Regards

     

    mseberg

Legend

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