BDS V2.0 Query Raises "ORA-29913: error in executing ODCIEXTTABLEOPEN callout"
Last updated on APRIL 13, 2017
Applies to:Oracle Big Data SQL - Version 2.0 and later
On BDS 2.0/BDA 4.3/Exadata 18.104.22.168 with Bundle Patch 10 it is possible to create an external table, but querying data from the external table raises:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
ORA-28575: unable to open RPC connection to external procedure agent
Troubleshooting ORA-29913: error in executing ODCIEXTTABLEOPEN callout
1. Since ODCIEXTTABLEOPEN can indicate that extproc is not being started or the listener not being configured:
a) Check if the extproc is started:
To do so run:
No real error is reported by the above, rather the command terminates with an error message which is the result of trying to stop the service just in case it was running.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms