{"id":798,"date":"2013-04-05T00:56:48","date_gmt":"2013-04-04T16:56:48","guid":{"rendered":"http:\/\/www.yallonking.com\/?p=798"},"modified":"2013-04-05T00:59:14","modified_gmt":"2013-04-04T16:59:14","slug":"data-guard%e5%b8%b8%e8%a7%81%e6%95%85%e9%9a%9c2%e5%88%99ora-16191-ora-1017-ora-00604-ora-06544-ora-06553","status":"publish","type":"post","link":"http:\/\/www.yallonking.com\/?p=798","title":{"rendered":"Data Guard\u5e38\u89c1\u6545\u969c2\u5219ORA-16191 ORA-1017 ORA-00604 ORA-06544 ORA-06553"},"content":{"rendered":"

\u95ee\u9898(\u4e00)<\/strong>
\n\u5728\u4e3b\u5907\u5e93\uff08rac+single standby\uff09\u642d\u5efa\u5b8c\u6210\u540e\uff0c\u53d1\u73b0\u4e3b\u5e93\u4e00\u4e2a\u8282\u70b9\u548c\u5907\u5e93\u7684\u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a
\n\u4e3b\u5e93\u95ee\u9898<\/p>\n

\r\nERROR_CODE SEVERITY      MESSAGE                                                                          TIMESTAMP\r\n---------- ------------- -------------------------------------------------------------------------------- --------------------\r\n     16191 Error         PING[ARC1]: Heartbeat failed to connect to standby 'racdb_st'. Error is 16191.   04-APR-13 20:54:28\r\n      1017 Error         Error 1017 received logging on to the standby                                    04-APR-13 20:55:59\r\n     16191 Error         PING[ARC1]: Heartbeat failed to connect to standby 'racdb_st'. Error is 16191.   04-APR-13 20:55:59\r\n      1017 Error         Error 1017 received logging on to the standby                                    04-APR-13 20:57:30\r\n     16191 Error         PING[ARC1]: Heartbeat failed to connect to standby 'racdb_st'. Error is 16191.   04-APR-13 20:57:30\r\n      1017 Error         Error 1017 received logging on to the standby                                    04-APR-13 20:59:01\r\n     16191 Error         PING[ARC1]: Heartbeat failed to connect to standby 'racdb_st'. Error is 16191.   04-APR-13 20:59:01\r\n      1017 Error         Error 1017 received logging on to the standby                                    04-APR-13 21:00:31\r\n     16191 Error         PING[ARC1]: Heartbeat failed to connect to standby 'racdb_st'. Error is 16191.   04-APR-13 21:00:31\r\n<\/pre>\n
\u5907\u5e93\u95ee\u9898<\/p>\n
\r\nERROR_CODE SEVERITY      MESSAGE                                                                          TIMESTAMP\r\n---------- ------------- -------------------------------------------------------------------------------- --------------------\r\n      1017 Error         Error 1017 received logging on to the standby                                    04-APR-13 20:48:46\r\n     16191 Error         FAL[client, MRP0]: Error 16191 connecting to racdb_1 for fetching gap sequence   04-APR-13 20:48:46\r\n      1017 Error         Error 1017 received logging on to the standby                                    04-APR-13 20:48:57\r\n     16191 Error         FAL[client, MRP0]: Error 16191 connecting to racdb_1 for fetching gap sequence   04-APR-13 20:48:57\r\n      1017 Error         Error 1017 received logging on to the standby                                    04-APR-13 20:49:09\r\n     16191 Error         FAL[client, MRP0]: Error 16191 connecting to racdb_1 for fetching gap sequence   04-APR-13 20:49:09\r\n      1017 Error         Error 1017 received logging on to the standby                                    04-APR-13 20:49:20\r\n     16191 Error         FAL[client, MRP0]: Error 16191 connecting to racdb_1 for fetching gap sequence   04-APR-13 20:49:20\r\n<\/pre>\n
\u95ee\u9898\u539f\u56e0\uff1a
\n1\u3001\u5bc6\u7801\u6587\u4ef6\u4e0d\u4e00\u81f4\uff0c\u9700\u8981\u5c06\u5bc6\u7801\u6587\u4ef6\u8fdb\u884c\u590d\u5236\uff0811g\uff09
\n2\u3001db_unique_name\u8bbe\u7f6e\u7684\u95ee\u9898<\/p>\n
\u95ee\u9898\uff08\u4e8c\uff09<\/strong>
\n\u4e3b\u5907\u53ef\u4ee5\u6b63\u5e38\u540c\u6b65\uff0c\u4f46\u662f\u4e3b\u5907\u5e93\u5207\u6362\u540e\uff0c\u65b0\u4e3b\u5e93\u95ee\u9898\u7684alert\u65e5\u5fd7\u4e2d\u62a5\u9519\u5982\u4e0b\uff1a<\/p>\n
\r\n<msg time='2013-04-05T00:32:42.693+08:00' org_id='oracle' comp_id='rdbms'\r\n client_id='' type='UNKNOWN' level='16'\r\n host_id='OELx64' host_addr='192.168.137.146' module=''\r\n pid='3226'>\r\n <txt>Errors in file \/u01\/app\/oracle\/diag\/rdbms\/racdb_st\/racdb_st\/trace\/racdb_st_cjq0_3226.trc:\r\nORA-00604: error occurred at recursive SQL level 1\r\nORA-06544: PL\/SQL: internal error, arguments: [56327], [], [], [], [], [], [], []\r\nORA-06553: PLS-801: internal error [56327]\r\n <\/txt>\r\n<\/msg>\r\n<\/pre>\n
\u95ee\u9898\u539f\u56e0\uff1a
\n\u67e5\u770bMOS\uff1aID 1436552.1\u540e\uff0c\u8bf4\u662f\u7248\u672c\u4f4d\u6570\u4e0d\u4e00\u81f4\u5bfc\u81f4\u7684\u3002
\n\u7ecf\u67e5\uff0c\u8fd9\u4e2arac+single standby\u7684DG\u786e\u5b9e\u662f\u5728\u4e0d\u540c\u7684\u7248\u672c\u4f4d\u6570\u4e0b\u5b9e\u65bd\u7684\u3002
\n\u4e3b\u5e93\uff1a<\/p>\n
\r\n[oracle@11grac1 ~]$ getconf LONG_BIT\r\n32\r\n<\/pre>\n
\u5907\u5e93\uff1a<\/p>\n
\r\n[root@OELx64 ~]# getconf LONG_BIT\r\n64\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
\u95ee\u9898(\u4e00) \u5728\u4e3b\u5907\u5e93\uff08rac+single standby\uff09\u642d\u5efa\u5b8c\u6210\u540e\uff0c\u53d1\u73b0\u4e3b\u5e93\u4e00\u4e2a\u8282\u70b9\u548c\u5907\u5e93\u7684\u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[35,36],"tags":[44,170,171,169,168],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/798"}],"collection":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=798"}],"version-history":[{"count":4,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/798\/revisions"}],"predecessor-version":[{"id":802,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/798\/revisions\/802"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=798"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=798"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=798"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}