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

1. Use a text editor to open the active Broker Rulebook (.../<OPENLINK_INSTALL>/bin/oplrqb.ini, by default).
   
2. 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
   

   
   
3. Ensure that ORACLE_HOME and ORACLE_SID are set correctly.
   
4. Save the Rulebook.
   
5. Restart the Request Broker.
   
6. Test your connection.

Evidence

• Session Rulebook
  
• Request Broker Log