nhManageDbSpace fails to create new datafile (Legacy KB ID CNC TS32028 )

Document ID : KB000052000
Last Modified Date : 14/02/2018
Show Technical Document Details
To add a new eHealth datafile to the Oracle database, the nhManageDbSpace command is used with the '-add' option.  The command will automatically create a


When creating a new datafile for the NH_DATA01 tablespace, the user would first run this command:

    nhManageDbSpace -add -evaluate -newPath <path> -tablespace NH_DATA01

The '-evaluate' option would allow the script to check for space prior to actually creating the file.  If the evaluate succeeds, then this command is run:

    nhManageDbSpace -add -newPath <path> -tablespace NH_DATA01

 If the latter command fails with the error "ORA-01119: error in creating database file<filename>", then check the directory in <path>.  There could be a datafile with the same name as the command is trying to create already in that directory.  The ORA-01119 error in this case is misleading, since the issue is not that there is lack of space, the issue is that a file already exists with the name that eHealth is trying to use.

Use this command to confirm that the datafile in the target directory is not part of the existing directory:

 On Solaris:
   echo "select file_name from dba_data_files;" - sqlplus $NH_USER/$NH_USER

On Windows:
   echo  select file_name from dba_data_files; - sqlplus %NH_USER%/%NH_USER%

If the datafile in the target directory is not in the list of datafiles listed, then delete that file and run the nhManageDbSpace command again.

Related Issues/Questions:
nhManageDbSpace fails to create new datafile
eHealth command nhManageDbSpace fails to create new datafile
nhManageDbSpace -evaluate succeeds. 

Problem Environment:
Oracle 9i
Oracle 10g
Error:"ORA-01119: error when running nhManageDbSpace with -add option"

(Legacy KB ID CNC TS32028 )