Oracle database will not start up because of some oracle error (Legacy KB ID CNC TS26269 )

Document ID : KB000052129
Last Modified Date : 14/02/2018
Show Technical Document Details

Problem:

Error generated when attempting to start the eHealth Oracle DB (via nhStartDb):

ORA-16038: log 2 sequence# 2698 cannot be archived

ORA-19504: failed to create file ""

ORA-00312: online log 2 thread 1: '/u01/oradata/EHEALTH/REDO2A.log'

 

ORA-00312: online log 2 thread 1: '/u01/oradata/EHEALTH/REDO2B.log'

Environment:

eHealth 6.0 and later

Resolution:

1. Access database using sysdba with command of sqlplus sys/ehealth as sysdba, then run following sql commands one by one:

startup mount

recover database until cancel;

alter database open resetlogs;

2. as $NH_USER, do nhStopDb immediate followed by nhStartDb, then followed by starting ehealth server.