Dataguard connection error
edited Apr 1, 2010 12:45AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 4 commentsAnswered
Hi to all,
Both primary and standby servers are on lunux redhat : same version of OS
- Primary DB : 10.2.0.1
- Standby DB : 10.2.0.3
- Host Name of Primary DB : arcdb01.es.egwn.lan
- Host Name of Standby DB : x06.d15.lan
I got an error : Any idea?
FROM PRIMARY DB :
I check alert log file :
Thu Mar 25 17:45:12 2010
Errors in file /u01/app/oracle/admin/ARCDB01/bdump/arcdb01_arc0_5800.trc:
ORA-01034: ORACLE not available
PING[ARC0]: Heartbeat failed to connect to standby 'X06.D15.LAN'. Error is 1034.
From PRIMARY DB , I run this query :
SQL>select message from v$dataguard_status where dest_id=2;
MESSAGE
- Primary DB : 10.2.0.1
- Standby DB : 10.2.0.3
- Host Name of Primary DB : arcdb01.es.egwn.lan
- Host Name of Standby DB : x06.d15.lan
I got an error : Any idea?
FROM PRIMARY DB :
I check alert log file :
Thu Mar 25 17:45:12 2010
Errors in file /u01/app/oracle/admin/ARCDB01/bdump/arcdb01_arc0_5800.trc:
ORA-01034: ORACLE not available
PING[ARC0]: Heartbeat failed to connect to standby 'X06.D15.LAN'. Error is 1034.
From PRIMARY DB , I run this query :
SQL>select message from v$dataguard_status where dest_id=2;
MESSAGE
0