Install Oracle Client and DBD:Oracle

Last login: Sun Oct 25 12:58:47 2020 from 192.168.10.17
[root@client_vm ~]# yum install -y oracle-release-el7
Loaded plugins: langpacks, ulninfo
Resolving Dependencies
--> Running transaction check
---> Package oracle-release-el7.x86_64 0:1.0-3.el7 will be installed
--> Processing Dependency: oraclelinux-release-el7 for package: oracle-release-el7-1.0-3.el7.x86_64
--> Running transaction check
---> Package oraclelinux-release-el7.x86_64 0:1.0-13.1.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

===================================================================================================================
 Package                              Arch                Version                    Repository               Size
===================================================================================================================
Installing:
 oracle-release-el7                   x86_64              1.0-3.el7                  ol7_latest               14 k
Installing for dependencies:
 oraclelinux-release-el7              x86_64              1.0-13.1.el7               ol7_latest               19 k

Transaction Summary
===================================================================================================================
Install  1 Package (+1 Dependent package)

Total download size: 33 k
Installed size: 47 k
Downloading packages:
(1/2): oracle-release-el7-1.0-3.el7.x86_64.rpm                                              |  14 kB  00:00:00
(2/2): oraclelinux-release-el7-1.0-13.1.el7.x86_64.rpm                                      |  19 kB  00:00:00
-------------------------------------------------------------------------------------------------------------------
Total                                                                               50 kB/s |  33 kB  00:00:00
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction

IMPORTANT: A legacy Oracle Linux yum server repo file was found. Oracle Linux yum server repository configurations have changed which means public-yum-ol7.repo will no longer be updated. New repository configuration files have been installed but are disabled. To complete the transition, run this script as the root user:

/usr/bin/ol_yum_configure.sh

See https://yum.oracle.com/faq.html for more information.

  Installing : oraclelinux-release-el7-1.0-13.1.el7.x86_64                                                     1/2
  Installing : oracle-release-el7-1.0-3.el7.x86_64                                                             2/2
  Verifying  : oraclelinux-release-el7-1.0-13.1.el7.x86_64                                                     1/2
  Verifying  : oracle-release-el7-1.0-3.el7.x86_64                                                             2/2

Installed:
  oracle-release-el7.x86_64 0:1.0-3.el7

Dependency Installed:
  oraclelinux-release-el7.x86_64 0:1.0-13.1.el7

Complete!
[root@client_vm ~]# /usr/bin/ol_yum_configure.sh
Repository ol7_UEKR5 already enabled
Repository ol7_latest already enabled
[root@client_vm ~]# yum install -y oracle-instantclient19.6-basic oracle-instantclient19.6-devel oracle-instantclient19.6-jdbc oracle-instantclient19.6-sqlplus
Loaded plugins: langpacks, ulninfo
ol7_UEKR5                                                                                   | 2.5 kB  00:00:00
ol7_latest                                                                                  | 2.7 kB  00:00:00
ol7_oracle_instantclient                                                                    | 2.5 kB  00:00:00
(1/2): ol7_oracle_instantclient/x86_64/primary_db                                           |  13 kB  00:00:00
(2/2): ol7_oracle_instantclient/x86_64/updateinfo                                           |   86 B  00:00:00
Resolving Dependencies
--> Running transaction check
---> Package oracle-instantclient19.6-basic.x86_64 0:19.6.0.0.0-1 will be installed
---> Package oracle-instantclient19.6-devel.x86_64 0:19.6.0.0.0-1 will be installed
---> Package oracle-instantclient19.6-jdbc.x86_64 0:19.6.0.0.0-1 will be installed
---> Package oracle-instantclient19.6-sqlplus.x86_64 0:19.6.0.0.0-1 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

===================================================================================================================
 Package                                 Arch          Version               Repository                       Size
===================================================================================================================
Installing:
 oracle-instantclient19.6-basic          x86_64        19.6.0.0.0-1          ol7_oracle_instantclient         52 M
 oracle-instantclient19.6-devel          x86_64        19.6.0.0.0-1          ol7_oracle_instantclient        599 k
 oracle-instantclient19.6-jdbc           x86_64        19.6.0.0.0-1          ol7_oracle_instantclient        1.5 M
 oracle-instantclient19.6-sqlplus        x86_64        19.6.0.0.0-1          ol7_oracle_instantclient        687 k

Transaction Summary
===================================================================================================================
Install  4 Packages

