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:
echo "select file_name from dba_data_files;" - sqlplus $NH_USER/$NH_USER
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.
nhManageDbSpace fails to create new datafile
eHealth command nhManageDbSpace fails to create new datafile
nhManageDbSpace -evaluate succeeds.
Error:"ORA-01119: error when running nhManageDbSpace with -add option"
(Legacy KB ID CNC TS32028 )