Failover during DB crash
- From: jaysingh1@xxxxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 31 Mar 2004 13:26:26 -0500
Dear All,
We tested failover functionality with "shutdown abort" or "shutdown immediate"
and it works fine. But failover did not happen when one of the Node got crashed
with follwoing error.
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []
Instance terminated by SMON, pid = 3245
My tnsnames.ora is configured like below.
=========================================================
mydb=
(DESCRIPTION=
(FAILOVER=ON)
(LOAD_BALANCE=ON)
(ADDRESS=(PROTOCOL=TCP)(HOST=machine1)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=machine2)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=mydb.mycompany.com)
(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC))))
mydb1=
(DESCRIPTION=
(FAILOVER=ON)
(ADDRESS=(PROTOCOL=TCP)(HOST=machine1)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=machine2)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=mydb.mycompany.com)
(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC))))
mydb2=
(DESCRIPTION=
(FAILOVER=ON)
(ADDRESS=(PROTOCOL=TCP)(HOST=machine2)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=machine1)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=mydb.mycompany.com)
(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC))))
======================================================
Could someone shed lights on this?
Thanks
Jay.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
- Follow-Ups:
- Re: Failover during DB crash
- From: Mladen Gogala
Other related posts:
- » Failover during DB crash
- » Re: Failover during DB crash
- Re: Failover during DB crash
- From: Mladen Gogala