eHealth is stopping and we see this error:
Error,Pgm nhiPoller[Net]: Append to table nh_stats_poll_info failed (ORA-30036: unable to extend segment by 8 in undo tablespace 'NH_ROLLBA).
System admin has already added more space to the drive, but it didn’t help.
EHealth 6.3.x on any supported platform
The error indicates that an oracle datafile is full, and not the actual drive.
Datafiles can only grow to 32g and then a new one must be added manually.
The NH_ROLLBACK datafile is handled differently from other datafiles in oracle.
Here are the steps to add a new one:
1. Stop eHealth processes
2. get the dbconnectstring:
env | grep -i connect
3. Start sqlplus as the sysdba user using the info from the above command:
sqlplus "sys/ehealth@dbconnectstring as sysdba"
4. Add a new datafile with the following command:
alter tablespace NH_ROLLBACK add datafile 'D:\OracleDB\oradata\EHBECSA\NH_ROLLBACK02.dbf' size 102400000 autoextend on next 52428800 maxsize 32767M;
Make sure there is enough space at the location specified (file will start
at 1024M, but grow to 32GB), if not choose a location with sufficient space.
5. Confirm that there are now two rollback files with this query:
select file_name,bytes from dba_data_files where tablespace_name='NH_ROLLBACK';
You should have NH_ROLLBACK01.DBF and NH_ROLLBACK02.DBF
To see the procedure to add a regular datafile, please see: