ORA-16055: FAL request rejected

ORA-16055: FAL request rejected

Kevin Zou

2011-8-30

在搭建DATAGUARD时多次看到ORA-16055: FAL request rejected，发现并不是每次ORA-16055的错误原因都是一样的。

在这里记录下：

FAL[server, ARC0]: Error 12154 creating remote archivelog file 'testdg' FAL[server, ARC0]: FAL archive failed, see trace file. Errors in file l:\oracle\diag\rdbms\test\test\trace\test_arc0_3652.trc: ORA-16055: FAL request rejected TRACE 文件的内容： .. Detailed OCI error val is 12154 and errmsg is 'ORA-12154: TNS:could not resolve the connect identifier specified ' *** 2011-08-30 10:08:36.529 4132 krsh.c Error 12154 received logging on to the standby *** 2011-08-30 10:08:36.529 869 krsu.c Error 12154 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'testdg' Error 12154 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'testdg' ORA-12154: TNS:could not resolve the connect identifier specified *** 2011-08-30 10:08:36.530 2747 krsi.c krsi_dst_fail: dest:2 err:12154 force:0 blast:1 kcrrwkx: unknown error:12154 ORA-16055: FAL request rejected

Errors in file l:\oracle\diag\rdbms\test\test\trace\test_arc0_5508.trc: ORA-16191: Primary log shipping client not logged on standby FAL[server, ARC0]: Error 16191 creating remote archivelog file 'testdg' FAL[server, ARC0]: FAL archive failed, see trace file. Errors in file l:\oracle\diag\rdbms\test\test\trace\test_arc0_5508.trc: ORA-16055: FAL request rejected TRACE 文件的内容： OCISessionBegin failed. Error -1 .. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied ' OCISessionBegin failed. Error -1 .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges ' ORA-01017: invalid username/password; logon denied OCI_DBVER attribute value retrieval failed error=1017 *** 2011-08-30 10:42:26.250 4132 krsh.c Error 1017 received logging on to the standby ------------------------------------------------------------ Check that the primary and standby are using a password file and remote_login_passwordfile is set to SHARED or EXCLUSIVE, and that the SYS password is same in the password files.       returning error ORA-16191 ------------------------------------------------------------ *** 2011-08-30 10:42:26.253 869 krsu.c Error 16191 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'testdg' Error 16191 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'testdg' ORA-16191: Primary log shipping client not logged on standby *** 2011-08-30 10:42:26.254 2747 krsi.c krsi_dst_fail: dest:2 err:16191 force:0 blast:1 kcrrwkx: unknown error:16191 ORA-16055: FAL request rejected *** 2011-08-30 10:43:47.923 *** 2011-08-30 10:43:47.923 2046 krse.c Archived Log entry 19 added for thread 1 sequence 14 ID 0x7ab3b2cc dest 1: L:\ORADATA\TEST\ARCH11\ARC0000000014_0760442707_0001.LOG

在网上，还有的案例是因为STANDBY DB 上的归档目录满了，也会报ORA-16055: FAL request rejected 的错误。

-THE END-

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/40239/viewspace-706249/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/40239/viewspace-706249/