on 11-26-2016 7:08 AM
Hi All,
We have a requirement to link the BO server to the Oracle database of a legacy system. The BO server is on the SUSE Linux platform. Hence, we have to configure the tnsnames.ora file to set the connection. The tnsnames.ora file already has the required information. Appreciate if somebody could assist in setting the environment variable for tnsnames.ora file in SUSE Linux to set the required connection.
Thanks in advance.
Regards,
you need to contact your Oracle DBA or Oracle support to answer your question as it is not BOE specific.
you need to install oracle client, configure tnsnames.ora file, LD_LIBRARY_PATH and PATH variables per Oracle's instructions.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, you should have oracle client installed, and it's enough.
In my answer above, there is no Oracle Home written at all, just path to the tnsnames folder.
BR, Sergo.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
If I understand properly your question, you need to set the TNS_ADMIN variable:
http://www.orafaq.com/wiki/TNS_ADMIN
To set it on session level depending on shell use:
set TNS_ADMIN /path/to/the/folder
export TNS_ADMIN=/path/to/the/folder
If you would like to set it permanently, you need to modify user's profiles, relogin, and restart the application.
Best Regards, Sergo.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.