# DCowb.ctl:391:Collects Oracle Warehouse Builder Information
# $Id: DCowb.ctl,v 1.5 2013/12/19 14:53:10 RDA Exp $
# ARCS: $Header: /home/cvs/cvs/RDA_8/src/scripting/lib/collect/OFM/DCowb.ctl,v 1.5 2013/12/19 14:53:10 RDA Exp $
#
# Change History
# 20131219  KRA  Fix spell.

=head1 NAME

OFM:DCowb - Collects Oracle Warehouse Builder Information

=head1 DESCRIPTION

This module collects Oracle Warehouse Builder-related information. The
following reports can be generated and are regrouped under C<Oracle Warehouse
Builder>:

=cut

echo tput('bold'),'Processing OFM.OWB module ...',tput('off')

# Initialization
var $ORACLE_HOME = ''

var $TOC = '%TOC%'
var $TOP = '[[#Top][Back to top]]'
toc '1:Oracle Warehouse Builder'

# Load the common macros
run DB:DBinfo()
run RDA:library()

# Set the database context
call setSqlTarget(${I_DB})

# Test the database connection and get the database version
if !testSql()
 var $ORACLE_VERSION = get_db_version()

=head2 not_applicable - Not Applicable

You can execute the Oracle Warehouse Builder module on Oracle 9i Release 2
or later only.

=head2 generic - Generic Information

Gathers generic information.

=head2 report11g - Repository Information (11g)

Gathers release-related information.

=head2 report10g - Repository Information (9.2, 10.1, or 10.2)

Gathers release-related information.

=cut

debug ' Inside OWB module, obtain the database version'
if match($ORACLE_VERSION,'^(92|10|11|12)')
{run OFM:OWBinfo()
 run OFM:OWBr11g()
 run OFM:OWBr10g()
}
else
{report not_applicable
 write 'The Oracle Warehouse Builder module requires a database connection \
        and can only be executed on 9i Release 2 or later.'
 toc '2:[[',getFile(),'][rda_report][Not Applicable]]'
}

=head2 Start Scripts

Gets start scripts.

=cut

debug ' Inside OWB module, gathering start scripts'
set $sql
{SELECT 'hom=' || server_side_home
" FROM owbsys.wb_rt_service_nodes;
}
if grepSql($sql,'^hom=','f')
 var $ORACLE_HOME = value(first)
if isUnix()
 var $sub = 'unix'
elsif or(isWindows(),isCygwin())
 var $sub = 'win32'
pretoc '2:Start Scripts'
call sort_files(3,0,\
  catFile($ORACLE_HOME,'owb','bin',$sub,${AS.BATCH:'cca_admin'}),\
  catFile($ORACLE_HOME,'owb','bin',$sub,${AS.BATCH:'ccashut'}),\
  catFile($ORACLE_HOME,'owb','bin',$sub,${AS.BATCH:'ccastart'}),\
  catFile($ORACLE_HOME,'owb','bin',$sub,${AS.BAT:'OMBPlus'}),\
  catFile($ORACLE_HOME,'owb','bin',$sub,${AS.BAT:'owbclient'}),\
  catFile($ORACLE_HOME,'owb','bin',$sub,${AS.BAT:'reposinst'}),\
  catFile($ORACLE_HOME,'owb','bin',$sub,${AS.BAT:'run_service'}),\
  catFile($ORACLE_HOME,'owb','bin',$sub,${AS.BAT:'startOwbbInst'}),\
  catFile($ORACLE_HOME,'owb','bin',$sub,${AS.BAT:'stopOwbbInst'}),\
  catFile($ORACLE_HOME,'owb','bin',$sub,${AS.BAT:'upgradeloc'}))
unpretoc

=head2 Configuration Files

Gets configuration files.

=cut

debug ' Inside OWB module, gathering configuration files'
pretoc '2:Configuration Files'
call sort_files(3,0,\
  catFile($ORACLE_HOME,'owb','bin','owb'),\
  catFile($ORACLE_HOME,'owb','bin','owb.boot'),\
  catFile($ORACLE_HOME,'owb','bin','owb.conf'),\
  catFile($ORACLE_HOME,'owb','bin','logging.properties'),\
  catFile($ORACLE_HOME,'owb','bin','owb-debug.conf'),\
  catFile($ORACLE_HOME,'owb','bin','owb-nodebug.conf'),\
  catFile($ORACLE_HOME,'owb','bin','owb.properties'),\
  catFile($ORACLE_HOME,'owb','bin','product.properties'),\
  catFile($ORACLE_HOME,'owb','bin','version.properties'),\
  catFile($ORACLE_HOME,'owb','bin','admin','Compatibility.properties'),\
  catFile($ORACLE_HOME,'owb','bin','admin','DebugUtility.properties'),\
  catFile($ORACLE_HOME,'owb','bin','admin','jdbcdriver.properties'),\
  catFile($ORACLE_HOME,'owb','bin','admin','Preference.properties'),\
  catFile($ORACLE_HOME,'owb','bin','admin','rtrepos.properties'),\
  catFile($ORACLE_HOME,'owb','bin','admin','Runtime.properties'),\
  catFile($ORACLE_HOME,'owb','bin','admin','owb.classpath'),\
  catFile($ORACLE_HOME,'owb','bin','admin','owbclient.logging.properties'))
unpretoc

=head1 SEE ALSO

L<DB:DBinfo|collect::DB:DBinfo>,
L<OFM:OWBinfo|collect::OFM:OWBinfo>,
L<OFM:OWBr10g|collect::OFM:OWBr10g>,
L<OFM:OWBr11g|collect::OFM:OWBr11g>,
L<RDA:library|collect::RDA:library>

=begin credits

=over 10

=item RDA 4.5:  Jean-Philippe Peelman, Mark Rovers.

=item RDA 4.7:  Jean-Philippe Peelman.

=item RDA 4.10: Sarath Babu, Jean-Philippe Peelman.

=item RDA 4.29: Mark Rovers.

=item RDA 8.00: Mark Rovers.

=back

=end credits

=head1 COPYRIGHT NOTICE

Copyright (c) 2002, 2016, Oracle and/or its affiliates. All rights reserved.

=head1 TRADEMARK NOTICE

Oracle and Java are registered trademarks of Oracle and/or its
affiliates. Other names may be trademarks of their respective owners.

=cut