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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
