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 JULY 31, 2015

Applies to:

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

Symptoms

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

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