ORA-03113: end-of-file on communication channel with ora2pg ver 23.2 under a container

[bharanisvng]

using ora2pg ver 23.2 under centos 8.X - in a container and running ora2pg showreport with debug mode

recevied following error

[2023-07-05 08:25:58] FATAL: ORA-03113: end-of-file on communication channel
Process ID: 3239724
Session ID: 1223 Serial number: 58409 (DBD ERROR: OCIStmtExecute/Describe)

sample script used 
e.g 
ora2pg -t SHOW_REPORT -c /var/lib/ora2pg/ora2pg-20.0/ora2pg.conf -s dbi:Oracle:host="192.168.1.??;sid=orcl;port=1521" -u ??? -w '??' -n ?? 1>/tmp/Report_Ora2PG_20230627080920.html 2>/tmp/b.lst

a) Same script executed as standalone (not in a container) worked fine
a) Same script executed windows 10 based desktop - (in a container) worked fine

Any guidance

output of b.lst is

Reporting Oracle Content...
Looking at Oracle server version...
Looking at Oracle database size...
Looking at Oracle defined objects...
        Found 129 valid and 108 invalid object FUNCTION
        Found 455 valid and 0 invalid object INDEX
        Found 3 valid and 0 invalid object MATERIALIZED VIEW
        Found 98 valid and 1 invalid object PACKAGE
        Found 87 valid and 11 invalid object PACKAGE BODY
        Found 525 valid and 69 invalid object PROCEDURE
        Found 1 valid and 0 invalid object QUEUE
        Found 410 valid and 0 invalid object SEQUENCE
        Found 1262 valid and 0 invalid object TABLE
        Found 611 valid and 25 invalid object TRIGGER
        Found 3 valid and 0 invalid object TYPE
        Found 606 valid and 72 invalid object VIEW
Looking at table definition...
Looking at views definition...
Looking at database links...
        Found 0 DATABASE LINK.
Looking at jobs...
        Found 0 JOB.
Looking at synonyms...
        Found 0 SYNONYM.
Looking at global temporary table...
        Found 106 GLOBAL TEMPORARY TABLE.
Looking at encrypted columns...
        Found 0 encrypted column.
Looking at identity columns...
        Found 5 identity column.
Building report for object DATABASE LINK...
Building report for object FUNCTION...
Building report for object GLOBAL TEMPORARY TABLE...
Building report for object INDEX...
Building report for object JOB...
Building report for object MATERIALIZED VIEW...
Building report for object PACKAGE BODY...
Building report for object PROCEDURE...
Aborting export...

output of Report_Ora2PG_20230627080920.html is

[2023-07-05 08:25:58] FATAL: ORA-03113: end-of-file on communication channel
Process ID: 3239724
Session ID: 1223 Serial number: 58409 (DBD ERROR: OCIStmtExecute/Describe)

[darold]

I don't use container so I will not be a great help here but if someone knows the source of the issue I will be pleased to apply a fix.

[bharanisvng]

Team Changed in source oracle db – sqlnet.ora settings

changed on 05-07-2023 from 60 to 600

SQLNET.RECV_TIMEOUT=600

Seems we had network contention from our container to our source oracle db. Post increasing the sqlnet.ora file -> sqlnet.recv_timeout, issue resolved and the show report ran correctly.

Please close the issue #1652

Regards Bharani SV

From: Gilles Darold @.> Sent: Wednesday, July 5, 2023 5:16 PM To: darold/ora2pg @.> Cc: Bharani Sethalapathy Vaidyanathan @.>; Author @.> Subject: Re: [darold/ora2pg] ORA-03113: end-of-file on communication channel with ora2pg ver 23.2 under a container (Issue #1652)

I don't use container so I will not be a great help here but if someone knows the source of the issue I will be pleased to apply a fix.

— Reply to this email directly, view it on GitHubhttps://github.com/darold/ora2pg/issues/1652#issuecomment-1621595754, or unsubscribehttps://github.com/notifications/unsubscribe-auth/A6B4AR2NWDEZ7YBAWZVBCGDXOVHW5ANCNFSM6AAAAAAZ6VSKI4. You are receiving this because you authored the thread.Message ID: @.**@.>>

[darold]

Thanks for the feedback.