OWB - Control Center Service

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.

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.