search

darold / ora2pg

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.
http://www.ora2pg.com/
GNU General Public License v3.0
978 stars 341 forks source link

can't read file ora2pg_stdout_locker #1708

Closed fljdin closed 4 months ago

fljdin commented 7 months ago

Hello,

When using TEST_COUNT with ora2pg v24.1, we observed a fatal error in the debug output:

$ ora2pg -t TEST_COUNT -c config/ora2pg.conf -d --jobs 1 --parallel 4 -l log/testcount.log

[2023-11-17 14:32:58] FATAL: can't read file ora2pg_stdout_locker, No such file or directory
HINT: you should activate USER_GRANTS for a connection without DBA privilege. Continuing with USER privilege.
FATAL: can't read file ora2pg_stdout_locker, No such file or directory

Our workaround was to create the ora2pg_stdout_locker file before running the command:

$ touch log/ora2pg_stdout_locker
$ ora2pg -t TEST_COUNT -c config/ora2pg.conf -d --jobs 1 --parallel 4 -l log/testcount.log -b log

[TEST ROWS COUNT]
[ERRORS ROWS COUNT]
OK, Oracle and PostgreSQL have the same number of rows.

Regards, Florent

darold commented 4 months ago

Commit 5d6ed42 fixes this issue.