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