ORACLE資料庫錯誤一例Error 12154 received logging on to the standby

標籤：oracle資料庫錯誤一例error 12154 received logging on to the standby

環境：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