Oracle 19C as source(OCI error)

[Pranita123]

Hello,

I'm encountering an issue while replicating data from Oracle 19c as the source to HDFS as the target. The error message I'm receiving is:

"Cannot fetch the maximum archived file sequence from v$archived_log. Thread 1 OCI error 'ORA-03113: end-of-file on communication channel'.

Process ID: ######

Session ID: ######

Serial number: ###### "

Could you please explain the meaning of this error and provide guidance on how to resolve it? Your assistance with this matter would be greatly appreciated.

Regards,

Pranita

[Yadunandan]

Hello @Pranita123,

Please refer the community post ORA-03113

which explains on how to mitigate the issue you are facing.

Regards,
Yadunandan

[Yadunandan]

Hello @Pranita123 ,

If our response has been helpful, please consider clicking "Accept as Solution". This will assist other users in easily finding the answer.

Regards,
Yadunandan

[Pranita123]

Thank you for your prompt response.

However, I couldn't locate the SQLNET.ORA file in my setup. What should be my next step in resolving this issue?

[Yadunandan]

Hello @Pranita123 

By default, the sqlnet. ora file is located in the ORACLE_HOME/network/admin directory.

May be you do not have access to this file, please ask your Oracle DBA to check into this, they might be able to locate the file.

Regards
Yadunandan

[john_wang]

Hello @Pranita123 ,

The file SQLNET.ORA maybe does not exist in your installation if you are running Oracle instant client, and many different reasons may lead the same error ORA-03113, and there are many articles about this error:

OCI error 'ORA-03113

Replicate ORA-03113 Error

select distinct(tzname)...from V$TIMEZONE_NAMES

ORACLE CDC ISSUE

If the problem still cannot be addressed by these articles, please open a support ticket with SOURCE_UNLOAD/SOUCE_CAPTURE set to Verbose and upload the Diag Packages.

Hope this helps.

John.