Error: ORA-01109 - database not open when trying to change the protect database password

Products

• Data Loss Prevention

Issue/Introduction

When trying to change the protect user's password in the Symantec Data Loss Prevention (DLP) database, the following error appears:
ORA-01109 database not open

Running the following two commands shows the database is mounted instead of running:

select instance_name, status from v$instance;


select name, open_mode from v$database;



Running the 'startup' command results in the following two errors:

ORA-01113: file 7 needs recovery
ORA-01110: data file 7: 'D:\Oracle\oradata\protect\LOB03.DBF'

Cause

The D:\Oracle\oradata\protect\LOB03.DBF needs to be restored.

Resolution

Restore a good known backup of the database.