Sunday, December 8, 2013

How to change Oracle resource autostart option (AUTO_START)


In CRS (GI) versions before 12c, to view resource's autostart option, run

> crs_stat -p resource_name

and find the line :
AUTO_START=0 - start resource after starting crsd if it was up before 
AUTO_START=1 - start resource after starting crsd AUTO_START=2 - do not start resource after starting crsd

To change that use next actions.
1. Create resource profile from CRS registry as file as

> crs_stat -p resource_name > /CRS_HOME/crs/public/resource_name.cap

2. Edit the profile using text editor.

3. Unregister resource

> crs_unregister resource_name

4. Register resource

> crs_register resource_name

5. Check the resourse's profile

> crs_stat -p resource_name

P.S. In recent versions of Grid Infrastructure (from 12c) you could use :

> crsctl modify resource resource_name -attr AUTO_START={always|restore|never} -unsupported 

or

> srvctl modify resource_type -policy {automatic|manual|norestart|useronly}

These values are quite different in their meaning (you can always consult the documentation about it), but crsctl AUTO_START=restore is equivalent to srvctl policy automatic.

Good Luck !

No comments:

Post a Comment