Load Data Warehouse fails with ORA-16000: database or pluggable database open for read-only access

book

Article ID: 206384

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS STARTER PACK-CLARITY PPM

Issue/Introduction

We migrated to Orcale 19c and Load Data Warehouse job started failing. From the logs I see that Load Data Warehouse is failing with error:

2021/01/04 18:08:14 - ClarityDB - isOracle? - [CA Clarity][Oracle JDBC Driver][Oracle]ORA-20100: ENCOUNTERED EXCEPTION WHILE INSERTING INTO DWH_TMP_RECORD_KEYS. SQLERRM : ORA-16000: database or pluggable database open for read-only access

 

Environment

Release : Any

Component : CA PPM INTEGRATIONS & INSTALLATIONS

Resolution

This means the database is not open for read-write access but read only. Please ask your DBA to correct this and run Load Data Warehouse job - Full Load again.