Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Ram.

Asked: September 13, 2017 - 12:10 pm UTC

Last updated: July 04, 2018 - 4:11 am UTC

Version: Any

Viewed 10K+ times! This question is

You Asked

Hi TOM,

We have ASM implemented in lot of databases and below are the values of auto_start attribute in our crs config:

NAME=ora.asm
AUTO_START=never

NAME=ora.DG_GRID_CL.dg --> This is the disk group which we use for keeping OCR & Voting disks
AUTO_START=never

Firstly, the default value of "never" didn't make sense. Secondly, when we tried to simulate a host reboot scenario (after gracefully bringing down ASM, DB), CRS always brings up ASM and mounts the cluster disk group even though auto_start is "never".

If that's the case, why do we even need auto_start value for these 2 resources?


and Connor said...

My suspicion is that it is an oversight, because in v12 we're more rigid on that, eg

$ crsctl modify resource "ora.asm" -attr "AUTO_START=never"
CRS-4995: The command 'Modify resource' is invalid in crsctl. Use srvctl for this command.

The correct syntax would hence be:

srvctl disable asm
srvctl enable asm
srvctl start asm

etc

Rating

  (6 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Follow up

Ram Dittakavi, September 15, 2017 - 2:01 am UTC

Thanks Connor. But i don't get it completely.

I tested various scenarios with different values of auto_start for the database resource and it worked as expected but only i gave -unsupported in the end of the crsctl modify resource command. I didn't even realize that i've used -unsupported and don't know where i saw that command syntax. I will try to re-test the scenarios without using -unsupported and see how it works.

Example: If auto_start=never, CRS will never bring up the database after restart. Similarly, if auto_start=always, CRS brings up the database even if it was shutdown gracefully before CRS reboot. Likewise, it worked as expected with auto_start=restore.

Are you saying crsctl modify resource itself is deprecated in 12c? But the documentation doesn't talk about that:

http://docs.oracle.com/database/122/CWADD/oracle-clusterware-control-crsctl-utility-reference.htm#CWADD-GUID-F73393B0-E1FE-4CA6-996D-60A41A4FD5A1

But then again, i've seen this:

crsctl modify ora.* resource fails with CRS-4995 in 12.1.0.2 and above (Doc ID 1918102.1)

I'm confused now. Which one to use for what?

Connor McDonald
September 19, 2017 - 2:09 am UTC

I think the intention is:

For your *own* resources, crsctl can be used.
For *our* resources, they'll be controlled by srvctl.


Follow up

Ram Dittakavi, September 15, 2017 - 2:01 am UTC

Thanks Connor. But i don't get it completely.

I tested various scenarios with different values of auto_start for the database resource and it worked as expected but only i gave -unsupported in the end of the crsctl modify resource command. I didn't even realize that i've used -unsupported and don't know where i saw that command syntax. I will try to re-test the scenarios without using -unsupported and see how it works.

Example: If auto_start=never, CRS will never bring up the database after restart. Similarly, if auto_start=always, CRS brings up the database even if it was shutdown gracefully before CRS reboot. Likewise, it worked as expected with auto_start=restore.

Are you saying crsctl modify resource itself is deprecated in 12c? But the documentation doesn't talk about that:

http://docs.oracle.com/database/122/CWADD/oracle-clusterware-control-crsctl-utility-reference.htm#CWADD-GUID-F73393B0-E1FE-4CA6-996D-60A41A4FD5A1

But then again, i've seen this:

crsctl modify ora.* resource fails with CRS-4995 in 12.1.0.2 and above (Doc ID 1918102.1)

I'm confused now. Which one to use for what?

Follow Up

Ram, September 20, 2017 - 2:03 am UTC

Hi Connor,

Still don't get it. What is your own and our own?
Connor McDonald
September 21, 2017 - 2:49 am UTC

CRS can manage resources that are not just related to the Oracle database. You can have your *own* resources (applications etc), that you want to be managed by the clusterware so you have consistency across the stack.

Follow up

Ram Dittakavi, October 04, 2017 - 6:31 am UTC

Hi Connor,

Can you please point out how we can use srvctl to modify resource attributes?
Connor McDonald
October 05, 2017 - 4:15 pm UTC

I didnt say that.

I said - for Oracle resources, they will be controlled by srvctl, eg

srvctl disable asm
srvctl enable asm

For your own resource, you can use crsctl

Follow up

Ram Dittakavi, October 04, 2017 - 6:46 am UTC

srvctl modify resource -help

Usage: srvctl <command> <object> [<options>]
commands: enable|disable|export|import|start|stop|relocate|status|add|remove|modify|getenv|setenv|unsetenv|config|convert|update|upgrade|downgrade|predict
objects: database|instance|service|nodeapps|vip|network|asm|diskgroup|listener|srvpool|server|scan|scan_listener|oc4j|home|filesystem|gns|cvu|havip|exportfs|rhpserver|rhpclient|mgmtdb|mgmtlsnr|volume|mountfs
For detailed help on each command and object and its options use:
srvctl <command> -help [-compatible] or
srvctl <command> <object> -help [-compatible]
PRKO-2001 : Invalid command line syntax

Cannot communicate with crsd

Osama Ammar, July 03, 2018 - 12:50 pm UTC

Dear Connor ,

I tried to user the asm commands but I got the following error
[grid@basis2db1 ~]$ srvctl disable asm
PRCR-1070 : Failed to check if resource ora.asm is registered
Cannot communicate with crsd
[grid@basis2db1 ~]$ srvctl enable asm
PRCR-1070 : Failed to check if resource ora.asm is registered
Cannot communicate with crsd

How to solve this issue as I can't start the crs and asm instance and hence the database.

BR,
Osama

Connor McDonald
July 04, 2018 - 4:11 am UTC

Check to make sure the cluster services are running

crsctl check crs
crsctl start cluster

If you can't start the cluster, then run some checks

ocrcheck
/etc/init.d/oracleasm status

so try diagnose the cause. If all else fails, time to chat to support

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database