Hi all,
I recently installed and configured two node Oracle 11g R2 RAC. And when I try to test node failure I receive error.
In first node:
[oracle@rac1 ~]$ sqlplus system/oracle@RAC
SQL*Plus: Release 11.2.0.3.0 Production on Fri Jan 8 01:07:24 2016
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> select instance_name from v$instance;
INSTANCE_NAME
----------------
RAC2
SQL> select * from dba_objects;
When this select statement processes I reboot 2nd node. And after a few second I face this error in 1st node:
ERROR:
ORA-03135: connection lost contact
Process ID: 5528
Session ID 47 Serial number: 23
Why session didn't continue its work?
Thanks