LAE

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

Originally posted by: Brad Brezinski

I installed LAE version 6.1.3 on new servers. I�m getting node errors that libcliv2.so cannot be found. Is this an oracle instance issue with my installation?

I�ve verified the LD_LIBRARY_PATH location, it does exist but it does not contain that file. I�ve pasted the files it does contain below.

This is the path LD_LIBRARY_PATH in my .profile.lavastorm file:

LD_LIBRARY_PATH="/opt/app/t1lae1c1/Lavastorm/LAE6.1/TERR/lib/x86_64-unknown-linux-gnu${LD_LIBRARY_PATH:+:}${LD_LIBRARY_PATH:-}"

Here are the files in that location:

$ pwd
/opt/app/t1lae1c1/Lavastorm/LAE6.1/TERR/lib/x86_64-unknown-linux-gnu
$ ls
libengine.so libimf.so libirng.so libRlapack.so libRzlib.so.1 libTERRcrypto.so.1.0.0
libifcore.so.5 libintlc.so.5 libRblas.so libR.so libsvml.so libTERRcurl.so.4
libifport.so.5 libiomp5.so libRgraphapp.so librt.so.1 libtermcap.so.2 libTERRssl.so.1.0.0
$

Thanks,
Brad

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

Originally posted by: stonysmith

You are on the correct trail here.. 99% time you see the message "xxxxxx.so cannot be found" - it is a problem with the LD_LIBRARY_PATH

In your case.. LD_LIBRARY_PATH is pointing (only) to the Teradata client software, and (usually) libcliv2.so is an Oracle module.
I would add your Oracle library path to the LD_LIBRARY_PATH

You need both of these lines:
LD_LIBRARY_PATH="/opt/app/t1lae1c1/Lavastorm/LAE6.1/TERR/lib/x86_64-unknown-linux-gnu${LD_LIBRARY_PATH:+:}${LD_LIBRARY_PATH:-}"
LD_LIBRARY_PATH="/opt/app/t1lae1c1/Lavastorm/LAE6.1/oracle/client13/lib${LD_LIBRARY_PATH:+:}${LD_LIBRARY_PATH:-}"

You obviously have to point it to the right folder for Oracle....

============================
It's also extremely common for the message above to then be followed by this message:
"INCORRECT ELF CLASS"
That usually means that you picked the 32 bit drivers instead of the 64 bit drivers, or vice versa..
If that happens, change "oracle/client13/lib" above to "oracle/client13/lib64"

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

Originally posted by: Brad Brezinski

Thanks! I'm not finding the oracle/client13 anywhere?

I'm finding:
$ pwd
/opt/app/t1lae1c1/Lavastorm/LAE6.1
$ ls -a
. conf docs infinispan jre log simba tmp
.. .cshrc.lavastorm ExhibitA.txt .install4j lib platform sql uninstall
bin data h2 jetty LicenseAgreement.txt .profile.lavastorm TERR web-conf
$ find /opt/app/t1lae1c1/Lavastorm/LAE6.1 -name "*oracle*"
/opt/app/t1lae1c1/Lavastorm/LAE6.1/h2/src/tools/oracle
/opt/app/t1lae1c1/Lavastorm/LAE6.1/sql/tables_oracle_lavastorm.sql
/opt/app/t1lae1c1/Lavastorm/LAE6.1/sql/tables_oracle_quartz.sql
/opt/app/t1lae1c1/Lavastorm/LAE6.1/sql/migration/oracle
/opt/app/t1lae1c1/Lavastorm/LAE6.1/jre/lib/missioncontrol/plugins/com.jrockit.mc.console.ui.notification_5.2.0.15728 4/html/dcommon/gifs/oracle.gif
/opt/app/t1lae1c1/Lavastorm/LAE6.1/lib/python/lavastorm/oracle
/opt/app/t1lae1c1/Lavastorm/LAE6.1/lib/python/lavastorm/installer/tasks/db/oracle
$ find /opt/app/t1lae1c1/Lavastorm/LAE6.1 -name "*client13*"
$

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

Originally posted by: stonysmith

That would be a general indication that Oracle hasn't been installed.

Run this:
find /opt/app/ -name "*oracle*" 2>/dev/null

or this:
find / -name "*oracle*" 2>/dev/null


Adding the 2>/dev/null to the command will silence some common errors the "find" command suffers from.

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

Originally posted by: Brad Brezinski

I used that thanks. To clarify, are we expecting to see the client13 folder and seeing that after the LAE6.1 folder? Does it get installed as part of the LAE installation or is the /opt/app/t1lae1c1/Lavastorm/LAE6.1/oracle/client13 path and associated files installed only if the LAE installation detects oracle?
Thanks,
Brad

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

Originally posted by: stonysmith

No. You want to use the folder where the Oracle client software was installed, and that's assuming that it WAS installed.

I used the folder names above as only a suggestion.. you may well have a different location for the files.

The Oracle client software is NOT installed as part of the LAE installation.. it is a separate process.