0

Oracle 11.2.0.3 on SunOS 5.1

i have a client who is running a 2 node RAC environment but has shutdown the instance on one of the nodes. I was wondering whether after doing this they should change the database parameters on the remaining instance to reflect this, in particular i am thinking of parameters such as parallel..., cluster_database, cluster_database_instances, gcs_server_processes etc.

also, if they don't remove the node from the cluster services and grid control, is there a performance overhead? is just shutting down an instance a bad idea when it comes to performance if it is not removed correctly from the cluster?

thanks Dave

6
  • We dont need to change parameters after shutting down a instance from cluster. Users can get connected to another instance if the cluster is properly configured. There might be performance issues since there were two instances to do the job and now there is only one. I just confused by your questions, you have said shutdown an instance at first and later talking about removing the instance from the cluster. – atokpas May 5 '16 at 15:32
  • hi they have shut the instance down, but didn't go through the steps you would normally follow when removing a node from the cluster, as there is a one to one relationship between instance and node in this case, i was wondering whether they should remove the node itself from the cluster. Their DB parameters on the remaining instance mention there are 2 instances in the cluster, but now there are not, so i was concerned this might cause a hit in performance while oracle tries to "get to" the second instance. – davegreen100 May 5 '16 at 15:36
  • So they dont want the instance any more and wish to convert to single instance database right? – atokpas May 5 '16 at 15:38
  • good question, they are being very cagey on the subject, they say they have just pointed their application at one of the nodes (using a service name) and the other will be used if the first node/instance fails. But i have seen the alert log for the unused instance and it is actually shutdown. I suspect for licencing reasons, but i have gone back to them for clarification. Slow response as they are several time zones away and i have no remote access. – davegreen100 May 5 '16 at 15:42
  • Are you talking about this Or this? – atokpas May 5 '16 at 15:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.