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