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

Products

• CA eHealth

Issue/Introduction

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.

 

Environment

Release: ADVEVS99000-6-AdvantEDGE View standalone
Component: