[Sqlrelay-discussion] Installing sqlrelay-oracle8 rpm with instant client

[MA M. A. (5542) <MAn...@ag...>]

I am trying to install the binary distributed rpm's using yum, and I am getting complaints about missing dependencies when installing sqlrelay-oracle8-0.54-1.x86_64 . The "missing" libraries are installed via oracle's instant client rpm. If I forcefully install the sqlrelay-oracle8 rpm, sqlrelay is able to connect to oracle okay. I would like to use yum for our installs. Any ideas on avoiding the dependency errors?

[root@stg-sqlrelay1 ~]# yum  install sqlrelay-oracle8
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* agcom: cf
* base: cf
* epel: cf
* extras: cf
* update: cf
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package sqlrelay-oracle8.x86_64 0:0.54-1 will be installed
--> Processing Dependency: libclntsh.so.12.1()(64bit) for package: sqlrelay-oracle8-0.54-1.x86_64
--> Processing Dependency: libnnz12.so()(64bit) for package: sqlrelay-oracle8-0.54-1.x86_64
--> Processing Dependency: libons.so()(64bit) for package: sqlrelay-oracle8-0.54-1.x86_64
--> Processing Dependency: libclntshcore.so.12.1()(64bit) for package: sqlrelay-oracle8-0.54-1.x86_64
--> Finished Dependency Resolution
Error: Package: sqlrelay-oracle8-0.54-1.x86_64 (agcom)
           Requires: libclntshcore.so.12.1()(64bit)
Error: Package: sqlrelay-oracle8-0.54-1.x86_64 (agcom)
           Requires: libons.so()(64bit)
Error: Package: sqlrelay-oracle8-0.54-1.x86_64 (agcom)
           Requires: libclntsh.so.12.1()(64bit)
Error: Package: sqlrelay-oracle8-0.54-1.x86_64 (agcom)
           Requires: libnnz12.so()(64bit)
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles -nodigest


[root@stg-sqlrelay1 ~]# ls /usr/lib/oracle/12.1/client64/lib
libclntshcore.so.12.1  libocci.so.12.1  libons.so         ojdbc7.jar
libclntsh.so.12.1      libociei.so      liboramysql12.so  xstreams.jar
libnnz12.so            libocijdbc12.so  ojdbc6.jar


[root@stg-sqlrelay1 ~]# rpm -qi oracle-instantclient12.1-basic
Name        : oracle-instantclient12.1-basic  Relocations: (not relocatable)
Version     : 12.1.0.1.0                        Vendor: Oracle Corporation
Release     : 1                             Build Date: Fri 24 May 2013 01:22:52 PM EDT
Install Date: Tue 24 Jun 2014 12:56:25 PM EDT      Build Host: adc4150438.us.oracle.com
Group       : Applications/File             Source RPM: oracle-instantclient12.1-basic-12.1.0.1.0-1.src.rpm
Size        : 214591244                        License: Oracle
Signature   : (none)
Packager    : Nobody <no...@or...>
URL         : http://www.oracle.com/
Summary     : Instant Client for Oracle Database 11g
Description :
Instant Client allows you to run your applications without installing the standard Oracle client or having an ORACLE_HOME.  OCI, OCCI, ODBC, and JDBC applications work without modification, while using significantly less disk space than before.  No recompile, no hassle.

This is the Basic package, supporting OCI, OCCI, and JDBC-OCI with all
languages.

--------
Martin Andrews
man...@ag...