topic Re: Oracle 19C as source(OCI error) in Qlik Replicate

Oracle 19C as source(OCI error)

Pranita123 — Mon, 12 Feb 2024 09:30:18 GMT

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

Re: Oracle 19C as source(OCI error)

Yadunandan — Mon, 12 Feb 2024 09:36:18 GMT

Hello @Pranita123,

Please refer the community post ORA-03113

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

Regards,
Yadunandan

Re: Oracle 19C as source(OCI error)

Yadunandan — Mon, 12 Feb 2024 09:37:19 GMT

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

Re: Oracle 19C as source(OCI error)

Pranita123 — Mon, 12 Feb 2024 10:21:28 GMT

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?

Re: Oracle 19C as source(OCI error)

Yadunandan — Mon, 12 Feb 2024 10:47:33 GMT

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

Re: Oracle 19C as source(OCI error)

john_wang — Mon, 12 Feb 2024 12:27:15 GMT

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.