ITPub博客

首页 > 数据库 > Oracle > 救命:dataguard日志无法传送,出现ora-04031错误

救命:dataguard日志无法传送,出现ora-04031错误

原创 Oracle 作者:lifewise 时间:2007-09-28 11:55:34 0 删除 编辑
dataguard日志无法传送,出现ora-04031错误[@more@]之前在rac上搭建dataguard,每次将dataguard的listener开起来之后,在primary的alert.log中出现
Errors in file /home/oracle/admin/rac/bdump/rac1_arc0_14665.trc:
ORA-04031: unable to allocate bytes of shared memory ("","","","")
把dataguard listener关掉就正常.
开始怀疑datagurad有问题,同时查了4031错误一般是share pool引起,且看我的share pool usaglization已达到百分之九十几,于是重新搭建了dataguard,而且将primary share pool增大了30M,(240M),开始dataguard 日志传送恢复均正常.但发现4031错误出现后日志就无法正常传送了,而且是primary rac两个节点不定时的出现该错误,国庆就要来了,很是担心呀,大家帮忙看看


环境:oracle 9i 9.2.04 rac +linux 3 64bit

Fri Sep 28 07:49:29 2007
Errors in file /home/oracle/admin/rac/bdump/rac1_arc0_14665.trc:
ORA-04031: unable to allocate bytes of shared memory ("","","","")
Fri Sep 28 07:54:36 2007
Errors in file /home/oracle/admin/rac/bdump/rac1_arc0_14665.trc:
ORA-04031: unable to allocate bytes of shared memory ("","","","")
Fri Sep 28 07:59:44 2007
Errors in file /home/oracle/admin/rac/bdump/rac1_arc0_14665.trc:
ORA-04031: unable to allocate bytes of shared memory ("","","","")
Fri Sep 28 08:04:51 2007
Errors in file /home/oracle/admin/rac/bdump/rac1_arc0_14665.trc:
ORA-04031: unable to allocate bytes of shared memory ("","","","")
Fri Sep 28 08:09:58 2007
Errors in file /home/oracle/admin/rac/bdump/rac1_arc0_14665.trc:
ORA-04031: unable to allocate bytes of shared memory ("","","","")
Fri Sep 28 08:15:05 2007
Errors in file /home/oracle/admin/rac/bdump/rac1_arc0_14665.trc:
ORA-04031: unable to allocate bytes of shared memory ("","","","")
Fri Sep 28 08:15:39 2007
Thread 1 advanced to log sequence 1417
Current log# 4 seq# 1417 mem# 0: /home/oracle/oradata/rac/REDO04.LOG
Fri Sep 28 08:15:39 2007
ARC0: Evaluating archive log 3 thread 1 sequence 1416
ARC0: Beginning to archive log 3 thread 1 sequence 1416
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/oradata/rac/archivelog/rac1/1_1416.dbf'
ARC0: Completed archiving log 3 thread 1 sequence 1416
Fri Sep 28 08:20:12 2007
Errors in file /home/oracle/admin/rac/bdump/rac1_arc0_14665.trc:
ORA-04031: unable to allocate bytes of shared memory ("","","","")
Fri Sep 28 08:25:19 2007
Errors in file /home/oracle/admin/rac/bdump/rac1_arc0_14665.trc:
ORA-04031: unable to allocate bytes of shared memory ("","","","")
Fri Sep 28 08:30:26 2007
Errors in file /home/oracle/admin/rac/bdump/rac1_arc0_14665.trc:
ORA-04031: unable to allocate bytes of shared memory ("","","","")
Fri Sep 28 08:35:33 2007
Errors in file /home/oracle/admin/rac/bdump/rac1_arc0_14665.trc:
ORA-04031: unable to allocate bytes of shared memory ("","","","")
Fri Sep 28 08:40:40 2007
Errors in file /home/oracle/admin/rac/bdump/rac1_arc0_14665.trc:
ORA-04031: unable to allocate bytes of shared memory ("","","","")
Fri Sep 28 08:45:48 2007
Errors in file /home/oracle/admin/rac/bdump/rac1_arc0_14665.trc:
ORA-04031: unable to allocate bytes of shared memory ("","","","")
Fri Sep 28 08:50:55 2007
Errors in file /home/oracle/admin/rac/bdump/rac1_arc0_14665.trc:
ORA-04031: unable to allocate bytes of shared memory ("","","","")
Fri Sep 28 08:56:02 2007
Errors in file /home/oracle/admin/rac/bdump/rac1_arc0_14665.trc:
ORA-04031: unable to allocate bytes of shared memory ("","","","")
Fri Sep 28 09:01:09 2007
Errors in file /home/oracle/admin/rac/bdump/rac1_arc0_14665.trc:
ORA-04031: unable to allocate bytes of shared memory ("","","","")

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

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

注册时间:2008-01-07

  • 博文量
    52
  • 访问量
    488454