In Rac Environment , if node 1 fails user can get access from surviving instance from node2.but suppose node1 system is up and runnig, but if the instance is shutdown,
suppose there is service called demo it's preffered instance in running on node1, available instance is running on node2. Suppose user A is using service demo, can he get access.
please tel me.
Please, provide RAC version ...
Let's assuming that you are 11G (126.96.36.199)
If you are using SCAN, the access will completed transparent to the user...
Does not matter on which node the instance is down, the client will have access...
Demo service is configured with instance1 as 'preferred instance'. So if instance1 is down the request for connection will be serviced by the available instance i.e. instance2 in that case. So a user connecting via demo service will be able to connect to DB via instance2, if instance1 is down.