Home » RDBMS Server » Enterprise Manager » INVALID OBJECTS UNDER SYSMAN SCHEMA (WINDOWS 32 BIT)
INVALID OBJECTS UNDER SYSMAN SCHEMA [message #302405] Mon, 25 February 2008 08:53 Go to next message
garry143
Messages: 17
Registered: November 2007
Junior Member
Hello everyone,

I have upgraded my database from 10.2.0.1 to 10.2.0.3.
Everything went well except i have some invalid objects under sysman schema. I could not compile them. database seems to be working fine so far. But i'm afraid i might get some problem in the future. May be new version doesn't need these sysman objects.
Any sugestions will be greatly appreciated.

Thanks
Re: INVALID OBJECTS UNDER SYSMAN SCHEMA [message #302470 is a reply to message #302405] Mon, 25 February 2008 19:07 Go to previous messageGo to next message
rhziaDBA
Messages: 17
Registered: February 2008
Location: Madrid
Junior Member
The sysman schema is used for Oracle Enterprise Manager. If you think to user OEM and enable the metrics and alarms that contains the OEM you can't

What objects are invalid?

execute the following

SELECT OBJECT_NAME,OBJECT_TYPE,STATUS FROM DBA_OBJECTS
WHERE STATUS <> 'VALID'
AND OWNER = 'SYSMAN'
ORDER BY OBJECT_TYPE,OBJECT_NAME


Regards
Re: INVALID OBJECTS UNDER SYSMAN SCHEMA [message #305431 is a reply to message #302470] Mon, 10 March 2008 14:12 Go to previous message
garry143
Messages: 17
Registered: November 2007
Junior Member
Sorry for replying late. Follwing objects are invalid. I can access the OEM. So far no problem.


OBJECT_NAME OBJECT_TYPE STATUS
-------------------------------------------------------------------------------- ------------------- -------
EMD_CHRONOS_ANALYZE PACKAGE INVALID
EMD_LOADER PACKAGE INVALID
EMD_MNTR_USER PACKAGE INVALID
EMD_MNTR_WEBSITE PACKAGE INVALID
CHRONOS_REPOSITORY_COLLECTIONS PACKAGE BODY INVALID
EMD_CHRONOS_ADMIN PACKAGE BODY INVALID
EMD_CHRONOS_ANALYZE PACKAGE BODY INVALID
EMD_LOADER PACKAGE BODY INVALID
EMD_MAINTENANCE PACKAGE BODY INVALID
EMD_MNTR_USER PACKAGE BODY INVALID
EMD_MNTR_WEBSITE PACKAGE BODY INVALID
EMD_RT_ROLLUP PACKAGE BODY INVALID
EM_PING PACKAGE BODY INVALID
EM_TARGET PACKAGE BODY INVALID
MGMT_ADMIN PACKAGE BODY INVALID
MGMT_ECM_POLICY PACKAGE BODY INVALID
MGMT_LOADER PACKAGE BODY INVALID
MGMT_TARGET PACKAGE BODY INVALID
MGMT_USER PACKAGE BODY INVALID
MGMT_WEBSITE_TARGET PACKAGE BODY INVALID

OBJECT_NAME OBJECT_TYPE STATUS
-------------------------------------------------------------------------------- ------------------- -------
OCS_COMP_MNTR PACKAGE BODY INVALID
OCS_OVF_COMP_MNTR PACKAGE BODY INVALID
CHECK_DUPLICATE_TARGETS TRIGGER INVALID
METRICS_SEVERITY_DUPLICATES TRIGGER INVALID
TARGETS_AVAILABILITY_DEFAULT TRIGGER INVALID
TARGETS_INSERT_TRIGGER TRIGGER INVALID
MGMT_TZRGN_UPDATE_CBK_OBJ TYPE BODY INVALID

27 rows selected
Previous Topic: OEM
Next Topic: Local Security Policies
Goto Forum:
  


Current Time: Thu Mar 28 19:41:42 CDT 2024