KBI 310782 New Feature: Vital System Health Check During GUI Startup
Version
Argent Advanced Technology 3.1A-1401-A and later
Date
Monday, 16 Dec 2013
Summary
The Argent AT Engine can shut down because of one of following conditions:
- Out of disk space for database
- Low disk space on installation disk (Less than 100 MB)
- Low physical memory (Less than 512 MB)
- Insufficient CPU (Less than a Pentium 166 MHz processor)
The first step is to check service logs when an Argent AT Engine shuts down unexpectedly
The Argent AT GUI is now enhanced to check these vital system health parameters during startup so that customer can see the issues interactively
Technical Background
The requirement on free SQL DB space is soft, controlled by registry ‘MIN_DB_FREE_PERCENT‘ (default: 5) and ‘MIN_DB_FREE_MB‘ (default: 100)
The checking is disabled if the correspondent registry is set to ZERO
If SQL backend is Oracle, the used Oracle account must have SELECT access to following three system tables or views in order to get the DB usage information:
- dba_data_files
- dba_free_space
- dba_users
DBA can grant the access within SQL/Plus with sysdba privileges by running following commands:
GRANT SELECT ON dba_data_files TO XXXX;
GRANT SELECT ON dba_free_space TO XXXX;
GRANT SELECT ON dba_users TO XXXX;
Resolution
Upgrade to Argent Advanced Technology 3.1A-1401-A or later