Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gmImR-0006xD-WB for pgsql-admin@arkaria.postgresql.org; Wed, 23 Jan 2019 13:41:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gmIlQ-0007TS-Rk for pgsql-admin@arkaria.postgresql.org; Wed, 23 Jan 2019 13:40:20 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gmIlQ-0007TL-4E for pgsql-admin@lists.postgresql.org; Wed, 23 Jan 2019 13:40:20 +0000 Received: from sonic314-13.consmr.mail.bf2.yahoo.com ([74.6.132.123]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gmIlM-0005VP-Lk for pgsql-admin@lists.postgresql.org; Wed, 23 Jan 2019 13:40:18 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1548250814; bh=JmiGAg8J7Xe9PsMlUTvtWxY6dpLhjATZ7XnCNXAd4mc=; h=Date:From:Reply-To:To:Subject:References:From:Subject; b=DXjUGlYrZi04vP7WYCGoczIl3HpJv5kbLhddeS07blHHuExbOvH0xBaNOYNFmyxK1kmsv/jQx+gmwCBa98IPem4LMmE6+pH0YzNlfBTIC+U2Tq9tPDHKWgCgHpn/huCA1FNoAOqRCikdV0UblelYT/gDQ60XCTqugg1nJE0ZDwRdEKbHmUm2GGYVwRyVjxq+rWJ4P8XrqCNWMqHXrK6wmLv2KAqVJ53F7s7LtNIsEn20cEloKxKjUXozltr0rYAoTbS0i1FBiZ2gzYQZA+lehI3alTwiYqirOU25JCXbNqRwA7ZlDxRSNgYfxuTJENmeqbTWMtETNiltv6OZDNlJSA== X-YMail-OSG: vtFjt4YVM1kEkMT431s7rie4irhBiwsjPAl5W774YjO1NvVxKfpGZYdL4yBPfha iMAUKnDnhNlwlJ0W9ZgMg6HQJxD9gFCo9sC49RDxcEfu7loX8_fL3jBloHqSuKz_Js_wj9fMpJZM jIYW3iDEXWNA8R4R8.6b8_DYiiFgMP7BxI1GFtQMnXGsBp3FTxRuSBxjMZYfjY8xtkn6_g0uM_DK vFHEHP.Ur5spTqRRiAFNwBXe0f_yzzIVcB8zI6XxGCtg1Gjp_Zbbvz67TEdd6ivC.XTLjsrV5GSU 6F04T68h1.DivlCBCKu2n4bJRaU34I2ctw2EVoALxY8MVPZ7rRZRS5e8fK236kl4YksFfxS_Bn6z amBjhSzyrp0fEUWdnI0BwHODa6zOJTjy._7U3m4sTN8Hk35.UOWQJcqTNkE4J6T1ePAOO3kwoWSI 6kQEU9tBWQjlPki_mgMcGcfWrtiXwODq6gZiMY1AHmPADrlLlTZ7BOyaPvV6VTCogh3QaSOTJ1k5 DDMqmN7ChyVuzJ_2FAbEHhvHNumQ5u5vd6ayahDdjCu9Q5A5K0g9nNM88sGdUM9vOG8GPZMXwlMp gbt3tdISYZfi0jpD_p4mlkcKcuo5j1yh1Iv_G5kXXCf9W3d2tEzQ0Z7uAJeaznEz7P.DTe9NEanY HWptpd5VTn5LsjNvLRe9b0yOO2HxUe8f.ng6r8kBD3X9wNxV3aSBWPPDBBsupk1nh8BvuG9BQLHp GJkFLnex5vuGkvGxK5lv.si4gzhs.gXhNkOAHhpLSyvAYAAj9YhMUzQLw.13.gxgvtfKr1J_prkN 9JE8YLCwRE1GNiznxtoOaOb794lXfy2AA9WhwFLMC7yRhjdfu0OLoOVLWX_nxYAaqPp_TSh.PKGh PfgxsnCixLglEI3ZXR55vfF6Xry5DVrWnmMLph0G2BEeoeX4Ukg5lA_4ysT3g0Xa7oPcRzDiX_BB rUw64JlsF5tW19.jorX7AIkCANM5TP7aA8wVxza.QZtm4Ps9kJ9VkN_P0.bFXTxO22RBggfSj14l gvRCTxUyeL4jQuiwmlHdtQdh49DFYT4XrVot.A3t9M6jfdmYcHTHahilubwF9LCSDj5s- Received: from sonic.gate.mail.ne1.yahoo.com by sonic314.consmr.mail.bf2.yahoo.com with HTTP; Wed, 23 Jan 2019 13:40:14 +0000 Date: Wed, 23 Jan 2019 13:40:12 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Pgsql-admin Message-ID: <1440746250.2295016.1548250812245@mail.yahoo.com> Subject: ora2pg perl module error MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2295015_505142045.1548250812243" References: <1440746250.2295016.1548250812245.ref@mail.yahoo.com> X-Mailer: WebService/1.1.13016 YahooMailNeo Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 Safari/537.36 Content-Length: 7329 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_2295015_505142045.1548250812243 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Good morning Experts, after install DBD::Oracle and configure ora2pg.conf.=C2=A0 I run orag2pg an= d get an error# cd /etc/ora2pg# cp ora2pg.conf.dist ora2pg.conf# vi ora2pg.= conf=C2=A0 =C2=A0---> with modification belowORACLE_HOME /u01/app/oracle/pr= oduct/12.2.0/dbhome_1ORACLE_DSN dbi::Oracle:host=3Dhostname;sid=3DCIDR;port= -1521ORACLE_USER systemORACLE_PWD xxxxxTYPE TAPE PACKAGE INSERT COPY VIEW G= RANT SEQUENCE TRIGGER FUNCTION PROCEDURE TABLESPACE TYPE PARTITION QUERY DB= LINK SYNONYM LOAD #ora2pginstall_driver(Oracle) failed: can't load '/usr/local/lib64/perl5/au= to/DBD/Oracle/Oracle.so' for module DBD::Oracle:libclntsh.so.12.1: cannot o= pen shared object file:No such file or directory at /usr/lib64/perl5/DynaLo= ader.pm line 190 at (evel13) line3.compilcation failed in require at (eval1= 3) line 3.Perhaps a required shared library or dll isn't installed where ex= pected at /usr/local/share/perl5/Ora2Pg.pm line 1570. the /usr/lib64/perl5/DynaLoader.pm existed and at line 190, I found:my $lib= reg =3D dl_load_file($file, $module->dl_load_flags) orcroak("Can't load '$f= ile' for module $module: ".dl_error()); what library/module needed? thank you.=C2=A0Bach-Nga No one in this world is pure and perfect.=C2=A0 If you avoid people for the= ir mistakes you will be alone. So judge less, love and forgive more.To call= him a dog hardly seems to do him justice though in as much as he had four = legs, a tail, and barked, I admit he was, to all outward appearances. But t= o those who knew him well, he was a perfect gentleman (Hermione Gingold) **Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely = rich *** Faithful talent *** Sharing success ------=_Part_2295015_505142045.1548250812243 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Good morning Experts,

after install DBD::Oracle and configure ora2pg.conf.  I run orag2p= g and get an error
# cd /etc/ora2pg
# cp ora2pg.conf.dist ora2pg.= conf
# vi ora2pg.conf&nbs= p;  ---> with modification below
ORACLE_HOME /u01/app/oracle/product/12.2.0/dbhome_1<= /div>
ORACLE_DSN dbi::Oracle:host=3Dho= stname;sid=3DCIDR;port-1521
ORACLE_USER system
ORACLE_PWD xxxxx
TYPE TAPE PACKAGE INSERT C= OPY VIEW GRANT SEQUENCE TRIGGER FUNCTION PROCEDURE TABLESPACE TYPE PARTITIO= N QUERY DBLINK SYNONYM LOAD

#ora2pg
install_driver(Oracle) failed: can't l= oad '/usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so' for module DBD::Orac= le:libclntsh.so.12.1: cannot open shared object file:No such file or direct= ory at /usr/lib64/perl5/DynaLoader.pm line 190 at (evel13) line3.
compilcation fail= ed in require at (eval13) line 3.
Perhaps a required shared library or dll isn't in= stalled where expected at /usr/local/share/perl5/Ora2Pg.pm line 1570.
=

the /usr/lib64/p= erl5/DynaLoader.pm existed and at line 190, I found:
my $libreg =3D dl_load_file($f= ile, $module->dl_load_flags) or
croak("Can't load '$file' for module $module: ".= dl_error());

what library/module needed?

thank you.
 
Bach-Ng= a

No one in this world is pure and= perfect.  If you avoid people for their mistakes you will be alone. S= o judge less, love and forgive more.
To call him a dog hardly seems to do him justice though in as much as he = had four legs, a tail, and barked, I admit he was, to all outward appearanc= es. But to those who knew him well, he was a perfect gentleman (Hermione Gi= ngold)

**Live simply = **Love generously **Care deeply **Speak kindly.
*** Genuinel= y rich *** Faithful talent *** Sharing success
------=_Part_2295015_505142045.1548250812243--