1 2 Previous Next 15 Replies Latest reply: Apr 12, 2012 2:35 AM by sachinpawan RSS

    no communication between primary and standby

    sachinpawan
      hi,

      i configured DG ,

      primary--->testprod
      standby--->testprod_s
      in standby machine i started standby instance with testprod and its up...
      but there is no communication between primary and standby...

      how can i lay/check communication?
        • 1. Re: no communication between primary and standby
          CKPT
          sachinpawan wrote:
          hi,

          i configured DG ,

          primary--->testprod
          standby--->testprod_s
          in standby machine i started standby instance with testprod and its up...
          but there is no communication between primary and standby...

          how can i lay/check communication?
          Have you configured all the standby parameters?
          use below link and post your output in coded format

          http://www.oracle-ckpt.com/dataguard_troubleshoot_snapper/
          • 2. Re: no communication between primary and standby
            Shivananda Rao
            Please post from the below details:

            Primary:
            log_archive_dest_1
            log_archive_dest_2
            Standby:
            log_archive_dest_1
            log_archive_dest_2
            fal_server
            fal_client
            • 3. Re: no communication between primary and standby
              sachinpawan
              its standby report
              SQL> set feedback off
              SQL> set trimspool on
              SQL> set line 500
              SQL> set pagesize 50
              SQL> set linesize 200
              SQL> column name for a30
              SQL> column display_value for a30
              SQL> col value for a10
              SQL> col PROTECTION_MODE for a15
              SQL> col DATABASE_Role for a15
              SQL> SELECT name, display_value FROM v$parameter WHERE name IN ('db_name','db_unique_name','log_archive_config','log_archive_dest_2','log_archive_dest_state_2','fal_client','fal_server','standby_file_management','standby_archive_dest','db_file_name_convert','log_file_name_convert','remote_login_passwordfile','local_listener','dg_broker_start','dg_broker_config_file1','dg_broker_config_file2','log_archive_max_processes') order by name;
              
              NAME                           DISPLAY_VALUE
              ------------------------------ ------------------------------
              db_file_name_convert           testprod_s, testprod
              db_name                        testprod
              db_unique_name                 testprod
              dg_broker_config_file1         /u01/app/oracle/product/11.2.0
                                             /dbhome_1/dbs/dr1testprod.dat
              
              dg_broker_config_file2         /u01/app/oracle/product/11.2.0
                                             /dbhome_1/dbs/dr2testprod.dat
              
              dg_broker_start                TRUE
              fal_client
              fal_server                     TESTPROD
              local_listener
              log_archive_config             DG_CONFIG=(TESTPROD,TESTPROD_S
                                             )
              
              log_archive_dest_2             SERVICE=testprod ASYNC VALID_F
                                             OR=(ONLINE_LOGFILES,PRIMARY_RO
                                             LE) DB_UNIQUE_NAME=TESTPROD
              
              log_archive_dest_state_2       ENABLE
              log_archive_max_processes      30
              log_file_name_convert
              remote_login_passwordfile      EXCLUSIVE
              standby_archive_dest           ?/dbs/arch
              standby_file_management        auto
              SQL> col name for a10
              SQL> col DATABASE_ROLE for a10
              SQL> SELECT name,db_unique_name,protection_mode,DATABASE_ROLE,OPEN_MODE from v$database;
              
              NAME       DB_UNIQUE_NAME                 PROTECTION_MODE DATABASE_R OPEN_MODE
              ---------- ------------------------------ --------------- ---------- --------------------
              TESTPROD   testprod                       MAXIMUM PERFORM PHYSICAL S READ ONLY WITH APPLY
                                                        ANCE            TANDBY
              
              SQL> select thread#,max(sequence#) from v$archived_log where applied='YES' group by thread#;
              SQL> select process, status,thread#,sequence# from v$managed_standby;
              
              PROCESS   STATUS          THREAD#  SEQUENCE#
              --------- ------------ ---------- ----------
              ARCH      CONNECTED             0          0
              ARCH      CONNECTED             0          0
              ARCH      CONNECTED             0          0
              ARCH      CONNECTED             0          0
              ARCH      CONNECTED             0          0
              ARCH      CONNECTED             0          0
              ARCH      CONNECTED             0          0
              ARCH      CONNECTED             0          0
              ARCH      CONNECTED             0          0
              ARCH      CONNECTED             0          0
              ARCH      CONNECTED             0          0
              ARCH      CONNECTED             0          0
              ARCH      CONNECTED             0          0
              ARCH      CONNECTED             0          0
              ARCH      CONNECTED             0          0
              ARCH      CONNECTED             0          0
              ARCH      CONNECTED             0          0
              ARCH      CONNECTED             0          0
              ARCH      CONNECTED             0          0
              ARCH      CONNECTED             0          0
              ARCH      CONNECTED             0          0
              ARCH      CONNECTED             0          0
              ARCH      CONNECTED             0          0
              ARCH      CONNECTED             0          0
              ARCH      CONNECTED             0          0
              ARCH      CONNECTED             0          0
              ARCH      CONNECTED             0          0
              ARCH      CONNECTED             0          0
              ARCH      CONNECTED             0          0
              ARCH      CONNECTED             0          0
              MRP0      WAIT_FOR_LOG          1          5
              SQL> col name for a30
              SQL> select * from v$dataguard_stats;
              
              NAME                           VALUE      UNIT                           TIME_COMPUTED                  DATUM_TIME
              ------------------------------ ---------- ------------------------------ ------------------------------ ------------------------------
              transport lag                             day(2) to second(0) interval   04/12/2012 08:50:56
              apply lag                                 day(2) to second(0) interval   04/12/2012 08:50:56
              apply finish time                         day(2) to second(3) interval   04/12/2012 08:50:56
              estimated startup time         7          second                         04/12/2012 08:50:56
              SQL> select * from v$archive_gap;
              SQL> col name format a60
              SQL> select    name
                2  ,    floor(space_limit / 1024 / 1024) "Size MB"
                3  ,    ceil(space_used  / 1024 / 1024) "Used MB"
                4  from    v$recovery_file_dest
                5  order by name;
              
              NAME                                                            Size MB    Used MB
              ------------------------------------------------------------ ---------- ----------
              /u01/app/oracle/flash_recovery_area                                3882        150
              SQL> spool offexit
              • 4. Re: no communication between primary and standby
                Shivananda Rao
                Looks like the db_unique_name on the standby is set as TESTPROD and your 1st post says TESTPROD is for standby.

                DB_UNIQUE_NAME should be different on primary and standby database, db_name parameter should be same on both primary and standby databases.

                Please post this:

                Primary:
                show parameter db_unique_name
                show parameter db_name
                Standby:
                show parameter db_unique_name
                show parameter db_name
                • 5. Re: no communication between primary and standby
                  sachinpawan
                  thank you ...

                  i renamed the the standby DB instance and i opened...i wil send my primary
                  • 6. Re: no communication between primary and standby
                    sachinpawan
                    SQL> set feedback off
                    SQL> set trimspool on
                    SQL> set line 500
                    SQL> set pagesize 50
                    SQL> column name for a30
                    SQL> column display_value for a30
                    SQL> column ID format 99
                    SQL> column "SRLs" format 99
                    SQL> column active format 99
                    SQL> col type format a4
                    SQL> column ID format 99
                    SQL> column "SRLs" format 99
                    SQL> column active format 99
                    SQL> col type format a4
                    SQL> col PROTECTION_MODE for a20
                    SQL> col RECOVERY_MODE for a20
                    SQL> col db_mode for a15
                    SQL> SELECT name, display_value FROM v$parameter WHERE name IN ('db_name','db_unique_name','log_archive_config','log_archive_dest_2','log_archive_dest_state_2','fal_client','fal_server','standby_file_management','standby_archive_dest','db_file_name_convert','log_file_name_convert','remote_login_passwordfile','local_listener','dg_broker_start','dg_broker_config_file1','dg_broker_config_file2','log_archive_max_processes') order by name;
                    
                    NAME                           DISPLAY_VALUE
                    ------------------------------ ------------------------------
                    db_file_name_convert           TESTPROD_S, TESTPROD
                    db_name                        testprod
                    db_unique_name                 testprod
                    dg_broker_config_file1         /u01/app/oracle/product/11.2.0
                                                   /dbhome_1/dbs/dr1testprod.dat
                    
                    dg_broker_config_file2         /u01/app/oracle/product/11.2.0
                                                   /dbhome_1/dbs/dr2testprod.dat
                    
                    dg_broker_start                TRUE
                    fal_client
                    fal_server                     TESTPROD_S
                    local_listener
                    log_archive_config             DG_CONFIG=(TESTPROD,TESTPROD_S
                                                   )
                    
                    log_archive_dest_2             SERVICE=testprod_s NOAFFIRM AS
                                                   YNC VALID_FOR=(ONLINE_LOGFILES
                                                   ,PRIMARY_ROLE) DB_UNIQUE_NAME=
                                                   TESTPROD_S
                    
                    log_archive_dest_state_2       ENABLE
                    log_archive_max_processes      30
                    log_file_name_convert          TESTPROD_S, TESTPROD
                    remote_login_passwordfile      EXCLUSIVE
                    standby_archive_dest           ?/dbs/arch
                    standby_file_management        auto
                    SQL> col name for a10
                    SQL> col DATABASE_ROLE for a10
                    SQL> SELECT name,db_unique_name,protection_mode,DATABASE_ROLE,OPEN_MODE,switchover_status from v$database;
                    
                    NAME       DB_UNIQUE_NAME                 PROTECTION_MODE      DATABASE_R OPEN_MODE            SWITCHOVER_STATUS
                    ---------- ------------------------------ -------------------- ---------- -------------------- --------------------
                    TESTPROD   testprod                       MAXIMUM PERFORMANCE  PRIMARY    READ WRITE           FAILED DESTINATION
                    SQL> select thread#,max(sequence#) from v$archived_log group by thread#;
                    
                       THREAD# MAX(SEQUENCE#)
                    ---------- --------------
                             1             16
                    SQL> SELECT ARCH.THREAD# "Thread", ARCH.SEQUENCE# "Last Sequence Received", APPL.SEQUENCE# "Last Sequence Applied", (ARCH.SEQUENCE# - APPL.SEQUENCE#) "Difference"
                      2  FROM
                      3  (SELECT THREAD# ,SEQUENCE# FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#)) ARCH,
                      4  (SELECT THREAD# ,SEQUENCE# FROM V$LOG_HISTORY WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$LOG_HISTORY GROUP BY THREAD#)) APPL
                      5  WHERE ARCH.THREAD# = APPL.THREAD# ORDER BY 1;
                    
                        Thread Last Sequence Received Last Sequence Applied Difference
                    ---------- ---------------------- --------------------- ----------
                             1                     16                    16          0
                    SQL> col severity for a15
                    SQL> col message for a70
                    SQL> col timestamp for a20
                    SQL> select severity,error_code,to_char(timestamp,'DD-MON-YYYY HH24:MI:SS') "timestamp" , message from v$dataguard_status where dest_id=2;
                    
                    SEVERITY        ERROR_CODE timestamp            MESSAGE
                    --------------- ---------- -------------------- ----------------------------------------------------------------------
                    Error                12514 11-APR-2012 20:38:21 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 11-APR-2012 20:44:21 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 11-APR-2012 20:49:22 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 11-APR-2012 20:55:22 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 11-APR-2012 21:01:22 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 11-APR-2012 21:07:22 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 11-APR-2012 21:13:22 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 11-APR-2012 21:19:22 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 11-APR-2012 21:25:22 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 11-APR-2012 21:31:22 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 11-APR-2012 21:37:22 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 11-APR-2012 21:43:22 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 11-APR-2012 21:49:22 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 11-APR-2012 21:55:22 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 11-APR-2012 22:00:57 FAL[server, ARCa]: Error 12514 creating remote archivelog file 'testpr
                                                                    od_s'
                    
                    Error                12514 11-APR-2012 22:06:22 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    SEVERITY        ERROR_CODE timestamp            MESSAGE
                    --------------- ---------- -------------------- ----------------------------------------------------------------------
                    
                    Error                12514 11-APR-2012 22:12:22 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 11-APR-2012 22:18:23 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 11-APR-2012 22:24:23 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 11-APR-2012 22:30:23 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 11-APR-2012 22:36:23 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 11-APR-2012 22:42:23 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 11-APR-2012 22:48:23 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 11-APR-2012 22:54:23 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 11-APR-2012 23:00:23 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 11-APR-2012 23:06:23 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 11-APR-2012 23:12:23 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 11-APR-2012 23:18:23 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 11-APR-2012 23:24:23 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 11-APR-2012 23:30:24 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 11-APR-2012 23:36:24 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 11-APR-2012 23:42:24 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                    
                    SEVERITY        ERROR_CODE timestamp            MESSAGE
                    --------------- ---------- -------------------- ----------------------------------------------------------------------
                                                                     is 12514.
                    
                    Error                12514 11-APR-2012 23:48:24 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 11-APR-2012 23:54:24 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 00:00:24 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 00:06:24 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 00:12:24 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 00:18:24 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 00:24:24 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 00:30:24 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 00:36:24 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 00:42:24 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 00:48:24 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 00:53:25 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 00:59:25 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 01:05:25 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 01:11:25 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    
                    SEVERITY        ERROR_CODE timestamp            MESSAGE
                    --------------- ---------- -------------------- ----------------------------------------------------------------------
                    Error                12514 12-APR-2012 01:17:25 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 01:23:25 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 01:29:25 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 01:35:25 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 01:41:25 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 01:47:25 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 01:53:25 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 01:59:25 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 02:05:25 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 02:10:26 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 02:16:26 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 02:22:26 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 02:28:26 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 02:34:26 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 02:40:26 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 02:46:26 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    SEVERITY        ERROR_CODE timestamp            MESSAGE
                    --------------- ---------- -------------------- ----------------------------------------------------------------------
                    
                    Error                12514 12-APR-2012 02:52:26 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 02:58:26 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 03:04:26 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 03:10:26 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 03:16:26 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 03:21:27 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 03:27:27 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 03:33:27 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 03:39:27 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 03:45:27 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 03:51:27 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 03:57:27 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 04:03:27 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 04:09:27 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 04:15:27 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 04:21:27 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                    
                    SEVERITY        ERROR_CODE timestamp            MESSAGE
                    --------------- ---------- -------------------- ----------------------------------------------------------------------
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 04:27:27 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 04:32:28 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 04:38:28 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 04:44:28 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 04:50:28 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 04:56:28 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 05:02:28 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 05:08:28 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 05:14:28 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 05:20:28 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 05:26:28 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 05:32:28 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 05:38:28 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 05:44:28 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 05:49:29 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    
                    SEVERITY        ERROR_CODE timestamp            MESSAGE
                    --------------- ---------- -------------------- ----------------------------------------------------------------------
                    Error                12514 12-APR-2012 05:55:29 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 06:01:29 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 06:07:29 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 06:13:29 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 06:19:29 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 06:25:29 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 06:31:29 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 06:37:29 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 06:43:29 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 06:49:29 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 06:55:29 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 07:00:48 FAL[server, ARCd]: Error 12514 creating remote archivelog file 'testpr
                                                                    od_s'
                    
                    Error                12514 12-APR-2012 07:06:30 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 07:12:30 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 07:18:30 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 07:24:30 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    SEVERITY        ERROR_CODE timestamp            MESSAGE
                    --------------- ---------- -------------------- ----------------------------------------------------------------------
                    
                    Error                12514 12-APR-2012 07:30:30 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 07:36:30 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 07:42:30 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 07:48:30 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 07:54:30 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 08:00:30 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 08:06:30 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 08:12:30 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 08:18:30 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 08:23:31 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 08:29:31 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 08:35:31 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 08:41:31 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 08:47:31 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    Error                12514 12-APR-2012 08:53:31 PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error
                                                                     is 12514.
                    
                    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;
                    
                     ID STATUS    DB_MODE         TYPE RECOVERY_MODE        PROTECTION_MODE      SRLs ACTIVE ARCHIVED_SEQ#
                    --- --------- --------------- ---- -------------------- -------------------- ---- ------ -------------
                      1 VALID     OPEN            ARCH IDLE                 MAXIMUM PERFORMANCE     0      0            16
                      2 ERROR     UNKNOWN         LGWR IDLE                 MAXIMUM PERFORMANCE     0      0             0
                    SQL> column FILE_TYPE format a20
                    SQL> col name format a60
                    SQL> select    name
                      2  ,    floor(space_limit / 1024 / 1024) "Size MB"
                      3  ,    ceil(space_used  / 1024 / 1024) "Used MB"
                      4  from    v$recovery_file_dest
                      5  order by name;
                    
                    NAME                                                            Size MB    Used MB
                    ------------------------------------------------------------ ---------- ----------
                    /u01/app/oracle/flash_recovery_area                                3882        161
                    SQL> spool off
                    • 7. Re: no communication between primary and standby
                      Shivananda Rao
                      Try it as below

                      Primary:
                      db_name=testprod
                      db_unique_name=testprod
                      Standby:
                      db_name=testprod
                      db_unique_name=testprod_s
                      FAL_SERVER=<net_oracle_service_name of Primary db>
                      • 8. Re: no communication between primary and standby
                        mseberg
                        Hello;

                        Try this simple query :
                        SELECT L.THREAD#, L.SEQUENCE#
                        FROM
                          ( SELECT THREAD#, SEQUENCE#
                            FROM V$ARCHIVED_LOG
                            WHERE DEST_ID=1) L
                          WHERE L.SEQUENCE# NOT IN
                                           ( SELECT SEQUENCE#
                                             FROM V$ARCHIVED_LOG
                                             WHERE DEST_ID=2
                                             AND THREAD# = L.THREAD#);
                        -- this should identify archive logs that have not made it to the standby

                        If it returns rows you may have an issue.

                        ORA-12514 is TNS listener issue.

                        Make sure there are no syntax errors anywhere in the TNSNAMES.ORA file.

                        Make sure a password file exists ( A copy - Create new with Oracle 11 DG does not work )


                        h3. 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. You have an error in your tnsnames and listener configuration.

                        Most likely your tnsname is missing an entry or has an incorrect entry.

                        OR

                        Check how LOG_ARCHIVE_DEST_2 is configured as in the PRIMARY database instance ?


                        Please review this note :

                        ORA-01031 ORA-12154 ORA-12514 in Standby or Dataguard Environment [ID 1271362.1]



                        Best Regards

                        mseberg

                        Edited by: mseberg on Apr 12, 2012 1:04 AM

                        Edited by: mseberg on Apr 12, 2012 1:09 AM
                        • 9. Re: no communication between primary and standby
                          CKPT
                          PING[ARC3]: Heartbeat failed to connect to standby 'testprod_s'. Error is 12514
                          post form standby

                          $lsnrctl status
                          $lsnrctl services

                          When oracle service not registered with listener, this kind of errors will be occurred.
                          Set the LOCAL_LISTENER & Register manually as below in standby and post

                          SQL>alter system register;
                          • 10. Re: no communication between primary and standby
                            mseberg
                            If you are using Data Broker do the "show database" command for both databases.

                            Change values as needed.


                            DGMGRL> show database 'testprod'

                            DGMGRL> show database 'testprod_s'


                            Look for ORA-16607 and ORA-01034


                            Also confirm the standby database is running, but "show database" should shake this out.

                            Make sure both listeners have a SID_LIST_LISTENER with a _DGMGRL entry
                            SID_LIST_LISTENER =
                              (SID_LIST =
                                (SID_DESC =
                                  (SID_NAME = PLSExtProc)
                                  (ORACLE_HOME = /u01/app/oracle/product/11.2.0)
                                  (PROGRAM = extproc)
                                )
                                (SID_DESC =
                                   (global_dbname = PRIMARY_DGMGRL.thanks.buddy.com)
                                   (ORACLE_HOME = /u01/app/oracle/product/11.2.0)
                                   (sid_name = PRIMARY)
                                )
                                  )
                            Note the _DGMGRL

                            Restart the listener (lsnrctl stop && lsnrctl start). Give your databases a few minutes to register with the listener again.

                            Best Regards

                            mseberg
                            • 11. Re: no communication between primary and standby
                              sachinpawan
                              i am not using dgbroker.....

                              FAL[client, ARC0]: Error 16191 connecting to TESTPROD for fetching gap sequence
                              Errors in file /u01/app/oracle/diag/rdbms/testprod/testprod_s/trace/testprod_s_arc0_15284.trc:
                              ORA-16191: Primary log shipping client not logged on standby
                              Errors in file /u01/app/oracle/diag/rdbms/testprod/testprod_s/trace/testprod_s_arc0_15284.trc:
                              its in standby alertlog
                              • 12. Re: no communication between primary and standby
                                sachinpawan
                                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
                                i got new error in alertlog
                                • 13. Re: no communication between primary and standby
                                  CKPT
                                  sachinpawan wrote:
                                  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
                                  i got new error in alertlog
                                  Have you put password file in standby?

                                  Copy password file and rename it in standby server, as per the SID name and then retry.
                                  from 11g you should not create password, just copy & rename.
                                  1 2 Previous Next