<docbook><section><title>ErrorWhileTryingToRetrieveText2</title><para> </para><title> Error Message: Error while trying to retrieve text for error ORA-##### or Unable to retrieve text of NETWORK/NCR message ##### </title> Error Message: <computeroutput>Error while trying to retrieve text for error ORA-#####</computeroutput> or <computeroutput>Unable to retrieve text of NETWORK/NCR message #####</computeroutput> 
<para>&quot;Retrieve text&quot; errors typically arise when your environment variables are not set properly.
 Most commonly, <computeroutput>ORACLE_HOME</computeroutput> and <computeroutput>ORACLE_SID</computeroutput> need correction.</para><bridgehead class="http://www.w3.org/1999/xhtml:h2"> Multi-Tier </bridgehead>
<orderedlist spacing="compact"><listitem> Use a text editor to open the active Broker Rulebook (<computeroutput>.../&lt;OPENLINK_INSTALL&gt;/bin/oplrqb.ini</computeroutput>, by default).
</listitem>
<listitem> Locate the <computeroutput>[Environment ORACLE*]</computeroutput> section which corresponds to the active Database Agent for Oracle.
 For example: <programlisting>[Environment ORACLE81]
ORACLE_HOME = /dbs/oracle/app/product/8.1.7
ORACLE_SID=ORCL
</programlisting></listitem>
<listitem> Ensure that <computeroutput>ORACLE_HOME</computeroutput> and <computeroutput>ORACLE_SID</computeroutput> are set correctly.
</listitem>
<listitem> Save the Rulebook.
</listitem>
<listitem> Restart the Request Broker.
</listitem>
<listitem> Test your connection.</listitem>
</orderedlist><bridgehead class="http://www.w3.org/1999/xhtml:h2"> Evidence </bridgehead>
<itemizedlist mark="bullet" spacing="compact"><listitem> Session Rulebook </listitem>
<listitem> Request Broker Log </listitem>
</itemizedlist></section></docbook>