My Oracle Support Banner

HP-UX: File handles not released after upgrade to 10.2.0.3 CRS Bundle#2 or 10.2.0.4 (Doc ID 739557.1)

Last updated on SEPTEMBER 16, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 to 11.1.0.6 [Release 10.2 to 11.1]
HP-UX PA-RISC (64-bit)
HP-UX Itanium
HP IA64 HPUNIXHP 9000 Series HP-UX (64-bit)




Symptoms

There are several symptoms for this issue:

  1.  Racgimon log reports these errors:
    imon_<DBNAME>.log

    2008-07-04 16:18:24.791: [RACG][20] [25433][20][ora.<DBNAME>.<INSTANCE NAME>.inst]:
    GIMH: GIM-00104: Health check failed to connect to instance.
    GIM-00090: OS-dependent operation:mmap failed with status: 12
    GIM-00091: OS failure message: Not enough space
    GIM-00092: OS failure occurred at: sskgmsmr_13



  2. You may see huge file handles to $ORACLE_HOME/dbs/hc_<SID>.dat file
    run lsof or glance to verify
    (See <note 390474.1> What Is The $ORACLE_HOME/dbs/hc_<ORACLE_SID>.dat File?)


  3. RAC Instance may crash due to following errors :

    DB Alert Log

    Tue Jun 3 09:21:32 2008
    Errors in file /<DIR>/admin/<DBNAME>/udump/<SID>_ora_20420.trc:
    ORA-00603: ORACLE server session terminated by fatal error
    ORA-27544: Failed to map memory region for export
    ORA-27300: OS system dependent operation:socket failed with status: 23
    ORA-27301: OS failure message: File table overflow
    ORA-27302: failure occurred at: sskgxpcre1
    Tue Jun 3 09:22:49 2008
    Shutting down instance (abort)



  4. System messages has following errors around time of crash

    /var/adm/syslog/syslog.log

    Jun 3 09:22:26 <HOSTNAME> vmunix: file: table is full
    Jun 3 09:22:27 <HOSTNAME> vmunix: file: table is full

Changes

These errors can be encountered on:
- 10.2.0.3, 10.2.0.3 +  CRS Bundle Patch #2  or CRS Bundle Patch #3
- 10.2.0.4
- 11.1.0.6


Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.