Hi all. This is an Oracle 19c Database on Windows:
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production Version 19.21.0.0.0
I'm getting the folowing errors during an impdp operation:
UDI-03113: la operaci¾n ha generado un error ORACLE 3113
ORA-03113: fin de archivo en el canal de comunicaci¾n
Identificador de Proceso: 6380
Identificador de Sesi¾n: 326 N·mero de Serie: 64776
UDI-03114: la operaci¾n ha generado un error ORACLE 3114
ORA-03114: no conectado a ORACLE
Also looking in alert log I found this error, which could be related or not:
2024-04-15T13:49:00.741046-03:00
SDSDESA(3):Resize operation completed for file# 21, fname D:\APP\ORACLE\ORADATA\CDBDESA\SDSDESA\EMPRESAS09.DBF, old size 9062400K, new size 9072640K
SDSDESA(3):Resize operation completed for file# 22, fname D:\APP\ORACLE\ORADATA\CDBDESA\SDSDESA\EMPRESAS10.DBF, old size 9144320K, new size 9154560K
SDSDESA(3):Resize operation completed for file# 13, fname D:\APP\ORACLE\ORADATA\CDBDESA\SDSDESA\EMPRESAS01.DBF, old size 9379840K, new size 9390080K
SDSDESA(3):Resize operation completed for file# 14, fname D:\APP\ORACLE\ORADATA\CDBDESA\SDSDESA\EMPRESAS02.DBF, old size 9113600K, new size 9123840K
SDSDESA(3):Resize operation completed for file# 15, fname D:\APP\ORACLE\ORADATA\CDBDESA\SDSDESA\EMPRESAS03.DBF, old size 9175040K, new size 9185280K
SDSDESA(3):Resize operation completed for file# 16, fname D:\APP\ORACLE\ORADATA\CDBDESA\SDSDESA\EMPRESAS04.DBF, old size 9431040K, new size 9441280K
SDSDESA(3):Resize operation completed for file# 17, fname D:\APP\ORACLE\ORADATA\CDBDESA\SDSDESA\EMPRESAS05.DBF, old size 9758720K, new size 9768960K
SDSDESA(3):Resize operation completed for file# 18, fname D:\APP\ORACLE\ORADATA\CDBDESA\SDSDESA\EMPRESAS06.DBF, old size 9492480K, new size 9502720K
SDSDESA(3):Resize operation completed for file# 19, fname D:\APP\ORACLE\ORADATA\CDBDESA\SDSDESA\EMPRESAS07.DBF, old size 9687040K, new size 9697280K
SDSDESA(3):Resize operation completed for file# 20, fname D:\APP\ORACLE\ORADATA\CDBDESA\SDSDESA\EMPRESAS08.DBF, old size 11704320K, new size 11714560K
2024-04-15T14:16:33.441038-03:00
***********************************************************************
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for 64-bit Windows: Version 19.0.0.0.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 19.0.0.0.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 19.0.0.0.0 - Production
Version 19.21.0.0.0
Time: 15-ABR-2024 14:16:33
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:timeout de la operación
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Timeout de la operación
nt secondary err code: 60
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.70.1)(PORT=28511))
Import is being perform where DB resides.
Are we having a net config issue here?
I found this note on MOS: DataPump Import (IMPDP) Ends with Errors UDI-3113 ORA-7445 Exception Encountered: Core Dump [Pfrins()+176] (Doc ID 1433875.1). Not sure if this is related or not.
Is there any patch related to this issue?
Thanks in advance !!!