[Translated from mos] In the rac database, the HC _ & lt; SID & gt;. dat file is used by instances in other Oracle_Home .,

[Translated from mos] In the rac database, the HC _ <SID>. dat file is used by instances under other Oracle_Home instances .,


In the rac database, the HC _ <SID>. dat file is used by instances under other Oracle_Home instances.


Reference Original:
RAC database HC _ <SID>. dat is used by instance of different Oracle_Home (Doc ID 1618161.1)


Applicable:
Oracle Database-Enterprise Edition-Version 11.2.0.0 and later
Information in this document applies to any platform.


Symptoms:
In the cluster environment, different Oracle Home instances run different databases.


The health check file (hc _ <sid>. dat) file of one database is used by instances in other Oracle Home databases.

hc_<SID>.dat files is shared with other databases' instances.  Example :-----------#lsof /u0n  COMMAND   PID          USER   FD   TYPE DEVICE  SIZE/OFF  NODE NAME  oracle           8167      oracle   60r  VREG 388,50     1544 48967 hc_sqa2d101.dat oracle           8167      oracle   72r  VREG 388,50     1544 78760 hc_sqa2e101.dat ...  oracle          8563      oracle   60r  VREG 388,50     1544 48967 hc_sqa2d101.dat  oracle          8563      oracle   72r  VREG 388,50     1544 78760 hc_sqa2e101.dat ... oracle          20049     oracle   60r  VREG 388,50     1544 48967 hc_sqa2d101.dat ===> ora_pz99_s20dv101 oracle          20049     oracle   72r  VREG 388,50     1544 78760 hc_sqa2e101.dat ===> ora_pz99_s20dv101  . hc_sqa2e101.dat file is used by ora_pz99_s20dv101 of s20dv101 instance.#ps -ef | egrep ' 8167 | 8563 |20049'   oracle  8167     1   0 23:45:33 ?           0:11 ora_cjq0_sqa1d101   oracle  8563     1   0 23:46:54 ?           0:02 ora_smco_sqa1e101   oracle  1074 28732   0 12:04:05 pts/1       0:00 egrep  8167 | 8563 |20049   oracle 20049     1   0 00:24:22 ?           0:25 ora_pz99_s20dv101

This phenomenon also occurs in Oracle Restart/SIHA node.


Change:
Out-of-place migration.


After the Out-of-place upgrade, the old file system cannot be unmounted because it is still in use.
The file hc _ <instance_name>. dat in the old ORACLE_HOME/dbs directory is locked by many processes on other instances.


Cause:
This is reported in


BUG 14351771-HC _ <SID>. DAT SHARED WITH OTHER DATABASES


Which is duplicate of unpublished bug 12792223.
 
Solution:
Patch: 12792223.


This bug is fixed in 11.2.0.4 and later versions.