How to troubleshoot error of ORA-00257 when starting sqlplus

book

Article ID: 33670

calendar_today

Updated On:

Products

EHEALTH CA eHealth

Issue/Introduction

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%.

 

Environment

Release: LHDEVC99000-6.3-eHealth-Live Health Upgrade Elements
Component: