Nis_server and mon_config_services probe is not able to start.

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Nis_server and mon_config_services probe is not able to start.

Environment

any environment

Cause

UIM tables on the database are configured to read only

Error message on the mon_config_services probe.

Caused by: java.sql.SQLException: ORA-00372: file 5 cannot be modified at this time
ORA-01110: data file 5: '+D2/prdutf4/datafile/uim.300.933529959'

Error message on the nis_server probe.

FATAL [main, nis_server] Unable to run CI importer, halting probe.
Feb 09 15:30:36:564 FATAL [main, nis_server] java.sql.SQLException: ORA-00372: file 5 cannot be modified at this time
ORA-01110: data file 5: '+D2/prdutf4/datafile/uim.300.933529959'
ORA-06512: at "UIM.SPN_NISSRV_UPDATE_CI_DEF", line 17
ORA-06512: at line 1

 

Resolution

1 Start SQLPLUS:
sqlplus “/as sysdba”

2 Check whether tablespaces are set READ ONLY (now the database is in OPEN state):
SELECT TABLESPACE_NAME FROM DBA_TABLESPACES WHERE STATUS = ‘READ ONLY’;

3 If tablespaces are returned, reset them to ONLINE:
ALTER TABLESPACE <Tablespace_Name> READ WRITE;

4 If the call in step 2 does not return lines anymore, the problem is corrected.

This error from Oracle means the database is be set to read-only

Make sure the UIM tables are read/write.