EM 12c: Where does a Cluster Database Get Its Oracle Home?
Hi
This is EM 12.1.0.2.3 on Red Hat x86_64. I have a Cluster (RAC) database that was upgraded from 11.2.0.2 to 11.2.0.4. The monitoring configuration properties has the new Oracle Home (11.2.0.4). However, when I look at the Target Information box from the Cluster Database home page, the old Oracle Home (11.2.0.2) is still shown. This means I can't use the Run SQL functionality (Performance > SQL > Run SQL) against his database, because it tries to use SQL*Plus from the 11.2.0.2 path, and that Home has been removed.
I checked the Oracle Home targets discovered for the hosts on the cluster. The only Oracle Home target associated to the database is the new, 11.2.0.4 home.