In the rac database, the HC_SID.dat file is used by instances in other Oracle_Home instances. Reference: RACdatabaseHC_SID.datisusedbyinstanceofdifferentOracle_Home (DocID1618161.1) applicable to: OracleDatabase
In the rac database, the HC_SID.dat file is used by instances in other Oracle_Home instances. Reference: RAC database HC_SID.dat is used by instance of different Oracle_Home (Doc ID 1618161.1) applicable to: Oracle Database-Enterprise Edition-Version 11.2.0.0 and later Infor
In the rac database, HC _ The. dat file is used by instances in other Oracle_Home instances.
Reference Original:
RAC database HC _ . 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.
Health check file (hc _ . Dat) files are used by instances in other Oracle Home.
Hc _
. 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 20 049 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 '2017 | 8167 | 100' oracle 8563 1 0 23:45:33? 23:46:54 ora_cjq0_sqa1d101 oracle 8563 1 0? 12:04:05 ora_smco_sqa1e101 oracle 1074 28732 0 00:24:22 pts/1 egrep 8167 | 8563 | 20049 oracle 20049 1 0? 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. File hc _ in the old ORACLE_HOME/dbs directory _
. Dat is locked by many processes on other instances. Reason: This is reported inBUG 14351771-HC _
. Dat shared with other DATABASESwhich is duplicate of unpublished bug 12792223. Solution: Application Patch: 12792223. This bug is fixed in 11.2.0.4 and later versions.