Home » RDBMS Server » Enterprise Manager » Problem with Notification
Problem with Notification [message #315858] Wed, 23 April 2008 00:45
Messages: 7
Registered: January 2007
Location: Uzbekistan
Junior Member
MS Windows 2003 SP1

Oracle Database 10g Enterprise Edition Release - Prod
PL/SQL Release - Production
CORE Production
TNS for 32-bit Windows: Version - Production
NLSRTL Version - Production


When I try as ordinary user with role SELECT_CATALOG_ROLE or privileges SELECT ANY DICTIONARY to add E-mail Addresses in Preference --> General it give me the error:
Internal error. ORA-02291: integrity constraint (SYSMAN.MGMT_NOTIFY_DEVICES_FK) violated - parent key not found ORA-06512: "SYSMAN.EMD_NOTIFICATION" at line 1765 ORA-06512: "SYSMAN.MGMT_USER" at line 6809 ORA-06512: in "SYSMAN.MGMT_PREFERENCES" at line 1490 ORA-06512: in "SYSMAN.MGMT_PREFERENCES", line 1541 ORA-06512: in line 1
And due to this error I can't add My Notification Rule for this user.

But when I do it as Super Administrator User (with MGMT_USER role) I have not any problem and error, EM add any email address and create any Notification Rule.

Can anybody tell me what I do wrong.

Sorry for my poor english.
Previous Topic: OEM Grid - Data Guard Performance Page error
Next Topic: EM configuration issue
Goto Forum:

Current Time: Mon May 16 06:06:35 CDT 2022