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

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

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...