Oracle home naming philosopy
As I start to get geared up to upgrade from 12.1.0.2 (SE2) to 18c or 19c, the question arises concerning a sane method of naming the ORACLE_HOME directory.
In the past, I've always included the version number to 4 digits, because that designated a release level.
/u01/app/oracle/product/11.2.0.3/dbhome_1
/u01/app/oracle/product/11.2.0.4/dbhome_1
/u01/app/oracle/product/12.1.0.2/dbhome_1
But with the new numbering system, even the second digit is "just" a patch update. I guess it might make sense to name homes thus:
/u01/app/oracle/product/18c/dbhome_1
/u01/app/oracle/product/19c/dbhome_1
But in my usual 'paralysis by analysis' tendency to overthink a problem, I can't help but wonder if I'm overlooking something. So, how are others approaching the naming of ORACLE_HOME, with Oracle's new numbering scheme.?