We have a 2 node Oracle 126.96.36.199 RAC on Linux.
When the cluster on one node is down or the node itself is brought down, the users connected to the instance on this node get 'end of communication' error.
My understanding was that oracle automatically forwards the connections of node1 to node2, when node1 goes down.
can someone kindly answer if the above is right? and also guide me documentation for the same
Are you connecting to a service which has failover configured?
Oracle will only failover the connection if the service has been configured as such.
Is SCAN properly configured so that remote_listener points to your scan address?
Check the status of your service:
srvctl status service -s service_name -d database_name
thank you freddie,
this is a new setup and i am testing if the setup is ok.
we have SCAN configured still when i shutdpwn one instance i got disconnected from database from client connected to that instance
So the correct behavior with SCAN configured should be that my session should automatically failover to node2 without i knowing it and the database giving me the error 'end of communication' am i right?
What about any dml/ddl statements that i was runing through that session, how would they move to the second node.
If you have everything properly configured...ie your SCAN listeners are setup, your remote_listener parameter is setup, all your local listeners have all the databases registered with them and your services are setup correctly..........If the above is done then your session should failover to node 2 and you will not get your "ORA-03113: end-of-file on communication channel" error.
Have a read of TAF and failover methods etc...http://www.dba-oracle.com/art_oramag_rac_taf.htm
However no ddl statements will be failed over. Only select statements will be failed over seamlessly (if you use the SELECT method).
Typically the application would handle any failed transactions and would retry the transaction if it received certain errors.
Hope that helps.