Preventing Automatic Instance Restart

When a node in RAC stops & re-start, oracle clusterware try to start the instance as soon as node starts. This may not be desirable, because instance start-up may fail, if system components on which instance depends are not ready

For example: Volume Manager is not started, file system is not mounted automatically

This scenario might occur, if oracle clusterware does not manage system components.

To manager automatic restart, we can use AUTO_START attribute.

AUTO_START parameter may have three values

1. always (1)
2. restore (0)
3. never (2)

How to change this parameter?

$ crs_stat -p > .cap

then change AUTO_START to a new value

$ crs_register -u

verify the change by

$ crs_stat -p

Advertisements
This entry was posted in Oracle Real Application Cluster and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s