If the output.sql file has not exported anything other than the Postgres Pro transaction header and footer, there are two possible reasons:
The Perl script ora2pgpro dumps an
ORA-XXXerror: that means that your DSN or login information is wrong, check the error and your settings, and try again.The Perl script says nothing, and the output file is empty: the user lacks permission to extract something from the database. Try to connect to Oracle as super user or take a look at the directive
USER_GRANTSabove and in the next section, especially theSCHEMAdirective.