You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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)
The text was updated successfully, but these errors were encountered:
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 GitHub<#1652 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/A6B4AR2NWDEZ7YBAWZVBCGDXOVHW5ANCNFSM6AAAAAAZ6VSKI4>.
You are receiving this because you authored the thread.Message ID: ***@***.******@***.***>>
using ora2pg ver 23.2 under centos 8.X - in a container and running ora2pg showreport with debug mode
recevied following error
output of b.lst is
output of Report_Ora2PG_20230627080920.html is
The text was updated successfully, but these errors were encountered: