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.

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/[email protected]

SQL*Plus: Release - 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 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

[email protected]>@stop_service
Not Available

PL/SQL procedure successfully completed.

[email protected]>@start_service

PL/SQL procedure successfully completed.

Powered by ComboStrap