"File Not Found" error when attempting to move an Oracle datafile for eHealth

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

Problem:

Some customers have experienced "file not found" errors when attempting to move an Oracle datafile for eHealth to a new location. This article provides the proper syntax for the nhManageDbSpace command for move datafile.

 

Environment:

eHealth 6.2.2 and higher installed on Windows / UNIX / Linux

 

Cause:

When running nhManageDbSpace command, you must include the full path to the datafile in the command with -p flag, or you will receive a "data file not found" error.

 

Solution:

The proper syntax for the command is as follows:

nhManageDbSpace -move -datafile <path/datafileName> -newPath <new directory path>

For example, to move the datafile NH_DATA01a.dbf to the new location /oradata2, the command would be typed as follows:

nhManageDbSpace -move -datafile /oradata/EHEALTH/NH_DATA01a.dbf -newPath /oradata2

If this were a Windows server, the command would be:

nhManageDbSpace -move -datafile d:\oradata\EHEALTH\NH_DATA01a.dbf -newPath D:\oradata2