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.

Advertising

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