EM 12 13c: Database Home page shows Incorrect DB version ,uptime

(Doc ID 2297424.1)

Last updated on APRIL 14, 2018

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 code-line 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

 value is coming -214


 Upgraded to


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms