Rem
Rem $Header: has/mgmtdb/sql/catmgmtpdb.sql /st_has_12.2.0.1.0/1 2016/08/10 22:33:32 espgarci Exp $
Rem
Rem catmgmtpdb.sql
Rem
Rem Copyright (c) 2013, 2016, Oracle and/or its affiliates. 
Rem All rights reserved.
Rem
Rem    NAME
Rem      catmgmtpdb.sql - CATalog script for ManaGMenT Pluggable DataBase
Rem
Rem    DESCRIPTION
Rem      This script is the top level sript that will be called by DBCA to 
Rem      create all the relevant objects for the respository representing
Rem      a single cluster which is a Pluggable DB in the Consolidated Grid 
Rem      Infrastructure Repository ie the consolidated MGMTDB
Rem
Rem    NOTES
Rem      The MGMTDB is a CDB  with one or more PDBs one for each cluster.
Rem      The  PDB schemas and objects within it contain the data for each 
Rem      representative cluster.  
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    espgarci    07/05/16 - Remove parameters from this file
Rem    ssmarath    05/19/16 - Add parameter to catmgmtdbtbs
Rem    ssmarath    04/01/16 - Add argument to pass GHSUER
Rem    sahkumar    03/03/16 - bug-22828634
Rem    ssmarath    02/10/15 - Refactor Script to call top level scripts
Rem    dbagaria    08/07/14 - Add calog table
Rem    arpshukl    05/13/14 - Backport arpshukl_bug17830158 from st_has_12.1
Rem    arpshukl    12/09/13 - Add Pdb information table
Rem    sbasu       09/30/13 - Created
Rem
Rem    BEGIN SQL_FILE_METADATA
Rem    SQL_SOURCE_FILE: has/mgmtdb/sql/catmgmtpdb.sql
Rem    SQL_SHIPPED_FILE: has/mgmtdb/sql/catmgmtpdb.sql
Rem    SQL_PHASE: CATMGMTPDB
Rem    SQL_STARTUP_MODE: NORMAL
Rem    SQL_IGNORABLE_ERRORS: NONE
Rem    SQL_CALLING_FILE: NONE
Rem    END SQL_FILE_METADATA

Rem Common script to Create Tablespaces, Users, Grants
@?/has/mgmtdb/sql/common/catcommon.sql

Rem Create Schema Objects for CHM default user
@?/has/mgmtdb/sql/chm/catchm.sql

Rem Create Schema Objects for CHA default user
@?/has/mgmtdb/sql/cha/catcha.sql

Rem Create Schema Objects for CALOG default user
@?/has/mgmtdb/sql/calog/catcalog.sql

Rem Create Schema objects for QOS default user
@?/has/mgmtdb/sql/qos/catqos.sql

