• hpunix 11G出现的BUG


    在ALERT的日志中出现如下报错:
    Errors in file /home/oracle/db/diag/rdbms/qdsj/qdsj1/trace/qdsj1_m000_18573.trc:
    ORA-04035: unable to allocate 4096 bytes of shared memory in shared object cache "JOXSHM" of size "134217728"
    Tue Jul 07 05:00:33 2009
    Thread 1 advanced to log sequence 79
     Current log# 5 seq# 79 mem# 0: /oradata1/qdsj/redo05.log
    经过查明,是ORACLE 11G的一个BUG,最终问题已经按照文档修改,是否解决需要观察。
    根据ORACLE文档的解决办法:

    There are 2 workarounds available:
    1] Create the following directories under the $ORACLE_HOME/dbs:
        javanld1
        plsqlnld1
    2] Disable the just in time compiler, set initialization parameter:
       java_jit_enabled = false
       
    The permanent solution is to upgrade to 11.1.0.7 when it is released
    NOTE:
    When the workaround of creating directories is implemented, there will be a lot of small files generated under $ORACLE_HOME/dbs/javanld1 with name format:
    JOXSHM_EXT_<nn>_TARSG1_0.so*
    These files get deleted when the database is shutdown.
     
    解决步骤如下:
    SQL> show parameter JAVA_JIT_ENABLED;
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    java_jit_enabled                     boolean     TRUE
    $ cd $ORACLE_HOME
    $ cd dbs
    $ mkdir javanld1
    $ mkdir plsqlnld1
    SQL> alter system set JAVA_JIT_ENABLED= FALSE scope = both;
    System altered.
    SQL> show parameter JAVA_JIT_ENABLED;
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    java_jit_enabled                     boolean     FALSE

  • 相关阅读:
    hihocoder #1388 : Periodic Signal NTT&FFT
    HDU 5895 Mathematician QSC(矩阵乘法+循环节降幂+除法取模小技巧+快速幂)
    hdu 5894 hannnnah_j’s Biological Test 组合数学
    csu 1812: 三角形和矩形 凸包
    地铁 Dijkstra(优先队列优化) 湖南省第12届省赛
    后缀自动机专题
    数学渣的自我修养!!!
    高斯消元(浮点)
    The PLAN
    ccpc网络赛
  • 原文地址:https://www.cnblogs.com/weaver1/p/2493821.html
Copyright © 2020-2023  润新知