Chapter 9. Other Configurations

I hope that the previous chapters gave enough handles to start working with the Scheduler. I am aware that there is a lot more to tell about the Scheduler, and this chapter will shed light on some other configurations where the Scheduler can be used. This time it is about RAC (Real Application Clusters) and the standby databases.

RAC

When the jobs you are running depend on things other than just the database, it might be interesting to know what these other things are, and where they can be found. There are several ways to control which instance a job is going to run, some of which are:

• Define instance_id in the job definition

• Use instance_stickiness in the job definition

• Define service_name in the job class definition for the job

To be able to show what exactly happens, we need an RAC installation. The RAC installation used here runs on two nodes—oralin01 and oralin02—using the shared storage that is exported as iSCSI disks from the of01 server running openfiler...