Oracle shared library<libclntsh.so> not found during i

dataservices administration
1

Hi all,

I keep getting error below:

Looks like sqlplus client is working and I can connect to oracle repository with no problems. Looks like my environment is set right.

Why am I getting this error when i am trying to configure bo data integrator server?

Any help would be really appreciated!!!

Enter a Name for Job Server [Server1]:
Enter TCP Port Number for Job Server :3500
Do you want to manage adapters and SNMP communication for the Job Server ‘Y|N’ [N]:
Do you want to Enable SNMP for this JobServer ‘Y|N’ [N]:

  1. Oracle
  2. Informix
  3. DB2
  4. Sybase ASE
    Enter the database type (1,2,3 or 4) for the associated repository: 1

Enter the repository connection string: REPO
Enter the repository username: bodi
Enter the repository password (not echoed):
Confirm the repository password (not echoed):

Passwords do not match!!! Please enter them again.
Enter the repository password (not echoed):
Confirm the repository password (not echoed):

Passwords do not match!!! Please enter them again.
Enter the repository password (not echoed):
Confirm the repository password (not echoed):

S# Job Server Name TCP Enable Repository Connection
Port SNMP

1 Server1 3500 N bodi@REPO__Oracle

Is this information correct [Y/N]? y

Updating the repository <bodi@REPO__Oracle>. Please wait…

(11.5) 04-08-08 16:05:42 (E) (25928:4130629312) CON-120421: Initialization
Oracle shared library <libclntsh.so> not found. Please make sure it is installed and can be located using the library search
path (LIBPATH on AIX, LD_LIBRARY_PATH on Solaris/Linux, SHLIB_PATH on HP-UX). Please check the file permissions for
<libclntsh.so>.
UNABLE to Update the repository <bodi@REPO__Oracle>. Please check the /tmp/al_machine.out.25909 for more details!
SNMP is disabled.

Also:

the file that it cant find. is there:

[oracle@batchetl-1 client]$ pwd

/data/oracle/product/10.2.0/client

[oracle@batchetl-1 client]$ find . -name libclntsh.so -print
./lib32/libclntsh.so
./lib/libclntsh.so

[b][oracle@batchetl-1 client]$ ls -lt lib/libclntsh.so

lrwxrwxrwx 1 oracle oinstall 59 Mar 28 19:33 lib/libclntsh.so -> /u01/app/oracle/product/10.2.0/client/lib/libclntsh.so.10.1[/b]

achervinsky (BOB member since 2008-04-08)

2

make sure that /data/oracle/product/10.2.0/client/lib/libclntsh.so is part of the shared library path.

DI 11.7?

Werner Daehn :de: (BOB member since 2004-12-17)

3

this is DI 11.5

if i type env:
LD_LIBRARY_PATH=/data/oracle/product/10.2.0/client/lib/:/u01/app/oracle/product/10.2.0/client/lib:/u01/app/oracle/product/10.2.0/client/oracm/lib:/lib:/usr/lib:/usr/local/lib:/home/bodi/DataIntegrator/bin

then

$ ls -l /data/oracle/product/10.2.0/client/lib/libclntsh.so
lrwxrwxrwx 1 oracle oinstall 59 Mar 28 19:33 /data/oracle/product/10.2.0/client/lib/libclntsh.so -> /u01/app/oracle/product/10.2.0/client/lib/libclntsh.so.10.1

$ ls -l /u01/app/oracle/product/10.2.0/client/lib/libclntsh.so.10.1
-rwxr-xr-x 1 oracle oinstall 20526416 Mar 28 18:08 /u01/app/oracle/product/10.2.0/client/lib/libclntsh.so.10.1

so looks like path and file is set appropriately.

Thanks
-Alex

achervinsky (BOB member since 2008-04-08)

4

11.5 is 32bit still, isn’t it? So you would need to remove the …/lib/… path and add the …/lib32/… path.

Any reason for installing 11.5, not 11.7?

Werner Daehn :de: (BOB member since 2004-12-17)

5

Thanks.
how do I tell if 11.5 is 32bit?

How do I upgrade to 11.7?

achervinsky (BOB member since 2008-04-08)

6

Unix? Type “file /DI/bin/al_engine” and the OS will tell. But for Solaris we had a 32bit version only, I just doublechecked.

For the upgrade, you just install 11.7 Dsigner over the old version, when asked upgrade the repo. Then you install the jobserver on Unix.

Before, you will do lots of backups so you can revert back to the current version and after the upgrade you will do lots of testing…

Werner Daehn :de: (BOB member since 2004-12-17)