%META:TOPICPARENT{name="ErrorMessagesE"}%
= Error Message: {{{Error while trying to retrieve text for error ORA-#####}}} or {{{Unable to retrieve text of NETWORK/NCR message #####}}} =

"Retrieve text" errors typically arise when your environment variables are not set properly.  Most commonly, {{{ORACLE_HOME}}} and {{{ORACLE_SID}}} need correction.

== Multi-Tier ==

# Use a text editor to open the active Broker Rulebook ({{{.../<OPENLINK_INSTALL>/bin/oplrqb.ini}}}, by default).
# Locate the {{{[Environment ORACLE*]}}} section which corresponds to the active Database Agent for Oracle. For example:
{{{
[Environment ORACLE81]
ORACLE_HOME = /dbs/oracle/app/product/8.1.7
ORACLE_SID=ORCL
}}}
# Ensure that {{{ORACLE_HOME}}} and {{{ORACLE_SID}}} are set correctly.
# Save the Rulebook.
# Restart the Request Broker.
# Test your connection.
    
== Evidence ==

* Session Rulebook
* Request Broker Log