Skip to Main Content

Issue in Big data sql setup on Oracle 12.1.0.2

767189Aug 8 2019 — edited Mar 23 2020

Friends ,

I have tried to reconfigure BDS for new DB installed .

Bds version : 3.1

Oracle db : 12.1.0.2

Cloudera (Kerberose enabled )and Oracle server are in different unix box .

I have successfully installed the database side bundle generated .Generated Keytab for oracle user and placed it in DB nodes too ..

Im able to access the hadoop machine from the machine in which the oracle server is installed \

with hadoop fs -ls /user and able to put files to hdfs too .

Table creation happens but im unable to retrieve the same .

Im unable to find DBMS_HADOOP package as sys user .

Please help if there are any patches to be installed .

SQL>

CREATE TABLE stg_custodial_accounts_try1 (.....................................)ORGANIZATION EXTERNAL (TYPE  oracle_hive DEFAULT DIRECTORY "ORA_BIGDATA_CL_cluster"

ACCESS PARAMETERS 12  (com.oracle.bigdata.tablename: dbname1.stg_custodial_accounts));

13

Table created.

SQL> SQL> select * from stg_custodial_accounts_try1

  2  ;

select * from stg_custodial_accounts_try1

*

ERROR at line 1:

ORA-29913: error in executing ODCIEXTTABLEOPEN callout

ORA-06550: line 1, column 68:

PLS-00201: identifier 'DBMS_HADOOP.GET_USER_MAP' must be declared

ORA-06550: line 1, column 53:

PL/SQL: Statement ignored

Comments
Post Details