How to troubleshoot error of ORA-00257 when starting sqlplus

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

PROBLEM

You may receive the following error when accessing sqlplus or launching eHealth OneClick (this error more likely appears on the old ehealth versions from 6.0 to 6.3.1).

sqlplus ehealth/ehealth
SQL*Plus: Release 9.2.0.7.0 - Production on Fri Nov 20 09:34:50 2015
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

ERROR:
ORA-00257: archives error. Connect internal only, until freed.

ENVIRONMENT

eHealth 6.0.x, 6.1.x, 6.2.x, 6.3.x
Any OS

SOLUTION

Check the partition disk space and make sure that $NH_HOME (the directory path where the eHealth application is installed) has at least 5 GB free disk space, and that the same is true for $NH_ORACLE_HOME (the directory path where the Oracle software is installed). Also make sure that none of the partition disk usage is over 95%.