My Oracle Support Banner

Enabled BDS V1.1 On Top Of BDA V4.2.0 Then See Errors Running Queries or BDS May Show OFFLINE Status on DB Node (Doc ID 2038151.1)

Last updated on DECEMBER 09, 2019

Applies to:

Big Data Appliance Integrated Software - Version 4.2.0 and later
Linux x86-64

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.

On BDA v4.2.0 on BDA and DB 12.1.0.2 (BP9) on Exadata after new installation of BDS on Exadata, the resource status of BDS showed ONLINE on both DB nodes, but after about 5 minutes, one of instances changed to "OFFLINE" on DB node #1.

OR

During enabling bigdata sql connector, users may face a problem as below on Exadata side and it appears that the bds-exadata-install.sh worked fine and see that it succeeded. However errors maybe seen when running a query or creating a table.

 

When trying to run a simple select below error may be seen:

SQL> select * from all_hive_tables;

select * from all_hive_tables

*

ERROR at line 1:

ORA-29400: data cartridge error

Invalid or missing cluster: <CLUSTER_NAME>

 

OR

 

After creating test_table as below, following errors may be seen:

CREATE TABLE test_table (  

   c0 NUMBER,

   c1 NUMBER

)

ORGANIZATION EXTERNAL

   (TYPE ORACLE_HIVE DEFAULT DIRECTORY DEFAULT_DIR

   ACCESS PARAMETERS

      (

       com.oracle.bigdata.cluster=<CLUSTER_NAME>

       com.oracle.bigdata.tablename=default.testdata

      )

   ) PARALLEL 2 REJECT LIMIT UNLIMITED;

 

OR

SQL> select * from test_table;

select * from test_table

*

ERROR at line 1:

ORA-29913: error in executing ODCIEXTTABLEOPEN callout

ORA-29400: data cartridge error

ORA-06550: line 1, column 25:

PLS-00306: wrong number or types of arguments in call to 'DESCRIBE_OPEN'

ORA-06550: line 1, column 14:

PL/SQL: Statement ignored

 

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
Cause
Solution


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