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