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 13.1.1.0.0 and later
Information in this document applies to any platform.

Symptoms

Target database has been upgraded from 11.2.0.3.2 to 11.2.0.4.4.

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

a. Incorrect database version for databases upgraded from 11.2.0.3.2 to 11.2.0.4.4

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

 

Changes

 Upgraded to 11.2.0.4.4

Cause

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
Symptoms
Changes
Cause
Solution
References


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