环境：AIX RAC + DG,ORACLE 10G
现象：主库一个节点出现如下报错
460a:/home/oracle/admin/port/bdump$tail -f *.log
Sat Jan 10 11:06:24 2015
Errors in file /home/oracle/admin/port/bdump/port1_cjq0_19661256.trc:
Sat Jan 10 11:09:19 2015
kkjcre1p: unable to spawn jobq slave process
Sat Jan 10 11:09:19 2015
Errors in file /home/oracle/admin/port/bdump/port1_cjq0_19661256.trc:
Sat Jan 10 11:10:43 2015
Error 12154 received logging on to the standby
分析：分析主库和备库连接失效
解决：临时断开主库和备库的同步
SQL> show parameter log_archive_dest_state_2;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_2 string ENABLE
SQL> alter system set log_archive_dest_state_2='DEFER';
System altered.
SQL>
本文转自zylhsy 51CTO博客，原文链接：http://blog.51cto.com/yunlongzheng/1601556，如需转载请自行联系原作者
