Reports after OEM Upgrade

This is a really short blog post but to long for Twitter anyway.

If you access the repository database of Oracle Enterprise Manager (OEM) Cloud Control 13.2 to use it for reports with a different database user, you may face the problem that it is no longer working after the upgrade from 12c.

The repository database is now using edition based redefinition (EBR) inside the database and therefore it must be enabled also for the reporting user.

sql> alter user xyz enable editions;

That’s all.
As default the following users have it enabled:

sql> select USERNAME,EDITIONS_ENABLED 
from dba_users 
where EDITIONS_ENABLED = 'Y' 
order by 1;

USERNAME             E
-------------------- -
MGMT_VIEW            Y
SYSMAN               Y
SYSMAN_RO            Y

Public Synonyms

Keep in mind, from 13.1 onwards, there are no public synonyms for the management views anymore. This is described in the documentation in the second note.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s