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

Mladen Gogala <gogala.mladen@xxxxxxxxx> · Tue, 17 Aug 2021 10:34:28 -0400



    You should locate Ora2Pg.pm using "find" like this:
    [mgogala@umajor ~]$ find
        /usr/local -name Ora2Pg.pm

        /usr/local/share/perl5/5.32/Ora2Pg.pm

        [mgogala@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@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.pansara@xxxxxxxxxxxxx

            FIS
              | Advancing the way the world Pays, Banks, and Invests 
        
         
      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