[Translated from mos] In the rac database, the HC _ & lt; SID). dat file is

Source: Internet
Author: User
Tags egrep
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.
      
     
    

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.