LAE

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

Originally posted by: dwong80

We are getting the following error when running a graph which used to run. Any ideas?

"ERROR opening i/o streams:^\nUnable to open library 'libclntsh.so': ld.so.1: querydumper: fatal: libclntsh.so: open failed: No such file or directory"

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

Originally posted by: timonk

This occurs when your oracle Lib and Lib32 paths are not in your LD_LIBRARY_PATH for the BRAIN/LAE user environment on the UNIX system where your server is installed. You need to be sure your oracle library paths are included.

You may also need to add them to the SHLIB_PATH, if adding to the above does not work.

Regards
Timon Koufopoulos
MDA Support.

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

Originally posted by: dwong80

There is reference to the shared object in the script. I exported/echoed the LD_LIBRARY_PATH.

Do this look right?

/opt/lavastorm/db/../lib/Solaris:/opt/lavastorm/db/../python/lib:/opt/lavastorm/lib/Solaris:/opt/lavastorm/python/lib:/opt/lavastorm/db/../lib/Solaris:/opt/lavastorm/db/../python/lib:/opt/oracle/app/oracle/instantclient32:/opt/oracle/app/oracle/lib32:/opt/oracle/app/oracle/lib:/usr/local/lib:/usr/lib:

This script worked for YEARS up until yesterday - not sure what happened.

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

Originally posted by: rboccuzzi

Did someone perform any maintenance on the oracle client installed on the server? If they did an upgrade or something, they may have moved or corrupted that installed library... as for your paths, I am not sure, it depends on where your oracle client was installed. You want to make sure that one of the directories pointed to in that path (LD_LIBRARY_PATH) is pointing at a directory that contains the 'libclntsh.so' file.
Cheers
Rich

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

Originally posted by: dwong80

No there hasn't. But fortunately this problem went away after we killed all the brain sessions running on the server and re-started it. Thanks for your response.

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

Originally posted by: dwong80

I ran into this problem again after upgrading from 4.1.9 to 4.5.4. Fortunately, the solution was posted above. I updated the LD_LIBRARY_PATH which didn't work by itself. So I updated the SHLIB_PATH as well then restarted the LAE server - and that worked.