OWB - Control Center Service

About

The control center service is a service which is embedded in the database : It manage :

• the deployment
• the execution
• the scheduling

of OWB object.

You manage all this action in the control center.

Articles Related

How to restart the control center service

The best way is to perform this action with SQLPlus.

With a command dos :

• go to the directory : OWBHOME\owb\rtp\sql
• connect to the repository owner with sqlplus
• start the sql file stop_service.sql
• start the sql file start_service.sql

Example :

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Nicolas>cd C:\OWBHOME10203\owb\rtp\sql

C:\OWBHOME10203\owb\rtp\sql>sqlplus repo_owner/password@orcl

SQL*Plus: Release 10.2.0.3.0 - Production on Fri Mar 20 15:55:36 2009

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

repo_owner_10203@orcl>@stop_service
Not Available

PL/SQL procedure successfully completed.

repo_owner_10203@orcl>@start_service
Available

PL/SQL procedure successfully completed.