oralogo_small

 

Last week i got following error-stack when trying to open the Enterpris-Manager:

503 Service Unavailable
Servlet error: Service is not initialized correctly. Verify that the repository connection information provided is correct.
conn.ConnectionService verifyRepositoryEx.818 - Invalid Connection Pool. ERROR = ORA-00376

When digging deeper into the error-logs i found the problem that a datafile was not online.

ORA-01110: Datendatei 5: 'C:\ORACLEHOMES\ORADATA\EMREP\MGMT.DBF'
ORA-06512: in "SYSMAN.MGMT_USER", Zeile 10174
ORA-06512: in "SYSMAN.SETEMUSERCONTEXT", Zeile 10
ORA-06512: in Zeile 1

I was asking our admin, and he tried a new file-backup that locked the datafile while oracle was trying to write to it.
So it went in "recover" mode.
Solution for this issue:

Select the files in recover-mode    : select file#,name,status,enabled from V$datafile;
recover them                                  : recover datafile 'XXX';
set them online                               : alter database datafile 'XXX' online;