OWB - Control Center Service

> Data Integration Tool (ETL/ELT) > Oracle Warehouse Builder

1 - 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.


3 - 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 - 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
Not Available
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.