Big Data SQL SELECT * FROM ALL_HIVE_DATABASES Fails With ORA-28579 (Doc ID 2224417.1)

Last updated on JANUARY 21, 2017

Applies to:

Oracle Big Data SQL - Version 3.0 and later
Linux x86-64

Symptoms

Big Data SQL queries fail with the following error:

ORA-28579: network error during callback from external procedure agent

To diagnose the issue further turn on extproc tracing. On the Exadata node open $ORACLE_HOME/hs/admin/extproc.ora and add the following.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms