1 Reply Latest reply on Dec 27, 2013 11:31 AM by mseberg

    oracle 11G  DG ,ERROR"PING[ARC2]: Heartbeat failed to connect to standby 'wnadsdy'. Error is 1033."

    b5d93519-db95-40aa-b6aa-94c856f41e13

      主库一直报错,提示 如下: Error 1033 received logging on to the standby FAL[server, ARC0]: Error 1033 creating remote archivelog file 'wnadsdy' FAL[server, ARC0]: FAL archive failed, see trace file. Error 1033 received logging on to the standby PING[ARC2]: Heartbeat failed to connect to standby 'wnadsdy'. Error is 1033. tnsping 可以Ping 到备库 wnadsdy primary ip 172.31.0.41 standby ip 1721.31.0.112 primary db initwnad.ora wnad.__db_cache_size=687865856 wnad.__java_pool_size=16777216 wnad.__large_pool_size=33554432 wnad.__oracle_base='/opr/oracle'#ORACLE_BASE set from environment wnad.__pga_aggregate_target=671088640 wnad.__sga_target=989855744 wnad.__shared_io_pool_size=0 wnad.__shared_pool_size=234881024 wnad.__streams_pool_size=0 *.audit_file_dest='/opr/oracle/admin/wnad/adump' *.audit_trail='db' *.compatible='11.2.0.4.0' *.control_files='/opr/oracle/wnad/control01.ctl','/opr/oracle/fast_recovery_area/wnad/control02.ctl' *.db_block_size=8192 *.db_domain='' *.db_name='wnad' *.db_recovery_file_dest='/opr/oracle/fast_recovery_area' *.db_recovery_file_dest_size=10737418240 *.diagnostic_dest='/opr/oracle' *.dispatchers='(PROTOCOL=TCP) (SERVICE=wnadXDB)' *.log_archive_dest_1='location=/opr/oracle/wnad/archive' *.log_archive_dest_2='SERVICE=wnadsdy' *.memory_target=1656750080 *.open_cursors=300 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.standby_file_management='AUTO' *.undo_tablespace='UNDOTBS1' listener.ora LISTENER=     (DESCRIPTION=         (ADDRESS_LIST=             (ADDRESS=(PROTOCOL=TCP)(HOST=oracle-test)(PORT=1521))               )     ) SID_LIST_LISTENER=       (SID_LIST=         (SID_DESC=               (SID_NAME=wnad)               (ORACLE_HOME=/opr/oracle/product/11.2.0/db_1)               (GLOBAL_DBNAME=wnad)           )       ) tnsnames.ora WNAD=   (DESCRIPTION=         (ADDRESS_LIST=             (ADDRESS=(PROTOCOL=TCP)(HOST=oracle-test)(PORT=1521))         )       (CONNECT_DATA=           (SERVER = DEDICATED)           (SERVICE_NAME=wnad)       )   ) wnadsdy=     (DESCRIPTION=         (ADDRESS_LIST=             (ADDRESS=(PROTOCOL=TCP)(HOST=oracle-test2)(PORT=1521))         )       (CONNECT_DATA=           (SERVER = DEDICATED)           (SERVICE_NAME=wnad)       )   ) standby db initwnad.ora wnad.__db_cache_size=687865856 wnad.__java_pool_size=16777216 wnad.__large_pool_size=33554432 wnad.__oracle_base='/opr/oracle'#ORACLE_BASE set from environment wnad.__pga_aggregate_target=671088640 wnad.__sga_target=989855744 wnad.__shared_io_pool_size=0 wnad.__shared_pool_size=234881024 wnad.__streams_pool_size=0 *.audit_file_dest='/opr/oracle/admin/wnad/adump' *.audit_trail='db' *.compatible='11.2.0.4.0' *.control_files='/opr/oracle/wnad/control01.ctl','/opr/oracle/fast_recovery_area/wnad/control02.ctl' *.db_block_size=8192 *.db_domain='' *.db_name='wnad' *.diagnostic_dest='/opr/oracle' *.dispatchers='(PROTOCOL=TCP) (SERVICE=wnadXDB)' *.log_archive_dest_1='location=/opr/oracle/wnad/archive' *.memory_target=1656750080 *.open_cursors=300 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.standby_file_management='AUTO' *.undo_tablespace='UNDOTBS1' listener.ora LISTENER=     (DESCRIPTION=         (ADDRESS_LIST=             (ADDRESS=(PROTOCOL=TCP)(HOST=oracle-test2)(PORT=1521))         )     ) SID_LIST_LISTENER=       (SID_LIST=         (SID_DESC=               (SID_NAME=wnad)               (ORACLE_HOME=/opr/oracle/product/11.2.0/db_1)               (GLOBAL_DBNAME=wnad)           )       ) tnsnames.ora wnad=   (DESCRIPTION=         (ADDRESS_LIST=             (ADDRESS=(PROTOCOL=TCP)(HOST=oracle-test)(PORT=1521))         )       (CONNECT_DATA=         (SERVER = DEDICATED)         (SERVICE_NAME=wnad)       )   ) wnadsdy=     (DESCRIPTION=         (ADDRESS_LIST=             (ADDRESS=(PROTOCOL=TCP)(HOST=oracle-test2)(PORT=1521))         )       (CONNECT_DATA=         (SERVER = DEDICATED)         (SERVICE_NAME=wnad)       )   )