Setting environment variables for tnsnames.ora in SUSE Linux

[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,

[denis_konovalov]

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.

[Former Member]

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.

[Former Member]

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.

[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,