Ora2Pg

测试操作系统:Centos 7.6 测试IP     :192.168.112.88 操作系统安装信息:最小化安装 官方网站: http://ora2pg.darold.net/ Requirement The Oracle Instant Client or a full Oracle instaaltion must be installed on the system. You can download the RPM from Oracle download center:     rpm -ivh oracle-instantclient12.2-basic-12.2.0.1.0-1.x86_64.rpm     rpm -ivh oracle-instantclient12.2-devel-12.2.0.1.0-1.x86_64.rpm     rpm -ivh oracle-instantclient12.2-jdbc-12.2.0.1.0-1.x86_64.rpm     rpm -ivh oracle-instantclient12.2-sqlplus-12.2.0.1.0-1.x86_64.rpm or simply download the corresponding ZIP archives from Oracle download center and install them where you want, for example: /opt/oracle/instantclient_12_2/ You also need a modern Perl distribution (perl 5.10 and more). To connect to a database and proceed to his migration you need the DBI Perl module > 1.614. To migrate an Oracle database you need the DBD::Oracle Perl modules to be installed. To migrate a MySQL database you need the DBD::MySQL Perl modules. These modules are used to connect to the database but they are not mandatory if you want to migrate DDL input files. To install DBD::Oracle and have it working you need to have the Oracle client libraries installed and the ORACLE_HOME environment variable must be defined. If you plan to export a MySQL database you need to install the Perl module DBD::mysql which requires that the mysql client libraries are installed. On some Perl distribution you may need to install the Time::HiRes Perl module. 1.准备 oracle instant client 环境   1.1 解压软件 [root@ora2pg u01]# unzip instantclient-sqlplus-linux.x64-12.2.0.1.0.zip [root@ora2pg u01]# unzip instantclient-sdk-linux.x64-12.2.0.1.0.zip [root@ora2pg u01]# unzip instantclient-jdbc-linux.x64-12.2.0.1.0.zip [root@ora2pg u01]# unzip instantclient-basic-linux.x64-12.2.0.1.0.zip   1.2 配置环境变量 PATH=$PATH:$HOME/bin:/u01/instantclient_12_2 export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/pgsoft/lib:/u01/instantclient_12_2 export PATH 2.准备 DBD::Oracle  ,  DBI        安装依赖包 yum install perl-DBI perl-DBD-Pg perl-ExtUtils-MakeMaker gcc 3. 准备ora2pg 环境 下载文件: ora2pg-20.0.zip 下载后解压执行 perl Makefile.PL make make install 4. 配置 /etc/ora2pg.conf  # oracle connect info ORACLE_DSN dbi:Oracle:host=192.168.112.77;sid=testdb;port=1521 ORACLE_USER SYSTEM ORACLE_PWD oracle # oracle schema SCHEMA MYUSER # oracle type TYPE TABLE COPY DATA OUTPUT table.sql  psql -U postgres -d postgres -h 127.0.0.1 -p 5432 -f TABLE_table.sql  psql -U postgres -d postgres -h 127.0.0.1 -p 5432 -f COPY_table.sql 或者  psql -U postgres -d postgres -h 127.0.0.1 -p 5432 -f INSERT_table.sql 5. 生成迁移模板 [root@ora2pg ora2pg-20.0]# ora2pg --project_base /u01/migration/ --init_project test_project