Home > cloud control1 2c > Job step scheduler showing as down in EM12c

Job step scheduler showing as down in EM12c

Image


a)Ensure that OS level timezone and the Timezone value set in the Database are in Sync.

Verify it with the following commands:

$date

This gives the timestamp on the Machine with Timezone.

b)Connect to the repository Database and run the following query to check the value set in the Database.

SQL> select dbms_scheduler.stime from dual;

If there is any difference, run the following as SYS user:

SQL> exec DBMS_SCHEDULER.SET_SCHEDULER_ATTRIBUTE('default_timezone','TimeZone');

For example:

SQL> exec DBMS_SCHEDULER.SET_SCHEDULER_ATTRIBUTE('default_timezone','Europe/London');

If there is no difference in the Time Zone values, proceed with the below Action plan.
 c)Connect as SYS user and Set the job_queue_processes to zero.

SQL>alter system set job_queue_processes=0 scope=BOTH;

SQL> commit;

d) Connect as SYSMAN user and execute the following:
 SQL>exec emd_maintenance.remove_em_dbms_jobs;

SQL> commit;

e) Reset the value of the following parameter to 1000 as SYS user:

SQL>alter system set job_queue_processes=1000 scope=BOTH;

f) Submit DBMS_SCHEDULER jobs. (Connect as SYSMAN user and execute the following:)

SQL>exec emd_maintenance.submit_em_dbms_jobs;

SQL>commit;

g)Verify the status of job on the console now

Advertisements
Categories: cloud control1 2c
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: