1 person found this helpful
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.