1 2 3 Previous Next 35 Replies Latest reply: Sep 12, 2012 6:36 AM by Sunny kichloo Go to original post RSS
      • 15. Re: PING[ARC1] Heartbeat failed to connect to standby 'xxxxx'.Error is 12154
        961013
        sorry this is my primary init


        orcldb.__db_cache_size=100663296
        orcldb.__java_pool_size=12582912
        orcldb.__large_pool_size=4194304
        orcldb.__oracle_base='/u01'#ORACLE_BASE set from environment
        orcldb.__pga_aggregate_target=113246208
        orcldb.__sga_target=3229614080
        orcldb.__shared_io_pool_size=0
        orcldb.__shared_pool_size=201326592
        orcldb.__streams_pool_size=0
        *.audit_file_dest='/u01/admin/orcldb/adump'
        *.audit_trail='db'
        *.compatible='11.1.0.0.0'
        *.control_files='/u02/orcldb/control01.ctl','/u02/orcldb/control02.ctl','/u02/orcldb/control03.ctl'
        *.db_block_size=8192
        *.db_domain=''
        *.db_name='orcldb'
        *.instance_name='orcldb'
        *.db_recovery_file_dest='/u02/FRA'
        *.db_recovery_file_dest_size=2147483648
        *.diagnostic_dest='/u01'
        *.dispatchers='(PROTOCOL=TCP) (SERVICE=orcldbXDB)'
        *.memory_target=433061888
        *.open_cursors=300
        *.processes=150
        *.remote_login_passwordfile='EXCLUSIVE'
        *.sessions=170
        #*.local_listener=prm-std
        *.undo_tablespace='UNDOTBS1'
        *.DB_UNIQUE_NAME=orcldb
        *.LOG_ARCHIVE_CONFIG='DG_CONFIG=(orcldb,standby)'
        *.LOG_ARCHIVE_DEST_1=
        'LOCATION=/u01/arch1/orcldb/
        VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
        DB_UNIQUE_NAME=orcldb'
        *.LOG_ARCHIVE_DEST_2=
        'SERVICE=stdb-prim LGWR ASYNC
        VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
        DB_UNIQUE_NAME=standby'
        LOG_ARCHIVE_DEST_STATE_1=ENABLE
        LOG_ARCHIVE_DEST_STATE_1=ENABLE
        FAL_SERVER=stdb-prim
        FAL_CLIENT=prm-std
        #DB_FILE_NAME_CONVERT='boston','chicago'
        #LOG_FILE_NAME_CONVERT=
        #'/arch1/boston/','/arch1/chicago/','/arch2/boston/','/arch2/chicago/'
        STANDBY_FILE_MANAGEMENT=AUTO
        • 16. Re: PING[ARC1] Heartbeat failed to connect to standby 'xxxxx'.Error is 12154
          abdul:
          hello,

          edit your initpfile.ora and paste it on there

          [for primary init:
          {code}
          orcl.__db_cache_size=176160768
          orcl.__java_pool_size=4194304
          orcl.__large_pool_size=4194304
          orcl.__shared_pool_size=96468992
          orcl.__streams_pool_size=0
          *.audit_file_dest='/u02/app/oracle/product/10.2.0/db_1/admin/orcl/adump'
          #*.background_dump_dest='/u02/app/oracle/product/10.2.0/db_1/admin/orcl/bdump'
          *.diagnostic_dest=/u02
          *.compatible='11.1.0.0.0'
          *.control_files='/u02/orcldb/control01.ctl','/u02/orcldb/control02.ctl','/u02/orcldb/control03.ctl'
          #*.core_dump_dest='/u02/app/oracle/product/10.2.0/db_1/admin/orcl/cdump'
          *.DB_FILE_NAME_CONVERT='oracldb','orcl'
          *.DB_UNIQUE_NAME='orcl'
          *.db_block_size=8192
          *.db_domain=''
          *.db_file_multiblock_read_count=16
          *.db_name='orcl'
          *.db_recovery_file_dest='/u01/flash_recovery_area'
          *.db_recovery_file_dest_size=2147483648
          *.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
          *.FAL_CLIENT='orcl'
          *.FAL_SERVER='orcldb'
          *.job_queue_processes=10
          *.LOG_ARCHIVE_CONFIG='DG_CONFIG=(orcl,orcldb)'
          *.log_archive_dest_1='location='LOCATION=/u01/arch1/orcldb/
          VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl'
          *.log_archive_dest_2='SERVICE=orcldb LGWR ASYNC
          VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orcldb'
          *.LOG_ARCHIVE_DEST_STATE_1='ENABLE'
          *.log_archive_dest_state_2='ENABLE'
          *.LOG_ARCHIVE_MAX_PROCESSES=6
          *.LOG_FILE_NAME_CONVERT='orcldb','orcl'
          *.open_cursors=300
          *.pga_aggregate_target=94371840
          *.processes=150
          *.remote_login_passwordfile='EXCLUSIVE'
          *.sga_target=285212672
          *.STANDBY_FILE_MANAGEMENT='AUTO'
          *.undo_management='AUTO'
          *.undo_tablespace='UNDOTBS1'
          #*.user_dump_dest='/u02/app/oracle/product/10.2.0/db_1/admin/orcl/udump'
          [forstandby init
          orcldb.__db_cache_size=100663296
          orcldb.__java_pool_size=12582912
          orcldb.__large_pool_size=4194304
          orcldb.__oracle_base='/u01'#ORACLE_BASE set from environment
          orcldb.__pga_aggregate_target=113246208
          orcldb.__sga_target=3229614080
          orcldb.__shared_io_pool_size=0
          orcldb.__shared_pool_size=201326592
          orcldb.__streams_pool_size=0
          *.audit_file_dest='/u01/admin/orcldb/adump'
          *.audit_trail='db'
          *.compatible='11.1.0.0.0'
          *.control_files='/u02/orcldb/newcnt.ctl'
          *.db_block_size=8192
          *.db_domain=''
          *.db_name='orcldb'
          #*.db_recovery_file_dest='/u02/FRA'
          *.db_recovery_file_dest_size=2147483648
          *.diagnostic_dest='/u01'
          *.dispatchers='(PROTOCOL=TCP) (SERVICE=orcldbXDB)'
          #*.memory_target=433061888
          *.open_cursors=300
          *.processes=150
          *.remote_login_passwordfile='EXCLUSIVE'
          *.sessions=170
          *.local_listener=std-prm
          *.undo_tablespace='UNDOTBS1'
          *.DB_UNIQUE_NAME=orcldb
          *.LOG_ARCHIVE_CONFIG='DG_CONFIG=(orcl,orcldb)'
          *.LOG_ARCHIVE_DEST_1=
          'LOCATION=/u01/arch1/orcldb/
          VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
          DB_UNIQUE_NAME=orcldb'
          *.LOG_ARCHIVE_DEST_2=
          'SERVICE=prm-std LGWR ASYNC
          VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
          DB_UNIQUE_NAME=orcl'
          LOG_ARCHIVE_DEST_STATE_1='ENABLE'
          LOG_ARCHIVE_DEST_STATE_1='defer'
          *.FAL_SERVER='orcl'
          *.FAL_CLIENT='orcldb'
          *.DB_FILE_NAME_CONVERT='orcl','orcldb'
          *.LOG_FILE_NAME_CONVERT='orcl','orcldb'
          *.STANDBY_FILE_MANAGEMENT=AUTO
          if you are using another name then change it by viceversa.
          best regards,
          
          Edited by: abdul_ora on Sep 10, 2012 6:38 PM                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
          • 17. Re: PING[ARC1] Heartbeat failed to connect to standby 'xxxxx'.Error is 12154
            961013
            hi friends,

            yesterday i posted wrong primary init.now am sending correct primary init.please help me out.

            primary init_


            orcldb.__db_cache_size=100663296
            orcldb.__java_pool_size=12582912
            orcldb.__large_pool_size=4194304
            orcldb.__oracle_base='/u01'#ORACLE_BASE set from environment
            orcldb.__pga_aggregate_target=113246208
            orcldb.__sga_target=3229614080
            orcldb.__shared_io_pool_size=0
            orcldb.__shared_pool_size=201326592
            orcldb.__streams_pool_size=0
            *.audit_file_dest='/u01/admin/orcldb/adump'
            *.audit_trail='db'
            *.compatible='11.1.0.0.0'
            *.control_files='/u02/orcldb/control01.ctl','/u02/orcldb/control02.ctl','/u02/orcldb/control03.ctl'
            *.db_block_size=8192
            *.db_domain=''
            *.db_name='orcldb'
            *.instance_name='orcldb'
            *.db_recovery_file_dest='/u02/FRA'
            *.db_recovery_file_dest_size=2147483648
            *.diagnostic_dest='/u01'
            *.dispatchers='(PROTOCOL=TCP) (SERVICE=orcldbXDB)'
            *.memory_target=433061888
            *.open_cursors=300
            *.processes=150
            *.remote_login_passwordfile='EXCLUSIVE'
            *.sessions=170
            #*.local_listener=prm-std
            *.undo_tablespace='UNDOTBS1'
            *.DB_UNIQUE_NAME=orcldb
            *.LOG_ARCHIVE_CONFIG='DG_CONFIG=(orcldb,standby)'
            *.LOG_ARCHIVE_DEST_1=
            'LOCATION=/u01/arch1/orcldb/
            VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
            DB_UNIQUE_NAME=orcldb'
            *.LOG_ARCHIVE_DEST_2=
            'SERVICE=stdb-prim LGWR ASYNC
            VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
            DB_UNIQUE_NAME=standby'
            LOG_ARCHIVE_DEST_STATE_1=ENABLE
            LOG_ARCHIVE_DEST_STATE_1=ENABLE
            FAL_SERVER=stdb-prim
            FAL_CLIENT=prm-std
            #DB_FILE_NAME_CONVERT='boston','chicago'
            #LOG_FILE_NAME_CONVERT=
            #'/arch1/boston/','/arch1/chicago/','/arch2/boston/','/arch2/chicago/'
            STANDBY_FILE_MANAGEMENT=AUTO
            • 18. Re: PING[ARC1] Heartbeat failed to connect to standby 'xxxxx'.Error is 12154
              Mahir M. Quluzade
              HI,

              You must enable LOG_ARCHIVE_DEST_STATE_2 with
              LOG_ARCHIVE_DEST_STATE_1=ENABLE
              LOG_ARCHIVE_DEST_STATE_2=ENABLE
              You are wnable LOG_ARCHIVE_DEST_STATE_1 two time

              Regards
              Mahir M. Quluzade
              www.mahir-quluzade.com
              • 19. Re: PING[ARC1] Heartbeat failed to connect to standby 'xxxxx'.Error is 12154
                961013
                thanks for quick reply.i modified that parameters u mentioned in the post

                i.e log_archive_dest_state_1
                log_archive_dest_state_2


                thanks,
                poorna
                • 20. Re: PING[ARC1] Heartbeat failed to connect to standby 'xxxxx'.Error is 12154
                  961013
                  even though i modified that parameters, i am getting same error.

                  thanks,
                  poorna.
                  • 21. Re: PING[ARC1] Heartbeat failed to connect to standby 'xxxxx'.Error is 12154
                    Mahir M. Quluzade
                    Hi,

                    Can you check TNSNAMES.ora file same on primary and standby side?
                    and can you add IPs (primary server and standby server IP) in hosts file with server names?
                    Can you try following commands and paste here your getting results

                    on both server
                     tnsping <primary service name> 
                     tnsping <standby service name> 
                    Regards
                    Mahir M. Quluzade
                    www.mahir-quluzade.com
                    • 22. Re: PING[ARC1] Heartbeat failed to connect to standby 'xxxxx'.Error is 12154
                      961013
                      am posting standby last few lines of alert logfile.please check it.

                      Tue Sep 11 11:46:30 2012
                      MMNL started with pid=15, OS id=2257
                      ORACLE_BASE from environment = /u01
                      Tue Sep 11 11:46:59 2012
                      alter database mount standby database
                      Setting recovery target incarnation to 1
                      ARCH: STARTING ARCH PROCESSES
                      Tue Sep 11 11:47:03 2012
                      ARC0 started with pid=17, OS id=2291
                      Tue Sep 11 11:47:03 2012
                      ARC1 started with pid=18, OS id=2295
                      Tue Sep 11 11:47:03 2012
                      ARC2 started with pid=19, OS id=2299
                      Tue Sep 11 11:47:03 2012
                      ARC3 started with pid=20, OS id=2303
                      ARC0: Archival started
                      ARC1: Archival started
                      ARC2: Archival started
                      ARC3: Archival started
                      ARCH: STARTING ARCH PROCESSES COMPLETE
                      ARC0: Becoming the 'no FAL' ARCH
                      ARC0: Becoming the 'no SRL' ARCH
                      ARC0: Thread not mounted
                      ARC1: Becoming the heartbeat ARCH
                      ARC2: Thread not mounted
                      ARC3: Thread not mounted
                      ARC1: Thread not mounted
                      Tue Sep 11 11:47:03 2012
                      Successful mount of redo thread 1, with mount id 2229677875
                      Physical Standby Database mounted.
                      Lost write protection disabled
                      Completed: alter database mount standby database
                      Tue Sep 11 11:47:36 2012
                      alter database recover managed standby database disconnect from session
                      Attempt to start background Managed Standby Recovery process (standby)
                      Tue Sep 11 11:47:36 2012
                      MRP0 started with pid=21, OS id=2325
                      MRP0: Background Managed Standby Recovery process started (standby)
                      Fast Parallel Media Recovery enabled
                      Managed Standby Recovery not using Real Time Apply
                      parallel recovery started with 2 processes
                      Waiting for all non-current ORLs to be archived...
                      Clearing online redo logfile 1 /u02/orcldb/redo01.log
                      Clearing online log 1 of thread 1 sequence number 103
                      Errors in file /u01/diag/rdbms/standby/standby/trace/standby_mrp0_2325.trc:
                      ORA-19527: physical standby redo log must be renamed
                      ORA-00312: online log 1 thread 1: '/u02/orcldb/redo01.log'
                      Clearing online redo logfile 1 complete
                      Media Recovery Waiting for thread 1 sequence 104
                      Completed: alter database recover managed standby database disconnect from session
                      • 23. Re: PING[ARC1] Heartbeat failed to connect to standby 'xxxxx'.Error is 12154
                        Mahir M. Quluzade
                        and I found new mistakes in your pfile
                        *.LOG_ARCHIVE_CONFIG='DG_CONFIG=(orcldb,standby)'
                        ...
                        FAL_SERVER=stdb-prim
                        FAL_CLIENT=prm-std
                        ...
                        what is your primary and standby service name, if your stanby service name is stdb-prim then
                        you must change your LOG_ARCHIVE_CONFIG parameter to
                         *.LOG_ARCHIVE_CONFIG='DG_CONFIG=(orcldb,stdb-prim)'
                        if your database version is 11.2 then FAL_CLIENT is deprecated, is not need set this parameter.

                        Regars
                        Mahir M. Quluzade
                        • 24. Re: PING[ARC1] Heartbeat failed to connect to standby 'xxxxx'.Error is 12154
                          961013
                          both primary and standby services are pinging from each other

                          even this is also working sqlplus sys/oracle@stdb-prim as sysdba(from standby to primary)

                          sqlplus sys/oracle@prm-std as sysdba(from primary to standby)


                          thanks,
                          poorna
                          • 25. Re: PING[ARC1] Heartbeat failed to connect to standby 'xxxxx'.Error is 12154
                            961013
                            standby service is stdb-prim
                            primary service is prm-std


                            i configured dataguard setup using oracle document.

                            for your reference:

                            the LOG_ARCHIVE_CONFIG database initialization parameter
                            has been defined on the primary database and on each standby database, and
                            that its value includes a DG_CONFIG list that includes the DB_UNIQUE_NAME of
                            the primary database and each standby database.

                            the above point from oracle document
                            • 26. Re: PING[ARC1] Heartbeat failed to connect to standby 'xxxxx'.Error is 12154
                              Mahir M. Quluzade
                              I understand your stanby database unique name is standby.

                              Can you try enable broker and create configuration?

                              Regards
                              Mahir M. Quluzade
                              • 27. Re: PING[ARC1] Heartbeat failed to connect to standby 'xxxxx'.Error is 12154
                                961013
                                i didnot configured broker

                                manuallly configured the dataguard



                                Thanks,
                                poorna.
                                • 28. Re: PING[ARC1] Heartbeat failed to connect to standby 'xxxxx'.Error is 12154
                                  Mahir M. Quluzade
                                  Then you must check all steps with following link
                                  http://docs.oracle.com/cd/E11882_01/server.112/e25608/create_ps.htm#i63561
                                  Regards
                                  Mahir M. Quluzade
                                  www.mahir-quluzade.com
                                  • 29. Re: PING[ARC1] Heartbeat failed to connect to standby 'xxxxx'.Error is 12154
                                    961013
                                    i followed the same document and created physical standby


                                    Thanks,
                                    poorna.