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

[David M. <dav...@fi...>]

Hi Martin,

Unfortunately the mailing list is all but dead.  People just aren't fond 
of mass email any more.  Feel free to send questions like this directly 
to me though.

Did you install instantclient using yum or rpm?

If you installed it using rpm, then...

I'm not exactly sure how yum does its dependency resolution but I 
suspect that it does it by integrating all of the repodata into a single 
local database and resolving dependencies against that.  I don't believe 
that it integrates the local rpm database as well.

If you installed the oracle instantclient rpms using rpm then their 
files would be in the rpm database.  If you then installed the sqlrelay 
rpms using rpm rather than yum, then rpm should find the dependencies in 
the rpm database and not display any error.

But, if you install the oracle instantclient rpms using rpm and then 
install sqlrelay using yum, yum might only look in the repodata to 
resolve dependencies and since the instantclient rpms aren't in that 
repodata, their files aren't found.  I'm not 100% sure of that, but I 
suspect that's what's happening.

It looks like you've set up your own repo to install sqlrelay from.  A 
solution would be to put the oracle instantclient rpms in your yum repo 
as well.  If you already did that though then I'm not sure what's going 
on.  I'd probably need to run some tests here and/or poke around on your 
system.

Dave
dav...@fi...

On 7/2/2014 4:16 PM, MA Martin Andrews (5542) wrote:
> 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...
>
>
>
> ------------------------------------------------------------------------------
> Open source business process management suite built on Java and Eclipse
> Turn processes into business applications with Bonita BPM Community Edition
> Quickly connect people, data, and systems into organized workflows
> Winner of BOSSIE, CODIE, OW2 and Gartner awards
> http://p.sf.net/sfu/Bonitasoft
>
>
>
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>