LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  libclntsh.so issue, don't know what we are missing out.

    Employee
    Posted 01-21-2015 08:10

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: vijayramachandran

    Hi,

    User is facing this issue, one server it is working good, on the other server, it is barfing with this issue.

    Don't know what is going wrong?

    .profile.lavastorm look ideal on both of the servers

    I did check LD_LIBRARY_DATA as well.

    Please help me with this.

    Refer the attachment for the error.ls.jpg


  • 2.  RE: libclntsh.so issue, don't know what we are missing out.

    Employee
    Posted 01-21-2015 14:08

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: ejones

    Ok, the first question, Is the Oracle client installed on the server where it is "barfing"?


  • 3.  RE: libclntsh.so issue, don't know what we are missing out.

    Employee
    Posted 01-21-2015 22:58

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: vijayramachandran

    Originally posted by: ejones
					

    Ok, the first question, Is the Oracle client installed on the server where it is "barfing"?
    Yes, I did.

    It isn't properly installed or something? Is that your hunch?


  • 4.  RE: libclntsh.so issue, don't know what we are missing out.

    Employee
    Posted 01-23-2015 04:44

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: ejones

    The error message indicates that LAE is not finding the Oracle client software it needs. This could either be caused by having something wrong in the installation, or by not having something the environment variables set properly for LAE to find it. One way to test the Oracle client installation is to see if you can run Oracle's sqlplus command and connect to the database.

    So, here are three environment variables to look at:
    1. ORACLE_HOME should point to the location where the Oracle client is installed.
    2. LD_LIBRARY_PATH should have an entry for the lib directory in the Oracle client software. $ORACLE_HOME/lib and you should be able to see the libclntsh.so in that lib directory.
    3. PATH should have an entry for the bin directory in the Oracle client software. $ORACLE_HOME/bin which is where you'll find commands like tnsping and sqlplus. It is possible to have a working Oracle client installation that does not include sqlplus, but that means that one of my favorite tools for troubleshooting is not available. The other favorite utility for troubleshooting is tnsping.