ACTIVE_INSTANCE_COUN of Oracle 10 Gb memory

Source: Internet
Author: User


ACTIVE_INSTANCE_COUN of Oracle 10 Gb memory is used in the cluster environment. It is deemed to be null, that is, all the nodes are master nodes. Www.2cto.com is in the RAC environment of the two sites, you can configure the master and compute nodes to run the show parameters active_instance_countNAME type value parameter ------------- active_instance_count interger command to set active_instance_count to 1RAC dynamic on both nodes, the instance that is triggered first is the primary vertex, followed by the standby vertex.
The master site accepts requests from users, the master site accepts requests when the master site fails, and the master site recovers, if the master region has been accepted, request select INSTANCE_NUMBER, INSTANCE_NAME, INSTANCE_ROLE from v $ instance; INSTANCE_NUMBER INSTANCE_NAME INSTANCE_ROLE primary keys ---------------------------- 1 ok1 secondary_instance2 ok2 primary_instance if the value is greater than the number of instances 2, it is the master node.
 

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.