ITPub博客

首页 > Linux操作系统 > Linux操作系统 > hp-unix 11G出现的BUG

hp-unix 11G出现的BUG

原创 Linux操作系统 作者:anycall2010 时间:2009-07-10 04:28:27 0 删除 编辑

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__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

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8334342/viewspace-608789/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-06-24

  • 博文量
    182
  • 访问量
    559491