Skip to Content
0

Setting environment variables for tnsnames.ora in SUSE Linux

Nov 26, 2016 at 07:08 AM

428

avatar image
Former Member

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,

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Sergo Beradze Nov 26, 2016 at 05:21 PM
0

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi,

Thanks for the info.

However, there is no Oracle installed on our BO server. Hence, the ORACLE HOME directory is currently not existing.

Appreciate if we could get the commands too to do the required settings since SUSE Linux is pretty new to us.

Regards,

0
Sergo Beradze Nov 28, 2016 at 06:44 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Denis Konovalov
Dec 05, 2016 at 03:09 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded