missing smsap schedule

[lukasz_borek]

Had strange problem last day.

We are using smsap 3.0.3P1 and got problem witch schedule, which are not viable through smsap gui. But still valid in smsap database :

SQL> select SCHEDULENAME, HOSTNAME, state from repomanager.SMO_30_SCHEDULEDOPERATION;

SCHEDULENAME                   HOSTNAME                       STATE
------------------------------ ------------------------------ --------------------
P02_Daily_Backup_Schedule      hostname     SUSPENDED
P02_Hourly_Backup_Schedule_1   hostname      SUSPENDED
P02_Hourly_Backup_Schedule_2   hostname      SUSPENDED

but no any of above are sean in gui? Have anyone meet with similar issue? Any advice?

[lukasz_borek]

Ok fixed...

Following 'have you tried turn it off & on againg..."   : smsap_server restart  fixed problem.

What a pitty I can't mark my answare as correct

[thomas_glodde]

repo database needs to be available before smsap/oracle starts, might not be the case if both, user database as well as repository database are on the same filer; make sm sap/oracle depended on oracle services then.

[lukasz_borek]

Yes, I'm aware of that. Smsap database is on separete server. But from time to time we got problem with missing schedule in gui. After re-bounce smsap_server deamon all back to normal :

#smsap_server restart

Thanks!