OWB - Control Center Service

Card Puncher Data Processing

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.

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.





Discover More
Card Puncher Data Processing
OWB - How to change the password of the repository Owner (of OWBSYS) ?

With OWB, when you change the password of the repository owner (of OWBSYS) in the database, you will then see that the OWB deployment hang. You can generate a script but when you start a deployment, it...
Card Puncher Data Processing
OWB - SAP - RPE-01082: Fail to execute the ABAP report

You have this message when the control center service is enable to start an ABAP report. By checking the Warehouse Builder Control Center Service log file, you will see this error : This error said...
Card Puncher Data Processing
Oracle Warehouse Builder

Owb Documentation - Understanding Data Quality Management White...



Share this page:
Follow us:
Task Runner