ORA-16000: database open for read-only access error when Testing connection

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Receiving error when testing the connection for Oracle database

StatementCallback; uncategorized SQLException for SQL [SELECT count(*) FROM convalidatedummyrec]; SQL state [60000]; error code [604]; ORA-00604: error occurred at recursive SQL level 1 ORA-16000: database open for read-only access

ORA-06512: at line 16 ORA-00942: table or view does not exist ; nested exception is java.sql.SQLException:

ORA-00604: error occurred at recursive SQL level 1 ORA-16000: database open for read-only access ORA-06512: at line 16 ORA-00942: table or view does not exist

 

 

Environment

Release : 4.10

Component : CA Test Data Manager - TDM Web Portal

Resolution

Portal cannot support this mode - if the user is not able to switch to writable mode then they can use a different (for example master) database.

However, during our testing Portal was working with the database in READ ONLY mode so as an alternative the user can consider switching their standby database to READ ONLY mode.