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

Changes

 Upgraded to 11.2.0.4.4

Cause

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