Oracle Database error A case in 12154 received logging on to the standby

Environment: AIX RAC + dg,oracle 10G

Symptom: A node in the main library has an error as follows

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

Analysis: Analysis of the failure of the main library and the standby connection

Workaround: Temporarily disconnect the synchronization of the primary and standby libraries

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>

This article is from the "Wheat Dock" blog, please make sure to keep this source http://yunlongzheng.blog.51cto.com/788996/1601556

Oracle Database error A case in 12154 received logging on to the standby