环境：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>
本文出自 “麦地坞” 博客，请务必保留此出处http://yunlongzheng.blog.51cto.com/788996/1601556
ORACLE数据库错误一例Error 12154 received logging on to the standby
原文：http://yunlongzheng.blog.51cto.com/788996/1601556