My Oracle Support Banner

EM 12 13c: Database Home page shows Incorrect DB version ,uptime (Doc ID 2297424.1)

Last updated on FEBRUARY 19, 2019

Applies to:

Enterprise Manager for Oracle Database - Version and later
Information in this document applies to any platform.


Target database has been upgraded from to

Navigating to DB home page  (Target > Database > click on Database link) show

a. Incorrect database version for databases upgraded from to

b. Incorrect Uptime


DB home page



EM uses following query to show version and uptime.

public static final String GetAllSummaryInfoMain_11 =
"select 'uptime' stat_type, \n" +
" round((sysdate - startup_time)*24) v1, null v2, " +
"(select NVL((select version from (select version || '.' || id version from dba_registry_history " +
" where NAMESPACE = 'SERVER' and BUNDLE_SERIES= 'PSU' order by ACTION_TIME desc) where rownum = 1), " +
"(select version from v$instance)) version from dual) v3, null v4 \n" +
" from v$instance \n" +
"union all \n" +
"select 'total_sga', \n" +
" sum(value)/1024/1024 v1, \n" +
" null v2, null v3, null v4 \n" +
" from v$sga \n" ;// +


 uptime sql



 Upgraded to


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.