LAE

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

Originally posted by: xathras

Hi Guys and Gals.

Just looking for a little bit of help setting up OCI Connectivity and wondered if anyone has done it before.

Thus far I have installed Oracle Instance Client, I have the LD_LIBRARY_PATH configured to include that so my LD_LIBRARY_PATH now reads:

/opt/software/lae/4.5.4/platform/linux-x86-64/python/lib:/opt/software/lae/4.5.4/platform/linux-x86-64/python/lib64:/opt/software/lae/4.5.4/platform/linux-x86-64/os/lib:/opt/software/lae/4.5.4/platform/linux-x86-64/os/lib64:/opt/software/lae/4.5.4/lib/linux-x86-64:/opt/instantclient/

TNS_ADMIN is configured as : /opt/instantclient

The Install was done under the LAE service user account.

I have created a tnsnames.ora file in /opt/instantclient and looks like:

# Generated by Oracle configuration tools.

PAFP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname.aircell.prod)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = someserver_services)
)
)

If I login to the linux account and issue a sqlplus command with the following

sqlplus sqlplus USERNAME/PASSWORD@PAFP I login fine:

SQL*Plus: Release 11.2.0.3.0 Production on Fri Mar 15 17:57:30 2013

Copyright (c) 1982, 2011, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Release 11.1.0.6.0 - 64bit Production
With the Real Application Clusters option

However, when I try use an DB Query node it doesn't work. Is there library dependancies as I get the following:

Unable to open library 'libclntsh.so': libclntsh.so: cannot open shared object file: No such file or directory. I am unable to find it located on the machine using whereis or find commands.

Can you also confirm how I have the node setup is correct?

node:DB_Query
bretype:core::DB Query
editor:sortkey=51435e4e43aa0601
output:@40fd2c7444283da6/=
prop:DbInterface=oci
prop:DbPassword=PASSWORD
prop:DbService=PAFP
prop:DbUser=USERNAME
prop:SqlQuery=<<EOX
select count(*) from customer
EOX
editor:XY=530,460
end:DB_Query


Appreciate your help in advance.

FYI edit - I saw this http://community.lavastorm.com/showt...ibclntsh.so%27 but that doesn't resolve it for us. I dont even see that file

wayne

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

Originally posted by: John Curtis

Hi Wayne,

Please refer this issue to Lavastorm support.

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

Originally posted by: xathras

Hi John, Normally do but since I've seen a few reports of similiar issues wanted to see if anyone had this exact issue.
I'll reach out to the team.

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

Originally posted by: rboccuzzi

In addition Wayne, you need to make sure the directory containing the libclntsh.so is part of your LD_LIBRARY_PATH...I don't know exactly where that file is installed in the instaclient install (it might be in a subdir). Additionally, I have seen Oracle client installs where the libclntsh.so ends up being a zero length file for some reason, and a reinstall can fix this. Please make sure your LD_LIBRARY_PATH contains a directory that contains a valid non-zero version of that file.

Cheers
Rich