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

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

Hmmm.   You're right.  That's interesting...  I wonder how Oracle is 
building those RPM's.  There's a step at the end of the process where 
rpmbuild digs through the files and automatically builds the list of 
files that it provides.  Or at least, it appears to.  Maybe it doesn't 
though.  Maybe that has to be done manually.  I wonder if the SQL Relay 
RPM's have the same issue!

I'd bet that it would be fairly straightforward to build a spec file 
that re-packages the oracle RPM's and includes that info.

Dave

On 7/3/2014 9:21 AM, MA Martin Andrews (5542) wrote:
> I am installing the rpm's from our custom repo. I think the problem is with the instant client rpm - it does not say it "provides" any if the libraries it contains:
>
> [root@stg-sqlrelay1 ~]# rpm -q --provides oracle-instantclient12.1-basic
> oracle-instantclient12.1-basic = 12.1.0.1.0-1
>
> For you edification - here is the full output I get when installing the rpm with yum:
>
> [root@stg-sqlrelay1 ~]#
> [root@stg-sqlrelay1 ~]# yum install -y oracle-instantclient12.1-basic
> 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 oracle-instantclient12.1-basic.x86_64 0:12.1.0.1.0-1 will be installed
> --> Finished Dependency Resolution
>
> Dependencies Resolved
>
> ==========================================================================================
>   Package                              Arch         Version              Repository   Size
> ==========================================================================================
> Installing:
>   oracle-instantclient12.1-basic       x86_64       12.1.0.1.0-1         agcom        67 M
>
> Transaction Summary
> ==========================================================================================
> Install       1 Package(s)
>
> Total size: 67 M
> Installed size: 205 M
> Downloading Packages:
> Running rpm_check_debug
> Running Transaction Test
> Transaction Test Succeeded
> Running Transaction
>    Installing : oracle-instantclient12.1-basic-12.1.0.1.0-1.x86_64                     1/1
>    Verifying  : oracle-instantclient12.1-basic-12.1.0.1.0-1.x86_64                     1/1
>
> Installed:
>    oracle-instantclient12.1-basic.x86_64 0:12.1.0.1.0-1
>
> Complete!
> [root@stg-sqlrelay1 ~]#
> [root@stg-sqlrelay1 ~]# yum install -y 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 ~]#
>
> -----Original Message-----
> From: David Muse [mailto:dav...@fi...]
> Sent: Wednesday, July 02, 2014 9:24 PM
> To: Discussion of topics related to SQL Relay
> Subject: Re: [Sqlrelay-discussion] Installing sqlrelay-oracle8 rpm with instant client
>
> Hi Martin,
>
> ...
>
> Did you install instantclient using yum or rpm?
>
> ...
>
> 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...
>
>
>
> ------------------------------------------------------------------------------
> 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
>