Skip to main content

[01000][unixODBC][Dr​iver Manager]Can't open lib libsq​ora.so.11.1 : file not found

Hi
assuming you have installed correctly these components:
ORACLE DB (including instance and listener)
ODBC driver
and you are facing this problem:

[root@linuxRHEL6 bin]# isql -v simple
[01000][unixODBC][Driver Manager]Can't open lib '/usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1' : file not found
 
you should check the following

[root@linuxRHEL6 bin]# ldd /usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1
ldd: warning: you do not have execution permission for `/usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1'
        linux-vdso.so.1 =>  (0x00007fffa11d1000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00007f5c2585e000)
        libm.so.6 => /lib64/libm.so.6 (0x00007f5c255d9000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f5c253bc000)
        libnsl.so.1 => /lib64/libnsl.so.1 (0x00007f5c251a3000)
        libclntsh.so.11.1 => /usr/lib/oracle/11.2/client64/lib/libclntsh.so.11.1 (0x00007f5c22833000)
        libodbcinst.so.1 => not found
        libc.so.6 => /lib64/libc.so.6 (0x00007f5c2249f000)
        /lib64/ld-linux-x86-64.so.2 (0x0000003593000000)
        libnnz11.so => /usr/lib/oracle/11.2/client64/lib/libnnz11.so (0x00007f5c220d1000)
        libaio.so.1 => /lib64/libaio.so.1 (0x00007f5c21ed0000)

set up env variables  

[root@linuxRHEL6 lib]# export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib
[root@linuxRHEL6 lib]# export ORACLE_HOME=/usr/lib/oracle/11.2/client64
[root@linuxRHEL6 ~]# export TWO_TASK=//localhost:1521/ORCL
 
Still got the same error :
[root@linuxRHEL6 ~]# isql -v simple
[01000][unixODBC][Driver Manager]Can't open lib '/was_profs_7/oracle/app/v11.2/lib/libsqora.so.11.1' : file not found
 
 
The Solution:
create ta link for libodbcinst.so
[root@linuxRHEL6 bin]# ln -s /usr/lib64/libodbcinst.so.2 /usr/lib64/libodbcinst.so.1

 
[root@linuxRHEL6 bin]# isql -v
[IM010][unixODBC][Driver Manager]Data source name too long
[ISQL]ERROR: Could not SQLConnect
[root@linuxRHEL6 bin]# isql -v simple
+---------------------------------------+
| Connected!                            |

|                                       |

| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> select * from dual;
+------+
| DUMMY|
+------+
| X    |
+------+
SQLRowCount returns -1
1 rows fetched




Comments

  1. mvsagarMarch 19, 2018 at 5:53 AM

    Thanks a lot. This blog saved me a lot of time!

    ReplyDelete
  2. sathishMay 19, 2020 at 10:38 AM

    Thanks a lot. Saved me in critical time..

    ReplyDelete

Post a Comment

Popular posts from this blog

ORA-27104: system-defined limits for shared memory was misconfigured

I faced this error while trying to restore & recover of a PDB (pluggable database) part of the log file and the solution is described here below: log: initialization parameters used for automatic instance: db_name=CDB db_unique_name=gbux_pitr_PDB1_CDB compatible=12.1.0.2.0 db_block_size=8192 db_files=200 diagnostic_dest=/oracle/app/oracle _system_trig_enabled=FALSE sga_target=1888M processes=200 db_create_file_dest=/oracle/auxilary log_archive_dest_1='location=/oracle/auxilary' enable_pluggable_database=true _clone_one_pdb_recovery=true #No auxiliary parameter file used starting up automatic instance CDB RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 07/31/2016 16:22:20 RMAN-04014: startup failed: ORA-27104: system-defined limits for shared
6 comments
Read more

mount.nfs: backgrounding

if you face this kind of error with your remote NFS: [root@Vertica000 ~]# mount /files/application/Rremote3 mount.nfs: backgrounding "10.0.0.2:/files/application/remoteFiles" mount.nfs: mount options: "bg,hard,nointr,rsize=65536,wsize=65536,tcp,actimeo=0,vers=3,timeo=600,addr=10.0.0.2" look for the problem in the log file: cat /var/log/messages | grep mount  mount to NFS server '10.0.0.2' failed: timed out, retrying Solution: In most of the cases, you have a problem with your iptables in the destination server login as root to dest server (10.0.0.2) in my case and type this command: iptables --flush  the go back to your origin server to try remount the problematic NFS file system of course this is in case nfs server was installed and functioning properly. Good luck.
1 comment
Read more

ora-65035 while create pluggable database from another one

or : ORA-21000: error number argument to raise_application_error of -65035 is out of range Cause: this error caused because of an unrecoverable transaction in the source DB. Solution: 1. either stop and start your pluggable source DB 2. identify the open transaction and kill it if you can. use this query to do so: select * from v$transaction t,v$session  s where t.ses_addr = s.saddr;
Post a Comment
Read more