OWB Control Center Service

How to Disable the OWB Service from Starting up Automatically upon Database Startup [ID 395325.1]

Applies to:

Oracle Warehouse Builder - Version: 10.1 and later    [Release: 10.1 and later]
Information in this document applies to any platform.

Goal

How to disable the OWB Control Center Service from starting up automatically upon database startup?

Solution

The script start_service.sql starts the service and creates a DBMS job that monitors the existence
of the service (every 6 minutes).
To disable the OWB service from starting up automatically upon database startup,  the DBMS job has to be disabled :

1. Log into sqlplus as the Repository Owner in 10g/ OWBSYS in 11g.                                                                                                                                     

2. Find the job number for the 'wb_rti_service_job.check_service' entry in the dba_jobs table :

SQL> select job, schema_user from dba_jobs where what = 'wb_rti_service_job.check_service(1);';

3. Disable the corresponding job :

SQL> exec dbms_job.broken(<job#>,TRUE);

Note : the script stop_service.sql stops the service and removes the DBMS job.