This content has been marked as final. Show 5 replies
You connect to service, not to sid. The service can run on multiple instances. Each instance every minute connects to local and remote listeners (if defined) and updates its services and load. So listener can balance connections among instances.
Their is concept of local listener and Remote Listener in Rac. I understand these are used internally for load balancing. Please correct me If I am wrong.If I provide the user tns details and having the enteries of one node (node 1) only and that node ( node 1) is heavily loaded. In that case load balancing takes place at listener level ? If yes How.
In 10g clients connect to VIP. If node fails, its VIP moves to another node. TAF does not require VIP, it was availiable before 10g.
Their is concept of VIP. Generally it is used to provide the High Availability. If the user query is runnning on node 1 and node 1 crashes, without knowing the user it will proccess the query from node 2.What kind of query can be executed ? Select , Insert , delete update . I heard that select will be executed but insert delete and update will be failed . Is that correct.
Thanks a lot . Failover is applicabel for all the DML and DDL .
Insert, Update , Delete , Select etc.
select only will be failed over.
Any update/insert/delete will be rolled back and your application should handle the error code to retry the operation.
Thanks a lot.
Even if session's query failed-over to another instance, session context is lost. So application should care of this.