Oracle database start up, but generate some oracle error ORA-19502

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

Problem:

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

Database mounted. 

ORA-16038: log 1 sequence# 124425 cannot be archived 

ORA-19502: write error on file "", blockno (blocksize=) 

ORA-00312: online log 1 thread 1: '/oradata/oradata/EHEALTH/REDO1A.log' 

ORA-00312: online log 1 thread 1: '/oradata/oradata/EHEALTH/REDO1B.log' 

and the command /nhiShowDbSpace shows a lack of tablespace free space 'DATA01 for exemple)

 

Environment:

eHealth 6.2 and later

 

Resolution:

1) Stop ehealth services 

2) run the command nhManageDbSpace -add -newPath /oradata -tablespace NH_DATA01 -size 20G 

   Remark : the size depend on the partition free space where is located "/oradata"    the size can be set until 32G 

3) Restart ehealth services