Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Ranger set up on ORACLE RAC

Highlighted

Ranger set up on ORACLE RAC

Explorer

I am installing via ambari -Ranger Admin and metadata on ORACLE RAC(ASM)

Now new tablespace could not create +DG f/s,tried using existing tablespace,there also got

ORA-01157

SQL> select object_name,owner from dba_objects where object_name='X_DB_VERSION_H';

OBJECT_NAME

--------------------------------------------------------------------------------

OWNER

--------------------------------------------------------------------------------

X_DB_VERSION_H

RANGERADMIN

SQL> select * from RANGERADMIN.X_DB_VERSION_H;

select * from RANGERADMIN.X_DB_VERSION_H

*

ERROR at line 1:

ORA-01157: cannot identify/lock data file 10 - see DBWR trace file

ORA-01110: data file 10: '/opt/oracle/product/12.1.0/db/dbs/rangerdba.dat'

SQL> select file_name from dba_data_files;

ERROR:

ORA-01157: cannot identify/lock data file 10 - see DBWR trace file

ORA-01110: data file 10: '/opt/oracle/product/12.1.0/db/dbs/rangerdba.dat'

Earlier it was like :

+DG_PROD_DATA_001/PRODRPL/DATAFILE/pool_data.335.915706325 +DG_PROD_DATA_001/PRODRPL/DATAFILE/pool_data.336.915706335 ERROR: ORA-01157: cannot identify/lock data file 89 - see DBWR trace file ORA-01110: data file 89: '/opt/oracle/product/12.1.0/db/dbs/prodrpl.dat'

3 REPLIES 3

Re: Ranger set up on ORACLE RAC

Explorer

Which version of Oracle are you using ?

Highlighted

Re: Ranger set up on ORACLE RAC

Explorer

12c RAC,its like whenever we pass db details in ranger config->it creates local datafiles for tablespaces :

FILE_NAME

--------------------------------------------------------------------------------

+DG_PROD_DATA_001/PRODMSTR/DATAFILE/system.354.916928451

+DG_PROD_DATA_001/PRODMSTR/DATAFILE/sysaux.355.916928451

+DG_PROD_DATA_001/PRODMSTR/DATAFILE/undotbs1.356.916928453

+DG_PROD_DATA_001/PRODMSTR/DATAFILE/undotbs2.358.916928463

+DG_PROD_DATA_001/PRODMSTR/DATAFILE/tools.365.916929929

+DG_PROD_DATA_001/PRODMSTR/DATAFILE/pool_data.364.916929929

+DG_PROD_DATA_001/PRODMSTR/DATAFILE/mstrbeatrix.363.916929935

+DG_PROD_DATA_001/PRODMSTR/DATAFILE/tbl_ambari.270.917879009

/opt/oracle/product/12.1.0/db/dbs/rangerdba.dat

Any way we can ask ranger to take care of RAC features?
Highlighted

Re: Ranger set up on ORACLE RAC

Explorer

Execute below given sql statement and see whether 'USERS' or 'SYSTEM' table exist or not. if any one of them exist then provide that as ranger db name and proceed the installation :

SELECT TABLESPACE_NAME FROM DBA_TABLESPACES where TABLESPACE_NAME in ('USERS','SYSTEM');

Don't have an account?
Coming from Hortonworks? Activate your account here