Skip to Content
avatar image
Former Member

Setting environment variables for tnsnames.ora in SUSE Linux

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,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Nov 26, 2016 at 05:21 PM

    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.

    Add comment
    10|10000 characters needed 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,

  • Nov 28, 2016 at 06:44 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 05, 2016 at 03:09 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded