Failover during DB crash

From: <jaysingh1_at_optonline.net>
Date: Wed, 31 Mar 2004 13:26:26 -0500
Message-id: <1333a311330dab.1330dab1333a31@optonline.net>

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_at_freelists.org 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
-----------------------------------------------------------------

Received on Wed Mar 31 2004 - 12:27:34 CST