Re: Can't locate Ora2Pg.pm while executing export_schema.sh

You should locate Ora2Pg.pm using "find" like this:

[mgogala(at)umajor ~]$ find /usr/local -name Ora2Pg.pm
/usr/local/share/perl5/5.32/Ora2Pg.pm
[mgogala(at)umajor ~]$

and then make sure that your PERL5LIB directory contains  the location:

export PERL5LIB=/usr/local/share/perl5/5.32:$PERL5LIB

That should do the trick. On most distributions,
/usr/local/share/perl5/<perl version> is already included into PERL5LIB.
Are you working on Cygwin? You can do a simple test:

[mgogala(at)umajor ~]$ perl -e 'use Ora2Pg; print "$Ora2Pg::VERSION\n";'
21.0

This is not related to PostgreSQL, this is a Perl question:
https://gist.github.com/cgoldberg/4332167

On 8/17/21 3:15 AM, Pansara, Jiten wrote:
>
> Hello Team,
>
> I am getting below error while executing export_schema.sh. Any
> suggestion/help is really appreciated.
>
> BEGIN failed--compilation aborted at
> /c/Strawberry/perl/site/bin/ora2pg line 27.
>
> Can't locate Ora2Pg.pm in @INC (you may need to install the Ora2Pg
> module) (@INC contains: /usr/lib/perl5/site_perl
> /usr/share/perl5/site_perl /usr/lib/perl5/vendor_perl
> /usr/share/perl5/vendor_perl /usr/lib/perl5/core_perl
> /usr/share/perl5/core_perl) at /c/Strawberry/perl/site/bin/ora2pg line 27.
>
> BEGIN failed--compilation aborted at
> /c/Strawberry/perl/site/bin/ora2pg line 27.
>
> If we don’t want to use this script, should we execute ora2pg directly
> to migrate the database from Oracle to Postgres?
>
> * Ora2pg -c ora2pg.conf
>
> Let me know your views.
>
> *Jiten Pansara*
>
> Senior Database Analyst
>
> *T*:  +91 9158149600
> *E*: jiten(dot)pansara(at)fisglobal(dot)com <mailto:jiten(dot)pansara(at)fisglobal(dot)com>
> *FIS | Advancing the way the world Pays, Banks, and
> Invests***<https://www.facebook.com/FIStoday><https://twitter.com/FISGlobal><https://www.linkedin.com/company/fis>
>
> A picture containing text, outdoor, sign Description automatically
> generated
>
> **
>
> The information contained in this message is proprietary and/or
> confidential. If you are not the intended recipient, please: (i)
> delete the message and all copies; (ii) do not disclose, distribute or
> use the message in any manner; and (iii) notify the sender
> immediately. In addition, please be aware that any message addressed
> to our domain is subject to archiving and review by persons other than
> the intended recipient. Thank you.

--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com