WarehouseBuilder_Commands

1. clean_owbsys.sql script drops the contents of any existing OWBSYS schema installations, but leaves the schema otherwise intact.
2. cat_owb.sql script checks if an OWBSYS schema exists, and creates it if necessary, and then installs the objects required by Oracle Warehouse Builder 11.2 repository.
3. The reset_owbcc_home.sql script ensures that Oracle Warehouse Builder uses the 11.2 version of the Control Center Service.
3. The remote_owb_install.sql script, when executed on the server, ensures that a repository on a remote system can be installed; it sets the REMOTE_OWB_HOME variable for authentication by remote systems.


Configuring the Control Center Service If you are installing OWB 11.2 on an older Oracle Database release, or if you integrating OWB with Oracle Business Intelligence Standard Edition (Oracle Discoverer), you must run the reset_owbcc_home.sql script to ensure that the Control Center Service functions correctly.
To configure the Control Center service:
1. In Windows Explorer, open Oracle Warehouse Builder 11.2 Oracle Home directory to confirm the correct Oracle Home path, paying particular attention to capitalization. In this example, the path is C:\OWB112. While Windows is generally case insensitive, the path entered in the next steps must be an exact match to Oracle Warehouse Builder home directory, as displayed in the Windows Explorer address bar. To avoid errors, copy and paste the path.
2. On the Microsoft Windows desktop, click Start and select Run.
3. At the command prompt, start SQL*Plus: C:\>sqlplus SQL*Plus..
4. When prompted for user name, log in as a user with administrative privileges. Enter user-name: sys as sysdba Enter password: password ..
5. Run the reset_owbcc_home.sql script to force the Control Center service to run from Oracle Warehouse Builder 11.2 installation:
SQL> @C:\OWB112\owb\UnifiedRepos\reset_owbcc_home.sql C:\OWB112


show_service - The show_service.sql script displays the status of the Control Center Service, which provides access to the deployment and execution features of an OWB repository. The valid return values for the status of the Control Service Center are Available or Not Available. Connect as repository owner, OWBSYS.
Run the script: SQL> @drive:OWB_HOME/owb/rtp/sql/show_service.sql

Service_doctor - The service_doctor.sql script displays diagnostics about the OWB repository and its Control Center Service. Connect as repository owner, OWBSYS.
Run the script: SQL> @drive:OWB_HOME/owb/rtp/sql/service_doctor.sql

Rtrepos_report - The rtrepos_report.sql script displays the details of the Control Center and its registered locations. It provides information before using the location_util.bat script to alter some of the stored credentials. Connect as repository owner, OWBSYS.
Run the script: SQL> @drive:OWB_HOME/owb/rtp/sql/rtrepos_report.sql

Start_service - The script start_service.sql starts a Control Center Service that is managed by the database. A Control Center Service, when available, provides access to the deployment and execution features of an OWB repository. Connect as repository owner, OWBSYS.
Run the script: - SQL> @drive:OWB_HOME/owb/rtp/sql/start_service.sql

Stop_service - The script stop_service.sql stops a Control Center Service that is managed by the database. When the service is stopped using this script, the monitoring job is removed; the service remains disabled until it is re-started by the start_service script. Connect as repository owner, OWBSYS. Run the script:
SQL> @drive:OWB_HOME/owb/rtp/sql/stop_service.sql