Business Objects - EDW - Oracle Client Error - Enterprise Data Warehouse
The University of Illinois recommends configuring the Oracle client to use the LDAP option for database discovery. Otherwise the client may not successfully connect to the database.
I'm trying to connect to the warehouse using ODBC with the Oracle client, however I'm receiving an error.
To resolve this error and re-establish a connection to the Data Warehouse, you much take the following action.
- Upgrade to Oracle 11g client, following the instructions posted on the AITS website: https://www.aits.uillinois.edu/common/pages/DisplayFile.aspx?itemId=102304
- Make sure to copy the SQLNET.ORA and LDAP.ORA files as described in the instructions.
If you continue to encounter problems, please submit a ticket to the AITS Service Desk or call them at (217) 333-3102 or (312) 996-4806 and they will send a ticket to the group for you.