Seems like you just upgraded; if not then this condition is intermittently plaguing you since last upgrade; i had same issues.
do the following: TRY THIS IN NON PROD FIRST:
- Run this Query from a TOAD or a SQL Developer or from Command line, if u know how to format the SQL command line..
select ts_monitors.ts_name, ts_child_services_def.ts_name,ts_monitor_child_service.ts_started from ts_monitors,ts_child_services_def, ts_monitor_child_service where ts_monitor_child_service.ts_child_service_id=ts_child_services_def.ts_id and ts_monitor_child_service.ts_monitors_id=ts_monitors.ts_id
Find out if TS_STARTED in "ts_monitor_child_service" Table has "2".
If Yes,
then update the TS_STARTED from "2" to "0".
update ts_monitor_child_service set TS_STARTED=0 where TS_STARTED=2;
make sure to Commit:
commit;
RESTART your Environment (all EMs) and TIMS...
and now you should have RTTM Services in "Stopped" condition; try starting it... it should startup with no issues.
Thanks
Ashish
brianmc wrote:
I have the same issue - did you resolve this?