Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdpii\tdpii_messaging031.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <title>Correcting an ORA-02019 Error for a Propagation</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1.1 Build 005" /> <meta name="date" content="2009-06-04T17:1:3Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Correcting an ORA-02019 Error for a Propagation" /> <meta name="relnum" content="11g Release 2 (11.2)" /> <meta name="partnum" content="E10703-01" /> <link rel="copyright" href="./dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="stylesheet" href="./dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" /> <link rel="contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="prev" href="tdpii_messaging030.htm" title="Previous" type="text/html" /> <link rel="next" href="tdpii_messaging032.htm" title="Next" type="text/html" /> <script src="./callback.js" type="text/javascript"></script> <noscript>Your browser does not support JavaScript. This help page requires JavaScript to render correctly.</noscript> </head> <body> <div class="zz-skip-header"><a href="#BEGIN">Skip Headers</a></div> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr valign="bottom"> <td align="left"></td> <td align="center"><a href="tdpii_messaging030.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_messaging032.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BABHFBAB" name="BABHFBAB"></a><a id="TDPII185" name="TDPII185"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>Correcting an ORA-02019 Error for a Propagation<a id="sthref687" name="sthref687"></a><a id="sthref688" name="sthref688"></a><a id="sthref689" name="sthref689"></a><a id="sthref690" name="sthref690"></a></h1> <a name="BEGIN" id="BEGIN"></a> <p>A propagation uses the privileges of the database user who owns its source queue when it sends messages. If the source queue owner cannot access the database link used by the propagation, then Oracle Database returns the following error:</p> <pre xml:space="preserve" class="oac_no_warn"> ORA-02019: connection description for remote database not found </pre> <p>The messages are not propagated when Oracle Database returns this message. The easiest way to correct this problem is to delete and re-create the database link so that the source queue owner can access it.</p> <p class="orderedlisttitle">To delete and re-create a database link: </p> <ol> <li> <p>In Oracle Enterprise Manager, log in to the database as an administrative user, such as the Oracle Streams administrator or <code>SYSTEM</code>.</p> </li> <li> <p>Go to the Database Home page.</p> </li> <li> <p>Click <span class="bold">Schema</span> to open the Schema subpage.</p> </li> <li> <p>Click <img src="shortcut.png" alt="callback" border="0" /><a href="javascript:void(0);" onclick="redirectEMpage('DATABASE_LINKS');"><span class="bold">Database Links</span></a> in the Database Objects section.</p> <p>The Database Links page appears.</p> </li> <li> <p>Use the search tool to list the database link you want to delete and re-create.</p> </li> <li> <p>Select the database link.</p> </li> <li> <p>Click <span class="bold">Delete</span>.</p> </li> <li> <p>Click <span class="bold">Yes</span> on the confirmation page to delete the database link.</p> </li> <li> <p>Follow the instructions in <a href="tdpii_common_ii006.htm#BGBGIACD">"Tutorial: Creating a Database Link"</a> to re-create the database link.</p> </li> </ol> <p>To ensure that the source queue owner for the propagation has access to the database link, specify this user as the fixed user in the Connect As section when you create the database link.</p> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdpii_messaging005.htm#CHDEJBBD">About Propagations</a></p> <p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=ADMIN12150','newWindow').focus()"><span class="italic">Oracle Database Administrator's Guide</span></a> for more information about database links</p> <p><a href="tdpii_messaging028.htm#CHDDGAFD">Troubleshooting a Messaging Environment</a></p> <p><a href="tdpii_messaging008.htm#CHDBACBE">Tutorial: Sending Messages Between Oracle Databases</a></p> </div> </div> <!-- class="sect2" --> <!-- Start Footer --> <div class="footer"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr> <td align="left"><span class="copyrightlogo">Copyright © 2007, 2009, Oracle and/or its affiliates. All rights reserved.</span><br /> <a href="./dcommon/html/cpyr.htm"><span class="copyrightlogo">Legal Notices</span></a></td> <td align="center"><a href="tdpii_messaging030.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_messaging032.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </div> <!-- class="footer" --> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de