| INVALID OBJECTS UNDER SYSMAN SCHEMA [message #302405] |
Mon, 25 February 2008 08:53  |
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  |
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
