CRS-4995
For Oracle 11g, we can modify the attribute of a resource like this:
[grid@primary01 ~]$ crsctl modify resource ora.dbname.db -attr AUTO_START=always
[grid@primary01 ~]$ crsctl status resource ora.dbname.db -p | grep AUTO_START
AUTO_START=always
But for 12c and later, you got error CRS-4995 like this:
[grid@primary01 ~]$ crsctl modify resource ora.dbname.db -attr AUTO_START=always
CRS-4995: The command 'Modify resource' is invalid in crsctl. Use srvctl for this command.
Solution
Error CRS-4995 is an Oracle expected response. For protecting critical attributes from being modified, we can no longer modify the resource by command crsctl from 12c.
srvctl
Formally, any modifiable attributes should be performed through command srvctl by user grid or oracle, but it's limited.
In this case, you should use srvctl to turn off AUTO_START of a RAC database.
crsctl
If you insist to use crsctl to modify the attribute, you should use an unsupported flag to do it. To overwrite the behavior, you can add a flag -unsupported to proceed:
[grid@primary01 ~]$ su -
Password:
[root@primary01 ~]# . /home/grid/.bash_profile
[root@primary01 ~]# crsctl modify resource ora.dbname.db -attr AUTO_START=always -unsupported
The modifier -unsupported makes the command workable.
Please note that, "Unsupported" means that the feature is not publicly supported, please use it only through the instruction of My Oracle Support (MOS).
Thank you!!!!!
My pleasure!