Install ora2pg

最新推荐文章于 2024-12-09 14:38:21 发布

原创最新推荐文章于 2024-12-09 14:38:21 发布 · 329 阅读

0 ·

CC 4.0 BY-SA版权

本文详细介绍了ora2pg的安装步骤，包括必要的命令行操作和验证过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Commands:

Last login: Sun Oct 25 17:35:10 2020 from 192.168.10.17
[root@client_vm ~]# yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-repo-latest.noarch.rpm
Loaded plugins: langpacks, ulninfo
pgdg-redhat-repo-latest.noarch.rpm                                                          | 6.8 kB  00:00:
Examining /var/tmp/yum-root-TZHBuC/pgdg-redhat-repo-latest.noarch.rpm: pgdg-redhat-repo-42.0-14.noarch
Marking /var/tmp/yum-root-TZHBuC/pgdg-redhat-repo-latest.noarch.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package pgdg-redhat-repo.noarch 0:42.0-14 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

============================================================================================================
 Package                     Arch              Version            Repository
============================================================================================================
Installing:
 pgdg-redhat-repo            noarch            42.0-14            /pgdg-redhat-repo-latest.noarch

Transaction Summary
============================================================================================================
Install  1 Package

Total size: 11 k
Installed size: 11 k
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : pgdg-redhat-repo-42.0-14.noarch
  Verifying  : pgdg-redhat-repo-42.0-14.noarch

Installed:
  pgdg-redhat-repo.noarch 0:42.0-14

Complete!
[root@client_vm ~]# yum install ora2pg
Loaded plugins: langpacks, ulninfo
pgdg-common                                                                                 | 2.9 kB  00:00:
pgdg10                                                                                      | 3.6 kB  00:00:
pgdg11                                                                                      | 3.6 kB  00:00:
pgdg12                                                                                      | 3.6 kB  00:00:
pgdg13                                                                                      | 3.6 kB  00:00:
pgdg95                                                                                      | 3.6 kB  00:00:
pgdg96                                                                                      | 3.6 kB  00:00:
(1/13): pgdg11/7Server/x86_64/group_gz                                                      |  245 B  00:00:
(2/13): pgdg10/7Server/x86_64/group_gz                                                      |  245 B  00:00:
(3/13): pgdg-common/7Server/x86_64/primary_db                                               | 136 kB  00:00:
(4/13): pgdg12/7Server/x86_64/group_gz                                                      |  245 B  00:00:
(5/13): pgdg13/7Server/x86_64/group_gz                                                      |  246 B  00:00:
(6/13): pgdg95/7Server/x86_64/group_gz                                                      |  249 B  00:00:
(7/13): pgdg13/7Server/x86_64/primary_db                                                    |  51 kB  00:00:
(8/13): pgdg96/7Server/x86_64/group_gz                                                      |  249 B  00:00:
(9/13): pgdg95/7Server/x86_64/primary_db                                                    | 226 kB  00:00:
(10/13): pgdg10/7Server/x86_64/primary_db                                                   | 270 kB  00:00:
(11/13): pgdg12/7Server/x86_64/primary_db                                                   | 145 kB  00:00:
(12/13): pgdg11/7Server/x86_64/primary_db                                                   | 278 kB  00:00:
(13/13): pgdg96/7Server/x86_64/primary_db                                                   | 259 kB  00:00:
Resolving Dependencies
--> Running transaction check
---> Package ora2pg.noarch 0:21.0-1.rhel7 will be installed
--> Processing Dependency: perl-DBD-MySQL for package: ora2pg-21.0-1.rhel7.noarch
--> Processing Dependency: perl(String::Random) for package: ora2pg-21.0-1.rhel7.noarch
--> Processing Dependency: perl(DBD::Oracle) for package: ora2pg-21.0-1.rhel7.noarch
--> Running transaction check
---> Package ora2pg.noarch 0:21.0-1.rhel7 will be installed
--> Processing Dependency: perl(String::Random) for package: ora2pg-21.0-1.rhel7.noarch
--> Processing Dependency: perl(DBD::Oracle) for package: ora2pg-21.0-1.rhel7.noarch
---> Package perl-DBD-MySQL.x86_64 0:4.023-6.0.1.el7 will be installed
--> Finished Dependency Resolution
Error: Package: ora2pg-21.0-1.rhel7.noarch (pgdg-common)
           Requires: perl(String::Random)
Error: Package: ora2pg-21.0-1.rhel7.noarch (pgdg-common)
           Requires: perl(DBD::Oracle)
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest
[root@client_vm ~]# perl -MCPAN -e 'install DBD::Oracle'
Reading '/root/.cpan/Metadata'
  Database was generated on Sun, 25 Oct 2020 00:17:03 GMT
DBD::Oracle is up to date (1.80).
[root@client_vm ~]#

Solution:

[root@client_vm ~]# yumdownloader ora2pg
Loaded plugins: langpacks
warning: /root/ora2pg-21.0-1.rhel7.noarch.rpm: Header V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEY0:00 ETA
Public key for ora2pg-21.0-1.rhel7.noarch.rpm is not installed
ora2pg-21.0-1.rhel7.noarch.rpm                                                       | 339 kB  00:00:03
[root@client_vm ~]# rpm -Uvh --nodeps ora2pg-21.0-1.rhel7.noarch.rpm
warning: ora2pg-21.0-1.rhel7.noarch.rpm: Header V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:ora2pg-21.0-1.rhel7              ################################# [100%]
[root@client_vm ~]#

Verification:

[root@client_vm ~]# which ora2pg
/usr/bin/ora2pg
[root@client_vm ~]#