Login to SQL db to see if there are invalid objects
1. login to eHealth DB as: $NH_USER/$NH_USER@$NH_DB_CONNECT_STRING
2. select * from dba_objects where status != 'VALID'
Environment: eHealth with oracle database
Cause: These objects state is benign. It should not have any adverse impact on functioning.
Resolution: If you would like to get rid of this status of the objects then run following in
sqlplus session login as sys.
Stop eHealth servers, stop/start database
sqlplus "/ as sysdba"
It will take about 20-30 min to complete
Then check with following query:
SELECT OWNER||';'||OBJECT_NAME||';'||OBJECT_TYPE||';' FROM DBA_OBJECTS WHERE STATUS='INVALID' order by OBJECT_NAME;