My Oracle Support Banner

Big Data SQL Query Raises "ORA-29913: error in executing ODCIEXTTABLEOPEN callout" with Standalone Database (Doc ID 2303397.1)

Last updated on JANUARY 14, 2020

Applies to:

Oracle Big Data SQL - Version 3.1.0 and later
Information in this document applies to any platform.

Symptoms

NOTE: In the examples that follow, user details, cluster names, hostnames, directory paths, filenames, etc. represent a fictitious sample (and are used to provide an illustrative example only). Any similarity to actual persons, or entities, living or dead, is purely coincidental and not intended in any manner. 

Background

1. Background on the Big Data SQL (BDS) install script:

The Big Data SQL install script creates an MTA sid and extproc with a name like:

2. Background on "mtactl start"/"mtactl restart"

Symptoms

Querying a Big Data SQL external table raises the ERROR like below.  This example makes use of a Big Data SQL (BDS) external table name of bda_bds_tab1. 

  

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
 Background
 Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.