Oracle ASM 11.2.0.3.0
Oracle DB 11.2.0.2.11
Oracle Linux 5.6 x86-64
Stand-alone systems, no cluster, no RAC
For every live server (test or prod) I have, I maintain a virtual counterpart under VBox on my desktop. I use these primarily to test out PSU and upgrade procedures. Whenever going live turns up a glitch that didn’t appear in my ‘lab’ machines I go back and refine the lab, as well as refining the procedure for identifying differences between the lab and the live machine.
Currently I’m comparing output of ‘crsctl status resource –p’, and focusing on the ASM section. What I’m seeing here is that for my live production database, I have the following value:
USR_ORA_ENV= asm_preferred_read_failure_groups@SMALL.SSD_GROUP
The same parameter is null in both my live test system as well as my vm lab system.
But on both live systems (prod and test) the initialization parameter is set. So comparing both indicators across 3 systems, I have this:
system | spfile – asm_preferred_read_failure_groups | crsctl – usr_ora_env |
Lab Prod | null | null |
Live Dev | SMALL.SSD_GROUP | null |
Live Prod | SMALL.SSD_GROUP | asm_preferred_read_failure_groups@SMALL.SSD_GROUP |
So at first blush, I could reconcile the difference between ‘LAB prod’ and ‘LIVE prod’ because they are each internally consistent. But then we throw in ‘LIVE DEV’, and I don’t know how to reconcile that with the live prod system. Looking at Oracle Clusterware Admin and Deployment Guide (E41959-03), Appendix B (Clusterware Resource Reference) I ‘m not seeing any reference to USER_ORA_ENV.
I'm open to explanations and/or pointers to relevant docs.