Problem: I find invalid objects in my eHealth database

Document ID : KB000031783
Last Modified Date : 14/02/2018
Show Technical Document Details

Symptom:

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" 
@?/rdbms/admin/catproc.sql 
@?/rdbms/admin/utlrp.sql 

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;