Total download size: 54 M
Installed size: 233 M
Downloading packages:
(1/4): oracle-instantclient19.6-devel-19.6.0.0.0-1.x86_64.rpm                               | 599 kB  00:00:00
(2/4): oracle-instantclient19.6-jdbc-19.6.0.0.0-1.x86_64.rpm                                | 1.5 MB  00:00:00
(3/4): oracle-instantclient19.6-sqlplus-19.6.0.0.0-1.x86_64.rpm                             | 687 kB  00:00:00
(4/4): oracle-instantclient19.6-basic-19.6.0.0.0-1.x86_64.rpm                               |  52 MB  00:00:08
-------------------------------------------------------------------------------------------------------------------
Total                                                                              6.2 MB/s |  54 MB  00:00:08
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : oracle-instantclient19.6-basic-19.6.0.0.0-1.x86_64                                              1/4
  Installing : oracle-instantclient19.6-jdbc-19.6.0.0.0-1.x86_64                                               2/4
  Installing : oracle-instantclient19.6-sqlplus-19.6.0.0.0-1.x86_64                                            3/4
  Installing : oracle-instantclient19.6-devel-19.6.0.0.0-1.x86_64                                              4/4
  Verifying  : oracle-instantclient19.6-jdbc-19.6.0.0.0-1.x86_64                                               1/4
  Verifying  : oracle-instantclient19.6-sqlplus-19.6.0.0.0-1.x86_64                                            2/4
  Verifying  : oracle-instantclient19.6-basic-19.6.0.0.0-1.x86_64                                              3/4
  Verifying  : oracle-instantclient19.6-devel-19.6.0.0.0-1.x86_64                                              4/4

Installed:
  oracle-instantclient19.6-basic.x86_64 0:19.6.0.0.0-1    oracle-instantclient19.6-devel.x86_64 0:19.6.0.0.0-1
  oracle-instantclient19.6-jdbc.x86_64 0:19.6.0.0.0-1     oracle-instantclient19.6-sqlplus.x86_64 0:19.6.0.0.0-1

Complete!
[root@client_vm ~]# export LD_LIBRARY_PATH=/usr/lib/oracle/19.6/client64/lib
[root@client_vm ~]# export ORACLE_HOME=/usr/lib/oracle/19.6/client64
[root@client_vm ~]# yum install -y perl-CPAN
Loaded plugins: langpacks, ulninfo
Resolving Dependencies
--> Running transaction check
---> Package perl-CPAN.noarch 0:1.9800-297.el7 will be installed
--> Processing Dependency: perl(local::lib) for package: perl-CPAN-1.9800-297.el7.noarch
--> Processing Dependency: perl(Digest::SHA) for package: perl-CPAN-1.9800-297.el7.noarch
--> Running transaction check
---> Package perl-Digest-SHA.x86_64 1:5.85-4.el7 will be installed
---> Package perl-local-lib.noarch 0:1.008010-4.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

===================================================================================================================
 Package                       Arch                 Version                         Repository                Size
===================================================================================================================
Installing:
 perl-CPAN                     noarch               1.9800-297.el7                  ol7_latest               293 k
Installing for dependencies:
 perl-Digest-SHA               x86_64               1:5.85-4.el7                    ol7_latest                57 k
 perl-local-lib                noarch               1.008010-4.el7                  ol7_latest                64 k

Transaction Summary
===================================================================================================================
Install  1 Package (+2 Dependent packages)

Total download size: 414 k
Installed size: 958 k
Downloading packages:
(1/3): perl-Digest-SHA-5.85-4.el7.x86_64.rpm                                                |  57 kB  00:00:00
(2/3): perl-local-lib-1.008010-4.el7.noarch.rpm                                             |  64 kB  00:00:00
(3/3): perl-CPAN-1.9800-297.el7.noarch.rpm                                                  | 293 kB  00:00:01
-------------------------------------------------------------------------------------------------------------------
Total                                                                              280 kB/s | 414 kB  00:00:01
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : perl-local-lib-1.008010-4.el7.noarch                                                            1/3
  Installing : 1:perl-Digest-SHA-5.85-4.el7.x86_64                                                             2/3
  Installing : perl-CPAN-1.9800-297.el7.noarch                                                                 3/3
  Verifying  : 1:perl-Digest-SHA-5.85-4.el7.x86_64                                                             1/3
  Verifying  : perl-CPAN-1.9800-297.el7.noarch                                                                 2/3
  Verifying  : perl-local-lib-1.008010-4.el7.noarch                                                            3/3

Installed:
  perl-CPAN.noarch 0:1.9800-297.el7

Dependency Installed:
  perl-Digest-SHA.x86_64 1:5.85-4.el7                    perl-local-lib.noarch 0:1.008010-4.el7

Complete!
[root@client_vm ~]# perl -MCPAN -e 'install DBD::Oracle'

CPAN.pm requires configuration, but most of it can be done automatically.
If you answer 'no' below, you will enter an interactive dialog for each
configuration option instead.

Would you like to configure as much as possible automatically? [yes]

If you are running for the first time it will ask many questions; you can keep defaults by pressing ENTER key, but you need to give one appropriate mirror site for CPAN to download the modules.